Bookshelf Home | Contents | Index | PDF     

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

File Record and Dimension Table Mapping

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

Table 136. File Record and DIM Table Mapping
Record Type
Table Name
Prepopulated
Industry Application
100
EDX_RPT_PAYMENT_TYPE_DIM
Can be populated from a data file
Telco and Utility
110
EDX_RPT_ADJUSTMENT_TYPE_DIM
Can be populated from a data file
Telco and Utility
120
EDX_RPT_CHARGE_TYPE_DIM
Can be populated from a data file
Telco and Utility
130
EDX_RPT_SUB_CHARGE_TYPE_DIM
Can be populated from a data file
Telco and Utility
140
EDX_RPT_PLAN_TYPE_DIM
Can be populated from a data file
Telco
150
EDX_RPT_PRODUCT_DIM
Can be populated from a data file
Telco
150
EDX_RPT_SUB_PRODUCT_DIM
Can be populated from a data file
Telco
160
EDX_RPT_USAGE_TYPE_DIM
Can be populated from a data file
Telco and Utility
170
EDX_RPT_TARIFF_DIM
Can be populated from a data file
Telco
180
EDX_RPT_REGION_DIM
Can be populated from a data file
Telco
190
EDX_RPT_CARRIER_DIM
Can be populated from a data file
Telco
200
EDX_RPT_AREA_CD_DIM
Can be populated from a data file
Telco
210
EDX_RPT_SERVICE_TYPE_DIM
Can be populated from a data file
Telco and Utility
220
EDX_RPT_UNIT_DIM
Can be populated from a data file
Telco and Utility
230
EDX_RPT_CHARGE_NOTES_DIM
Can be populated from a data file
Telco and Utility
240
EDX_RPT_DIRECTION_DIM
Can be populated from a data file
Telco
250
EDX_RPT_PRODUCT_RATE_MAP_DIM
Can be populated from a data file
 
Telco

    
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.