Keysproperty operations Corbelstone Residential

Ask

Plain-English questions, answered only through the definitions. Where a term has two meanings, both answers are shown with their owners; where no definition fits, there is no number.

Sheet K-01
answers at Mon 20:00

How many homes are vacant?Which tenants are in arrears?How many open tickets?Tickets in SLA last weekLeases in the renewal windowWater alarms with no ticket

441 tickets according to the Head of Maintenance (maintenance v1, last week (Mon–Sun)).

maintenance · v1 · Head of Maintenance

441 tickets

SLA ended in the period, not cancelled, attended at or before due_at.

From in_sla (maintenance) · last week (Mon–Sun) · tables tickets

SQL and the first rows of 441
SELECT id AS ticket_id, building_id, priority, due_at, attended_at, vendor_id
FROM tickets
WHERE due_at >= TIMESTAMP '2026-10-26 00:00:00' AND due_at < TIMESTAMP '2026-11-02 00:00:00' AND due_at <= TIMESTAMP '2026-11-02 20:00:00' AND status <> 'cancelled'
  AND attended_at IS NOT NULL AND attended_at <= due_at
ORDER BY due_at, id
[
  {
    "attended_at": "2026-10-22 19:38:24.907214",
    "building_id": 34,
    "due_at": "2026-10-26 01:15:54.779313",
    "priority": "routine",
    "ticket_id": 4835,
    "vendor_id": 20
  },
  {
    "attended_at": "2026-10-22 18:52:16.786790",
    "building_id": 74,
    "due_at": "2026-10-26 02:08:58.977548",
    "priority": "routine",
    "ticket_id": 4836,
    "vendor_id": 235
  },
  {
    "attended_at": "2026-10-26 01:09:28.520754",
    "building_id": 87,
    "due_at": "2026-10-26 02:12:46.855540",
    "priority": "emergency",
    "ticket_id": 5119,
    "vendor_id": 24
  },
  {
    "attended_at": "2026-10-23 02:09:32.297734",
    "building_id": 110,
    "due_at": "2026-10-26 02:23:34.301918",
    "priority": "routine",
    "ticket_id": 4838,
    "vendor_id": 68
  },
  {
    "attended_at": "2026-10-24 01:06:10.915877",
    "building_id": 4,
    "due_at": "2026-10-26 03:39:20.639607",
    "priority": "routine",
    "ticket_id": 4786,
    "vendor_id": 263
  },
  {
    "attended_at": "2026-10-25 19:01:20.724159",
    "building_id": 18,
    "due_at": "2026-10-26 05:20:44.424717",
    "priority": "urgent",
    "ticket_id": 5057,
    "vendor_id": 103
  },
  {
    "attended_at": "2026-10-25 11:41:18.293404",
    "building_id": 55,
    "due_at": "2026-10-26 06:05:26.603233",
    "priority": "urgent",
    "ticket_id": 5058,
    "vendor_id": 75
  },
  {
    "attended_at": "2026-10-26 02:04:10.179612",
    "building_id": 78,
    "due_at": "2026-10-26 07:14:13.114016",
    "priority": "urgent",
    "ticket_id": 5061,
    "vendor_id": 82
  }
]