Table 134. Payment Consolidation Database Tables
Payment Consolidation Database Table |
|
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. |