SERVICE_BENEFIT_BUCKET

Description: |
This table stores benefit bucket information relevant to or caused by AP Claim service lines.
To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique ID of the AP Claim procedure transaction.
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 | BENEFIT_BUCKET_ID | NUMERIC | No |
Stores the unique identifier of the benefit bucket affected by this service.
4 | BENEFIT_BUCKET_ID_BUCKET_NAME | VARCHAR | No |
The name of the bucket.
5 | BENEFIT_BUCKET_MAX | NUMERIC | No |
Stores the maximum number of units allowed for this benefit bucket level.
6 | BENEFIT_BUCKET_USED | NUMERIC | No |
Stores the number of units used for this benefit bucket level.
7 | BENEFIT_BCKT_REMAIN | NUMERIC | No |
Stores the number of units remaining for this benefit bucket level.
8 | BUCKET_LEVEL | VARCHAR | No |
Stores the benefit bucket level used.
9 | BENEFIT_BUCKET_COMPUTED | NUMERIC | No |
The original amount that the system computed to be accumulated to the bucket.
10 | ROLL_PRD_STR | VARCHAR | No |
The roll period that the benefit bucket accumulation used.