The purpose of this Integration Agreement is to provide
VistA application with a list of Transfusions given to 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)
Transfusion.date
fnDateTimeConversionToFileManDateTime(PatientTransfusion.TransfusinoEndDat
eTime)
Transfusion.unitsPooled BloodUnit.PooledUnitsCount
Transfusion.productTypeName ProductType.ProductTypeName
Transfusion.productTypePrintName ProductType.ProductTypePrintName
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">
<Transfusions>
<Transfusion date="20000101115535-0600" unitsPooled="3"
productTypeName="RED BLOOD CELLS" productTypePrintName="RBC" />
</Transfusions>
</Patient>
</Bloodbank>
|
