AP_CLAIM_PX_PT_BKT

Description: |
This table contains patient buckets involved with or affected 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 | BEN_BKT_COVERAGE_ID | NUMERIC | No |
The ID of the coverage associated with the benefit accumulation bucket that was involved in the adjudication of the procedure.
4 | BEN_BKT_ID | NUMERIC | No |
The ID of the benefit accumulation bucket that was involved in the adjudication of the procedure.
5 | BEN_BKT_ID_BUCKET_NAME | VARCHAR | No |
The name of the bucket.
6 | BEN_BKT_HX_LINE | INTEGER | No |
The benefit bucket accumulation history line number that corresponds to the state of the benefit bucket when it was used in the adjudication of the procedure. This column is often used to join to BEN_ACCUMULATION_HX_PAT.LINE.
7 | BEN_ACCUM_SEQUENCE_NUM | INTEGER | No |
The sequence number for the benefit accumulation associated with the procedure.
8 | BEN_ACCUM_PREV_TOTAL | NUMERIC | No |
The total of the benefit accumulation bucket before the benefit amounts were added for the procedure.
9 | BEN_BKT_LIMIT_TYPE_C | VARCHAR | No |
The limit type of the benefit accumulation bucket that was involved in the adjudication of the procedure. This is only populated for benefit accumulations where a benefit bucket is not specified.