Concat and Copying two PID fields

[Eric Sligh]

Hey everyone,

Here is what I am trying to accomplish. We send our FIN Number in PID-4 and our MRN in PID-3 in our ADT’s from McKesson Series. We are currently doing a CONCAT on both fields with MSH-4 to send a unique id for our ADT’s into McKesson CareEnhance Review Manager. What I want to do is a COPY after we do the CONCAT of the MRN from PID-4 to PID-3 and then vice versa with our FIN Number from PID-3 to PID-4. Would this be easier to accomplish with tcl or in the Xlate? I should know this but I have so much going on these days it is crazy.

Thanks,

Eric

Topic

[Nick Stainback]

Hey,

So you are trying to copy the concat’ed ID’s to both PID 3 and and 4 or do you want the ori ID back in 3 and 4 after the concat?

[Eric Sligh]

I want the concatenated ids copied, not the original ids.

Thanks,

Eric

[Jim Kosloskey]

Eric,

If I understand the need correctly here are two alternatives (neither require Tcl):

1. do the CONCAT to a temp variable then do the COPY(s) using the temp variable.

2. or… after the current CONCAT I think the data you want is in the outbound field. In the COPY (or other Action you want to do) with the values in the outbound field simply use the outbound field reference in the Source column of the Xlate Action. You can do this by highlighting the outbound field in the Outbound message tree and then clicking on the button below that indicates ‘copy to source’ (or something like that). You will know you have done this correctly if there is a tilde(~) in front of the address path in the Source column for the field after you have copied it.

If I have not understood the issue clearly or if what I have suggested is unclear, let me know.

Thanks,

Jim Kosloskey

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Eric Sligh]

Jim,

I knew I was overlooking something simple.

Thanks,

Eric

[Author]

Replies