Re: Copy HL7 record/file into PostgreSQL Table - Mailing list pgsql-admin

An HL7 file is a tagged file used to transfer electronic health
records. The file looks like:

MSH|^~\&|EPIC|EPICADT|SMS|SMSADT|199912271408|CHARRIS|ADT^A04|1817457|
EVN|A04|199912271408|||CHARRIS
PID||0493575^^^2^ID 1|454721||DOE^JOHN^^^^|DOE^JOHN^^^^|19480203|M|
NK1||CONROY^MARI^^^^|SPO||(216)731-4359||EC|||||||||||||||||||||||||||
PV1||O|168 ~219~C~PMA^^^^^^^^^||||277^ALLEN FADZL^BONNIE^^^^||||||||||

You can download a PDF for details here:

http://www.hl7.org/Special/IG/final.pdf

-Ken

On May 12, 2006, at 10:01 AM, Scott Marlowe wrote:

> On Fri, 2006-05-12 at 11:41, Kenneth B. Hill wrote:
>> I'm looking for a way to get an HL7 file into a table. My current
>> thinking is I need to parse the HL7 file to a flat-file and use the
>> copy command. I would appreciate some guidance on doing this.
>> Thank you.
>
> I'd love to help out.
>
> Just one thing... What's an HL7 file?