Administration Guide for Oracle Self-Service E-Billing > Recurring Payments >

Database Tables Affected by Recurring Payments

The recurring_payments table only contains the setup information for the recurring payment, which is the data entered from Web interface by end users. It is not used to save bill summary or actual payment information. The amount field in the recurring_payments table records the amount as a result of the following actions:

• Specify the recurring payment to pay fixed amount, or
• Pay if less than this amount, or
• Pay up to this amount

Bill summary information is retrieved from the Oracle Self-Service E-Billing tables and saved into the payment_bill_summaries table. After the pmtRecurringPayment job runs, the payment_bill_summaries table is populated, and the bill ID of the recurring_payments table is also populated. Payment information is scheduled into the check_payments (for check) or creditcard_payments (for credit card) tables.