eMaRC Plus imports HL7 batch files, parses the messages and stores HL7 data elements to tables in the PATHLAB database. A mapping table, called DATAMAP, contains the mapping of HL7 data elements to fields of tables (refer to Local Customization section below to see how individual states can use this table to select additional data items for storage). There are 7 data tables, MSH, PV1, PID, ORC, OBR, OBX, and OBXCOMBINEDTEXT, the first 6 of which correspond to the 6 segments of the ORU^01 message. Data elements can be stored at the field, component or sub-component level. The hierarchical relationships among segments are maintained in the database.
To simplify processing and use of text data, in addition to the OBX table which stores data elements of individual OBX segments as separate records, the text field (OBX-5) of all OBX segments that belong to an OBR segment are combined and inserted as one row in the OBXCOMBINEDTEXT table. This table has 8 fields to store texts of the OBX segments, and depending on the LOINC code in the OBX-3 field, the text of OBX-5 will go into one of these 8 text fields.
Raw HL7 messages are also saved to the HL7MESSAGES table.
|
