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