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

Definitions / priority_customer

Priority customer

A premise on the medical priority register: someone there depends on electricity for their health and is called first in an outage.

customer · Head of Customer Operations · version 1

Premises registered on or before now, with the reason on the register and where they are supplied.

Latest change: First version.

SQL
SELECT r.premise_id, r.category, r.registered_at, m.id AS meter_id, m.feeder_id, p.town
FROM priority_register r JOIN meters m ON m.premise_id = r.premise_id JOIN premises p ON p.id = r.premise_id
WHERE r.registered_at <= {now}
ORDER BY r.premise_id

Tests

meaningtestresultobservedexpected
customercount_betweenpass2200between 1000.0 and 4000.0
customeruniquepass{'duplicates': 0}premise_id unique