HSP_ADMIT_DIAG

Description: |
The HSP_ADMIT_DIAG table contains information on admission diagnoses. This table is based on patient contact serial number.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | LINE | INTEGER | No |
The line number of the admission diagnosis for the patient.
2 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
3 | ADMIT_DIAG_TEXT | VARCHAR | No |
Free text admission diagnosis for the patient.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.