HRL and Repeating PO Lines

[Bevan Klassen]

I am using the HRL Configurator to build a proprietary record layout for an External Purchase Order (PO).  Despite the HRL Configurator indicating that I can use a ‘Repeat Block’ for repeating PO Lines, I cannot.  This has been confirmed by Cloverleaf Support.  (I can use the ‘Repeat While’ functionality for PO Instructions though.)  My data has the following different variable length segments and cardinality:

  PO_H – Purchase Order (PO) Header

     PO_I – PO Instructions

     PO_L – PO Lines

        PO_L_L – PO Line Lot

        PO_L_S – PO Line Scheduled Deliveries

        PO_L_DESC – PO Line Descriptions

  A PO_H can have multiple PO_I and PO_L.  A PO_L can have multiple

  PO_L_L, PO_L_S, and PO_L_DESC.

  Data Sample:

     PO_H      ~Retransmit~RM~MISFL   …

     PO_I      ~RM~0000001337~00001~…

     PO_I      ~RM~0000001337~00003~…

     PO_L_D    ~RM~0000001337~00001~…

     PO_L      ~RM~CNL       ~0000001337…

     PO_L_D    ~RM~0000001337~00001~…

     PO_L      ~RM~CNL       ~0000001337…

     PO_L      ~RM~CNL       ~0000001337…

One suggestion that I have been given is to write a proc to convert the proprietary record layout to HL7.  This will be very time consuming.  I’m wondering if anyone has any other suggestions to simplify this task and still use Cloverleaf tool functionality?

Bevan.

Topic

[Kevin Scantlan]

It amazes me that this part does not work.  I’ve been trying for some time, too.   HL7 is just a specialized HRL and VRL structure.  So, if the specific works why can the general case work?

I’ve had a co-worker suggest that all I write a script puts a MSH segment in the front and then create a Z segment for each segment in the layout.  Then set up a HL7 variant that describes this message.  Seems like a lot of trouble, too, but it should work.

[garry r fisher]

Hi,

You could use Tcl to pre or post process your format. I have done something similar and used a combination of inbound TPS to preformat the data, an Xlate on a HRL (built up on vrl’s with a repeating block) followed by an outbound TPS to final format the record.

The HL7 method also works and I’ve used that on other occassions. I look at the data first and see which is the best fit but sometimes its not obvious until you’ve done both:-)

Regards

Garry

[Bevan Klassen]

Garry and Kevin thank you for your input on this problem.  I’ll post again to this thread once we decide on a solution.

Bevan.

[Author]

Replies