| GENERAL DESCRIPTION |
The purpose of this Integration Agreement is to provide
VistA applications with a list of Blood Bank patient diagnostic testing
results, blood products requested, and blood units associated with a patient.
XML Mapping:
____________
XML Element.Attribute / VBECS SQL Table.Column or Function
Patient.dfn / Patient.VistaPatientId
Patient.firstName / Patient.PatientFirstName
Patient.lastName / Patient.PatientLastName
Patient.dob / fnPatientDobConversionToFileManDateTime(Patient.PatientGuid)
Patient.ssn / Patient.PatientSsn
Patient.abo / fnGetAbo(Patient.PatientGuid)
Patient.rh / fnGetRh(Patient.PatientGuid)
SpecimenTest.printTestName / BloodTestType.BloodTestName
SpecimenTest.orderableTestName / OrderableTest.OrderableTestName
SpecimenTest.result / TestResult.TestResultText
SpecimenTest.testDate /
fnDateTimeConversionToFileManeDateTime(SpecimenTest.TestDate)
SpecimenTest.cprsOrderId / PatientOrder.OrderGroupNumber
SpecimenTest.divisionCode / SpecimenTest.DivisionCode
SpecimenTest.enteringTechId / VbecsUser.UserDuz
SpecimenTest.requestorId / PatientOrder.OrderingProviderId
SpecimenTestComments / InformationMessage.InformationMessageText
ComponentRequest.dateRequested /
fnDateTimeConversionToFileManDateTime(PatientOrder.orderPlacedDatetime)
ComponentRequest.dateWanted /
fnDateTimeConversionToFileManDateTime(OrderedComponent.RequiredDatetime)
ComponentRequest.unitsRequested / OrderedComponent.RequiredUnitQuantity
ComponentRequest.cprsOrderId / PatientOrder.OrderGroupNumber
ComponentRequest.componentClassName / ComponentClass.ComponentClassName
ComponentRequest.componentClassShortName /
ComponentClass.ComponentClassShortName
ComponentRequest.requestorId / PatientOrder.OrderingProviderId
ComponentRequest.enteredById / PatientOrder.OrderEnteredById
Unit.status / UnitStatus.UnitStatusCode
Unit.id / BloodUnit.EyeReadableUnitId
Unit.product / ProductType.ProductTypePrintName
Unit.abo / BloodUnitMedia.BloodTypeCode
Unit.rh / BloodUnitMedia.RhFactorCode
Unit.divisionCode / BloodUnit.DivisionCode
Unit.location / IssuedUnit.LocationIen
Unit.expDate /
fnDateTimeConversionToFileManDateTime(BloodUnitMedia.UnitExpirationDate)
Function Description:
_____________________
fnPatientDobConversionToFileManDateTime - This function returns the patient's
date of birth in FileMan format based on the patient unique identifier in the
VBECS database.
fnGetAbo - This function returns the patient's current ABO Group.
fnGetRh - This function returns the patient's current Rh Type.
fnDateTimeConversionToFileManDateTime - This function converts a SQL DateTime
data type to FileMan format.
XML Example:
____________
<BloodBank>
<Patient dfn="5000" firstName="One" lastName="VBECSpatient"
dob="19500101" ssn="000000000" abo="A" rh="P">
<SpecimenTests>
<SpecimenTest printTestName="ABO Interp"
orderableTestName="ABO/Rh" result="A" testDate="20030101115535-0600"
cprsOrderId="12345" divisionCode="589" enteringTechId="5335"
requestorId="3553">
<SpecimenTestComments></SpecimenTestComments>
</SpecimenTest>
</SpecimenTests>
<ComponentRequests>
<ComponentRequest dateRequested="20030101115535-0600"
dateWanted="20030102" cprsOrderId="12346" componentClassName="RED BLOOD CELLS"
componentClassShortName="RBC" requestorId="3553" enteredById="3553"
/>
</ComponentRequests>
<Units>
<Unit status="C" id="04215" product="RBC" abo="A" rh="P"
divisionCode="589" location="4E" expDate="20030103115535-0600" />
</Units>
</Patient>
</BloodBank>
|
