HSP_BUCKET_2

Description:

This table contains hospital liability bucket information from the Hospital Liability Buckets (HLB) master file. This table does not include information for pre-allocated HLB records that are not yet in use.

Primary Key

Column Name	Ordinal Position
BUCKET_ID	1

Column Information

	Name	Type	Discontinued?
1	BUCKET_ID	NUMERIC	No
	The unique identifier (.1 item) for the bucket record.
2	TIMELY_FILING_DATE	DATETIME	No
	The timely filing deadline date for insurance buckets. This is blank for Late Write Off and Supplemental Payment Claim buckets.
3	REPLACEMENT_TIMELY_FILING_DATE	DATETIME	No
	The replacement timely filing deadline date for insurance buckets. This is blank for Late Write Off and Supplemental Payment Claim buckets.
4	AR_CLASSIFICATION_C_NAME	VARCHAR	No
	This column stores the A/R classification of this bucket. May contain organization-specific values: No Category Entries: Active AR External AR Bad Debt Outsourced Received Self-Pay Active AR Received Self-Pay External AR Received Self-Pay Bad Debt
5	BUCKET_CLAIM_STATUS_C_NAME	VARCHAR	No
	The current claim status associated with the claim status update for the accepted claim on the bucket. May contain organization-specific values: No Category Entries: Received Rejected Accepted Pended In Progress Forwarded Adjudicated Revised Payment Expected Denial Expected Not Found Claim Split Data Error System Error Notification Unmapped Code
6	BUCKET_AR_STATUS_C_NAME	VARCHAR	No
	A status for the bucket with detail about which stage of the billing cycle the AR is at. May contain organization-specific values: No Category Entries: In-House - Unbilled Held for Minimum Days Candidate for Billing Late Charges Claim Rejected Billed to Payer Pending Claim Resubmission Open Denial Open Underpayment Other Open Follow-up Closed Denial - Waiting on Payer Closed Underpayment - Waiting on Payer Closed Denial - Pending Write-Off Closed Underpayment - Pending Write-Off Billed to Self-Pay Credit Balance - Prepaid Zero Balance Open Debit Balance Open Credit Balance Credit Balance - Pending Refund Credit Balance - Candidate For Billing Credit Balance - Billed to Payer
7	CURRENT_CLAIM_PRINT_ID	NUMERIC	No
	The current active claim that is associated with the bucket. If the bucket has multiple active claims, this value will be the first claim.
8	TOTAL_REFUND_AMT	NUMERIC	No
	The total refund amount for the bucket.
9	TOTAL_ADJ_EXCL_REFUND_AMT	NUMERIC	No
	The total adjustment amount for the bucket, excluding refunds.