Implementation Guide for Oracle Billing Insight > Customizing the Payment Consolidator Integration Module >

Payment Consolidation Database Tables


The database tables shown in Table 114 Oracle Billing Insight database tables store data used exclusively for use with the payment consolidation feature.

Table 114. 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 Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.