Metric migration / DS-03
DS-03 Inspections completed by the next business day
Owner: Development Services. Unit: %. Reconciliation tolerance: 0.1. Target: 90.0 (higher is better).
Written definition
- Source
- EnerGov inspections
- Calculation
- Inspections completed in the month within one business day of the request, divided by all inspections completed in the month, times 100.
- Inclusions
- All inspection types.
- Exclusions
- Inspections not yet completed.
- Time frame
- Calendar month of completion.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Inspections completed by the next business day
- Note
- Inspections completed in the month within one business day of the request
- Script
perf_ds_03.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', completed_at)::date as month, 100.0 * avg(case when business_days_to_complete <= 1 then 1 else 0 end) as value from curated.fact_inspection where completed_at is not null group by 1
Reproduce now from the curated layer Runs the SQL above against the current curated tables, read only.
Reproduced 13 months in 10 ms from the curated layer; 13 of 13 match the values stored by the latest run.
| Oct 2025 | Nov 2025 | Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026 | Jun 2026 | Jul 2026 | Aug 2026 | Sep 2026 | Oct 2026 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91.35 | 90.99 | 89.91 | 89.21 | 90.43 | 88.46 | 89.68 | 91.09 | 92.25 | 90.49 | 91.16 | 91.42 | 89.36 |
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 91.4 | 91.351 | -0.049 | Within tolerance |
| Nov 2025 | 91.0 | 90.990 | -0.010 | Within tolerance |
| Dec 2025 | 89.9 | 89.910 | 0.010 | Within tolerance |
| Jan 2026 | 89.2 | 89.208 | 0.008 | Within tolerance |
| Feb 2026 | 90.4 | 90.427 | 0.027 | Within tolerance |
| Mar 2026 | 88.5 | 88.456 | -0.044 | Within tolerance |
| Apr 2026 | 89.7 | 89.676 | -0.024 | Within tolerance |
| May 2026 | 91.1 | 91.086 | -0.014 | Within tolerance |
| Jun 2026 | 92.3 | 92.251 | -0.049 | Within tolerance |
| Jul 2026 | 90.5 | 90.487 | -0.013 | Within tolerance |
| Aug 2026 | 91.2 | 91.155 | -0.045 | Within tolerance |
| Sep 2026 | 91.4 | 91.417 | 0.017 | Within tolerance |
| Oct 2026 | 89.4 | 89.362 | -0.038 | Within tolerance |
Reconciliation history
| Run | Result | Months |
|---|---|---|
| L-20261101-0100 | Within tolerance | 13 |
| R-20261102-0200 | Within tolerance | 13 |
| R-20261103-0200 | Within tolerance | 13 |
| R-20261104-0200 | Within tolerance | 13 |
| R-20261105-0200 | Within tolerance | 13 |
| R-20261106-0200 | Within tolerance | 13 |
| R-20261107-0200 | Within tolerance | 13 |
| R-20261108-0200 | Within tolerance | 13 |
| R-20261109-0200 | Within tolerance | 13 |
| R-20261110-0200 | Within tolerance | 13 |
| R-20261111-0200 | Within tolerance | 13 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.