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.