Definitions / outage
Outage
An interruption the control room is managing: an open ticket in the outage management system, planned or not.
control · Head of Network Operations · version 1
OMS tickets opened on or before now and not restored as of now (withdrawn tickets excluded), with the customers each covers.
Latest change: First version.
SQL
SELECT o.id AS outage_id, o.feeder_id, f.code AS feeder, o.transformer_id, o.from_position, o.source, o.cause,
o.opened_at, o.customers, round(date_diff('second', o.opened_at, {now}) / 60.0, 0) AS minutes_open
FROM outages o JOIN feeders f ON f.id = o.feeder_id
WHERE o.opened_at <= {now} AND (o.restored_at IS NULL OR o.restored_at > {now})
AND coalesce(o.status, '') <> 'withdrawn'
ORDER BY o.opened_at, o.id
Tests
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| control | count_between | pass | 163 | between 0.0 and 300.0 |
| control | storm_evening | FAIL | 232 | between 20.0 and 200.0 |
| control | unique | pass | {'duplicates': 0} | outage_id unique |