The purpose of this Integration Agreement is to provide
patient specific and common order entry data to VistA for the purpose of
creating VBECS orders for blood products and diagnostic tests performed in the
Blood Bank.
XML Mapping:
XML Element.Attribute VBECS SQL Table.Column or Function
_____________________ __________________________________
Patient.dfn Patient.VistaPatientId
Patient.firstName Patient.PatientFirstName
Patient.lastName Patient.PatientLastName
Patient.abo fnGetAbo(Patient.PatientGuid)
Patient.rh fnGetRh(Patient.PatientGuid)
TransfusionReaction.type TransfusionReactionType.TransfusionReactionTypeText
TransfusionReaction.date
fnDateTimeConversionToHL7DateTime(PatientTransfusionReaction.NotedDateTim e
)
TransfusionRequirement.modifier
PatientTransfusionRequirement.TransfusionRequirementText
Antibody.name AntibodyType.AntibodyTypeName
Unit.status UnitStatus.UnitStatusCode OR
DonationType.RestrictionTypeCode
Unit.id BloodUnit.EyeReadableUnitId
Unit.product ProductType.ProductTypePrintName
Unit.location VamcDivision.DivisionName
Unit.expDate
fnDateTimeConversionToHL7DateTime(BloodUnitMedia.UnitExpirationDate)
Specimen.expDate
fnDateTimeConversionToHL7DateTime(PatientSpecimen.SpecimenExpirationDate)
Specimen.uid PatientSpecimen.SpecimenUid
Component.name ComponentClass.ComponentClassShortName
Component.id ComponentClass.CprsOrderableItemId
Component.specimen ComponentClassParameter.SpecimenRequiredIndicator
LabTest.id SpecimenTestThreshold.LabTestId
LabTest.name SpecimenTestThreshold.VistALaboratoryTestName
Msbos.name Msbos.SurgeryName
Msbos.threshold MsbosComponentClass.MaximumSetupUnitQuantity
Surgery.name Msbos.SurgeryName
Function Description:
fnGetAbo - This function returns the patient's current ABO Group.
fnGetRh - This function returns the patient's current Rh Type.
fnDateTimeConversionToHL7DateTime - This function converts a SQL DateTime
data type to HL7 format.
XML Example:
<?xml version="1.0" encoding="utf-8" ?>
<BloodBank>
<Patient dfn="5000" firstName="One" lastName="VBECSpatient"
ssn="000000000" abo=A"" rh="P">
<TransfusionReactions>
<TransfusionReaction type="Acute Hemolytic"
date="20010101120035-0600" />
</TransfusionReactions>
<TransfutionRequirements>
<TransfusionRequirement modifier="Washed RBC products">
<Antibodies>
<Antibody name="Anti-E" />
</Antibodies>
<Units>
<Unit status="C" id="04215" product="RBC" location="4E"
expDate="20010103115535-0600" />
</Units>
<Specimen expDate="20010115115535-0600" uid="1234567890" />
</Patient>
<Components>
<Component name="RED BLOOD CELLS" id="2" specimen="R">
<LabTests>
<LabTest id="320" name="HGB" />
</LabTests>
<MsbosList>
<Msbos name="Esophogectomy" threshold="5" />
</MsbosList>
</Component>
</Components>
<Surgeries>
<Surgery name="Esophogectomy" />
</Surgeries>
</BloodBank>
|
