Run R-20261109-0200 Succeeded
Nightly in Production, scheduled 11/09/2026 02:00, finished 11/09/2026 02:13.
Rows extracted2,831
Rows quarantined0
Rows released0
Alerts opened / resolved0 / 0
Reconciliation: Within tolerance168 metric months
Alerts opened in this run
No alerts opened.
Alerts resolved in this run
None.
Steps
| # | Step | Dataset | Connector | Method | Rows | Seconds | Status | Detail |
|---|---|---|---|---|---|---|---|---|
| 1 | Extract | Accounts payable invoices | Tyler Munis | CDC | 73 | 5.8 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 2 | Extract | Utility bills | Tyler Munis | CDC | 1,441 | 9.0 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 3 | Extract | Permits | EnerGov | API incremental | 0 | 4.0 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 4 | Extract | Inspections | EnerGov | API incremental | 3 | 5.7 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 5 | Extract | Code enforcement cases | EnerGov | API incremental | 7 | 7.4 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 6 | Extract | Work orders | Cityworks | API incremental | 81 | 4.1 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 7 | Extract | 311 service requests | 311 CRM (SaaS) | API incremental | 94 | 5.8 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 8 | Extract | CAD incident summaries | CAD (SQL Server) | CDC | 86 | 7.5 | Succeeded | Window 11/08 02:00 to 11/09 02:00. |
| 9 | Extract | Employees | HR (SQL Server) | Batch full | 1,046 | 5.2 | Succeeded | Window 11/08 02:00 to 11/09 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) | 0 | 7.4 | Succeeded | Window 11/08 02:00 to 11/09 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 | All blocking rules passed. |
| 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.