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.