Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Billing Insight > Load Input File Specifications and Data Mapping >

File Record and Dimension Table Mapping

Table 122 shows the mapping between load record types and Oracle Billing Insight database tables.

Table 122. 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 Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.