HSP_BKT_ADDTL_REC

Description:

Additional Payment Reconciliation Information This table holds current information sent back by the payor at a later date. This can be after the account has been closed. See table HSP_BKT_REC_HX for the history of these items.

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 bucket record.
2	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account to which the liability bucket is linked.
3	ADDTL_NA_AMT	NUMERIC	No
	Additional Payment Reconciliation Information - Not allowed amount
4	ADDTL_PAYOR_PMT	NUMERIC	No
	This column stores the payer payment amount.
5	ADDTL_NON_CVD_CHGS	NUMERIC	No
	Additional Payment Reconciliation Information - Non-covered charges
6	ADDTL_TOT_CHARGES	NUMERIC	No
	This column stores the payer reported amount of total charges.
7	ADDTL_REPORT_DATE	DATETIME	No
	This column stores the date on the report from the payer.
8	ADDTL_REPT_TYPE_C_NAME	VARCHAR	No
	Additional Payment Reconciliation Information - report type. May contain organization-specific values: Yes No Entries Defined