HPF_ADMIT_DIAG

Description:

This 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 for the information associated with this contact. Multiple pieces of information can be associated with this contact.
2	DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
3	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.