BILL_SCHED_PMT_2

Description:

This table contains information about scheduled payments. This can include payment plan agreements and payments, Visit Auto Pay payment plans and payments, and trust transfers and payments.

Primary Key

Column Name	Ordinal Position
SCHED_PMT_ID	1

Column Information

	Name	Type	Discontinued?
1	SCHED_PMT_ID	NUMERIC	No
	The unique identifier (.1 item) for the scheduled payment record.
2	PP_INITIAL_DUE_AMT	NUMERIC	No
	The amount requested to be paid on this payment plan at the start of the monthly cycle.
3	PP_INITIAL_OVERPAID_AMT	NUMERIC	No
	The amount in which this payment plan was overpaid at the start of the monthly cycle.
4	PP_INITIAL_OVERDUE_AMT	NUMERIC	No
	The overdue amount on this payment plan at the start of the monthly cycle.
5	PP_REMAINING_DUE_AMT	NUMERIC	No
	The outstanding amount for this month on this payment plan.
6	PP_PAID_AMT	NUMERIC	No
	The total amount paid towards the current month's due amount. This number includes payments, reversals, and transfers that affect the due, but will not include adjustments and other non-payment transactions.
7	PP_OVERPAYMENT_AMT	NUMERIC	No
	The amount that is overpaid and accounting for future months.
8	PP_OVERDUE_AMT	NUMERIC	No
	The amount that was unpaid from prior months.
9	PP_OVERPMT_CONTRIB_MTHD_C_NAME	VARCHAR	No
	The category ID of the payment plan overpayment contribution method setting in the hospital billing profile at the time of the payment plan tracker record's creation. May contain organization-specific values: No Category Entries: Remaining Balance Future Months
10	PP_AUTO_PAY_INCL_OVERDUE_YN	VARCHAR	No
	Indicates that the Auto Pay payment plan amount should include any overdue balances when processing. This is copied from the hospital billing profile at the time of the payment plan's most recent calculation. A 'Y' indicates that the payment plan should include overdue balances. 'N' indicates that it should not. NULL indicates that this is not an Auto Pay payment plan. May contain organization-specific values: No Category Entries: No Yes
11	PP_PB_UNDIST_PMT_AMT	NUMERIC	No
	The total amount of PB payments that have been applied to the payment plan but not yet applied to PB visit accounts on the payment plan.