Repeating VRL inside HRL

[Huy Tran]

I have a text file and need to convert it to DFT_P03. A transaction starts with D|number| line and ends with D|$CHARGE| line. ODOA at the end of each line.

I have HRL and 2 VRL. Header.vrl; Data.vrl.

In HRL: Header.vrl – No Repeat

           Data.vrl –    Repeat while

                             Field: Data.Num

                             Value: $CHARGE

I’m not getting the repeating data in HRL.  I even got a script to map odoa to ~…trial and error with this option but didn’t work out either.

Could someone please let me know what I’m missing?

Thanks in advance.

H|10012010|MHS|WinSURGE|35.1

D|number|1,1|S10-10546|S10-10546

D|patientbillingnumber|1,1|S10-10546|4005618789

D|patient.number|1,1,1|S10-10546|2641281

D|patient.ssn|1,1,1|S10-10546|123-45-6789

D|patient.name|1,1,1|S10-10546|SMITH, BETTY

D|$PTDOB|1,1|S10-10546|07181967

D|patient.sex|1,1,1|S10-10546|Female

D|patient.address|1,1,1|S10-10546|7828 ELM ST

D|patient.city|1,1,1|S10-10546|MIRAMAR

D|patient.state|1,1,1|S10-10546|FL

D|patient.zip|1,1,1|S10-10546|33023

D|$PTTEL|1,1|S10-10546|$UNKNOWN

D|clin.address|1,1,1|S10-10546|3449 JOHNSON STREET

D|clin.address|1,1,2|S10-10546|HOLLYWOOD,FL  33021

D|$COLLDT|1,1|S10-10546|09022010

D|colldate|1,1|S10-10546|09022010

D|sodate|1,1|S10-10546|10012010

D|dept.name|1,1,1|S10-10546|MRH INPATIENT

D|dept.abbr|1,1,1|S10-10546|MRHIN

D|$CHARGE|1,1|S10-10546|+1 CPT=0007090183 ICD9=^1^0007090183

D|number|2,1|S10-10804|S10-10804

D|patientbillingnumber|2,1|S10-10804|4005654622

D|patient.number|2,1,1|S10-10804|2093645

D|patient.ssn|2,1,1|S10-10804|987-65-4321

D|patient.name|2,1,1|S10-10804|BILL, ROY

D|$PTDOB|2,1|S10-10804|07271961

D|patient.sex|2,1,1|S10-10804|Female

D|patient.address|2,1,1|S10-10804|1111 N UNIVERSITY DR 468

D|patient.city|2,1,1|S10-10804|CORAL SPRINGS

D|patient.state|2,1,1|S10-10804|FL

D|patient.zip|2,1,1|S10-10804|33067

D|$PTTEL|2,1|S10-10804|$UNKNOWN

D|clin.address|2,1,1|S10-10804|3700 JOHNSON STREET

D|clin.address|2,1,2|S10-10804|HOLLYWOOD,FL  33021

D|$COLLDT|2,1|S10-10804|09082010

D|colldate|2,1|S10-10804|09082010

D|sodate|2,1|S10-10804|09282010

D|dept.name|2,1,1|S10-10804| BREAST CENTER

D|dept.abbr|2,1,1|S10-10804|BRC

D|$CHARGE|2,1|S10-10804|+1 CPT=0007090474 ICD9=^1^0007090474

Topic

[Jim Kosloskey]

Huy,

Make sure you have the 0D0A set in your VRL global options as the mesage termination characters.

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

[Robert Kersemakers]

Hi Huy,

I think your HRL definition is wrong: you try to select the $CHARGE lines in the HRL, but you will need to do that in the Xlate. You HRL definition should include all lines of the incoming message. So you should change it to:

In HRL: Header.vrl – No Repeat

            Data.vrl –    Repeat while

                              Field: Data.

                              Value: D

Hope this helps.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Huy Tran]

Thanks Jim, Yes, I had odoa as Terminator in Global Properties.

Robert, Thanks for the info on repeating field. I’m still getting the same result. When run HRL testing tools I have over 1000 messages, it treats each line as 1 message because of odoa.

I was hoping if configured the HRL/VRL correctly, it should combined all lines into one message. In Xlate, use ITERATE and CONTINUE to generate one DFT transaction per $CHARGE. Please let me know if there’s a better way.

Thank You.

[Jim Kosloskey]

Huy,

Have you tried different styles for the file in the tester (end of file might work)?

It might be the tester that is breaking the inbound file up for the Xlate.

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

[Huy Tran]

Looking at my data more carefully, I’d need to create another HRL inside HRL for repeating group… don’t want to open up that can. Got a procs to convert the text file into HL7 (look alike) format. Then dummy up a message type (DFT_Z03) to parse it. It works for me.  A lot easier to deal with repeating group in HL7 than HRL. That HRL stuff is hard for me.

Thanks Jim and Robert for the help.

[Author]

Replies