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.
10 | CONTRACTUALIZED_STS_C_NAME | VARCHAR | No |
The current contractualized status of the bucket.
May contain organization-specific values: No
Category Entries:
Uncontractualized
Expected Contractual Calculated
Pending Resolution
Contractualized
Secondary
Self-Pay
Undistributed
11 | POSTED_NA_WOFF_AMT | NUMERIC | No |
The monetary amount that has been posted as a contractual not-allowed write-off to the bucket. The amount is calculated based on the adjustments posted to the bucket.