Implementation Guide for Oracle Self-Service E-Billing > ETL Input File Specifications and Data Mapping >
File Formats for Service-Level Information
This topic shows the file formats for service-level information. Table 161 shows the file format for service level total information.
Table 161. Service Level Total File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 162 shows the file format for the service level on charge type information.
Table 162. Service Level on Charge Type Level File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_CHARGE_FACT
|
|
|
Table 163 shows the file format for the service charge on product and plan information.
Table 163. Service Charge on Product and Plan File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_PRODUCT_FACT
|
|
|
Table 164 shows the file format for service charge on usage type information.
Table 164. Service Charge on Usage Type File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
Table 165 shows the file format for the service charges on various tariff information.
Table 165. Service Charges on Various Tariffs File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
Table 166 shows the services miscellaneous charges type information.
Table 166. Services Miscellaneous Charges File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_MISC_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_MISC_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_MISC_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_MISC_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_MISC_FACT
|
|
|
|