Picking out the SubFields within a message

[Chris Wethey]

Withing some of the HL7 messages you have say as an example for OBR records an OBR4.0 but within the OBR4.0 you have subfields.  How or can you select them in the Translation Configurator version 5.5 QDX or do you have to use the TCL process to select the information in the subfield OBR4.0.2.

Example:

OBR|1|96179^HBOC|0000010864A5132^HBOL|5132^CULTURE, URINE^99STBB|||201005130851|||^211|||||335&Urine Clean Catch&HL70070&335&Urine Clean Catch&99ASPM|4851^CHOWDHRY^SAPNA^””^^^MD^HL70010|||||||LANDMARK MEDICAL CENTER|LBW-MIC|F|||792^^^^^^^99DOC|||^TEST

The “&” ampersand is the seperator within a field so 335&Urine Clean Catch&HL70070&335&Urine Clean Catch&99ASPM

So OBR15.0 has 6 subfields – looking to select only one of the subfields to place back into OBR15.0 as one field.

Topic

[Jim Kosloskey]

Chris,

…OBR.#15.[0].[5]  will point to the first component (the first [0] and the 6th sub-component of the first component (the second [5]). The … is the address pathing up to the segment for your variant.

So .[x].[x] is component/sub-component notation.

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

[Tom Rioux]

Chris,

Also remember that if you are using bulkcopy (for the entire message) or pathcopy (for each segment), that you may need to null out the OBR.15 destination field before you perform the copy that Jim spoke of.  

If you only want to grab one subcomponent and use that as the entire OBR.15 field, then you can do something like this:

@null  —->  1(0).0(0).OBR(0).#15(0)

1(0).0(0).OBR(0).#15(0).[0].[2]  —> 1(0).0(0).OBR(0).#15(0)

Tom

[Chris Wethey]

Jim and Thomas,

Thanks for the subfield coding – that worked the second time around.  I did not clear out all of the subfields prior to moving my results to the field and had “&” after the description.  

The next round is on me.

Chris

[Author]

Replies