HRL, VRL, tcl or none of the above

[Tim Gobbel]

I have a flat file to xlate to HL7.  These are clinical observation and there is one observation per incoming line of text.  however, they want all the observations for a particular patient on a particular date which could be 8 to 10 lines (records) to go out as one message with multiple OBX segments.

IB text example:

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BP Syst 1 NM,Systolic:,103

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BP Type of Measurement,Type of Measurement:,Dynamap

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS Weight Kg NM,Weight:,16.8

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BP Diast 1 NM,Diastolic:,64

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS Height cm NM,Height:,108.5

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BSA CAL,BSA:,0.71

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BMI CAL,BMI:,14.27

“last, first mi”,xxxxxxMRN,866444524,4/3/07 13:45,4/3/07 14:15,XXX Triage Note,104-PED,NURS VS BP Sources,BP Source:,Left Arm

“last, first mi”,xxxxxxMRN,876219981,2/7/08 10:28,2/7/08 10:41,XXX Triage Note,104-PED,NURS VS BP Syst 1 NM,Systolic:,104

“last, first mi”,xxxxxxMRN,876219981,2/7/08 10:28,2/7/08 10:41,XXX Triage Note,104-PED,NURS VS BP Type of Measurement,Type of Measurement:,Dynamap

“last, first mi”,xxxxxxMRN,876219981,2/7/08 10:28,2/7/08 10:41,XXX Triage Note,104-PED,NURS VS BP Diast 1 NM,Diastolic:,56

“last, first mi”,xxxxxxMRN,876219981,2/7/08 10:28,2/7/08 10:41,XXX Triage Note,104-PED,NURS VS BP Sources,BP Source:,Right Arm

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BP Syst 1 NM,Systolic:,101

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BP Type of Measurement,Type of Measurement:,Dynamap

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS Weight Kg NM,Weight:,19.4

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BP Diast 1 NM,Diastolic:,58

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS Height cm NM,Height:,116

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BSA CAL,BSA:,0.8

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BMI CAL,BMI:,14.42

“last, first mi”,xxxxxxMRN,878228147,4/9/08 9:06,4/9/08 9:14,XXX Triage Note,104-PED,NURS VS BP Sources,BP Source:,Right Arm

any suggestions?

Thanx!

Topic

[garry r fisher]

Hi,

From a quick look I would do it as VRL and Tcl. VRL would define your message and I would then use Tcl to check the patients number and the date. For each matching record concatenate them into either a HRL or another VRL (both built of VRL records) and then on change of date/MRN forward your concatenated message to the next stage.

The next stage can either use a bit more tcl as preprocess or you could go straight to an xlate – You might need to do a bit of testing to see which is best.

I would probably use more Tcl to sort your concatenated record into a more readily xlatable form.

Hopefully that all makes sense. I sure somebody else will say there are other ways to do it but that’s the beauty of this forum and of the flexibility of Cloverleaf.

Regards

Garry

[Jim Kosloskey]

Tim,

At first glance I think HRL and VRL.

VRL for each actual mesage then HRL to specify how the VRL will repeat.

I suspect your repeating field wouldf be the MRN Number.

If that works as I think it should no Tcl would be necesary – at least for navigating through the recrod sets.

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

[Tim Gobbel]

Thanx!  I really appreciate all your help and this forum!  I will give both a try.  I have a VRL working to do one OBX per message but not quite there yet for the combining.  I tried an HRL but the test tool was not recognizing the segment.MRN field and no data was pulled in.  I will go back for another try.  Thanx!

[Tim Gobbel]

OK, so I tried the HRL/VRL and can’t seem to figure out how to set it up.  Every time I put anything in the repeat section it prvents my data from displaying in the tester. So does anyone have a tcl proc that will suck in a flat file and create a dummy HL7.  That looks like how I need to go at this point unless there is an HRL guru out there that can tell me how to configure the VRL and HRL to work together.  Thanx!

[Jim Kosloskey]

Tim,

I am on vacation otherwise I could assist you in trying to get the HRL/VRL combination working.

I have helped others get similar situations resolved.

I will be back on 7/30.

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

[Charlie Bursell]

Tim:

When we have something like this we usually normalize it to an HL7 variant.

It is easy enough to define and HRL for output but for input where you have repeating segments, etc.  and HL7 is much easier

[Tim Gobbel]

Thanx!  i have passed this off to another group here at JHH as i have three others to get working by Friday.  if they cannot do it, i will get back to you for some details as i seem to be a little THICK when it comes to flat files.  Thanx!

[Author]

Replies