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
Tax Charge
Oncology Treatment Plan
Therapy Plan
Orthodontic Treatment Charges Table
Orthodontic Appliance Charges
Orthodontic Consult Visit Charges
Orthodontic Records Visit Charges
Orthodontic Case Presentation Charges
Orthodontic Banding Visit Charges
Orthodontic Debanding Visit Charges
Orthodontic Adjustment Visit Charges
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
Tax Charge
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.
17 | SYSTEM_NDC_ID | VARCHAR | No |
This is the default NDC medication package used for pricing a medication.
18 | SYSTEM_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
19 | OVERRIDE_NDC_ID | VARCHAR | No |
This is the NDC medication package selected by a user used for pricing a medication.
20 | OVERRIDE_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
21 | SOURCE_TREATMENT_PLAN_ID | NUMERIC | No |
Stores the treatment plan record from where procedure lines on an estimate were pulled from.
22 | TREATMENT_DAY_LINE | INTEGER | No |
Stores the line from related group TPL 5000 for where procedure lines on an estimate were pulled from if they were added from a Beacon treatment plan.
23 | TREATMENT_BLOCK_C_NAME | VARCHAR | No |
Stores the block category type that a procedure was in when pulled in from a Beacon treatment plan.
May contain organization-specific values: Yes
Category Entries:
Other
24 | DISC_PRIC_CONTRACT_ID_CONTRACT_NAME | VARCHAR | No |
The name of the pricing contract.
25 | APPLIED_DISC_PRIC_CONTRACT_AMT | NUMERIC | No |
Discount amount calculated from the discount pricing contract.