1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| insert into lsc001.lscid, lsc001.lscnam1a, lsc001.lscsysc1b
VALUES ('9', 'manu',"<?xml version='1.0'?><labtype name="hsc" type="hl7"><bloodtest>
<field name="ULI">
<location>/PATIENT_RESULT(0)/PATIENT(0)/PID-2</location>
</field>
<field name="sampledate">
<location>/PATIENT_RESULT(0)/PATIENT(0)/PID-7</location>
</field>
<field name="WBC">
<location>/PATIENT_RESULT(0)/ORDER_OBSERVATION(0)/OBSERVATION(9)/OBX-5</location>
</field>
<field name="ANC">
<location>/PATIENT_RESULT(0)/ORDER_OBSERVATION(0)/OBSERVATION(10)/OBX-5</location>
</field>
</bloodtest>
</labtype>
"); |
Partager