Run R-20261106-0200 Succeeded with alerts
Nightly in Production, scheduled 11/06/2026 02:00, finished 11/06/2026 02:13.
Rows extracted2,964
Rows quarantined115
Rows released0
Alerts opened / resolved4 / 0
Reconciliation: Out of tolerance2 metric months
Reconciliation: Within tolerance166 metric months
Metric months outside tolerance.
DS-01 Oct 2026: legacy database 143.0, CDR 55.0, difference -88.0 (tolerance 0.0).
DS-02 Oct 2026: legacy database 5.0, CDR 6.0, difference 1.0 (tolerance 0.1).
DS-01 Oct 2026: legacy database 143.0, CDR 55.0, difference -88.0 (tolerance 0.0).
DS-02 Oct 2026: legacy database 5.0, CDR 6.0, difference 1.0 (tolerance 0.1).
Alerts opened in this run
High Resolved Schema change detected in EnerGov permits
Mapped column IssuedDate not found in energov.permit_v11; source now exposes IssueDate. issued_date loaded as null for 119 rows. Check the EnerGov release notes and update the source mapping.
A-1043 to Kevin Tran, Data Engineer. Acknowledged by Kevin Tran 11/06/2026 07:52: EnerGov 11.0 went live last night. Confirmed field rename with Tyler support; mapping v4 in progress (CDR-2291). Resolved by R-20261107-0200.
High Resolved EnerGov permits: 115 records held by DQ-101
Rule DQ-101 (issued or finaled permits have an issue date) failed for 115 records. They are held out of the curated layer until the source is corrected.
A-1044 to Kevin Tran, Data Engineer. Resolved by R-20261107-0200.
High Resolved DS-01 does not reconcile with the legacy performance database
1 month(s) outside tolerance (Oct 2026). For Oct 2026 the CDR shows 55.0 against 143.0.
A-1045 to Marisol Ortega, Data and Innovation Administrator. Acknowledged by Marisol Ortega 11/06/2026 08:20: Holding the October permit numbers from the department dashboard until the replay runs. Resolved by R-20261107-0200.
High Resolved DS-02 does not reconcile with the legacy performance database
1 month(s) outside tolerance (Oct 2026). For Oct 2026 the CDR shows 6.0 against 5.0.
A-1046 to Marisol Ortega, Data and Innovation Administrator. Acknowledged by Marisol Ortega 11/06/2026 08:20: Holding the October permit numbers from the department dashboard until the replay runs. Resolved by R-20261107-0200.
Alerts resolved in this run
None.
Quarantine
| Dataset | Rule | Held in this run | Released in this run |
|---|---|---|---|
| Permits | DQ-101 Issued or finaled permits have an issue date | 115 |
Steps
| # | Step | Dataset | Connector | Method | Rows | Seconds | Status | Detail |
|---|---|---|---|---|---|---|---|---|
| 1 | Extract | Accounts payable invoices | Tyler Munis | CDC | 72 | 5.8 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 2 | Extract | Utility bills | Tyler Munis | CDC | 1,395 | 8.9 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 3 | Extract | Permits | EnerGov | API incremental | 119 | 4.1 | Succeeded with warnings | Mapped column IssuedDate not found in energov.permit_v11; source now exposes IssueDate. issued_date loaded as null for 119 rows. Window 11/05 02:00 to 11/06 02:00. |
| 4 | Extract | Inspections | EnerGov | API incremental | 64 | 5.8 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 5 | Extract | Code enforcement cases | EnerGov | API incremental | 5 | 7.4 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 6 | Extract | Work orders | Cityworks | API incremental | 61 | 4.1 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 7 | Extract | 311 service requests | 311 CRM (SaaS) | API incremental | 92 | 5.8 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 8 | Extract | CAD incident summaries | CAD (SQL Server) | CDC | 100 | 7.5 | Succeeded | Window 11/05 02:00 to 11/06 02:00. |
| 9 | Extract | Employees | HR (SQL Server) | Batch full | 1,046 | 5.2 | Succeeded | Window 11/05 02:00 to 11/06 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) | 10 | 7.4 | Succeeded | Window 11/05 02:00 to 11/06 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 | 115 | 7.1 | Succeeded with alerts | 115 new rows quarantined, 0 released, 115 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 with alerts | 166 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.