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

File Record and Fact Table Mapping


Table 135 shows the mapping between ETL record types and fact tables.

Table 135. File Record and Fact Table Mapping
Record Type
Table Name
Pre-Populated
Industry Application
0000
None
Fact Data
Telco and Utility
1000
EDX_RPT_STATEMENT_FACT
Fact Data
Telco and Utility
1000
EDX_RPT_COMPANY_DIM
Can be populated from data file
Telco and Utility
1000
EDX_RPT_COUNTRY_DIM
Can be populated from data file
Telco and Utility
1000
EDX_RPT_CURRENCY_TYPE_DIM
Can be populated from data file
Telco and Utility
1000
EDX_RPT_TIME_ZONE_DIM
Can be populated from data file
Telco and Utility
1100
EDX_RPT_STATEMENT_PAYMENT
_FACT
Fact Data
Telco and Utility
1200
EDX_RPT_STATEMENT_ADJUST
_FACT
Fact Data
Telco and Utility
1300
EDX_RPT_ADDRESS_DIM
Populates from data file
Telco and Utility
2000
EDX_RPT_ACCOUNT_DIM
Populates from data file
Telco and Utility
2000
EDX_RPT_ADDRESS_DIM
Populates from data file
Telco and Utility
2000
EDX_RPT_ACCOUNT_FACT
Fact Data
Telco and Utility
2100
EDX_RPT_ACCOUNT_CHARGE
_FACT
Fact Data
Telco and Utility
3000
EDX_RPT_SERVICE_DIM
Populates from data file
Telco and Utility
3000
EDX_RPT_SERVICE_FACT
Fact Data
Telco and Utility
3100
EDX_RPT_SERVICE_CHARGE
_FACT
Fact Data
Telco and Utility
3200
EDX_RPT_SERVICE_PRODUCT
_FACT
Fact Data
Telco
3300
EDX_RPT_SERVICE_USAGE_FACT
Fact Data
Telco and Utility
3400
EDX_RPT_SERVICE_TARIFF_FACT
Fact Data
Telco
3500
EDX_RPT_SERVICE_MISC_FACT
Fact Data
Utility
4000
EDX_RPT_SERVICE_DETAIL_FACT
Fact Data
Telco
5000
EDX_RPT_PREMISE_DIM
Populates from data file
Utility
5100
EDX_RPT_CONSUM_FACT
Fact Data
Utility
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.