PR_EST_PROFEE_CXT
Description:
Context information for the professional fees in the price estimate. Context information is used to define the expected circumstances of the charges such as provider and department. Professional fees are generated in Resolute Professional Billing.

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 price 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 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.
4 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
5 POS_TYPE_C_NAME VARCHAR No
The place of service (POS) type that is used to provide context for the price estimate's professional fees.
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
6 VISIT_TYPE_ID_PRC_NAME VARCHAR No
The name of the visit type.
7 SERVICE_TYPE_ID VARCHAR No
The benefit service type used to determine benefit information for the professional fees section. This information comes from the benefit record attached to the estimate. Use the PR_EST_INFO table, BENEFITS_INFO_ID column to link this data.
8 SERVICE_TYPE_ID_SERVICE_TYPE_NAME VARCHAR No
The name of this benefit service type.
9 PB_PR_EST_TEMPLATE_ID NUMERIC No
The estimate template that was used to create this context.
10 PB_PR_EST_TEMPLATE_ID_PR_EST_TEMPLATE_NAME VARCHAR No
The name of the estimate template record.
11 PB_DENT_PROC_SUBSTATUS_C_NAME VARCHAR No
Status explaining why a procedure is not scheduled. Also groups procedures in the estimates activity and on the letter.
May contain organization-specific values: Yes
12 PB_LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
13 PRICING_CONTRACT_ID_CONTRACT_NAME VARCHAR No
The name of the pricing contract.
14 PRICING_CNTR_OVR_YN VARCHAR No
This item stores whether a user has overridden the pricing contract that is stored in I PES 311. There are two values: 0) No - Contract has been selected by the system. 1) Yes - Contract has been chosen by the user. The default is No.
May contain organization-specific values: No
Category Entries:
No
Yes