Oracle Self-Service E-Billing v6.0: File Record and Table Mapping

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


Record Type	Table Name	Pre-Populated
100	EDX_RPT_PAYMENT_TYPE_DIM	Can be populated from data file
110	EDX_RPT_ADJUSTMENT_TYPE_DIM	Can be populated from data file
120	EDX_RPT_CHARGE_TYPE_DIM	Can be populated from data file
130	EDX_RPT_SUB_CHARGE_TYPE_DIM	Can be populated from data file
140	EDX_RPT_PLAN_TYPE_DIM	Can be populated from data file
150	EDX_RPT_PRODUCT_DIM	Can be populated from data file
150	EDX_RPT_SUB_PRODUCT_DIM	Can be populated from data file
160	EDX_RPT_USAGE_TYPE_DIM	Can be populated from data file
170	EDX_RPT_TARIFF_DIM	Can be populated from data file
180	EDX_RPT_REGION_DIM	Can be populated from data file
190	EDX_RPT_CARRIER_DIM	Can be populated from data file
200	EDX_RPT_AREA_CD_DIM	Can be populated from data file
1000	EDX_RPT_STATEMENT_FACT	Fact Data
1000	EDX_RPT_COMPANY_DIM	Can be populated from data file
1000	EDX_RPT_PERIOD_DIM	Can be populated from data file
1000	EDX_RPT_COUNTRY_DIM	Can be populated from data file
1000	EDX_RPT_COMPANY_DIM	Can be populated from data file
1000	EDX_RPT_CURRENCY_TYPE_DIM	Can be populated from data file
1000	EDX_RPT_TIME_ZONE_DIM	Can be populated from data file
1100	EDX_RPT_STATEMENT_PAYMENT_FACT	Fact Data
1200	EDX_RPT_STATEMENT_ADJUST_FACT	Fact Data
2000	EDX_RPT_ACCOUNT_DIM	Populates from data file
2000	EDX_RPT_ADDRESS_DIM	Populates from data file
2000	EDX_RPT_ACCOUNT_FACT	Fact Data
2100	EDX_RPT_ACCOUNT_CHARGE_FACT	Fact Data
3000	EDX_RPT_SERVICE_DIM	Populates from data file
3000	EDX_RPT_SERVICE_FACT	Fact Data
3100	EDX_RPT_SERVICE_CHARGE_FACT	Fact Data
3200	EDX_RPT_SERVICE_PRODUCT_FACT	Fact Data
3300	EDX_RPT_SERVICE_USAGE_FACT	Fact Data
3400	EDX_RPT_SERVICE_TARIFF_FACT	Fact Data
4000	EDX_RPT_SERVICE_DETAIL_FACT	Fact Data

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