Implementation Guide for Oracle Billing Insight > Load Input File Specifications and Data Mapping >
File Formats for Service-Level Information
This topic shows the file formats for service-level data. Table 148 shows the file format for service level total information.
Table 148. Service Level Total File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 149 shows the file format for the service level on charge type information.
Table 149. 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 150 shows the file format for the service charge on product and plan information.
Table 150. 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 151 shows the file format for service charge on usage type information.
Table 151. 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
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_USAGE_FACT
|
|
|
Table 152 shows the file format for the service charges on various tariff information.
Table 152. 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
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_SERVICE_TARIFF_FACT
|
|
|
Table 153 shows the services miscellaneous charges type information.
Table 153. 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
|
|
|
|