PR_EST_AP_CLAIM

Description:

This table stores accounts payable claim context information for managed care estimates.

Primary Key

Column Name	Ordinal Position
ESTIMATE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ESTIMATE_ID	NUMERIC	No
	The unique identifier for the patient estimate record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	VENDOR_ID_VENDOR_NAME	VARCHAR	No
	The name of the vendor.
4	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.
5	POS_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
6	CLAIM_FORMAT_C_NAME	VARCHAR	No
	The claim format for the estimate claim detail. May contain organization-specific values: No Category Entries: CMS UB Rx
7	HISTORY_TYPE_C_NAME	VARCHAR	No
	The type of historical data used for this estimate claim detail. May contain organization-specific values: No Category Entries: Individual Procedure Historical Claim
8	HX_UB_CLASS_C_NAME	VARCHAR	No
	The historical UB claim classification to use for this estimate claim detail. May contain organization-specific values: No Category Entries: Inpatient Outpatient Emergency
9	POS_TYPE_C_NAME	VARCHAR	No
	The place of service type of the related line. 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
10	MC_ANCHOR_CONTEXT	INTEGER	No
	This is the Anchor context, meaning if there are mulitple lines in the related group that come from the same Anchor procedure this number points to the line that has the Anchor procedure. The Anchor procedure is what is shown to the member in Cost Calculator.
11	MC_SEARCH_CONTEXT	INTEGER	No
	Holds a line number that corresponds to a line in RG PES 18180 which has the related search parameters that were in use when the detailed view was selected.