HSP_BKT_ACT_HX

Description: |
This table contains hospital liability bucket action history information from the Hospital Liability Buckets (HLB) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
BUCKET_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the bucket record.
2 | LINE | INTEGER | No |
This column stores the line number in the results of a query. Because multiple actions can be performed on a liability bucket, each action will have a unique line number.
3 | ACTIVITY_DATE | DATETIME | No |
The date an action was recorded on a liability bucket.
4 | ACTIVITY_TYP_HA_C_NAME | VARCHAR | No |
The type of action that was recorded on a liability bucket. Examples are Claim Accepted, Transfer In, Claim Denied.
May contain organization-specific values: No
Category Entries:
Created
Demand Claim Accepted
Claim Accepted
Transfer In
Claim Denied
Resubmit Claim
Rejected
Transfer Out
Bill Charges
Claim Status Request
Claim Status Update
Remark
Allowance Discrepancy
Cancel Claim
Invoice Number Edit
Removed from Claim Queue
Claim ICN Edit
Replaced
Queue for Credit Statement
Debit Statement Accepted - Transfer to GL
Credit Statement Accepted - Transfer to GL
Transfer Denied Amount to Self-Pay
Transfer Denied Amount from Claim
NRP In
NRP Out
Transfer Liability In
Transfer Liability Out
Advance Bill Transfer In
Advance Bill Transfer Out
Advance Bill Transfer Update
Advance Bill Transfer Canceled
Undo NRP In
Undo NRP Out
Consolidated Balances Transfer In
Consolidated Balances Transfer Out
Automated Plan Change
5 | TRANSFER_TYP_HA_C_NAME | VARCHAR | No |
The transfer type associated with an activity on a liability bucket. Transfer types are Charge, Payment, Adjustment, and Balance.
May contain organization-specific values: No
Category Entries:
Charge
Payment
Adjustment
Balance
6 | DENIAL_CODE_ID | VARCHAR | No |
A claim denial code associated with a claim denied action that was recorded on a liability bucket.
7 | DENIAL_CODE_ID_REMIT_CODE_NAME | VARCHAR | No |
The name of each remittance code.
8 | ACTIVITY_AMOUNT | NUMERIC | No |
The monetary amount associated with an action that was recorded on a liability bucket.
9 | ACTIVITY_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user who performed an action that was recorded on a liability bucket.
10 | ACTIVITY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | SOURCE_BUCKET_ID | NUMERIC | No |
The liability bucket that is considered the source for this liability bucket. A source liability bucket is a bucket out of which transactions are transferred into another bucket.
12 | TARGET_BUCKET_ID | NUMERIC | No |
The liability bucket that is considered the target for this liability bucket. A target liability bucket is a bucket into which transactions are transferred from another bucket.
13 | BALANCE_AFTER | NUMERIC | No |
The balance on a liability bucket after an action was performed on it.
14 | NEW_BKT_STS_HA_C_NAME | VARCHAR | No |
The status of a liability bucket after an action was performed on it.
May contain organization-specific values: No
Category Entries:
Created
Queued
Processed
Printed
Outstanding
Error
Closed
Rejected
Replaced
15 | ACTIVITY_PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
16 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account with which the liability bucket is associated.
17 | EXT_DENIAL_CODE | VARCHAR | No |
External claim denial code associated with a claim denied action that was recorded on the liability bucket.
18 | GRP_CODE_C_NAME | VARCHAR | No |
Reason group code associated with the denial code that was recorded on a liability bucket.
May contain organization-specific values: Yes
Category Entries:
Patient Responsibility
Contractual Obligation
Payor Initiated
Correction and Reversal
Other Adjustment
19 | ACTIVITY_DTTM | DATETIME (Local) | No |
The column returns the instant an action was recorded on a liability bucket.
20 | ACTIVITY_CONTEXT_C_NAME | VARCHAR | No |
The column stores the context for the action on a given liability bucket.
May contain organization-specific values: No
Category Entries:
Initiate billing
Late claim
Late replacement claim
Late charge write-off
Late addition
Undo billing
Next responsible party
Account reached full self-pay
Account financial reclassification
Charge filed
Payment posted
Adjustment posted
Coverage Automation Plan Change
Advance bill estimate finalized
Advance bill estimate detached
Advance bill estimate replaced
Patient admission
Admission canceled
21 | ACTIVITY_SRC_C_NAME | VARCHAR | No |
The column stores the source of an activity for a given liability bucket.
May contain organization-specific values: No
Category Entries:
System
User