ESTIMATE_ACCUM_INFO
Description:
Contains accumulation information for each search result in a Cost Calculator estimate.

Primary Key
Column Name Ordinal Position
ESTIMATE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ESTIMATE_ID NUMERIC No
The unique identifier (.1 item) for the estimate record.
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 EST_ACCUM_LINE_NUM INTEGER No
The line number of related group 18000, which stores accmulation information about the estimate.
4 ACCUM_GRP_NAME VARCHAR No
The display name for the accumulation group. This name is generated at the original runtime of the estimate, based on the context of the benefit plan.
5 ACCUM_GRP_LIMIT NUMERIC No
The maximum amount that can be contributed to the accumulation group.
6 ACCUM_GRP_ADDL_AMT NUMERIC No
Additional amount added to the accumulation group from the estimate.
7 ACCUM_GRP_REMAIN NUMERIC No
Amount left in the accumulation group after adding the additional amount from the estimate.
8 ACCUM_GRP_LEVEL_C_NAME VARCHAR No
The account level that the accumulation contributes to. Can be Inidvidual (patient) or Family (account).
May contain organization-specific values: No
Category Entries:
Account
Patient
9 ACCUM_GRP_TYPE_C_NAME VARCHAR No
The type of accumulation this accumulation group represents. Can be a MOOP, a deductible, or other.
May contain organization-specific values: No
Category Entries:
Other
Deductible
MOOP
10 ACCUM_IS_MONETARY_YN VARCHAR No
Is the accumulation for this accumulation group a monetary amount?
May contain organization-specific values: No
Category Entries:
No
Yes
11 ACCUM_IS_PER_DAY_YN VARCHAR No
Is the accumulation for this accumulation group limited per day?
The category values for this column were already listed for column: ACCUM_IS_MONETARY_YN