10 runnable scenarios. Preview them in your browser without an account; the hosted sandbox opens when the pack becomes activatable.
Everyday supply
Normal UTL_EVERYDAY_SUPPLY
Ordinary customers, premises, accounts, meters, reads, bills and field visits
Everyday, valid records: the baseline most tests expect. Children per parent record: 1–3.
Preview in the browser demo: Everyday supply
Estimated reads
Rare UTL_ESTIMATED_READS
Reads estimated because no actual read was obtained, and bills issued on estimates
Valid but uncommon business situations that production samples often miss. Children per parent record: 2–4.
Preview in the browser demo: Estimated reads
Customers in arrears
Rare UTL_CUSTOMERS_IN_ARREARS
Overdue bills, failed collections with reasons and payment arrangements for the debt
Valid but uncommon business situations that production samples often miss. Children per parent record: 1–3.
Preview in the browser demo: Customers in arrears
Meter exchanges
Rare UTL_METER_EXCHANGES
Meters exchanged at the same premise, with the field visits that performed the exchange
Valid but uncommon business situations that production samples often miss. Children per parent record: 1–3.
Preview in the browser demo: Meter exchanges
Vulnerable customers
Rare UTL_VULNERABLE_CUSTOMERS
Customers registered for priority services with synthetic reasons
Valid but uncommon business situations that production samples often miss. Children per parent record: 1–2.
Preview in the browser demo: Vulnerable customers
Zero and negative consumption
Boundary UTL_ZERO_AND_NEGATIVE_CONSUMPTION
Reads at the consumption boundary: exactly zero (vacant premises) and negative corrections
Values at the edges of valid ranges (limits, thresholds, extremes). Children per parent record: 3–6.
Preview in the browser demo: Zero and negative consumption
Back billing
Rare UTL_BACK_BILLING
Back-bills catching up long unbilled periods after missing or faulty reads
Valid but uncommon business situations that production samples often miss. Children per parent record: 1–2.
Preview in the browser demo: Back billing
Outage surge
Rare UTL_OUTAGE_SURGE
A network outage: many outage-response visits within two days, one outage reference
Valid but uncommon business situations that production samples often miss. Children per parent record: 2–5.
Preview in the browser demo: Outage surge
Duplicate reads
Duplicate UTL_DUPLICATE_READS
Meter reads submitted twice with identical content under new read ids
Records that repeat others under new keys (clean-up and matching tests). Children per parent record: 2–4.
Preview in the browser demo: Duplicate reads
Supply histories
Historical UTL_SUPPLY_HISTORIES
Multi-year, referentially intact supply, read and billing histories without gaps
Old records for archive, migration and retention tests. Children per parent record: 2–4.
Preview in the browser demo: Supply histories