Bookshelf Home | Contents | Index | PDF     

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

File Record and Fact Table Mapping

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

Table 137. File Record and Fact Table Mapping
Record Type
Table Name
Prepopulated
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
4900
EDX_RPT_UNBILLED_DETAIL _FACT
Fact Data
Telco
5000
EDX_RPT_PREMISE_DIM
Populates from data file
Utility
5100
EDX_RPT_CONSUM_FACT
Fact Data
Utility
9000
EDX_RPT_PREPAY_ACCOUNT_FACT
Fact Data
Telco
9200
EDX_RPT_PREPAY_PRODUCT_FACT
Fact Data
Telco
9500
EDX_RPT_PREPAY_DETAIL_FACT
Fact Data
Telco
    
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.