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