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.