HSP_ACCT_CVG_LIST

Description:

This table contains hospital account and PB visit coverage list 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
	This column stores the unique identifier for the hospital account.
2	LINE	INTEGER	No
	This column stores the line number in the results of a query. As multiple coverages can be associated with one hospital account, each coverage will have a unique line number.
3	COVERAGE_ID	NUMERIC	No
	This column stores the unique identifier for the coverage associated with the hospital account.
4	CVG_IGNR_PRIM_PAY_YN	VARCHAR	No
	This item stores whether the coverage was ignored for being assigned as primary payer. Typically the first coverage in the coverage list is used for primary payer, but a subsequent coverage may be assigned in some cases instead. May contain organization-specific values: No Category Entries: No Yes
5	CVG_IGNR_RSN_C_NAME	VARCHAR	No
	This item stores the reason why the coverage was ignored for primary payer. Typically the first coverage in the coverage list is used to determine primary payer, but a subsequent coverage may be assigned in some cases instead. May contain organization-specific values: No Category Entries: Coverage Billed for LTC Denial Coverage Billed for Home Infusion Denial Coverage Manually Skipped for Financial Class Reporting
6	CVG_TIMELY_FILING_DATE	DATETIME	No
	This item stores the timely filing date for the coverage. The date is updated as the HAR changes and remains populated after the HAR is closed for reporting purposes. The date stamped is the earliest timely filing date from any active, non-closed buckets for this coverage. If no buckets are active, for primary coverages the prebilled bucket is used to calculate the expected timely filing. For secondary coverages with non active buckets, the NRP deadline is used from the previous coverage.