pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hélder M. Vieira <hmv@mail.telepac.pt>
To: pgsql-admin@postgresql.org
Subject: Re: Copy HL7 record/file into PostgreSQL Table
Date: Fri, 12 May 2006 22:54:18 +0100
Message-ID: <005a01c6760e$9e55ca40$6200a8c0@hmv02> (raw)
References: <B37BD591-E458-4C5B-88A3-094F32AF8BD5@scottshill.com>
	<1147453260.9755.116.camel@state.g2switchworks.com>
	<7D1BD819-CD34-4760-8C7A-89F944A4D589@scottshill.com>
	<4464CE12.8070900@commandprompt.com>

HL7 is a complex standard, because the reality it tries to describe is 
complex. It was designed (and is still being designed) to allow the transfer 
of all kinds of information related with health institutions.
So, depending on the specific institutions and purposes involved, either the 
HL7 messages flowing between them contain a small and simple set of useful 
information, and therefore might be parsed on the fly, or they contain a 
full load of technical, administrative and financial information and 
therefore demand a slightly more complex parser and a lot of related tables 
and business rules.
I guess it would be important to Sean to get more specific information on 
the task, because the parser will probably be the least complicated part of 
it.


Hélder M. Vieira



----- Original Message ----- 
From: "Joshua D. Drake" <jd@commandprompt.com>
To: "Kenneth B. Hill" <ken@scottshill.com>
Cc: "Scott Marlowe" <smarlowe@g2switchworks.com>; 
<pgsql-admin@postgresql.org>
Sent: Friday, May 12, 2006 7:04 PM
Subject: Re: [ADMIN] Copy HL7 record/file into PostgreSQL Table


> Kenneth B. Hill wrote:
>> 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 *might* actually not have to parse this... just use | as your 
> delimiter with copy.





view thread (10+ messages)  latest in thread

Message-ID: <005a01c6760e$9e55ca40$6200a8c0@hmv02>
Permalink:  ../005a01c6760e$9e55ca40$6200a8c0@hmv02/
Also on:    postgresql.org/message-id/005a01c6760e$9e55ca40$6200a8c0@hmv02

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: hmv@mail.telepac.pt
  Subject: Re: Copy HL7 record/file into PostgreSQL Table
  In-Reply-To: <005a01c6760e$9e55ca40$6200a8c0@hmv02>
  References: <B37BD591-E458-4C5B-88A3-094F32AF8BD5@scottshill.com> <1147453260.9755.116.camel@state.g2switchworks.com> <7D1BD819-CD34-4760-8C7A-89F944A4D589@scottshill.com> <4464CE12.8070900@commandprompt.com> <005a01c6760e$9e55ca40$6200a8c0@hmv02>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox