|
Implementation Guide for Oracle Billing Insight > Customizing the Payment Consolidator Integration Module >
Data Element Mappings - Example B
This topic shows an example of how the following file elements can map between the data files for Consolidator B and Oracle Billing Insight:
- A consolidator's enrollment response file
- Oracle Billing Insight bill summary file
- A consolidator's details confirmation file
Table 106 shows how the file header elements of Consolidator B's enrollment response file map to elements in Oracle Billing Insight.
Table 106. Mapping of Consolidator B's Enrollment Response File Header Elements to Oracle Billing Insight
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type code |
Header Record Type |
ENV |
None |
Originator ID |
Sender ID |
Originator Name |
Sender Name |
File ID |
File ID |
File Creation Date |
File Creation Date |
File Creation Time |
File Creation Time |
File Type |
None |
UTC |
Time Zone Offset |
UTC Timezone |
Time Zone Offset |
Custom Field 1 |
Custom Field 1 |
Custom Field 2 |
Custom Field 2 |
None |
Receiver ID |
None |
Status Code |
None |
Status Message |
Table 107 shows how the batch header elements of Consolidator B's enrollment response file map to elements in Oracle Billing Insight.
Table 107. Mapping of Consolidator B's Enrollment Response File Batch Header Elements to Oracle Billing Insight
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type code |
Batch Record Type |
Biller ID |
Biller ID |
Biller Name |
Biller Name |
Batch ID |
Batch ID |
Custom Field 1 |
Custom Field 1 |
Custom Field 2 |
Custom Field 2 |
Table 108 shows how body detail elements of Consolidator B's enrollment response file map to elements in Oracle Billing Insight.
Table 108. Mapping of Consolidator B's Enrollment Response File Body Detail Elements to Oracle Billing Insight
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type code |
Detail Record Type |
Transaction Code |
Action Type |
EBill Channel Type ID |
Sponsor ID |
Transaction Expression |
Action Description |
Originator Enrollment ID |
Consolidator Transaction ID |
Processor Enrollment ID |
Biller Transaction ID |
Originator Payor ID |
Consolidator User ID |
Processor Payor ID |
Biller User ID |
eBill Start Date |
E-Bill Start Date |
Paper Suppression Date |
Paper Suppression Date |
Biller ID |
Biller ID |
Custom Field 1 |
Account Number |
Custom Field 2 |
Custom Field 1 |
Custom Field 3 |
Custom Field 2 |
Custom Field 4 |
Custom Field 3 |
Custom Field 5 |
Custom Field 4 |
Custom Field 6 |
Custom Field 5 |
Status Code |
Status Code |
Status Message |
Status Message |
None |
Consolidator ID, |
None |
New Account Number |
None |
User Type |
None |
Business Name |
None |
Biller Name |
None |
Biller Address 1 |
None |
Biller Address 2 |
None |
City |
None |
State |
None |
ZipCode |
None |
Zip+4 |
None |
User Last Name |
None |
User First Name |
None |
User Middle Name |
None |
User Email Address |
None |
Address Line 1 |
None |
Address Line 2 |
None |
Address Line 3 |
None |
City |
None |
State |
None |
Zip 5 |
None |
Zip 4 |
None |
Zip 2 |
None |
Country Code |
None |
Postal Code |
None |
Province Name |
None |
Day Phone Number, |
None |
Evening Phone Number |
None |
Bill Processing Center ID |
None |
Bill Payment Activated |
None |
Service Verification Field 1 |
None |
Service Verification Field 2 |
None |
Service Verification Field 3 |
None |
Service Verification Field 4 |
None |
Service Verification Field 5 |
None |
Service Verification Field 6 |
None |
Alternate Biller Account Number |
None |
New Alternate Biller Account Number |
None |
Server Transaction Timestamp |
None |
Auto Activation Flag |
None |
Bill Remittance Account Number |
None |
Response Code |
None |
Rejection Text |
None |
Paper Question Status |
None |
Paper Status |
None |
Custom Field 6 |
None |
Custom Field 7 |
None |
Custom Field 8 |
None |
Custom Field 9 |
Record Type Code |
None |
Total Transaction Count |
None |
Batch ID |
None |
Record Type Code |
None |
Total Batch Count |
None |
Total Transaction Count |
None |
File ID |
None |
Mapping of the Oracle Billing Insight Bill Summary File Elements
Table 109 shows how the file header elements in the Oracle Billing Insight file map to elements for Consolidator B.
Table 109. Mapping of the Bill Summary File Header Elements to Consolidator B's Elements
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type code |
Header Record Type |
ENV |
None |
Originator ID |
Sender ID |
Originator Name |
Sender Name |
File ID |
File ID |
File Creation Date |
File Creation Date |
File Creation Time |
File Creation Time |
File Type |
None |
UTC |
Time Zone Offset |
UTC Timezone |
Time Zone Offset |
Custom Field 1 |
Custom Field 1 |
Custom Field 2 |
Custom Field 2 |
None |
Receiver ID |
The batch header elements in the Bill Summary file map to Consolidator B's file details as shown in Table 108. Table 110 shows how the body detail elements in the Oracle Billing Insight Bill Summary File map to Consolidator B's data elements.
Table 110. Mapping of the Body Detail Elements in the Bill Summary File to Consolidator B's Elements
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type |
Detail Record Type |
Transaction Code |
Action Type |
Transaction Expression |
None |
Processor Enrollment ID |
Biller Transaction ID |
Processor Payor ID |
Biller User ID |
Biller ID |
Biller ID |
Payor Account Number |
Biller Account Number |
Processor E- Bill Detail ID |
Biller E- Bill ID |
Invoice Number |
Biller E- Bill ID |
Payor First Name |
User First Name |
Payor Last Name |
User Last Name |
Total Amount Due |
Amount Due |
Account Balance |
Balance Amount |
Next Statement Date |
Next Statement Date |
Minimum Due |
Minimum Amount Due |
Previous Balance |
Previous Balance Amount |
Statement Date |
Statement Date |
Due Date |
Bill Due Date |
Bill URL Type |
None |
Bill URL Expire Date |
Bill URL Expiry Date |
NOC 1 |
None |
NOC 2 |
None |
Bill URL |
Electronic Billing URL |
Custom1 |
Custom Field 1 |
Custom2 |
Custom Field 2 |
Custom3 |
Custom Field 3 |
Custom4 |
Custom Field 4 |
None |
Bill Processing Center Number |
None |
Alternate Biller Account Number |
None |
Payment Received |
None |
Biller Reference Text |
None |
Bill Cycle End Date |
None |
Payment Due Text Flag |
None |
Text Due Date |
None |
Bill Cycle Start Date |
None |
Teaser Link URL |
None |
Teaser Ad URL |
None |
Teaser Ad Text |
None |
E-Bill Category URL |
None |
E-Bill Category Text |
None |
E-Bill Magnet Type |
None |
E-Bill Magnet URL |
None |
E-Bill Category |
None |
Custom Field 5 |
None |
Custom Field 6 |
None |
Custom Field 7 |
Table 111 shows how the batch control elements in the Oracle Billing Insight Bill Summary file map to Consolidator B's data elements.
Table 111. Mapping of the Batch Control Elements in the Bill Summary File to Consolidator B's Elements
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type code |
Batch Control Record Type Code |
Total Transaction Count |
Total Record Count |
Batch ID |
Batch ID |
Custom Field 1 |
Custom Field 1 |
Custom Field 2 |
Custom Field 2 |
Table 112 shows how the file control elements in the Oracle Billing Insight Bill Summary File map to Consolidator B's elements.
Table 112. Mapping of the File Control Elements in the Bill Summary File Map to Consolidator B's Elements
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type Code |
Trailer Record Type |
Total Batch Count |
Total Batch Count |
Total Transaction Count |
Total Record Count |
File ID |
File ID |
None |
Record Type 1 |
None |
Number of Records 1 |
None |
Record Type 2 |
None |
Number of Records 2 |
None |
Record Type 3 |
None |
Number of Records 3 |
None |
Record Type 4 |
None |
Number of Records 4 |
None |
Record Type 5 |
None |
Number of Records 5 |
None |
Record Type 6 |
None |
Number of Records 6 |
None |
Record Type 7 |
None |
Number of Records 7 |
None |
Record Type 8 |
None |
Number of Records 8 |
None |
Record Type 9 |
None |
Number of Records 9 |
None |
Record Type 10 |
None |
Number of Records 10 |
None |
Record Type 11 |
None |
Number of Records 11 |
None |
Record Type 12 |
None |
Number of Records 12 |
None |
Record Type 13 |
None |
Number of Records 13 |
None |
Record Type 14 |
None |
Number of Records 14 |
None |
Record Type 15 |
None |
Number of Records 15 |
None |
Record Type 16 |
None |
Number of Records 16 |
None |
Record Type 17 |
None |
Number of Records 17 |
None |
Custom Field 1 |
Mapping of the Details Confirmation File to Oracle Billing Insight
The file header elements in the details confirmation file map to elements in Oracle Billing Insight as shown in Table 107. The batch header elements in the details confirmation file map to elements in Oracle Billing Insight as shown in Table 108. Table 113 shows how the body detail elements of Consolidator B's details confirmation file map to elements in Oracle Billing Insight.
Table 113. Mapping of the Body Detail Elements of Consolidator B's Details Confirmation File Map to Oracle Billing Insight
File Element of Consolidator B |
Oracle Billing Insight Element |
Record Type |
Detail Record Type |
Processor E-Bill Detail ID |
Biller E-Bill ID |
Status Code |
Status Code |
Status Message |
Status Message |
Custom1 |
Custom Field 1 |
Custom2 |
Custom Field 2 |
Custom3 |
Custom Field 3 |
Custom4 |
Custom Field 4 |
None |
Custom Field 5 |
None |
Custom Field 6 |
None |
Custom Field 7 |
None |
Consolidator ID |
None |
Bill Processing Center Number |
None |
Biller ID |
None |
Biller Account Number |
None |
Alternate Biller Account Number |
None |
E-Bill Category |
| 
