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	NUMERIC	No
	Unique Identifier for diagnosis record used to document patient's admission 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.