HSP_ACCT_CONS_SP_CVG

Description:

This table contains Consolidated Self Pay coverage information from the Hospital Accounts Receivable 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 unique identifier (.1 item) for the hosp acct record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	PAYER_NAME	VARCHAR	No
	The name of the coverage payer.
4	PLAN_NAME	VARCHAR	No
	The name of the coverage plan.
5	SOURCE_CVG_IDENT	VARCHAR	No
	The source system's coverage ID.
6	SUBSCRIBER_NUM	VARCHAR	No
	The unique ID of the subscriber for this coverage.
7	SUBSCRIBER_NAME	VARCHAR	No
	The name of the subscriber for this coverage.
8	PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
9	MEMBER_NUM	VARCHAR	No
	The member ID of the coverage.