HSP_BUCKET
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
This column stores the unique identifier for the liability bucket.
2 BUCKET_NAME VARCHAR No
The name of the liability bucket.
3 HSP_ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the hospital account to which the liability bucket is linked.
4 BKT_TYPE_HA_C_NAME VARCHAR No
The type of the liability bucket.
May contain organization-specific values: No
Category Entries:
Prebilled
Primary Claim
Secondary Claim
Self-Pay
Bad Debt
Interim Primary Claim
Interim Secondary Claim
Undistributed
Home Health RAP
Secondary Home Health RAP
Hospice Election
Secondary Hospice Election
Informational
Homing
5 CLAIM_TYPE_HA_C_NAME VARCHAR No
The type of claim associated with the liability bucket.
May contain organization-specific values: No
Category Entries:
New Claim
Late Replacement Claim
Late Charge Claim
Late Write Off
Supplemental Payment Claim
6 BKT_STS_HA_C_NAME VARCHAR No
The status of the liability bucket.
May contain organization-specific values: No
Category Entries:
Created
Queued
Processed
Printed
Outstanding
Error
Closed
Rejected
Replaced
7 CLOSE_REASON_HA_C_NAME VARCHAR No
The reason why the liability bucket was closed.
May contain organization-specific values: No
Category Entries:
Transferred
Zero Balance
Replaced
Late Write-Off
RAP Canceled
No Part B Charges
Alternate Payor Charges Only
SNF Part B Charges Only
SNF Non-Covered Part A
Informational Claim Accepted
8 COVERAGE_ID NUMERIC No
This column stores the unique identifier for the coverage associated with the liability bucket.
9 PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
10 BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
11 CURRENT_BALANCE NUMERIC No
The current balance on the liability bucket.
12 PREVIOUS_CREDITS NUMERIC No
The total monetary amount of credits on buckets from which liability was transferred to the bucket in question.
13 CHARGE_TOTAL NUMERIC No
The total monetary amount of charges on the liability bucket.
14 PAYMENT_TOTAL NUMERIC No
The total monetary amount of payments on the liability bucket.
15 ADJUSTMENT_TOTAL NUMERIC No
The total monetary amount of adjustments on the liability bucket.
16 NEXT_RESP_AMT NUMERIC No
The amount of liability that was transferred from this liability bucket to another bucket.
17 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
18 INTERIM_START_DATE DATETIME No
For an interim liability bucket, the billing start date. The first charge service date that is included in the bucket.
19 INTERIM_END_DATE DATETIME No
For an interim liability bucket, the billing end date. The last charge service date that is included in the bucket.
20 INTERIM_TYPE_C_NAME VARCHAR No
For an interim liability bucket, the interim bucket type. Choices are First Claim, Middle Claim, and Last Claim.
May contain organization-specific values: No
Category Entries:
First Claim
Middle Claim
Last Claim
21 LAST_CLAIM_DATE DATETIME No
The date of the last claim for the liability bucket.
22 PMT_DIST_COMP_YN VARCHAR No
This column stores whether payment distribution is complete.
May contain organization-specific values: No
Category Entries:
Yes
No
23 EXP_NA_WOFF_AMT NUMERIC No
This column stores the expected not-allowed write-off amount.
24 ACT_NA_WOFF_AMT NUMERIC No
This column stores the actual not-allowed write-off amount.
25 CURR_AUTO_WO_TX_ID NUMERIC No
This column stores the unique identifier for the current auto write-off transaction.
26 RVSE_AUTO_WO_TX_ID NUMERIC No
This column stores the unique identifier for the automatic write-off transaction's reversal on the liability bucket.
27 WO_ADJ_STATUS_C_NAME VARCHAR No
This column stores the write-off adjustment status.
May contain organization-specific values: No
Category Entries:
No Expected W/O, No Actual W/O
Expected W/O done, No Actual W/O
No Expected W/O, Actual W/O done
Expected W/O = Actual W/O
Expected W/O <> Actual W/O
28 MDCRE_B_CLM_FLG_C_NAME VARCHAR No
Indicates that the charges in the liability bucket should be submitted for Medicare part B claims processing.
May contain organization-specific values: No
Category Entries:
No
Yes - Part A Exhausted
Yes - Part B Only
29 CLAIM_FORM_TYPE_C_NAME VARCHAR No
The form type of the last claim on the bucket.
May contain organization-specific values: Yes
Category Entries:
CMS Claim
UB Claim
State Visit Data
State Visit Provider Data
Vektis Claim
Pharmacy Claim
30 EXTERN_AR_FLAG_YN VARCHAR No
External A/R Flag. This flag determines if a bucket's balance is to be counted as belonging to an external agency.
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
31 BAD_DEBT_FLAG_YN VARCHAR No
Bad Debt Flag. This flag determines if a bucket's balance is to be counted as belonging to a bad debt agency.
The category values for this column were already listed for column: EXTERN_AR_FLAG_YN
32 PYR_RCVD_DATE DATETIME No
This column stores the date on which the latest claim for the associated liability bucket was received by a payer.
33 FST_PYR_RCVD_DATE DATETIME No
This column stores the date on which the first claim for the associated liability bucket was received by a payer.
34 WO_CPTN_TX_ID NUMERIC No
This column stores the unique identifier for the transaction used to write off non-covered charges using a system action.
35 LEVEL_OF_CARE_C_NAME VARCHAR No
The category number of the patient's Level of Care on the interim bill start date associated with this bucket.
May contain organization-specific values: Yes
36 USE_EXIST_DATA_YN VARCHAR No
Indicates whether the claims processor should use data from an existing claim when resubmitting or demanding a new claim.
May contain organization-specific values: No
Category Entries:
No
Yes
37 ALT_PAY_YN VARCHAR No
This column stores whether this bucket resulted from alternate payer routing logic. Yes - It is an alternate payer; No - It is not an alternate payer; " - Not been evaluated, status unknown.
The category values for this column were already listed for column: USE_EXIST_DATA_YN
38 EXPECTED_REIMB_CMT VARCHAR No
Stores the expected reimbursement comment
39 SURCHARGE_HTR_ID NUMERIC No
Stores the current transaction for the surcharge.
40 COPAY_AMOUNT NUMERIC No
Total current copay due on the bucket as specified by last payment on the insurance bucket or last user override.
41 COINS_AMOUNT NUMERIC No
Total current coinsurance due on the bucket as specified by last payment on the insurance bucket or last user override.
42 DEDUCTIBLE_AMOUNT NUMERIC No
Total current deductible due on the bucket as specified by last payment on the insurance bucket or last user override.
43 NON_COVERED_AMT NUMERIC No
Total current non covered due on the bucket as specified by last payment on the insurance bucket or last user override.
44 USER_COMMENT VARCHAR No
This column stores the comment the user entered when overriding self-pay explanation of benefits (EOB) information.
45 XR_BILLED_AMOUNT NUMERIC No
Stores the expected reimbursement billed amount. It is the billed amount of the claim where the expected reimbursement is calculated.