Pipeline runs / L-20261101-0100 Next run

Run L-20261101-0100 Succeeded

Initial load in Production, scheduled 11/01/2026 01:00, finished 11/01/2026 01:13.

Rows extracted459,874

Rows quarantined17

Rows released0

Alerts opened / resolved2 / 0

Reconciliation: Within tolerance168 metric months

Changes since the previous run.
10/28/2026 08:40 Marisol Ortega: Approved AR-0412 (Department Analyst, Utilities) for position 4410. (AR-0412)

Alerts opened in this run

Low Open CAD incident summaries: 11 records held by DQ-401

Rule DQ-401 (first unit on scene is after dispatch, a clock sync check) failed for 11 records. They are held out of the curated layer until the source is corrected.

A-1041 to Jasmine Patel, Data Steward. Acknowledged by Jasmine Patel 11/02/2026 10:05: CAD clock sync on two MDTs; vendor ticket open. Records stay out of response time metrics as defined

Low Open Munis utility bills: 6 records held by DQ-502

Rule DQ-502 (billed consumption is not negative) failed for 6 records. They are held out of the curated layer until the source is corrected.

A-1042 to Brandon Hayes, Data Steward. Acknowledged by Brandon Hayes 11/02/2026 09:31: Rebills after meter swaps. Utility Billing will post corrected reads in the November cycle

Alerts resolved in this run

None.

Quarantine

Dataset	Rule	Held in this run	Released in this run
Utility bills	DQ-502 Billed consumption is not negative	6
CAD incident summaries	DQ-401 First unit on scene is after dispatch, a clock sync check	11

Steps

#	Step	Dataset	Connector	Method	Rows	Seconds	Status	Detail
1	Extract	Accounts payable invoices	Tyler Munis	CDC	14,562	21.9	Succeeded	Window 01/01 00:00 to 11/01 01:00.
2	Extract	Utility bills	Tyler Munis	CDC	316,800	359.4	Succeeded	Window 01/01 00:00 to 11/01 01:00.
3	Extract	Permits	EnerGov	API incremental	7,822	12.7	Succeeded	Window 01/01 00:00 to 11/01 01:00.
4	Extract	Inspections	EnerGov	API incremental	15,887	23.4	Succeeded	Window 01/01 00:00 to 11/01 01:00.
5	Extract	Code enforcement cases	EnerGov	API incremental	2,265	9.9	Succeeded	Window 01/01 00:00 to 11/01 01:00.
6	Extract	Work orders	Cityworks	API incremental	21,838	28.3	Succeeded	Window 01/01 00:00 to 11/01 01:00.
7	Extract	311 service requests	311 CRM (SaaS)	API incremental	29,476	38.5	Succeeded	Window 01/01 00:00 to 11/01 01:00.
8	Extract	CAD incident summaries	CAD (SQL Server)	CDC	37,631	49.2	Succeeded	Window 01/01 00:00 to 11/01 01:00.
9	Extract	Employees	HR (SQL Server)	Batch full	1,044	5.2	Succeeded	Window 01/01 00:00 to 11/01 01:00.
10	Extract	Parcels	ArcGIS Enterprise	Feature service snapshot	9,200	15.9	Succeeded	Full snapshot.
11	Extract	Parks program registrations	SharePoint Online	File (Graph export)	3,181	10.9	Succeeded	Window 01/01 00:00 to 11/01 01:00.
12	Extract	Legacy performance metric values	Performance metrics database (PostgreSQL)	Database full	168	4.2	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	6	6.8	Succeeded with alerts	6 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	11	8.3	Succeeded with alerts	11 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.