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