Feeder Vellmoor Distribution · control room Synthetic data Sun 02:00

Definitions / sustained_outage

Sustained outage

2 meanings

An interruption long enough to count against the network's reliability figures. The regulator counts anything over three minutes; network operations reports interruptions over five minutes, the international convention its benchmarking uses. Both are right for their purpose; until one is made canonical, every answer shows both.

regulator · Regulation Manager · version 1

Unplanned OMS tickets opened in the period and restored after more than 3 minutes (or still open), with the customer minutes lost.

Latest change: First version.

SQL
SELECT o.id AS outage_id, o.feeder_id, o.opened_at, o.restored_at, o.customers,
       round(date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 1) AS minutes,
       round(o.customers * date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 0) AS customer_minutes
FROM outages o
WHERE o.source IN ('calls', 'scada') AND o.opened_at >= {period_start} AND o.opened_at < {period_end}
  AND o.opened_at <= {now}
  AND (o.restored_at IS NULL OR o.restored_at > {now} OR o.restored_at > o.opened_at + INTERVAL 3 MINUTE)
ORDER BY o.opened_at, o.id

control · Head of Network Operations · version 1

Unplanned interruptions over 5 minutes counted from the meters themselves: tickets opened in the period whose first last gasp came more than 5 minutes before the restore (or which are still open).

Latest change: First version.

SQL
SELECT o.id AS outage_id, o.feeder_id, o.opened_at, o.restored_at, o.customers,
       round(date_diff('second', o.opened_at, coalesce(least(o.restored_at, {now}), {now})) / 60.0, 1) AS minutes
FROM outages o
WHERE o.source IN ('calls', 'scada') AND o.opened_at >= {period_start} AND o.opened_at < {period_end}
  AND o.opened_at <= {now}
  AND (o.restored_at IS NULL OR o.restored_at > {now} OR o.restored_at > o.opened_at + INTERVAL 5 MINUTE)
ORDER BY o.opened_at, o.id

Tests

meaningtestresultobservedexpected
regulatorcount_betweenpass188between 20.0 and 400.0
regulatoruniquepass{'duplicates': 0}outage_id unique
controlcount_betweenpass187between 20.0 and 400.0
controluniquepass{'duplicates': 0}outage_id unique