STMT_PMT_PLAN_ESTIMATES

Description:

Contains the pre-service estimates on payment plan that were included in the statement.

Primary Key

Column Name	Ordinal Position
PRINT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PRINT_ID	NUMERIC	No
	The unique identifier (.1 item) for the statement or detail bill 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 on the payment plan that generated this statement.
4	INITIAL_ESTIMATED_BAL	NUMERIC	No
	The initial balance of the pre-service estimate on the payment plan.
5	TOT_PAT_PMT_AMT	NUMERIC	No
	The total patient payments towards the pre-service estimate on the payment plan.
6	TOT_PAT_ADJ_AMT	NUMERIC	No
	The total patient adjustments towards the pre-service estimate on the payment plan.
7	REMAINING_ESTIMATED_BAL	NUMERIC	No
	The remaining balance of the pre-service estimate on the payment plan.
8	PREVIOUS_ESTIMATED_BAL	NUMERIC	No
	The remaining balance from the previous statement for the pre-service estimate on the payment plan.
9	NEW_PAT_PMT_AMT	NUMERIC	No
	The new patient payments towards the pre-service estimate on the payment plan.
10	NEW_PAT_ADJ_AMT	NUMERIC	No
	The new patient adjustments towards the pre-service estimate on the payment plan.