ACCUM_GENERAL

Description:

This table contains general information about accumulation (ACC) records.

Primary Key

Column Name	Ordinal Position
ACCUMULATION_ID	1

Column Information

	Name	Type	Discontinued?
1	ACCUMULATION_ID	NUMERIC	No
	The unique identifier (.1 item) for the accumulation record.
2	ACCUM_PAT_ID	VARCHAR	No
	The ID of the associated member.
3	ACCUM_DATE	DATETIME	No
	The service date of the accumulation.
4	ACCUM_INST_UPDATE_DTTM	DATETIME (UTC)	No
	The instant this accumulation was created.
5	ACCUM_USER_ID	VARCHAR	No
	The user the accumulation was applied by.
6	ACCUM_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	ACCUM_COMMENT	VARCHAR	No
	The free-text comment associated with the accumulation.
8	ACCUM_AMT	NUMERIC	No
	The default accumulation amount.
9	ACCUM_SRC_C_NAME	VARCHAR	No
	The source type of the accumulation. May contain organization-specific values: No Category Entries: Service Manual Adjustment
10	ACCUM_SRC_CLAIM_ID	NUMERIC	No
	The ID of the associated claim if the accumulation source is a claim.
11	ACCUM_SRC_TX_ID	NUMERIC	No
	The ID of the associated service if the accumulation source is a claim.
12	REVERSAL_OF_ACC_ID	NUMERIC	No
	The ID of the accumulation record that this record reverses.
13	RECORD_STATUS_C_NAME	VARCHAR	No
	The record status (hidden, soft-deleted, etc...) May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted