Re: Re: add unique number to field

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf add unique number to field Re: Re: add unique number to field

#56749
Brian Goad
Participant

    Jason Bond wrote:

    I have a one time file conversion from a vrl to hl7 to run to import data from one emr to another.  I need a unique number identifier for each patient.  So I need to have a proc or tool to add a number to a field and count up by one for each message.  Any ideas would be greatly appreciated.

    Jason you say you need a unique number for each patient, does that mean you are looking for something that will create a number for the patient and if farther into the file you find the same patient use the number you created? Or would you create a new number for this message.

    In other words:

    ADT’s

    A01 for admit

    A08 for update

    have same unique ID

    Brian