HSP_ACCT_PAT_CSN

Description:

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.