PR_EST_ADDL_INFO
Description:
Contains additional information related to a price estimate, such as tax and discount amounts.

Primary Key
Column Name Ordinal Position
ESTIMATE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ESTIMATE_ID NUMERIC No
This column stores 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 SURCHARGE_AMT NUMERIC No
The estimated surcharge amount.
4 SYS_SURCHARGE_AMT NUMERIC No
The system-calculated surcharge amount.
5 SP_DISCOUNT_AMT NUMERIC No
The estimated self-pay discount amount.
6 SYS_SP_DISCOUNT_AMT NUMERIC No
The system-calculated self-pay discount amount.
7 FA_DISCOUNT_AMT NUMERIC No
The estimated financial assistance discount amount.
8 SYS_FA_DISCOUNT_AMT NUMERIC No
The system-calculated financial assistance discount amount.
9 SOURCE_ORDER_ID NUMERIC No
This is the order this line of the estimate was created from.
10 APPLIED_DISCR_DISCOUNT_AMT NUMERIC No
The applied discretionary discount amount on the estimate.
11 DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
12 SYS_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
13 PX_SOURCE_C_NAME VARCHAR No
Stores a category describing where procedure lines on an estimate originated from.
May contain organization-specific values: No
Category Entries:
Manual Entry
OPC
Surgery History
Template
Related Procedure History
Advance Billing Daily Charge
Dental Treatment
Orthodontic SmartSet
14 CHG_AMOUNT_SOURCE_C_NAME VARCHAR No
Source of the estimated charge amount.
May contain organization-specific values: No
Category Entries:
History
Historical Reprice
Fee Schedule
Manually Specified
15 ALLOW_AMOUNT_SOURCE_C_NAME VARCHAR No
Source of the estimated allowed amount.
May contain organization-specific values: No
Category Entries:
History
Historical Reevaluation with Contract
Total Charges
Total Charges (Due to Zero Allowed)
Contract
Contract (Limited History)
Total Charges (Due to Zero Allowed With Limited History)
Total Charges (Coverage Not Applied)
Manually Specified
External System – 3M CGS or External Grouper System (APC/APG)
External System – 3M CGS or External Grouper System (APC/APG) (Limited History)
Payer Adjudication
Payer Adjudication (Limited History)
16 PX_SOURCE_PAT_ENC_CSN_ID NUMERIC No
This is the CSN this line of the estimate was generated from by the system.