Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Marisol Ortega, Data and Innovation Administrator (CDR Administrator)
View as Administrator Data engineer Utilities steward Police steward

Alerts

Schema drift, quarantine, reconciliation and cost alerts, each sent to a named recipient. Alerts close automatically when the next run passes. Open only | All
AlertSeverityCategorySubject and messageRecipientOpenedStatusAcknowledged
A-1046HighReconciliation 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.
Marisol Ortega, Data and Innovation Administrator11/06/2026 02:10 Resolved Marisol Ortega, 11/06/2026 08:20
Holding the October permit numbers from the department dashboard until the replay runs.
A-1045HighReconciliation 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.
Marisol Ortega, Data and Innovation Administrator11/06/2026 02:10 Resolved Marisol Ortega, 11/06/2026 08:20
Holding the October permit numbers from the department dashboard until the replay runs.
A-1044HighQuarantine 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.
Kevin Tran, Data Engineer11/06/2026 02:10 Resolved
A-1043HighSchema drift 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.
Kevin Tran, Data Engineer11/06/2026 02:10 Resolved 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).
A-1042LowQuarantine 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.
Brandon Hayes, Data Steward11/01/2026 01:10 Open Brandon Hayes, 11/02/2026 09:31
Rebills after meter swaps. Utility Billing will post corrected reads in the November cycle.
A-1041LowQuarantine 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.
Jasmine Patel, Data Steward11/01/2026 01:10 Open 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.

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.