The HL7 Comprehensive Database: Corrections to Version 1

Home -> HL7 -> Comprehensive Database -> Corrections to Version 1
 

Suggested Corrections to the Database

The database sold by Health Level Seven, Inc. unfortunately is not free of errors. Nevertheless this homepage should provide a means to inform about necessary corrections which should by applied to the database.

In order to reduce the amount of effort the are sorted chronologously.

Suggested Corrections to Tables

Table Version Value Comment Correction
MessageStructIDSegments 2.3.1
2.3
2.2		 Messagedefinition for O01 and O02 contain segment OBR replace single segment by sequence < OBR| RQD| RQ1| RXO| ODS| ODT>
MessageStructIDSegments 2.1 Messagedefinition for O01 and O02 contain segment OBR replace single segment by sequence < OBR| ORO| RX1>
TableValues 2.3.1 ORM__O01 OFM_O01 change
TableValues 2.3.1 RROR_ROR ROR_ROR change
TableValues 2.3.1 SIIU_S12 SIU_S12 change
TableValues 2.3.1 PIN_107 PIN_I07 change
TableValues 2.3.1 RRE_O01 RRE_O02 change
TableValues 2.3.1 ACK
OMS_O01
OMN_O01
OMD_O01
ORS_O02
ORN_O02
ORD_O02
RDO_O01
RRO_O02		   add
MsgStructIDs 2.3.1 SIIU_S1 
RROR_RO		   delete
TableValues 2.3   all values from MsgStructIDs add
Tables 2.3 0354   add
EventMessage TypeSegments (events I08, I09, I10, I11) 2.3 [ { NTE } ] OBX change the order of the segments to:
OBX [ { NTE } ]		 change
EventMessageTypes 2.3.1 I08@2.3.1@RQA@RPA@RQA_I08@RPA_I08
I09@2.3.1@RQA@RPA@RQA_I08@RPA_I08
I10@2.3.1@RQA@RPA@RQA_I08@RPA_I08
I11@2.3.1@RQA@RPA@RQA_I08@RPA_I08
I12@2.3 1@REF@RRI@REF_I12@RRI_I12 
I13@2.3 1@REF@RRI@REF_I12@RRI_I12
I14@2.3 1@REF@RRI@REF_I12@RRI_I12
I15@2.3 1@REF@RRI@REF_I12@RRI_I12
PC1@2.3 1@PPR@ACK@PPR_PC1@ACK 
PC2@2.3 1@PPR@ACK@PPR_PC1@ACK
PC3@2.3 1@PPR@ACK@PPR_PC1@ACK
PC6@2.3 1@PGL@ACK@PGL_PC6@ACK
PC7@2.3 1@PGL@ACK@PGL_PC6@ACK
PC8@2.3 1@PGL@ACK@PGL_PC6@ACK
PCB@2.3 1@PPP@ACK@PPP_PCB@ACK
PCC@2.3 1@PPP@ACK@PPP_PCB@ACK
PCD@2.3 1@PPP@ACK@PPP_PCB@ACK
PCG@2.3 1@PPG@ACK@PPG_PCG@ACK
PCH@2.3 1@PPG@ACK@PPG_PCG@ACK
PCJ@2.3 1@PPG@ACK@PPG_PCG@ACK		 "@" is the separator add
Components 2.2 component 45 ()
component 120 (location)		 data_structure = AD change
Components 2.3
2.3.1		 component 218 (price) data_structure = MO change
Components 2.3.1 component 137 (privilege class)
component 120 (privilege)
component 81 (units)
component 217 (range units)		 data_structure = CE change
Components 2.2 component 63 (quantity) data_structure = CQ_QUANTITY change
Components 2.3
2.3.1		 component 241 (application ID) data_structure = HD change
Segments RXD-13, RXG-11 2.3 data element: 00299 => 01303 wrong reference change

Suggested Corrections to Queries

Query Suggested Correction Comment
xInconsistency: MessageStructure without Values in Table 354 SELECT DISTINCTROW MsgStructIDs.message_structure, MsgStructIDs.hl7_version, TableValues.hl7_version, TableValues.table_value, MsgStructIDs.description, TableValues.table_id 
FROM MsgStructIDs LEFT JOIN TableValues ON (MsgStructIDs.hl7_version = TableValues.hl7_version) AND (MsgStructIDs.message_structure = TableValues.table_value) 
WHERE (((TableValues.hl7_version) Is Null)) 
ORDER BY TableValues.hl7_version, TableValues.table_value; 		 add
xInconsistency: Table 354 without MessageStructure SELECT DISTINCTROW TableValues.hl7_version, TableValues.table_value, MsgStructIDs.message_structure, MsgStructIDs.hl7_version, MsgStructIDs.description, TableValues.table_id 
FROM TableValues LEFT JOIN MsgStructIDs ON (TableValues.table_value = MsgStructIDs.message_structure) AND (TableValues.hl7_version = MsgStructIDs.hl7_version) 
WHERE (((MsgStructIDs.message_structure) Is Null) AND ((MsgStructIDs.hl7_version) Is Null) AND ((TableValues.table_id)=354)) 
ORDER BY TableValues.hl7_version, TableValues.table_value; 		 add
xInconsistency: Events without EventMessagetypes refer to attribute "chapter" instead of "page" change
xInconsistency: Components with unknown data structures SELECT Components.comp_nr, Components.hl7_version, Components.description, Components.data_structure, DataStructures.data_structure
FROM Components LEFT JOIN DataStructures ON (Components.data_structure = DataStructures.data_structure) AND (Components.hl7_version = DataStructures.hl7_version)
WHERE (((Components.data_structure)<"") AND ((DataStructures.data_structure) Is Null));
 		 add

 

 

Last Update : September 4, 2000