HSP_BKT_SURCHARGE

Description:

Holds information regarding percentages applied to buckets based on the date ranges of the buckets charges.

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	EFFECTIVE_DT	DATETIME	No
	Stores the effective date in the HSD that stored the settings used to calculate the surcharge.
4	SURCHARGE_PERCENT	NUMERIC	No
	Percent used to calculate surcharge
5	AMOUNT	NUMERIC	No
	This item stores the amount used for the surcharge for a date range.
6	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account on the liability bucket record.
7	SURCHARGABLE_AMT	NUMERIC	No
	This item stores the amount that the surcharge is applied to on the bucket.
8	SRCHG_CREDIT_AMT	NUMERIC	No
	This item returns the total amount of surcharge credit transactions posted against a bucket.
9	SRCHG_XFER_IN	NUMERIC	No
	Stores the total amount of surcharge that has transferred into a liability bucket.
10	SRCHG_XFER_OUT	NUMERIC	No
	Stores the total amount of surcharge transferred out of a liability bucket.