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

Definitions / restored

Restored

An interruption whose customers have supply again, by the ticket being closed in the outage management system.

control · Head of Network Operations · version 1

OMS tickets restored in the period (on or before now), with how long each was open.

Latest change: First version.

SQL
SELECT o.id AS outage_id, o.feeder_id, o.source, o.opened_at, o.restored_at, o.customers,
       round(date_diff('second', o.opened_at, o.restored_at) / 60.0, 1) AS minutes_open
FROM outages o
WHERE o.restored_at >= {period_start} AND o.restored_at < {period_end} AND o.restored_at <= {now}
ORDER BY o.restored_at, o.id

Tests

meaningtestresultobservedexpected
controlcount_betweenpass56between 0.0 and 400.0
controluniquepass{'duplicates': 0}outage_id unique