The syntax of the mapping table is:
[fieldname] , [HL7 segment code] , [field number] , [sub-field number] , [format code]
The following is an example of a mapping table for importing orders 'i.e. ORM messages' into the Orders table.
The mapping table is defined in the "Mapping" page of the MTORDER profile record.
PATIENTID,PID,18,1
ORDERNO,OBR,3,1
ORDERNO2,OBR,2,1
ORDERDR,OBR,16,1
ORDERDRNM,OBR,16,2,DOCNAME
EXAMCODE,OBR,4,1
EXAMDESC,OBR,4,2
EXAMDATE,OBR,27,4,DATE
EXAMTIME,OBR,27,4,TIME
ORDERDATE,OBR,6,1,DATE
ORDERTIME,OBR,6,1,TIME
REASON,OBR,31,2
STATUS,ORC,5,1