PR_EST_FAC_FEES
Description:
The facility fees information for the price estimate. Facility fees are generated in Resolute Hospital 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 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 CODE_TYPE_C_NAME VARCHAR No
Category to indicate which type of code (DRG/ICD/CPT) was used when preparing the estimate.
May contain organization-specific values: No
Category Entries:
DRG
ICD
CPT
EAP
4 DRG_CODE_ID VARCHAR No
Contains the DRG code upon which the estimate for the facility fees is based.
5 DRG_CODE_ID_DRG_NAME VARCHAR No
The name of the Diagnoses Related Group name.
6 ICD_CODE_ID VARCHAR No
The ICD code upon which the estimate for the facility fees is based.
7 ICD_CODE_ID_ICD_PX_NAME VARCHAR No
The name of the ICD procedure record.
8 CPT_CODE VARCHAR No
Stores the CPT code upon which the hospital fees estimate is based.
9 LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
10 ACCT_CLASS_C_NAME VARCHAR No
Account class for this facility fee estimate.
May contain organization-specific values: Yes
11 BILLED_AMT NUMERIC No
Estimated charge amount for an Hospital Billing (HB) historical case estimate.
12 ALLOWED_AMT NUMERIC No
The estimated allowed amount for the facility fees.
13 SELF_PAY_AMT NUMERIC No
The estimated self-pay amount for the facility fees.
14 SERVICE_TYPE_ID VARCHAR No
The benefit service type used to determine benefit information for the facility 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.
15 SERVICE_TYPE_ID_SERVICE_TYPE_NAME VARCHAR No
The name of this benefit service type.
16 ACTUAL_DISCOUNT_AMT NUMERIC No
The estimated discount amount for the facility fees.
17 SYSTEM_DISCOUNT_AMT NUMERIC No
The system-calculated discount amount for the facility fees.
18 SYS_CHG_AMT NUMERIC No
The system-calculated charge amount for a Hospital Billing (HB) historical case estimate.
19 SYS_ALLOWED_AMT NUMERIC No
The system-calculated allowed amount for a Hospital Billing (HB) historical case estimate.
20 HB_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.
21 HB_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
22 BASE_CLASS_C_NAME VARCHAR No
Base class for this facility fee estimate.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
Emergency
23 HB_MEDIAN_CHARGES NUMERIC No
Median charge amount from historical cases.
24 HB_MEDIAN_ALLOWED NUMERIC No
Median allowed amount from historical cases.
25 HB_CONTRACT_ID NUMERIC No
The reimbursement contract calculated for a Hospital Billing context.
26 HB_CONTRACT_ID_CONTRACT_NAME VARCHAR No
The name of the Vendor-Network contract.
27 HB_OVRIDE_CONTRACT_ID NUMERIC No
The reimbursement contract manually selected to find historical data in a Hospital Billing context.
28 HB_OVRIDE_CONTRACT_ID_CONTRACT_NAME VARCHAR No
The name of the Vendor-Network contract.
29 HB_OVRIDE_BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
30 HB_OVRIDE_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
31 HB_OVRIDE_FIN_CL_C_NAME VARCHAR No
The financial class category ID in an Hospital Billing context for the patient estimate.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
32 FAC_ADDL_LINE INTEGER No
This item holds a line number in the PR_EST_ADDL_INFO table, which stores additional information about the charge line.
33 SELF_PAY_DISCNT_CONTRACT_ID NUMERIC No
The reimbursement discount contract calculated as part of a self-pay discount.
34 SELF_PAY_DISCNT_CONTRACT_ID_CONTRACT_NAME VARCHAR No
The name of the Vendor-Network contract.
35 SELF_PAY_DISCNT_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
36 SELF_PAY_DISCNT_SCOPE_C_NAME VARCHAR No
Scope used to find median case for self-pay discount by contract calculation.
May contain organization-specific values: No
Category Entries:
Plan
Payer
Financial Class
Contract
All Financial Classes
All Insurance
37 SELF_PAY_DISCNT_MEDIAN_AMT NUMERIC No
Median contractual amount to apply as part of a self-pay discount.
38 REPRESENT_HSP_ACCOUNT_ID NUMERIC No
The representative Hospital Account used during the calculation of the context line. For HB Case contexts, the historical median Hospital Account used to calculate amounts will be saved. For HB Procedure contexts, the representative Hospital Account used to create a simulated claim will be saved. This item does not store the Hospital Account used to find related procedure information.