BILL_SCHED_PMT_PP_EST
Description:
This table contains information about estimates on a payment plan.

Primary Key
Column Name Ordinal Position
SCHED_PMT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SCHED_PMT_ID NUMERIC No
The unique identifier (.1 item) for the scheduled payment 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 ESTIMATE_ID NUMERIC No
The unique ID of the pre-service estimate record for the payment plan.
4 ESTIMATE_INITIAL_BALANCE NUMERIC No
The initial responsibility the pre-service estimate contributes to the payment plan.
5 ESTIMATE_REMAINING_BALANCE NUMERIC No
The remaining responsibility the pre-service estimate contributes to the payment plan.
6 ESTIMATE_STATUS_C_NAME VARCHAR No
The category ID of the pre-service estimate's status on the payment plan.
May contain organization-specific values: No
Category Entries:
On Plan
Completed
Removed
7 ESTIMATE_STATUS_UPDATE_DATE DATETIME No
The most recent date the pre-service estimate's status on the payment plan was updated.
8 ESTIMATE_COVERED_BY_EST_AMT NUMERIC No
The portion of the pre-service estimate's initial balance that is still estimate responsibility. This amount is reduced by charges moving to Self-Pay on hospital accounts linked to the estimate.
9 ESTIMATE_COVERED_BY_HAR_AMT NUMERIC No
The portion of the pre-service estimate's initial balance that is applied to hospital accounts linked to the estimate. This amount plus the estimate responsibility remaining always equals the initial balance of the estimate.