ACCUM_GRP_GENERAL

Description:

This table contains general information about accumulation group (ACG) records.

Primary Key

Column Name	Ordinal Position
ACCUM_GRP_ID	1

Column Information

	Name	Type	Discontinued?
1	ACCUM_GRP_ID	NUMERIC	No
	The unique identifier (.1 item) for the accumulation group record.
2	BUCKET_ID	NUMERIC	No
	The ID of the benefit bucket being accumulated to.
3	BUCKET_ID_BUCKET_NAME	VARCHAR	No
	The name of the bucket.
4	RLL_START_DATE	DATETIME	No
	The start date of the roll period accumulations are being made in.
5	RECENT_ACC_ID	NUMERIC	No
	The ID of the most recent accumulation made to the accumulation group.
6	RECENT_ACC_LN	INTEGER	No
	The line in related group 60 from the accumulation corresponding to the most recent accumulation instance.
7	PLAN_GRP_ID	VARCHAR	No
	The ID of the associated employer group.
8	PLAN_GRP_ID_PLAN_GRP_NAME	VARCHAR	No
	The name of the employer group record
9	PAT_ID	VARCHAR	No
	The ID of the associated member.
10	EX_ACC_ID	NUMERIC	No
	The accumulation which pushed the running total over the limit
11	EX_ACC_LN	INTEGER	No
	The line in Related group 60 for the ACC that pushed the running total over the limit corresponding to the instance which exceeded the limit
12	RLL_END_DATE	DATETIME	No
	The end date of the roll period accumulations are being made in.
13	BUCKET_LEVEL	INTEGER	No
	The bucket level associated with this ACG, if applicable.
14	BUCKET_PAYMENT_MECHANISM_C_NAME	VARCHAR	No
	The payment mechanism of the associated bundle bucket at this level, which determines how associated services are priced. May contain organization-specific values: No Category Entries: Pay Up to Bundle Rate Not Paid Pay in Addition to Bundle Rate
15	BUCKET_LIMIT_AMOUNT	NUMERIC	No
	The amount limit associated with this bucket level.
16	RECORD_STATUS_C_NAME	VARCHAR	No
	Stores the record status (hidden, soft-deleted, etc...) May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted