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 NUMERIC No
The diagnosis used to calculate benefits for the procedure. Unless the value was manually specified by a user, this will be equivalent to the value in SYS_DX_ID.
12 SYS_DX_ID NUMERIC No
The diagnosis that the system originally calculated to be used for benefits. DX_ID contains the value that was actually used to calculate the estimate.
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
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
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
Total Charges
Total Charges (Due to Zero Allowed)
Contract
Manually Specified
16 PX_SOURCE_PAT_ENC_CSN_ID NUMERIC No
This is the CSN this line of the estimate was generated from by the system.