HSP_BKT_SPLIT_CLMS

Description: |
This table contains information about split claims associated with liability buckets.

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 | SPLIT_INV_NO | VARCHAR | No |
The invoice number for the split claim associated with this bucket.
4 | SPLIT_FORM | VARCHAR | No |
The form used for the split claim associated with this bucket.
5 | SPLIT_CHG_TOT | NUMERIC | No |
The charge total for the split claim associated with this bucket.
6 | SPLIT_CLP_ID | NUMERIC | No |
This column stores the unique identifier for the claim print for the claims split that is associated with this bucket.
7 | SPLIT_ORIG_FORM | VARCHAR | No |
The original form used for the claim associated with this bucket.
8 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account to which the liability bucket is linked.