HSP_DISCH_DIAG

Description: |
The HSP_DISCH_DIAG table contains information on inpatient discharge diagnoses. Each record in this table is based on PAT_ENC_CSN_ID

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 discharge diagnosis for the patient.
2 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
3 | DISCH_DIAG_CMNT | VARCHAR | No |
Free text discharge 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.