Xlate problems – help appreciated!

I’ve written an xlate that works in the testing tool but not in reality – first time I’ve seen this happen….

The whole purpose of this xlate is to change the ORC-13 and ORC18.1 to the proper value to have lab labels print at the proper printing location. I am trying to achieve this  by taking info from the PV1-3 and PV1-4, concatenating it together and placing it into the PV1-51 (and also moving the stuff in PV1-4 to PV1-50), then having a table look at the resulting value and assign a new value to ORC-13 and ORC-18.1

Here’s the raw message to be acted upon:

MSH|^~&|IBEX|L|LAB|L|20090617092506||ORM^O01|1227755|D|2.5||

PID|1||0419905||PICIS^JOSEPH^^||19550910|M|||^^^^20176|||||||0916700004|

PV1|1|E|ERC^^^L|ED^ED^09^L||||||MED|||||||620^BENKELMAN^DOUGLAS^W^^^MD|EQC^^L||SP|||||||||||||||||||L|||||20090616142728|

ORC|NW|1227755^IBEX|||IP||1^^^200906170924^^STAT||20090617092506| ^Cates, ADMIN^Joann^^^^||801^Virmani, MD^Pranay^^^^|ED||200906170924|||ED^EDN| ^Cates, ADMIN^Joann^^^^||

OBR|||IBEX001227755^IBEX|LAB-50702^PEDIATRIC FRESH FROZEN PLASMA(FFP^BOOD_BANK|||||||||||^^^|801^Virmani, MD^Pranay^^^^|||||||||||1^^^200906170924^^STAT||||^

OBX|1|TX|SPECAMT^||20|

Here’s what the testing tool does:

Please Wait ……

Command Issued: hcixlttest -L -d 1 -f len10 PICIS_ORM_to_HLAB.xlt /quovadx/qdx5.4.1/integrator/Data/PrintRouting.len

Command output:

MESSAGE 1

0(0).MSH(0)  :  >|^~&|IBEX|L|LAB|L|20090617092506||ORM^O01|1227755|D|2.3< 1(0).0(0).PID(0)  :  >|1||0419905||PICIS^JOSEPH||19550910|M|||^^^^20176|||||||0916700004< 1(0).1(0).0(0).PV1(0)  :  >|1|E|ERC^^^L|||||||MED|||||||620^BENKELMAN^DOUGLAS^W^^^MD|EQC^^L||SP|||||||||||||||||||L|||||20090616142728||||||ED^ED^09^L|ED09C< 2(0).0(0).ORC(0)  :  >|NW|1227755^IBEX|||IP||1^^^200906170924^^STAT||20090617092506| ^Cates, ADMIN^Joann||801^Virmani, MD^Pranay|ERC||200906170924|||ERC^EDN| ^Cates, ADMIN^Joann< 2(0).1(0).0(0).OBR(0)  :  >|||IBEX001227755^IBEX|LAB-50702^PEDIATRIC FRESH FROZEN PLASMA(FFP^BOOD_BANK||||||||||||801^Virmani, MD^Pranay|||||||||||1^^^200906170924^^STAT< 2(0).1(0).1(0).0(0).OBX(0)  :  >|1|TX|SPECAMT||20< Checking for leaked handles…

But when I move message through the engine – the PV1 stuff works but the ORC stuff does not! here’s a copy of that:

MSH|^~&|IBEX|L|LAB|L|20090617092506||ORM^O01|1227755|D|2.3

PID|1||0419905||PICIS^JOSEPH||19550910|M|||^^^^20176|||||||0916700004

PV1|1|E|ERC^^^L|||||||MED|||||||620^BENKELMAN^DOUGLAS^W^^^MD|EQC^^L||SP|||||||||||||||||||L|||||20090616142728||||||ED^ED^09^L|ED09C

ORC|NW|1227755^IBEX|||IP||1^^^200906170924^^STAT||20090617092506| ^Cates, ADMIN^Joann||801^Virmani, MD^Pranay|ED||200906170924|||ED^EDN| ^Cates, ADMIN^Joann

OBR|||IBEX001227755^IBEX|LAB-50702^PEDIATRIC FRESH FROZEN PLASMA(FFP^BOOD_BANK||||||||||||801^Virmani, MD^Pranay|||||||||||1^^^200906170924^^STAT

OBX|1|TX|SPECAMT||20

I have built a table that takes the value in PV1-51 and then assigns a printing location of ERE, ERC or ERP depending on the value. The fact that the testing tool works means the table works, right?

Confusing! Any help appreciated … I’m up against a go-live deadline here….

I’ve attached a word document with a screen shot of the Xlate…..

Tom

(703) 779-5474