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
Import
Cost Calculator
ANSI 271 / Virtual 271
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
14 MAN_ACC_EDIT_TYPE_C_NAME VARCHAR No
Indicates if a manual accumulation entry was an accrual, payout, or correction. Data is entered for this item during manual accumulation entry and is not stored for accumulation updates made by the system.
May contain organization-specific values: Yes
Category Entries:
Accrual
Payout
Correction
15 MAN_ACCUM_IDENT VARCHAR No
Indicates the source of the change. Data is entered for this item during manual accumulation entry and is not stored for accumulation updates made by the system.
16 SKIP_CARRYOVER_YN VARCHAR No
This flag will be set if this accumulation should be carried over during carrover.
May contain organization-specific values: No
Category Entries:
No
Yes
17 ALLOWED_ACCUM_GRP_FUN_TYP_C_NAME VARCHAR No
The functionality types on accumulation groups that this accumulation is allowed to contribute to.
May contain organization-specific values: No
Category Entries:
Third Party Administration
Bundle Expenditure
Bundle Service Limit
Benefits Limit Mechanism
Benefits Payment Mechanism
Benefits Visit
18 COUNTED_UNIT_TYPE_C_NAME VARCHAR No
The type of entity counted by this accumulation.
May contain organization-specific values: No
Category Entries:
Patient Payment
Insurance Payment
Procedure Quantity
Days
Visits
Contractual
19 PAT_PMT_RMT_CAT_C_NAME VARCHAR No
The remittance categorization subtype for the patient payment amount unit type.
May contain organization-specific values: No
Category Entries:
Deductible
Coinsurance
Copay
Not Covered
20 ACCUM_SRC_BEN_EVAL_ID NUMERIC No
The benefits engine evaluator that generated the accumulation.
21 ACCUM_SRC_BEN_EVAL_ID_BEN_EVAL_NAME VARCHAR No
The name of the benefit evaluator record.
22 ACCUM_SRC_PAYMENT_MECH_ID NUMERIC No
The benefits payment mechanism that generated this accumulation.
23 ACCUM_SRC_PAYMENT_MECH_ID_PAYMENT_MECH_NAME VARCHAR No
The name of the payment mechanism record.