| From: | "Kenneth B(dot) Hill" <ken(at)scottshill(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Copy HL7 record/file into PostgreSQL Table |
| Date: | 2006-05-12 17:27:37 |
| Message-ID: | 7D1BD819-CD34-4760-8C7A-89F944A4D589@scottshill.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-05-12 17:50:37 | Re: Copy HL7 record/file into PostgreSQL Table |
| Previous Message | Joshua D. Drake | 2006-05-12 17:14:37 | Re: Copy HL7 record/file into PostgreSQL Table |