ACCUM_INSTANCES

Description: |
This table contains general information about accumulation instances.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCUMULATION_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCUMULATION_ID | NUMERIC | No |
The unique identifier (.1 item) for the accumulation 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 | ACCUM_GROUP_ID | NUMERIC | No |
The accumulation group associated with the accumulation instance.
4 | ACCUM_PREV_ACC_ID | NUMERIC | No |
The ID of the previous accumulation applied to the associated accumulation group.
5 | ACCUM_PREV_ACC_LN | INTEGER | No |
The line in related group 90 from the accumulation corresponding to the previous accumulation instance.
6 | ACCUM_APPLIED_AMT | NUMERIC | No |
The amount applied to the associated accumulation group.
7 | ACCUM_RUNNING_TOTAL | NUMERIC | No |
The running total for the associated ACG after this accumulation instance was added.
8 | ACCUMULATION_INSTANT_DTTM | DATETIME (UTC) | No |
The instant this accumulation happened.
9 | TARGET_AMOUNT | NUMERIC | No |
The amount that we attempt to accumulate towards the associated accumulation group (ACG).
10 | REVERSED_LINE | INTEGER | No |
The line in this ACC's related group 90 which is reversed by this line.
11 | SEQUENCE_NUMBER | INTEGER | No |
The position in the sequence of accumulation instances this line represents for the associated accumulation group.
12 | ACCUM_LIMIT_AMT | NUMERIC | No |
The limit amount for the associated ACG when this accumulation instance was added.
13 | ADJUD_SEQ_NUM | INTEGER | No |
The number of times the claim has been priced by the adjudicator when this accumulation instance was added.
14 | VISIT_ACCUM_GRP_ID | NUMERIC | No |
The visit (represented by a Benefits Visit ACG, separate from the one accumulated to on this line) that was counted towards the Benefit Limit Mechanism ACG on this line.
15 | CARRY_FLAG_C_NAME | VARCHAR | No |
Stores a category value representing the type of carryover workflow that resulted in the accumulation.
May contain organization-specific values: No
Category Entries:
Coverage to Coverage Carryover
4th Quarter Carryover
Reversal
Reversed C2C Carryover
Reversed Q4 Carryover
16 | CARRY_FROM_COVERAGE_ID | NUMERIC | No |
Stores the source coverage this accumulation was carried from if it is a result of coverage to coverage carryover.
17 | ACCUM_SERVICE_DATE | DATETIME | No |
The service date at the time the accumulation line was generated (or, if it's a reversal line, the time the original accumulation line was generated).
18 | WAS_LIMIT_CHECKED_YN | VARCHAR | No |
Says whether the limit was checked during adjudication when we originally calculated the accumulation amount
May contain organization-specific values: No
Category Entries:
No
Yes