HSP_BKT_REC_HX

Description:

Additional Payment Reconciliation Information History table. This table stores a history of the amounts from HSP_BKT_ADDTL_REC, which has the current values.

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
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	SOURCE_C_NAME	VARCHAR	No
	Additional Payment Reconciliation Information - Source of the change May contain organization-specific values: No Category Entries: Imported Manual Entry Transferred
4	INSTANT_OF_ENTRY_TM	DATETIME (Local)	No
	Additional Payment Reconciliation Information - Instant when the information was updated
5	ADDTL_NA_AMT_HX	NUMERIC	No
	Additional Payment Reconciliation Information - Not allowed amount history
6	ADDTL_PAYOR_PMT_HX	NUMERIC	No
	This column stores the payer payment amount history.
7	ADDTL_N_CVD_CHGS_HX	NUMERIC	No
	Additional Payment Reconciliation Information - Non-covered charges history
8	ADDTL_TOT_CHGS_HX	NUMERIC	No
	This column stores the payer reported amount of total charges history.
9	ADDTL_REPT_HX_DATE	DATETIME	No
	This column stores the date on the report from the payer history.
10	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account to which the liability bucket is linked.
11	ADDTL_TYPE_HX_C_NAME	VARCHAR	No
	Additional Payment Reconciliation Information - report type history. May contain organization-specific values: Yes No Entries Defined