The purpose of this Integration Agreement is to provide
VistA applications with a list of 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)
Unit.status DonationType.RestrictionTypeCode
Unit.id BloodUnit.EyeReadableUnitId
Unit.product ProductType.ProductTypeName
Unit.productCode BloodProduct.ProductCode
Unit.abo BloodUnitMedia.BloodTypeCode
Unit.rh BloodUnitMedia.RhFactorCode
Unit.volume BloodUnit.OriginalVolume
Unit.dateAssigned
fnDateTimeConversionToFileManDateTime(OrderedUnit.SelectedDate)
Unit.divisionCode VamcDivision.DivisionCode
Unit.location IssuedUnit.IssueToLocation
Unit.expDate
fnDateTimeConversionToFileManDateTime(BloodUnitMedia.UnitExpirationDate)
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:
<?xml version="1.0" encoding="utf-8" ?>
<BloodBank>
<Patient dfn="5000" firstName="One" lastName="VBECSpatient" dob="19500101"
ssn="000000000" abo="A" rh="P" />
<Units>
<Unit status="C" id="04215" product="RBC" productCode="E0335" abo="A"
rh="P" volumn="250" dateAssigned="20010430115535-0600" divisionCode="589"
location="4E" expDate="20010430115535-0600" />
</Units>
</BloodBank>
|
