This table contains hospital account patient contact serial number (CSN) information from the Hospital Accounts Receivable (HAR) master file.
Primary Key
Column Name
Ordinal Position
HSP_ACCOUNT_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
HSP_ACCOUNT_ID
NUMERIC
No
The ID number of a hospital account.
2
LINE
INTEGER
No
The line number in the results of a query. Since multiple patient contacts can be associated with one hospital account, each contact will have a unique line number.
3
PAT_ENC_CSN_ID
NUMERIC
No
The unique identifier for the treatment plan record.