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.