The purpose of this Integration Agreement is to provide
Blood Bank related workload data to VistA for workload reporting.
XML Mapping:
XML Element.Attribute VBECS SQL Table.Column or Function
_____________________ __________________________________
Transaction.id WorkloadEvent.WorkloadEventGuid
Transaction.type VbecsProcess.TransactionType
Transaction.division WorkloadEvent.DivisionCode
Transaction.accessionArea VamcDivision.AccessionAreaId
Transaction.dateTime
fnDateTimeConversionToFileManDateTime(WorkloadEvent.WorkloadEventDate)
Transaction.status WorkloadEvent.WorkloadEventStatusCode
Workload.code WorkloadProcess.WorkloadCode
Workload.multiplyFactor WorkloadEvent.WeightMultiplier
Patient.dfn Patient.VistaPatientId
VbecsUser.duz VbecsUser.UserDuz
Lab.accessionNumber OrderedTest.SpecimenWorkloadUid OR
OrderedComponent.SpecimenWorkloadUid
Lab.testPerformed OrderedTest.LabTestId OR
OrderedComponent.LabTestId
Unit.id BloodUnit.UnitProductCode
Note:
Transaction.type is a conditional code where the values can be
one of the following depending on the type of workload event being
returned.
U = Unit
P = Patient
M = Miscellaneous
The WorkloadEventStatusCode is always P for 'Pending Processing'.
Function Description:
fnDateTimeConversionToFileManDateTime - This function converts a SQL DateTime
data type to FileMan format.
XML Example:
<WorkloadTransactions>
<Transaction id="28711464-EFB3-453E-8B8A-025BA85CCD10" type="U"
division="589" accessionArea="29" dateTime="20030101113555-0600" status="P">
<Workload code="86832.0000" multiplyFactor="1" />
<VbecsUser duz="53555" />
<Lab accessionNumber="2930160023" testPerformed="6478" />
</Transaction> </WorkloadTransactions>
|
