Metric migration / DS-04
DS-04 Code enforcement cases closed within 30 days
Owner: Development Services. Unit: %. Reconciliation tolerance: 0.1. Target: 75.0 (higher is better).
Written definition
- Source
- EnerGov code cases
- Calculation
- Cases closed in the month that were open 30 days or less, divided by all cases closed in the month, times 100.
- Inclusions
- All violation types.
- Exclusions
- Open cases.
- Time frame
- Calendar month of closure.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Code enforcement cases closed within 30 days
- Note
- Cases closed in the month that were open 30 days or less
- Script
perf_ds_04.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', closed_at)::date as month, 100.0 * avg(case when closed_at - opened_at <= interval '30 days' then 1 else 0 end) as value from curated.fact_code_case where closed_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 4 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100.00 | 78.06 | 80.00 | 76.29 | 80.34 | 74.47 | 79.39 | 84.66 | 78.71 | 80.46 | 76.80 | 77.65 | 76.21 |
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 100.0 | 100.000 | 0.000 | Within tolerance |
| Nov 2025 | 78.1 | 78.065 | -0.035 | Within tolerance |
| Dec 2025 | 80.0 | 80.000 | 0.000 | Within tolerance |
| Jan 2026 | 76.3 | 76.289 | -0.011 | Within tolerance |
| Feb 2026 | 80.3 | 80.337 | 0.037 | Within tolerance |
| Mar 2026 | 74.5 | 74.468 | -0.032 | Within tolerance |
| Apr 2026 | 79.4 | 79.394 | -0.006 | Within tolerance |
| May 2026 | 84.7 | 84.663 | -0.037 | Within tolerance |
| Jun 2026 | 78.7 | 78.710 | 0.010 | Within tolerance |
| Jul 2026 | 80.5 | 80.460 | -0.040 | Within tolerance |
| Aug 2026 | 76.8 | 76.796 | -0.004 | Within tolerance |
| Sep 2026 | 77.7 | 77.654 | -0.046 | Within tolerance |
| Oct 2026 | 76.2 | 76.214 | 0.014 | 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.