SCE Summary Report

Note: This report is designed for internal Finance use and is not available to most users. You must be an Organizations user with a special sce_reports role to view and download this report.

How to download the SCE Summary Report

1. Log in to the UI and then click on the Reports button:

2. Click on the SCE Summary Report button:

3. The SCE Summary Report dialog will be displayed:

4. Select the Year and Month for that report that you wish to download, then click the Download button:

5. The UI will display a pair of success messages and the report will be downloaded as a .csv file:

Understanding the SCE Summary Report

This report is available for the usage associate with a given Calendar Month

1. sceNumber – ID of the EA SCE
2. currency – The currency of the EA
3. sceCostDiscounted – identifies if the EA is discounted (true) or not discounted (false)
4. totalSceCost –  the aggregated sceCost for all usage in the EA, including all types of usage rounded to two-digit currency
5. totalReservedCost – the aggregated sceCost for all usage in the EA that is of meterType = RI rounded to two-digit currency
6. totalSavingsPlanCost – the aggregated sceCost for all usage in the EA that is of meterType = SPLAN rounded to two-digit currency
7. totalMarketplaceCost – the aggregated sceCost for all usage in the EA that is of meterType = MARKETPLACE rounded to two-digit currency
8. totalSpotCost – the aggregated sceCost for all usage in the EA that is of meterType = SPOT rounded to two-digit currency
9. totalPaygCost – the aggregated sceCost for all usage in the EA that is of meterType = PAYG rounded to two-digit currency
10. systemReservedAdjustments – the aggregated sceCost for the all adjustments of meterType=RI  rounded to two digit currency
11. systemSavingsPlanAdjustments – the aggregated sceCost for the all adjustments of meterType=SPLAN  rounded to two digit currency
12. systemMarketplaceAdjustments – the aggregated sceCost for the all adjustments of meterType=MARKETPLACE  rounded to two digit currency
13. systemSpotAdjustments – the aggregated sceCost for the all adjustments of meterType=SPOT  rounded to two digit currency
14. systemPaygAdjustments – the aggregated sceCost for the all adjustments of meterType=PAYG  rounded to two digit currency
15. calculatedSceDiscount
    1. If sceCostDiscounted = TRUE, this is “N/A”
    2. If sceCostDiscounted = FALSE, this represents the system’ expected manual discount rounded to two digit currency (this is a negative number)
16. calculatedSceCost
    1. If sceCostDiscounted = TRUE, this is “N/A”
    2. If sceCostDiscounted = FALSE, this is equal to totalSceCost + calculatedSceDiscount (same or less than totalSceCost)
17. manualSceAdjustment – If a Manual Adjustment has been submitted for this SCE for the month, an amount (positive or negative) will appear here.
18. calculatedSceCostWithAllAdjustments – the sum of calculatedSceCost + manualSceAdjustment + systemReservedAdjustments + systemSavingsPlanAdjustments + systemMarketplaceAdjustments + systemSpotAdjustments + systemPaygAdjustments

Note: In order to preserve Japanese characters in a CSV file, you must take additional steps. Please see:
https://smallbusiness.chron.com/microsoft-excel-wont-show-japanese-characters-77317.html