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 FUN_TYP_C_NAME VARCHAR No
The functional type that specifies which workflows can interact with this accumulation group.
May contain organization-specific values: No
Category Entries:
Third Party Administration
Bundle Expenditure
Bundle Service Limit
Benefits Limit Mechanism
Benefits Payment Mechanism
Benefits Visit
17 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
18 ASSOC_SPECIALTY_C_NAME VARCHAR No
The claim specialty associated with the accumulation group
May contain organization-specific values: Yes
19 BEN_LIM_ACCUM_GRP_ID NUMERIC No
The benefit limit ACG that the visit originated with. Due to carryover, the visit ACG may be on other benefits ACG's besides this, and may even have originally accumulated to those; this just tracks where the first line was.
20 BEN_LIM_ACCUM_GRP_ST_TOT NUMERIC No
The total of the benefit limit accumulation group when this visit was created.
21 ACCUM_GRP_COVERAGE_ID NUMERIC No
Coverage ID associated with the accumulation group.
22 CURRENT_RUNNING_TOTAL NUMERIC No
The total accumulations that have been made. This item links to the most recent accumulation line's (I ACG 50/51) running total (I ACC 94).
23 ACCUM_BEN_FUNCTION_C_NAME VARCHAR No
The function of the benefits engine evaluator that generated the accumulation. The system uses this item to categorize the purposes of the accumulation group.
May contain organization-specific values: Yes
Category Entries:
Coverage Limit
Maximum Out of Pocket
Pre-Deductible
Deductible
Core Payment
24 ACCUM_BEN_EVAL_ORDER INTEGER No
The function order of the benefits engine evaluator that generated the accumulation. The system uses this item to categorize the purposes of the accumulation group.
25 COUNTED_UNIT_TYPE_C_NAME VARCHAR No
The type of entity counted by this accumulation group.
May contain organization-specific values: No
Category Entries:
Patient Payment
Insurance Payment
Procedure Quantity
Days
Visits
Contractual
26 ACCUM_GRP_NETWORK_LEVEL_C_NAME VARCHAR No
The network level associated with the accumulation group.
May contain organization-specific values: Yes
Category Entries:
In
Out
Out of Area
N/A
27 ACCUM_GRP_BEN_VAR_ID NUMERIC No
The grouper keyword associated with the accumulation group.
28 ACCUM_GRP_BEN_VAR_ID_BEN_VAR_NAME VARCHAR No
The name of the benefit variable.
29 ACCUM_GRP_PROC_CD VARCHAR No
The procedure code associated with the accumulation group.
30 ACCUM_GRP_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
31 ACCUM_GRP_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
32 ACCUM_GRP_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
33 ACCUM_GRP_PAYMENT_MECH_ID NUMERIC No
The payment mechanism associated with the accumulation group.
34 ACCUM_GRP_PAYMENT_MECH_ID_PAYMENT_MECH_NAME VARCHAR No
The name of the payment mechanism record.
35 ACCUM_GRP_CLAIM_ID NUMERIC No
The claim associated with the accumulation group. This is only populated if the limit is set to apply per claim.