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
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| customer | count_between | pass | 2200 | between 1000.0 and 4000.0 |
| customer | unique | pass | {'duplicates': 0} | premise_id unique |