HRL, VRL, tcl or none of the above

This topic has 7 replies, 4 voices, and was last updated 12 years, 5 months ago by Tim Gobbel.

Creator

Topic
July 19, 2012 at 1:37 am #53202
Tim Gobbel
Participant
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!
Creator

Topic

Viewing 6 reply threads

Author

Replies
- July 19, 2012 at 11:44 am #76901
  garry r fisher
  Participant
  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
- July 19, 2012 at 12:18 pm #76902
  Jim Kosloskey
  Participant
  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.
- July 19, 2012 at 1:29 pm #76903
  Tim Gobbel
  Participant
  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!
- July 20, 2012 at 12:21 am #76904
  Tim Gobbel
  Participant
  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!
- July 20, 2012 at 1:09 am #76905
  Jim Kosloskey
  Participant
  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.
- July 20, 2012 at 1:12 pm #76906
  Charlie Bursell
  Participant
  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
- July 24, 2012 at 5:08 pm #76907
  Tim Gobbel
  Participant
  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

Viewing 6 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.