|
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. |
|
|