Implementation Guide for Oracle Self-Service E-Billing > ETL Input File Specifications and Data Mapping >

File Record and Table Mapping


Table 134 shows the mapping between ETL record types and Oracle Self-Service E-Billing database tables.

Table 134. File Record and DIM Table Mapping
Record Type
Table Name
Pre-Populated
Industry Application
100
EDX_RPT_PAYMENT_TYPE_DIM
Can be populated from data file
Telco and Utility
110
EDX_RPT_ADJUSTMENT_TYPE_DIM
Can be populated from data file
Telco and Utility
120
EDX_RPT_CHARGE_TYPE_DIM
Can be populated from data file
Telco and Utility
130
EDX_RPT_SUB_CHARGE_TYPE_DIM
Can be populated from data file
Telco and Utility
140
EDX_RPT_PLAN_TYPE_DIM
Can be populated from data file
Telco
150
EDX_RPT_PRODUCT_DIM
Can be populated from data file
Telco
150
EDX_RPT_SUB_PRODUCT_DIM
Can be populated from data file
Telco
160
EDX_RPT_USAGE_TYPE_DIM
Can be populated from data file
Telco and Utility
170
EDX_RPT_TARIFF_DIM
Can be populated from data file
Telco
180
EDX_RPT_REGION_DIM
Can be populated from data file
Telco
190
EDX_RPT_CARRIER_DIM
Can be populated from data file
Telco
200
EDX_RPT_AREA_CD_DIM
Can be populated from data file
Telco
210
EDX_RPT_SERVICE_TYPE_DIM
Can be populated from data file
Telco and Utility
220
EDX_RPT_UNIT_DIM
Can be populated from data file
Telco and Utility
230
EDX_RPT_CHARGE_NOTES_DIM
Can be populated from data file
Telco and Utility
240
EDX_RPT_DIRECTION_DIM
Can be populated from data file
Telco
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.