Step 3 — Data Validation

Step 3 — Validation run for 2026-01-08

❌ Data Validation Failed

Issues:

Summary table property_summary has no rows for 2026-01-08
Summary table workorder_summary has no rows for 2026-01-08
Summary table unit_vacancy_summary has no rows for 2026-01-08

Core Tables

{
    "property_directory": {
        "exists": true,
        "row_count": 257
    },
    "work_order": {
        "exists": true,
        "row_count": 107
    },
    "unit_vacancy": {
        "exists": true,
        "row_count": 32
    }
}

Summary Tables

{
    "property_summary": {
        "exists": true,
        "rows_today": 0,
        "null_values": 0
    },
    "workorder_summary": {
        "exists": true,
        "rows_today": 0,
        "null_values": 0
    },
    "unit_vacancy_summary": {
        "exists": true,
        "rows_today": 0,
        "null_values": 0
    }
}

Anomalies

{
    "total_properties": {
        "today": null,
        "yesterday": "257.00",
        "delta": null
    }
}

Logged to system_logs as error.