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.