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

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

meaningtestresultobservedexpected
controlcount_betweenpass163between 0.0 and 300.0
controlstorm_eveningFAIL232between 20.0 and 200.0
controluniquepass{'duplicates': 0}outage_id unique