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.