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.