‹ Back


The DIAGNOSIS table contains a list of the diagnoses associated with a patient’s encounter.

Field Name Field Description
DIAGNOSIS_ID The unique primary identifier of the diagnosis table
ENCOUNTER_ID The foreign key linking the record to the encounter table
DIAGNOSIS_DT_TM Date/time for which the Diagnosis was saved
DIAGNOSIS_CODE SNOMED code for the diagnosis
DIAGNOSIS text description of the SNOMED diagnosis
DIAGNOSIS_TYPE Care phase in which this diagnosis was assigned (e.g. discharge)
DIAGNOSIS_CLASSIFICATION Indicates if the diagnosis was made by the emergency physician or not
DIAGNOSIS_CONFIRMATION Indicates if the diagnosis is confirmed