HSP_BKT_SURCHARGE

Description:

Holds information regarding percentages applied to buckets based on the date ranges of the bucket's 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.
11	TAX_HAR_CER_RULE_ID	VARCHAR	No
	The unique Id of the general rule that was last used to generate tax charges. If the tax charges on this bucket generated due to multiple account rules then this contains no rule.
12	TAX_HAR_CER_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.