Each Condition for every Person, along with its matching standard concept code from the Terminology Dictionary, is extracted from the source data along with the person identifier, start/onset date of the condition, end date for condition (where available), and diagnosis qualifier (DX_QUALIFIER) attributes. Special handling is necessary for source data in which person condition entries are updated by expiration of the current entry and addition of an updated entry. In such cases, only the final version of the record is extracted for inclusion in the CDM. Example of Loaded Table Consider the following example of inbound source data on medications, from GE EHRs. PERSON ICD-9 PROBLEM DESCRIPTION PROBLEM PROBLEM DX ID DIAGNOSIS START END QUALIFIER CODE DATE DATE 127260 787.02 Nausea Diagnosis Of 127260 787.02 Nausea Diagnosis Of 127260 531.01 Acute gastric ulcer without Diagnosis Of hemorrhage or perforation without obstruction The following concept codes correspond to the meanings of the problems captured in the source data: Concept Code Concept Description GDS999y Gastric Ulcers GDS999x Nausea Condition Occurrence types are determined for Conditions extracted from EHR Problem list as follows. Condition Occurrence Type Condition Occurrence Type Description 063 EHR - Problem List The CONDITION_URCE, loaded with the above data, would appear as follows. SOURCE DX UR-CE ID ID UR TYPE START END CONCEPT CODE DATE DATE CODE 3003 127260 GDS999x 787.02 063 Diagnosis Of 3004 127260 GDS999x 787.02 063 Diagnosis Of 3005 127260 GDS999y 531.01 063 Diagnosis Of
Each Condition for every Person, along with its matching standard concept code from the Terminology Dictionary, is extracted from the source data along with the person identifier, start/onset date of the condition, end date for condition (where available), and diagnosis qualifier (DX_QUALIFIER) attributes. Special handling is necessary for source data in which person condition entries are updated by expiration of the current entry and addition of an updated entry. In such cases, only the final version of the record is extracted for inclusion in the CDM. Example of Loaded Table Consider the following example of inbound source data on medications, from GE EHRs. PERSON ID ICD-9 DIAGNOSIS CODE PROBLEM DESCRIPTION PROBLEM START DATE PROBLEM END DATE DX QUALIFIER 127260 787.02 Nausea Diagnosis Of 127260 787.02 Nausea Diagnosis Of 127260 531.01 Acute gastric ulcer without hemorrhage or perforation without obstruction Diagnosis Of The following concept codes correspond to the meanings of the problems captured in the source data: Concept Code Concept Description GDS999y Gastric Ulcers GDS999x Nausea Condition Occurrence types are determined for Conditions extracted from EHR Problem list as follows. Condition Occurrence Type Condition Occurrence Type Description 063 EHR - Problem List The CONDITION_URCE, loaded with the above data, would appear as follows. UR-CE ID ID CONCEPT CODE SOURCE CODE UR TYPE START DATE END DATE DX 3003 127260 GDS999x 787.02 063 Diagnosis Of 3004 127260 GDS999x 787.02 063 Diagnosis Of 3005 127260 GDS999y 531.01 063 Diagnosis Of
7b3fb0f7acda70533b966d2834fef4ded62a97be.docx