Diagnosis
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 |