Xlate problems – help appreciated!

[Tom Arrowsmith]

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

Topic

[Tom Rioux]

Tom,

My first suggestion (and I may be totally off base here) would be to try splitting out the Table lookup into two separate commands.  As it is set up now, because the input value is a list of both fields,  I believe it would search the table for something like:

“ED09C ED09C”

I would imagine you have your table built to only search for something like “ED09C”.  Try splitting your Table command into two separate commands and see if that works for you.

Tom

[Tom Arrowsmith]

I will try that – but the mystery to me is why it works in the testing tool but not in reality……

I’ll get back to you in regards to your suggestion.

Thanks!

[Author]

Replies