|
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 |
|
|
| 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 |
|
|
