Implementation Guide for Oracle Self-Service E-Billing > Customizing the Payment Consolidator Integration Module >

Payment Consolidation Database Tables


The database tables shown in Table 134 Oracle Self-Service E-Billing database tables store data used exclusively for use with the payment consolidation feature.

Table 134. Payment Consolidation Database Tables
Payment Consolidation Database Table
Description

EDX_PC_ACCOUNT_ENROLL

This table stores information on the enrollment status of an account with a consolidator.

EDX_PC_ACCOUNT_ENROLL_HISTORY

This table stores information on the changes to the enrollment status of an account over time.

EDX_PC_ACCT_ENROLL_DETAIL

This table stores detail information on an account.

EDX_PC_ACCT_ENROLL_DETAIL_HIST

This table stores information on every file and record that has been processed by the enrollment jobs.

EDX_PC_ENROLL_FILE

This table stores file record information for the enrollment input file.

EDX_PC_ENROLL_BATCH

This table stores batch record information for the enrollment input file.

EDX_PC_BILLER

This table stores records that were rejected by the external system or failed internal processing.

EDX_PC_BILLER

This table stores biller ID and names, processing center, and the URLs to bill and marketing links.

EDX_PC_CONSOLIDATOR

This table stores the consolidator ID and names.

EDX_PC_BILLSUMMARY_LOG

This table stores bill summary generation and acknowledgement status information.

EDX_PC_FILETYPE_MAPPING

This table stores the file-type mapping information configured for the payment consolidator.

Implementation Guide for Oracle Self-Service E-Billing Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.