Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Mapping Multiple Fields of an Incoming HL7 Message to a Single Table Column |
 | ||
| Before proceeding, download this sample VMD file that you can use to perform the steps in this section. | ||
 |
Consider the following message:
MSH|^~\&|ADV-LABLOG|WML|MEDICALCENTER|NAPOLEAN|200603170742||ORU^R01|14589|P|2.5|| 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.