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.