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

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

meaningtestresultobservedexpected
controlcount_betweenpass2286between 0.0 and 30000.0
controluniquepass{'duplicates': 0}premise_id unique