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).