|
Implementation Guide for Oracle Self-Service E-Billing > Customizing the Payment Consolidator Integration Module >
Data Element Mappings - Example A
This topic shows an example of how the following example file elements can map between the data files for consolidator A and Oracle Self-Service E-Billing:
- SIS2050ACK
- SIS2070
- SIS2070ACK
Mapping of the SIS2050ACK Data Elements to Oracle Self-Service E-Billing
NOTE: A batch header is not applicable in this example.
Table 119 shows how the file header elements in the SIS2050ACK file map to data elements in Oracle Self-Service E-Billing.
Table 119. Mapping of SIS2050ACK File Header Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Header Record Type |
Sender ID |
Sender ID |
Receiver ID |
Receiver ID |
Entity Name |
Sender Name |
File ID |
File ID |
File Creation Date |
File Creation Date |
File Creation Time |
File Creation Time |
None |
Time Zone Offset |
Filler |
Custom Field 1 |
Filler |
Custom Field 2 |
Error Code |
Status Code |
Error Message |
Status Message |
End of Record |
End of Record |
Table 120 shows how the body detail elements in the SIS2050ACK file map to elements in Oracle Self-Service E-Billing.
Table 120. Mapping of SIS2050ACK Body Detail Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Detail Record Type |
Record Action |
Action Type |
Sponsor ID |
Sponsor ID |
Subscriber ID |
Consolidator User ID |
Bill Publisher ID |
Consolidator ID |
Biller ID |
Biller ID |
Biller Account Number |
Account Number |
Service Holder Business Name |
Business Name |
Service Holder Last Name |
User's Last Name |
Service Holder First Name |
User's First Name |
Service Holder Middle Name |
User's Middle Name |
Service Address Line 1 |
User Address Line 1 |
Service Address Line 2 |
User Address Line 2 |
Service Address Line 3 |
User Address Line 3 |
Service City |
User City |
Service State |
User State |
Service Zip 5 |
User Zip 5 |
Service Zip 4 |
User Zip 4 |
Service Zip 2 |
User Zip 2 |
Service Country Code |
User Country Code |
Service Postal Code |
User Postal Code |
Service Province Name |
User Province Name |
Service Day Phone Number |
User Day Phone Number |
Service Evening Phone Number |
User Evening Phone Number |
Bill Processing Center Number |
Bill Processing Center ID |
Alternate Biller Account Number |
Alternate Biller Account Number |
New Alternate Biller Account Number |
New Alternate Biller Account Number |
Server Transaction Timestamp |
Server Transaction Timestamp |
Bill Remittance Account Number |
Bill Remittance Account Number |
Response Code |
Response Code |
Rejection Text |
Rejection Text |
Paper Question Status |
Paper Question Status |
Paper Status Code |
Paper Status |
Incentive Message ID |
Incentive Message ID |
Filler |
Custom Field 1 |
Error Code |
Status Code |
Error Message |
Status Message |
None |
Biller Name |
None |
Biller User ID |
None |
Consolidator Transaction II |
None |
Biller Transaction ID |
None |
Biller Address Line 1 |
None |
Biller Address Line 2 |
None |
Biller City |
None |
Biller State |
None |
Biller Zipcode |
None |
Biller Zip + 4 |
None |
New Account Number |
None |
User Type |
None |
User Email Address |
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 |
Auto Activation Flag |
None |
Paper Suppression Date |
None |
Custom Field 2 |
None |
Consolidator Enrollment Status |
None |
Biller Enrollment Status |
None |
Deactivation Source |
None |
Custom Field 3 |
None |
Custom Field 4 |
None |
Custom Field 5 |
None |
Custom Field 6 |
None |
Custom Field 7 |
None |
Custom Field 8 |
None |
Custom Field 9 |
None |
Record Type |
None |
Biller ID |
None |
Biller Name |
None |
Batch ID |
None |
Custom Field 1 |
None |
Custom Field 2 |
End of Record |
End of Record |
Mapping of the SIS2070 File Elements to the Oracle Self-Service E-Billing Bill Summary File
Table 121 shows the how the header elements in the SIS2070 file map to elements in Oracle Self-Service E-Billing.
Table 121. Mapping of SIS2070 File Header Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Header Record Type |
Sender ID |
Sender ID |
Receiver ID |
Receiver ID |
Sender Name |
Sender Name |
File ID |
File ID |
File Creation Date |
File Creation Date |
File Creation Time |
File Creation Time |
None |
Time Zone Offset |
None |
Custom Field 1 |
None |
Custom Field 2 |
End of Record |
End of Record |
Table 122 shows how the body detail elements in the SIS2070 file map to elements in Oracle Self-Service E-Billing.
Table 122. Mapping of the SIS2070 Body Detail Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Detail Record Type |
Record Action |
Action Type |
Bill Publisher ID |
Consolidator ID |
Bill Processing Center Number |
Bill Processing Center Number |
Biller ID |
Biller ID |
Biller Account Number |
Account Number |
Alternate Biller Account Number |
Alternate Biller Account Number |
Biller E-Bill ID |
Biller E-Bill ID |
Electronic Bill Activity Amount |
Payment Received |
Electronic Bill Amount Due |
Amount Due |
Electronic Bill Balance Amount |
Balance Amount |
Electronic Bill Minimum Amount Due |
Minimum Amount Due |
Electronic Bill Previous Balance Amount |
Previous Balance Amount |
Biller Reference Text |
Biller Reference Text |
Electronic Bill Timestamp |
Bill Statement Date |
Electronic Bill Closed Timestamp |
Bill Cycle End Date |
Payment Due Text Flag |
Payment Due Text Flag |
Electronic Bill Due Date Timestamp |
Bill Due Date |
Text Due Date |
Text Due Date |
Electronic Billing Open Statement Timestamp |
Bill Cycle Start Date |
Electronic Billing URL |
Electronic Billing URL |
Teaser Link URL |
Teaser Link URL |
Teaser Ad URL |
Teaser Ad URL |
Teaser Ad Text |
Teaser Ad Text |
E-Bill Category URL |
E-Bill Category URL |
E-Bill Category Text |
E-Bill Category Text |
FI Transaction Stamp |
None |
Electronic Bill Magnet Type |
Bill Magnet Type |
Magnet URL |
Bill Magnet URL |
Filler |
Custom Field 1 |
E-bill Category |
E-Bill Category |
Filler |
Custom Field 2 |
Error Code |
Status Code |
Error Message |
Status Message |
None |
Biller Transaction ID |
None |
Biller User ID |
None |
User First Name |
None |
User Last Name |
None |
Next Statement Date |
None |
Bill URL Expiry Date |
None |
Custom Field 3 |
None |
Custom Field 4 |
None |
Custom Field 5 |
None |
Custom Field 6 |
None |
Custom Field 7 |
None |
Custom Field 8 |
None |
Custom Field 9 |
None |
Record Type |
None |
Biller ID |
None |
Biller Name |
None |
Batch ID |
None |
Custom Field 1 |
None |
Custom Field 2 |
End of Record |
None |
Table 123 shows how the file control elements in the SIS2070 file map to elements in Oracle Self-Service E-Billing.
Table 123. Mapping of the SIS2070 File Control Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Trailer Record Type |
Record Type 1 |
Record Type 1 |
Number of Records 1 |
Number of Records 1 |
Record Type 2 |
Record Type 2 |
Number of Records 2 |
Number of Records 2 |
Record Type 3 |
Record Type 3 |
Number of Records 3 |
Number of Records 3 |
Record Type 4 |
Record Type 4 |
Number of Records 4 |
Number of Records 4 |
Record Type 5 |
Record Type 5 |
Number of Records 5 |
Number of Records 5 |
Record Type 6 |
Record Type 6 |
Number of Records 6 |
Number of Records 6 |
Record Type 7 |
Record Type 7 |
Number of Records 7 |
Number of Records 7 |
Record Type 8 |
Record Type 8 |
Number of Records 8 |
Number of Records 8 |
Record Type 9 |
Record Type 9 |
Number of Records 9 |
Number of Records 9 |
Record Type 10 |
Record Type 10 |
Number of Records 10 |
Number of Records 10 |
Record Type 11 |
Record Type 11 |
Number of Records 11 |
Number of Records 11 |
Record Type 12 |
Record Type 12 |
Number of Records 12 |
Number of Records 12 |
Record Type 13 |
Record Type 13 |
Number of Records 13 |
Number of Records 13 |
Record Type 14 |
Record Type 14 |
Number of Records 14 |
Number of Records 14 |
Record Type 15 |
Record Type 15 |
Number of Records 15 |
Number of Records 15 |
Record Type 16 |
Record Type 16 |
Number of Records 16 |
Number of Records 16 |
Record Type 17 |
Record Type 17 |
Number of Records 17 |
Number of Records 17 |
Custom Field 1 |
Custom Field 1 |
None |
Custom Field 1 |
None |
Total Batch Count |
None |
Total Record Count |
None |
File ID |
Total Record Count |
End of Record |
About Amount Fields
For some consolidators, amount fields consist of four parts:
- The amount sign. This value is a plus sign (+) for a positive balance or a minus sign (-) for a negative balance.
- The amount. The dollar amount in 9(11)V9(4) format. The amount is exactly 15 digits in length, padded with zeros if necessary. There is an implied decimal point before the right-most four numbers of the amount.
- A debit or credit indicator. The value code is always C.
- The currency code. The value is always USD (United States Dollar).
Check with your consolidator. If the biller wants to send something in an amount field, then all of these parts must be populated. If the biller does not want to send something in an amount field, then all four parts must be blank. Mapping of the SIS2070ACK File Elements to Oracle Self-Service E-Billing
NOTE: The SIS2070ACK file contains no batch header, batch control, or file control records.
Table 124 shows how the header record elements in the SIS2070ACK file map to elements in Oracle Self-Service E-Billing.
Table 124. Mapping of SIS2070ACK Header Record Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Header Record Type |
Sender ID |
Sender ID |
Receiver ID |
Receiver ID |
Sender Name |
Sender Name |
File ID |
File ID |
File Creation Date |
File Creation Date |
File Creation Time |
File Creation Time |
None |
Time Zone Offset |
Error Code |
Status Code |
Error Message |
Status Message |
None |
Custom Field 1 |
None |
Custom Field 2 |
End of Record |
End of Record |
Table 125 shows how the body detail elements in the SIS2070ACK file map to elements in
Table 125. Mapping of the SIS2070ACK Body Detail Elements to Oracle Self-Service E-Billing
File Element of Consolidator A |
Oracle Self-Service E-Billing Element |
Record Type |
Detail Record Type |
Record Action |
Action Type |
Bill Publisher ID |
Consolidator ID |
Bill Processing Center Number |
Bill Processing Center Number |
Biller ID |
Biller ID |
Biller Account Number |
Biller Account Number |
Alternate Biller Account Number |
Alternate Biller Account Number |
Biller E-Bill ID |
Biller E-Bill ID |
Electronic Bill Activity Amount |
Payment Received |
Electronic Bill Amount Due |
Amount Due |
Electronic Bill Balance Amount |
Balance Amount |
Electronic Bill Minimum Amount Due |
Minimum Amount Due |
Electronic Bill Previous Balance Amount |
Previous Balance Amount |
Biller Reference Text |
Biller Reference Text |
Electronic Bill Timestamp |
Bill Statement Date |
Electronic Bill Closed Timestamp |
Bill Cycle End Date |
Payment Due Text Flag |
Payment Due Text Flag |
Electronic Bill Due Date Timestamp |
Bill Due Date |
Text Due Date |
Text Due Date |
Electronic Billing Open Statement Timestamp |
Bill Cycle Start Date |
Electronic Billing URL |
Electronic Billing URL |
Teaser Link URL |
Teaser Link URL |
Teaser Ad URL |
Teaser Ad URL |
Teaser Ad Text |
Teaser Ad Text |
E-Bill Category URL |
E-Bill Category URL |
E-Bill Category Text |
E-Bill Category Text |
FI Transaction Stamp |
None |
Electronic Bill Magnet Type |
Bill Magnet Type |
Magnet URL |
Bill Magnet URL |
Filler |
Custom Field 1 |
E-bill Category |
E-Bill Category |
Filler |
Custom Field 2 |
Error Code |
Error Code |
Error Message |
Error Message |
None |
Custom Field 3 |
None |
Custom Field 4 |
None |
Custom Field 5 |
None |
Custom Field 6 |
None |
Custom Field 7 |
None |
Custom Field 8 |
None |
Custom Field 9 |
None |
Record Type |
None |
Biller ID |
None |
Biller Name |
None |
Batch ID |
None |
Custom Field 1 |
None |
Custom Field 2 |
End of Record |
End of Record |
Oracle Self-Service E-Billing.
| 
