Anyway, here is my delimna. The first HL7 message passing thru this xlate in the engine and the testing tool great! However, with subsequent messages processed, the new NTE segemnt I build in each has the comment contents of the previous message’s NTE preceeding what I expect to be loaded. Obviously, it acts like I need to clear a field but I thought that the outbound side of the xlate was reset with each new HL7 message passing thru it.
I have attached the xlate I built and here is the Data passing inbound followed by what is coming out. Any help would be greatly appreciated! Thank you!
Data inbound
MSH|^~&|OCRR|GSH||GSH|20070626080553||ORM^O01|337891|D|2.2
NTE|1|P|ORDER COMMENT 1 FROM AFFINITY
NTE|2|P|ORDER COMMENT 2 FROM AFFINITY
PID|||000106||INTERFACE^KAZ1^XV||19740923|M|INTERFACE^KAZ1|O|ROAD FIXED^^VINCENNES^IN^47591|KNOX|(777)777-7777|(111)111-1111||M||606171|545-44-5454
PV1||I|4E^411^1|9||||||MED||||9|||0686^CARANDANG^REYNALDO^A^^MD|MED|2796|199||||||||||||||||||||||||20070626080221
ORC|NW|L05836-1^HIS||||N|||20070626080553|KAZ|||ISDPRG
OBR|1|L05836-1^HIS||URINE-C^URINE CULTURE|||||||L||||11|0686^CARANDANG^REYNALDO^A^^MD||MICRO|||||||||1^^^20070626080300^^A
NTE|1|P|ITEM COMMENT 1 FROM AFFINITY
NTE|2|P|ITEM COMMENT 2 FROM AFFINITY
OBX|1|TX|CURNT ANTIBIOTIC^CURRENT ANTIBIOTIC THERAPY||NONE CURRENTLY BEING USED
OBX|2|CE|BS^BODY SITE||008^BLADDER^L
MSH|^~&|OCRR|GSH||GSH|20070626084641||ORM^O01|337892|D|2.2
NTE|1|P|BODY SITE,BLADDER::this is a comment coming from hom and I a
NTE|2|P|m trying to demonstrate how these fields populate affinity a
PID|||000106||INTERFACE^KAZ1^XV||19740923|M|INTERFACE^KAZ1|O|ROAD FIXED^^VINCENNES^IN^47591|KNOX|(777)777-7777|(111)111-1111||M||606171|545-44-5454
PV1||I|4E^411^1|9||||||MED||||9|||0686^CARANDANG^REYNALDO^A^^MD|MED|2796|199||||||||||||||||||||||||20070626080221
ORC|NW|L05837-1^HIS|2392184|||N|||20070626084641|SYS|||ISDPRG
OBR|1|L05837-1^HIS|2392184|URINE-C^URINE CULTURE|||||||L||||41|0686^CARANDANG^REYNALDO^A^^MD||MICRO||HOM_ORM^008|||||||1^^^20070626084000^^R
NTE|1|P|nd then go over to lab. hopefully this is working well.::CUR
NTE|2|P|RENT ANTIBIOTICS,none today::
Data outbound:
MSH|^~&|OCRR|GSH||GSH|20070626080553||ORM^O01|337891|D|2.2
PID|||000106||INTERFACE^KAZ1^XV||19740923|M|INTERFACE^KAZ1|O|ROAD FIXED^^VINCENNES^IN^47591|KNOX|(777)777-7777|(111)111-1111||M||606171|545-44-5454
PV1||I|4E^411^1|9||||||MED||||9|||0686^CARANDANG^REYNALDO^A^^MD|MED|2796|199||||||||||||||||||||||||20070626080221
ORC|NW|L05836-1^HIS||||N|||20070626080553|KAZ|||ISDPRG
OBR|1|L05836-1^HIS||URINE-C^URINE CULTURE|||||||L||||11|0686^CARANDANG^REYNALDO^A^^MD||MICRO|||||||||1^^^20070626080300^^A
NTE|||ORDER COMMENT 1 FROM AFFINITY~ORDER COMMENT 2 FROM AFFINITY~ITEM COMMENT 1 FROM AFFINITY~ITEM COMMENT 2 FROM AFFINITY
OBX|1|TX|CURNT ANTIBIOTIC^CURRENT ANTIBIOTIC THERAPY||NONE CURRENTLY BEING USED
OBX|2|CE|BS^BODY SITE||008^BLADDER^L
MSH|^~&|OCRR|GSH||GSH|20070626084641||ORM^O01|337892|D|2.2
PID|||000106||INTERFACE^KAZ1^XV||19740923|M|INTERFACE^KAZ1|O|ROAD FIXED^^VINCENNES^IN^47591|KNOX|(777)777-7777|(111)111-1111||M||606171|545-44-5454
PV1||I|4E^411^1|9||||||MED||||9|||0686^CARANDANG^REYNALDO^A^^MD|MED|2796|199||||||||||||||||||||||||20070626080221
ORC|NW|L05837-1^HIS|2392184|||N|||20070626084641|SYS|||ISDPRG
OBR|1|L05837-1^HIS|2392184|URINE-C^URINE CULTURE|||||||L||||41|0686^CARANDANG^REYNALDO^A^^MD||MICRO||HOM_ORM^008|||||||1^^^20070626084000^^R
NTE|||ORDER COMMENT 1 FROM AFFINITY~ORDER COMMENT 2 FROM AFFINITY~ITEM COMMENT 1 FROM AFFINITY~ITEM COMMENT 2 FROM AFFINITY~BODY SITE,BLADDER~this is a comment coming from hom and I am trying to demonstrate how these fields populate affinity and then go over to lab. hopefully this is working well.~CURRENT ANTIBIOTICS,none today