Trouble Reporting Reports

The Oracle Utilities Network Management System – Trouble Reporting module gathers pertinent information about completed outages from the Oracle Analytics Server Data Warehouse and calculates performance measures of the distribution system. The information gathered consists of historical data from various areas such as causes, devices, outage times, call details, crew details, and customer details. In addition to reports of trouble-related information, Trouble Reporting includes reports of performance measures based on reliability indices.

This section describes the following reports:

• CEMI

• CELID

• Daily Trouble

• Device Outage History

• Feeder Impact on Systems Metrics

• Recurring Device Outages

• IEEE Indices Calculations

• IEEE TMED Calculations

• IEEE Benchmarking

CEMI

The CEMI report calculates the IEEE CEMI and CEMSMI metric at the company, district, and feeder levels. CEMI is the percentage of customers that have experienced N or more number of sustained outages. CEMSMI is the percentage of customers that have experienced N or more number of sustained and momentary outages. For this report, CEMI and CEMSMI are calculated for N between 1 and 10.

The CEMI report displays the following columns:

• % of Customers with >= N Interruptions contains the CEMI metric corresponding to the Number of Interruptions value of that row.

• Average Customers Served contains the average number of customers that were served during the time period selected. This value is used as the denominator in the CEMI metric.

• District (in the District tab of the report) shows the District for which the metric is being calculated.

• Substation (in the Feeder tab of the report) shows the Substation the Feeder belongs to.

• Feeder (in the Feeder tab of the report) shows the Feeder for which the metric is being calculated.

CELID

The CELID report calculates the IEEE CELIDT metric at the company, district, and feeder levels. CELIDT is the percentage of customers that have experienced N or more hours of total outage duration.

The CELID report displays the following columns:

• Company contains the name of the company for which the metric is calculated.

• District contains the name of the district for which the metric is calculated.

• Feeder contains the name of the feeder for which the metric is calculated.

• Substation contains the name of the substation the feeder belongs to.

• Hours of Interruption is the N number of hours value for which the metric is calculated.

• % of Customers With >= N Hours of Interruption value is the CELID metric for the corresponding Hours of Interruption.

• Average Customers Served is the average customers served for the company, district, or feeder and time period selected.

Daily Trouble

The Daily Trouble Report displays events on a daily basis. It identifies the crew, hours worked, resolution and primary cause. Each column is organized by the report categories.

This report contains the following columns:

• Company contains the name of the company where the outage is located.

• Region contains the name of the region where the outage is located.

• Division contains the name of the division where the outage is located.

• District contains the name of the district where the outage is located.

• Substation contains the name of the substation where the outage is located.

• Feeder contains the name of the feeder where the outage is located.

• Device Name contains the name of the interrupting device associated with the outage.

• Event # contains the system identification number for the outage.

• CI contains the number of customers impacted for the outage.

• MCI contains the number of momentary customers impacted for the outage.

• CMI contains the customer minutes interrupted for the outage.

• Begin Date Time contains the date and time the outage began.

• Restore Date Time contains the date and time the outage was restored.

• Primary Cause contains the primary cause of the outage as determined from the drop-down selection in the Event Details window. This is useful for filtering, sorting, and analyzing outage causes.

• Crew Assigned contains the name of the crew leader for the crew associated with the outage, if any.

• Operator Comments contains the operations event note associated with the outage.

Device Outage History

The Device Outage History displays the history of outages for a selected device during a selected period. A summarization of the customer interruptions, customer minutes interrupted and number of events for each distinct interrupting device and each distinct interrupting device type is also displayed.

This report contains the following columns:

• Device Type contains the type of device.

• Device Name contains the name of the interrupting device.

• Begin Date contains the date and time the outage began.

• Restored Date contains the date and time the outage was restored.

• Customer Interruptions contains the total number of customers affected by the outage.

• Customer Minutes Interrupted contains the sum of the customers affected by the outage multiplied by the outage duration.

• Event # contains the system identification number for the outage.

• Primary Cause contains the primary cause of the outage as determined from the drop-down selection in the Event Details window. This is useful for filtering, sorting, and analyzing outage causes.

Feeder Impact on Systems Metrics

The Feeder Impact on Systems Metrics Report has 3 tabs. The SAIDI Impact tab shows the impact of feeders on the SAIDI metric. The SAIFI Impact tab shows the impact of feeders on the SAIFI metric. The MAIFI Impact tab shows the impact of feeders on the MAIFI metric.

The report has the following prompts:

• Begin constrains outages occurring on or after the selected date.

• End constrains outages occurring before the selected date.

• Excluding Major Events includes or excludes major events.

• The report displays the following columns:

• Feeder contains the name of the feeder for which the metrics are calculated.

• CMI contains the Customer Minutes of Interruption occurred on the feeder during the selected time period.

• System SAIDI Impact contains the percentage of the system SAIDI the feeder accounts for.

• Cumulative System SAIDI contains the Cumulative Impact of System SAIDI up to the current row.

• System SAIFI Impact contains the percentage of the system SAIFI the feeder accounts for.

• Cumulative System SAIFI contains the Cumulative Impact of System SAIFI up to the current row.

• System MAIFI Impact contains the percentage of the system MAIFI the feeder accounts for.

• Cumulative System MAIFI contains the Cumulative Impact of System MAIFI up to the current row.

Recurring Device Outages

The Recurring Device Outages report identifies interrupting devices that have been associated with a specified number or more sustained and momentary outages. This report displays all device outages for the period requested and is organized by the report categories.

This report displays the following columns:

• Company contains the name of the company where the outages are located.

• Region contains the name of the region where the outages are located.

• Division contains the name of the division where the outages are located.

• District contains the name of the district where the outages are located.

• Substation contains the name of the substation where the outages are located.

• Feeder contains the name of the feeder where the outages are located.

• Device Type contains the device type of the interrupting device on which the outages are located.

• Device Name contains the device name of the interrupting device on which the outages are located.

• Total Outages contains the total number of outages on the device during the specified period.

• Total Duration contains the total duration of outages on the device experiencing outages during the specified period.

• Customer Minutes Interrupted contains the sum of the customers affected multiplied by the outage duration for each outage on the device during the specified period.

• Sustained Customers Interrupted contains the total number of sustained customers interrupted on the device experiencing outages during the specified period.

• Momentary Customers Interrupted contains the total number of momentary customers interrupted on the device experiencing outages during the specified period.

• Customer Minutes Interrupted contains the sum of the customers affected multiplied by the outage duration for each outage on the device during the specified period.

IEEE Indices Calculations

The reliability indices are calculated values that provide a measure of reliability of the distribution system. This report has tabs for reliability indices calculated at 6 control zone levels (Company, Region, Division, District, Substation, and Feeder). Users can filter by Begin and End date, Major Event Type, and Primary Cause.

For more information about reliability indices, refer to the IEEE Std 1366-2003.

The report displays the following columns:

• Region contains the name of the Region for the indices calculations.

• Division contains the name of the Division for the indices calculations.

• District contains the name of the District for the indices calculations.

• Substation contains the name of the Substation for the indices calculations.

• Feeder contains the name of the Feeder for the indices calculations.

• Avg Customers Served contains the Average Customers Served during the selected time period.

• SAIDI contains the SAIDI metric (Customer Minutes Interrupted/Avg Customers Served).

• SAIFI contains the SAIFI metric (Sustained Customer Interruptions/Avg Customers Served).

• CAIDI contains the CAIDI metric (Customer Minutes Interrupted/Sustained Customers Interrupted).

• MAIFI contains the MAIFI metric (Momentary Customers Interrupted/Avg Customers Served).

• ASAI contains the ASAI metric (Customer Service Availability/Customer Service Demand).

• CAIFI contains the CAIFI metric (Sustained Customers Interrupted/Total Number of Distinct Sustained Customers Interrupted).

• CTAIDI contains the CTAIDI metric (Customer Minutes Interrupted/Total Number of Distinct Sustained Customers Interrupted).

IEEE TMED Calculations

The IEEE TMED Calculations report calculates the Major Event Threshold using the IEEE 1366-2003 2.5 Beta Method. The report has 4 tabs. The tabular view shows the daily SAIDI, SAIFI, and CAIDI metrics, and the Major Event Threshold calculation details. The other tabs show a graph of the daily SAIDI, SAIFI, and CAIDI metric for major events included and excluded.

The IEEE TMED Calculations report consists of the following columns:

• Year contains year for the Major Event Threshold calculation.

• Non-Zero Days contains the number of days that had sustained outages in the 5-year period used for the Major Event Threshold calculation.

• Alpha contains the average of natural log of the daily SAIDI values for the 5-year period used in the Major Event Threshold calculation.

• Beta contains the standard deviation of the natural log of the daily SAIDI values for the 5-year period used in the Major Event Threshold calculation.

• SAIDI TMED contains the calculated Major Event SAIDI threshold.

• Average Customers Served contains the Average Customers Served for the year the major event threshold was calculated for.

• CMI TMED contains the Customer Minutes Interrupted Major Event Threshold.

• SAIDI IEEE Cumulative contains the Cumulative Daily SAIDI IEEE value.

• SAIFI IEEE Cumulative contains the Cumulative Daily SAIFI IEEE value.

• CAIDI IEEE Cumulative column contains the Cumulative Daily CAIDI IEEE value.

• SAIDI All Cumulative contains the Cumulative Daily SAIDI All value.

• SAIFI All Cumulative contains the Cumulative Daily SAIFI IEEE value.

• CAIDI All Cumulative contains the Cumulative Daily CAIDI All value.

• Daily SAIDI contains the Daily SAIDI value.

• Daily SAIFI contains the Daily SAIFI value.

• MED indicates if the day exceeded the Major Event Threshold and qualifies as a Major Event Day.

IEEE Benchmarking

The IEEE Benchmarking Report contains columns necessary to submit data to the IEEE Distribution Reliability Working Group for participation in benchmarking activities.

This report displays the following columns:

• Year contains year for the Average Customers Served measure.

• Average Customers Served contains the average customers served for the year.

• Date contains the date for outage metrics.

• CMI contains Customer Minutes Interrupted for the date.

• CI contains the Sustained Customer Interruptions for the date.

• Events contains the number of sustained outages for the date.