Mapping Multiple Fields of an Incoming HL7 Message to a Single Table Column

MSH|^~\&|ADV-LABLOG|WML|MEDICALCENTER|NAPOLEAN|200603170742||ORU^R01|14589|P|2.3||
PID|1||102688||JOHNSON^TYLER||19590910|M|||||||||||5713448509|
ORC|RE||27828002^||F|N|||200603011208|||1VANL^GUTIERREZ^NOEL^M.D.|W2||200603011208||
OBR|1||27828002^|1|27828002^|||200603011355|||WML||||200603011208||D84051|||||||||F|
OBX|1|FT|13690106^Vaccination adverse events and treatment, if any^LN|1|Observation: Patient has a fever of 106F, with vomiting,|
OBX|2|FT|13690106^|1|seizures, and persistent crying lasting over 3 hours. |
OBX|3|FT|13690106^|1|Patient also has a loss of appetite and refuses medical|
OBX|4|FT|13690106^|1|attention.|

In the above message, you will notice that there are three repeats of the OBX segment. In the VMD file, each repeat of the OBX segment currently maps to multiple rows, one for each repeat.

You will test what the message looks like when it is parsed in the next section.

Parsing the Sample Message
Creating the Python Code
Modifying the Table Grammar
Adding the ResultInformation Table to the Table Grammar
Re-Parsing the Sample Message
Completed VMD File

iNTERFACEWARE™ Inc.

Mapping Multiple Fields of an Incoming HL7 Message to a Single Table Column