Definitions / affected_customers
Affected customers
Customers off supply right now inside open tickets: every premise whose meter hangs off a transformer an open ticket covers.
control · Head of Network Operations · version 1
Premises on transformers covered by open OMS tickets (opened on or before now, not restored, not withdrawn), each counted once.
Latest change: First version.
SQL
SELECT DISTINCT m.premise_id, m.id AS meter_id, m.feeder_id, m.transformer_id
FROM outages o
JOIN transformers t ON t.feeder_id = o.feeder_id
AND (o.transformer_id = t.id OR (o.transformer_id IS NULL AND t.position >= o.from_position))
JOIN meters m ON m.transformer_id = t.id
WHERE o.opened_at <= {now} AND (o.restored_at IS NULL OR o.restored_at > {now})
AND coalesce(o.status, '') <> 'withdrawn'
ORDER BY m.premise_id
Tests
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| control | count_between | pass | 2286 | between 0.0 and 30000.0 |
| control | unique | pass | {'duplicates': 0} | premise_id unique |