ACCUM_CONTEXTUAL_DATA
Description:
This table contains contextual data about a claim and service when an accumulation occurred.

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 GROUPING_BEN_VAR_ID NUMERIC No
Stores the benefit grouping matched to during this accumulation event.
3 GROUPING_BEN_VAR_ID_BEN_VAR_NAME VARCHAR No
The name of the benefit variable.
4 SERVICE_BEN_VAR_ID NUMERIC No
Stores the benefit service matched to during this accumulation event.
5 SERVICE_BEN_VAR_ID_BEN_VAR_NAME VARCHAR No
The name of the benefit variable.
6 AUTH_PRES_YN VARCHAR No
Stores whether an authorization was present during this accumulation event.
May contain organization-specific values: No
Category Entries:
No
Yes
7 NET_LEVEL_PROV_C_NAME VARCHAR No
Stores the network level matched to during this accumulation event.
May contain organization-specific values: Yes
Category Entries:
In
Out
Out of Area
N/A
8 EAP_CODE_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
9 PX_QUANTITY_CNT NUMERIC No
Stores the procedure quantity for the service matched to during this accumulation event.
10 PX_NUM_MINUTES_CNT INTEGER No
Stores the procedure number of minutes for the service matched to during this accumulation event.
11 PX_NUM_DAYS_CNT INTEGER No
Stores the procedure number of days for the service matched to during this accumulation event.
12 SERVICE_START_DATE DATETIME No
Stores the service start date for the service matched to during this accumulation event.
13 SERVICE_END_DATE DATETIME No
Stores the service end date for the service matched to during this accumulation event.
14 POS_TYPE_C_NAME VARCHAR No
Stores the place of service type for the service matched to during this accumulation event.
May contain organization-specific values: Yes
Category Entries:
Telehealth - Provided in Patient's Home
Office
Home
Assisted Living Facility
Group Home
Mobile Unit
Temporary Lodging
Walk-in Retail Health Clinic
Place of Employment - Worksite
Off Campus - Outpatient Hospital
Urgent Care Facility
Inpatient Hospital
On Campus - Outpatient Hospital
Emergency Room - Hospital
Ambulatory Surgical Center
Birthing Center
Military Treatment Facility
Outreach Site/Street
Skilled Nursing Facility
Nursing Facility
Custodial Care Facility
Hospice
Adult Living Care Facility
Ambulance - Land
Ambulance - Air or Water
Independent Clinic
Federally Qualified Health Center
Inpatient Psychiatric Facility
Psychiatric Facility - Partial Hospitalization
Community Mental Health Center
Intermediate Care Facility/ Individuals with Intellectual Disabilities
Residential Substance Abuse Treatment Facility
Psychiatric Residential Treatment Center
Non-residential Substance Abuse Treatment Facility
Non-residential Opioid Treatment Facility
Mass Immunization Center
Comprehensive Inpatient Rehabilitation Facility
Comprehensive Outpatient Rehabilitation Facility
End-Stage Renal Disease Treatment Facility
Programs of All-Inclusive Care for the Elderly (PACE) Center
Public Health Clinic
Rural Health Clinic
Independent Laboratory
Other Place of Service
Pharmacy
Telehealth - Provided Other than in Patient's Home
School
Homeless Shelter
Indian Health Service Free-standing Facility
Indian Health Service Provider-based Facility
Tribal 638 Free-standing Facility
Tribal 638 Provider-based Facility
Prison/Correctional Facility
15 REV_CODE_ID NUMERIC No
Stores the revenue code for the service matched to during this accumulation event.
16 REV_CODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
17 CNTRCT_AMOUNT_NUM NUMERIC No
Stores the contractual amount calculated for the service matched to during this accumulation event.
18 RNDR_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
19 ASSOC_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
20 DISCH_STATUS_C_NAME VARCHAR No
Stores the discharge status for the claim during this accumulation event.
May contain organization-specific values: Yes
21 ATT_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
22 ASSOC_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
23 ADJ_METHOD_C_NAME VARCHAR No
Stores the adjudication method for the claim during this accumulation event.
May contain organization-specific values: Yes
Category Entries:
Primary Coverage
Coordination of Benefits
Maintenance of Benefits
COB Savings
Preservation of Benefits
Claim-Level Coordination of Benefits
Claim-Level Maintenance of Benefits
24 ASSOC_COVERAGE_ID NUMERIC No
Stores the coverage for the claim during this accumulation event.
25 CLM_SPEC_C_NAME VARCHAR No
Stores the specialty for the claim during this accumulation event.
May contain organization-specific values: Yes
26 CLM_FORMAT_C_NAME VARCHAR No
Stores the format for the claim during this accumulation event.
May contain organization-specific values: No
Category Entries:
CMS
UB
Rx
27 TYPE_OF_BILL VARCHAR No
Stores the type of bill for the claim during this accumulation event.
28 ADMISSION_DATE DATETIME No
Stores the admission date for the claim during this accumulation event.
29 DISCHARGE_DATE DATETIME No
Stores the discharge date for the claim during this accumulation event.
30 ADM_NUM_DAYS_CNT INTEGER No
Stores the length of stay (days) for the claim during this accumulation event.
31 ACCUM_DATA_SOURCE_C_NAME VARCHAR No
Stores the data source type for this accumulation event.
May contain organization-specific values: No
Category Entries:
Patient and Coverage
Manual Adjustment
MyChart Benefits Summary
AP Claim Service Line Temporary Data
AP Claim Service Line
Coverage Benefits
32 TARGET_BEN_FUNCTION_C_NAME VARCHAR No
Stores the target limit type that the accumulation can apply to. Used to determine which accumulation groups the accumulation can apply to.
May contain organization-specific values: Yes
Category Entries:
Pre-Benefit Penalty
Coverage Limit
Maximum Out of Pocket
Preventive Care Limit
Deductible
Core Payment
Routine Care Allowance
Reserve Period
33 ACCUMULATE_BY_C_NAME VARCHAR No
Stores the what accumulation types this accumulation can apply to (I BEB 204 value). Used to determine which accumulation groups the accumulation can apply to.
May contain organization-specific values: No
Category Entries:
Account
Patient
34 MOOP_DED_BEN_VAR_ID NUMERIC No
Stores the MOOP/Deductible type (CMW ID) that the accumulation can apply to. Used to determine which accumulation groups the accumulation can apply to.
35 MOOP_DED_BEN_VAR_ID_BEN_VAR_NAME VARCHAR No
The name of the benefit variable.