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:
Claim
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.