Run R-20261107-0200 Succeeded
Nightly in Production, scheduled 11/07/2026 02:00, finished 11/07/2026 02:13.
Rows extracted2,991
Rows quarantined0
Rows released115
Alerts opened / resolved0 / 4
Reconciliation: Within tolerance168 metric months
Changes since the previous run.
11/06/2026 07:52 Kevin Tran: Acknowledged schema drift alert on EnerGov permits. (CDR-2291)
11/06/2026 09:42 Kevin Tran: Published source mapping v4 (IssueDate) for EnerGov permits and scheduled a replay from the 11/05 02:00 watermark. (CDR-2291)
11/06/2026 07:52 Kevin Tran: Acknowledged schema drift alert on EnerGov permits. (CDR-2291)
11/06/2026 09:42 Kevin Tran: Published source mapping v4 (IssueDate) for EnerGov permits and scheduled a replay from the 11/05 02:00 watermark. (CDR-2291)
Alerts opened in this run
No alerts opened.
Alerts resolved in this run
High Schema change detected in EnerGov permits
A-1043, opened by R-20261106-0200, resolved 11/07/2026 02:11
High EnerGov permits: 115 records held by DQ-101
A-1044, opened by R-20261106-0200, resolved 11/07/2026 02:11
High DS-01 does not reconcile with the legacy performance database
A-1045, opened by R-20261106-0200, resolved 11/07/2026 02:11
High DS-02 does not reconcile with the legacy performance database
A-1046, opened by R-20261106-0200, resolved 11/07/2026 02:11
Quarantine
| Dataset | Rule | Held in this run | Released in this run |
|---|---|---|---|
| Permits | DQ-101 | 115 |
Steps
| # | Step | Dataset | Connector | Method | Rows | Seconds | Status | Detail |
|---|---|---|---|---|---|---|---|---|
| 1 | Extract | Accounts payable invoices | Tyler Munis | CDC | 68 | 5.8 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 2 | Extract | Utility bills | Tyler Munis | CDC | 1,437 | 9.0 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 3 | Extract | Permits | EnerGov | API incremental | 156 | 4.2 | Succeeded | Replay from the 11/05 02:00 watermark after mapping v4. Window 11/05 02:00 to 11/07 02:00. |
| 4 | Extract | Inspections | EnerGov | API incremental | 34 | 5.7 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 5 | Extract | Code enforcement cases | EnerGov | API incremental | 7 | 7.4 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 6 | Extract | Work orders | Cityworks | API incremental | 75 | 4.1 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 7 | Extract | 311 service requests | 311 CRM (SaaS) | API incremental | 77 | 5.8 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 8 | Extract | CAD incident summaries | CAD (SQL Server) | CDC | 86 | 7.5 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 9 | Extract | Employees | HR (SQL Server) | Batch full | 1,046 | 5.2 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 10 | Extract | Parcels | ArcGIS Enterprise | Feature service snapshot | 0 | 5.7 | Succeeded | Weekly snapshot (Sundays); not due. |
| 11 | Extract | Parks program registrations | SharePoint Online | File (Graph export) | 5 | 7.4 | Succeeded | Window 11/06 02:00 to 11/07 02:00. |
| 12 | Extract | Legacy performance metric values | Performance metrics database (PostgreSQL) | Database full | 0 | 4.0 | Succeeded | Full snapshot. |
| 13 | Cleanse and validate | Parcels | CDR | SQL | 0 | 5.9 | Succeeded | All blocking rules passed. |
| 14 | Cleanse and validate | 311 service requests | CDR | SQL | 0 | 6.2 | Succeeded | All blocking rules passed. |
| 15 | Cleanse and validate | Accounts payable invoices | CDR | SQL | 0 | 6.5 | Succeeded | All blocking rules passed. |
| 16 | Cleanse and validate | Utility bills | CDR | SQL | 0 | 6.8 | Succeeded | 0 new rows quarantined, 0 released, 6 held. |
| 17 | Cleanse and validate | Permits | CDR | SQL | 0 | 7.1 | Succeeded | 0 new rows quarantined, 115 released, 0 held. |
| 18 | Cleanse and validate | Inspections | CDR | SQL | 0 | 7.4 | Succeeded | All blocking rules passed. |
| 19 | Cleanse and validate | Code enforcement cases | CDR | SQL | 0 | 7.7 | Succeeded | All blocking rules passed. |
| 20 | Cleanse and validate | Work orders | CDR | SQL | 0 | 8.0 | Succeeded | All blocking rules passed. |
| 21 | Cleanse and validate | CAD incident summaries | CDR | SQL | 0 | 8.3 | Succeeded | 0 new rows quarantined, 0 released, 11 held. |
| 22 | Cleanse and validate | Employees | CDR | SQL | 0 | 8.6 | Succeeded | All blocking rules passed. |
| 23 | Cleanse and validate | Parks program registrations | CDR | SQL | 0 | 8.9 | Succeeded | All blocking rules passed. |
| 24 | Cleanse and validate | Legacy performance metric values | CDR | SQL | 0 | 9.2 | Succeeded | All blocking rules passed. |
| 25 | Build curated layer | curated | CDR | SQL | 38.4 | Succeeded | Facts and dimensions rebuilt from cleansed tables. | |
| 26 | Compute metrics and reconcile | metrics | CDR | SQL | 168 | 11.2 | Succeeded | 168 of 168 metric months match the legacy performance database within tolerance. |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.