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 156 shows the file format service level total information. Table 156. Service Level Total
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
File FormatTable 157 shows the file format for the service level on charge type information. Table 157. Service Level on Charge Type
|
|
|
|
|
|
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
|
|
|
File FormatTable 158 shows the file format for the service charge on product and plan information. Table 158. Service Charge on Product and Plan
|
|
|
|
|
|
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
|
|
|
File FormatTable 159 shows the file format for service charge on usage type information. Table 159. Service Charge on Usage Type
|
|
|
|
|
|
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
|
|
|
File FormatTable 160 shows the file format for the service charges on various tariff information. Table 160. Service Charges on Various Tariff
|
|
|
|
|
|
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
|
|
|
File Format
Table 161 shows the services miscellaneous charges type information. Table 161. 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
|
|
|
|