HRL Question

Hi Jim,

Yes I am using newline and it is defined in the global config.  My HRL has both VRL.  Only the 2nd VRL in HRL is defined with REPEAT WHILE.

I’m still testing the HRL through the testing tool.  This is where I see that messages do not have both records populating.  Record 01 is there but Record 2 is empty (see below ouput):

Command output:

MESSAGE 1

Field Number:          1

Field Name:            Record01

— Begin VRL Segment Record01 —  

Length of Repeat Field:         55

Repeat Field Offset from Field: 0

                 RecType: ch >01<

                Facility: ch >1001<

                  SHCnum: ch >2001<

                    EMRN: ch >3001<

         PatientLastName: ch >4001<

        PatientFirstName: ch >5001<

       PatientMiddleInit: ch >6001<

           PatientSuffix: ch >7001<

           PatientPrefix: ch >8001<

                     DOB: ch >9001<

                  Gender: ch >10001<

                    Race: ch ><

         PatientAddress1: ch ><

         PatientAddress2: ch ><

             PatientCity: ch ><

            PatientState: ch ><

              PatientZip: ch ><

          PatientCountry: ch ><

               HomePhone: ch ><

             VisitNumber: ch ><

            PatientClass: ch ><

         PatientLocation: ch ><

           AdmissionType: ch ><

          AttendingDocID: ch ><

        AttendingDocLast: ch ><

       AttendingDocFirst: ch ><

          ReferringDocID: ch ><

        ReferringDocLast: ch ><

       ReferringDocFirst: ch ><

            ConsultDocID: ch ><

          ConsultDocLast: ch ><

         ConsultDocFirst: ch ><

         HospitalService: ch ><

             AdmitSource: ch ><

              AdmitDocID: ch ><

            AdmitDocLast: ch ><

           AdmitDocFirst: ch ><

           DischargeDisp: ch ><

               AdmitDate: ch ><

           DischargeDate: ch ><

          PlacerOrderNum: ch ><

             OrderStatus: ch ><

QuantityTimingPriorityORC: ch ><

           OrderingDocID: ch ><

         OrderingDocLast: ch ><

        OrderingDocFirst: ch ><

          FillerOrderNum: ch ><

   UniversalSericeIDcode: ch ><

   UniversalServiceIDdes: ch ><

     ObservationDateTime: ch ><

       ResultRptStatusDT: ch ><

       ResultStatusOBR25: ch ><

QuantityTimingPriorityOBR: ch ><

       PrincipleInterpID: ch ><

     PrincipleInterpLast: ch ><

    PrincipleInterpFirst: ch ><

—- End VRL Segment Record01 —-  

Field Number:          2 (empty)

Field Name:            Record02

Thanks,

Bart.

Hi Jim, the terminating character for all records is 0xa and per your suggestion I have set global properties on the VRLs to match, however, my testing output of the HRL is still lacking the 02 Record data fields.

Charlie, normalizing via Tcl sounds like a great way to go, but I’d sure like to get a good handle on using HRL with VRLs.

If it starts taking me any longer I’ll probably go Charlie’s route…

Thanks again everyone for your time and guidance.

Bart.

Hi Robert,

Thanks for your input.  Looks like I’m getting data now (at least in the testing tool), I’m glad you and Jim had me check my terminator characters again in my VRL global properties.  I had xa instead of x0a.  I also had to create a HRL within an HRL (this stuff is confusing).  My current HRL contains a repeating VRL for the 01 record and an additional HRL with a repeating VRL for the 02 records.  Seems to work, time will tell.

Basic structure:

HRL

  VRL (repeats for 01 records in a file)

  HRL

     VRL (repeats the 02 records under the 01 record)

Detailed HRL structure for the 01 (VRL) and 02 records (HRL):

{NAME Record01} {TYPE fmt} { FMT {

   { RECORD EKG_Extract_01Record.vrl }

   { RECORD_TYPE vrl }

   { REPEATWHILE {

       {

           { FIELD Record01.RecType }

           { VALUE 01 }

       }

   } }

}}

{NAME Segment} {TYPE fmt} { FMT {

   { RECORD test_bart_HRL02.hrl }

   { RECORD_TYPE hrl }

}}

Detailed structure for the second HRL for the 02 records

{NAME Record02} {TYPE fmt} { FMT {

   { RECORD EKG_Extract_02Record.vrl }

   { RECORD_TYPE vrl }

   { REPEATWHILE {

       {

           { FIELD Record02.RecType }

           { VALUE 02 }

       }

   } }

}}

And this is not even getting to the Xlate.  Now I know why Charlie advised (correctly) to use Tcl to create a dummy message (MSH, Z01, {Z02}).  Now to spend some time figuring out Tcl to split up the file to multiple messages… this is getting fun… I learned a lot regarding HRL/VRL.

Thanks all and Merry Christmas and have a Happy 2011.

Bart.

Hi Robert,

You’re correct a single HRL with a VRL for the 01 followed by a VRL for the 02 that is repeating would be nice.  I created the HRL within the HRL business since I had a pseudo test file with multiple 01 and associated 02 records.  This overkill HRL was to handle this scenario since I did not have a Tcl proc to break up the messages, if I did then the more direct HRL could have been used.  I’m still trying to figure out how to split up the file to multiple messages so I can use the more simplified HRL or just go with the dummy message and create a variant to xlate with.

Thanks,

Bart.