HAR_ALL

Description:

Generic table that contains every hospital account record regardless of its type. It also contains the patient record that is associated with the hospital account.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account.
2	PAT_ID	VARCHAR	No
	This column stores the unique identifier for the patient associated with this hospital account.
3	PRIM_ENC_CSN_ID	NUMERIC	No
	The contact serial number associated with the primary patient contact.