Keysproperty operations Corbelstone Residential

Definitions

One set of definitions for the detectors, the operator, the building stack and Ask. Each has an owner, a version, its SQL and its tests. A term with two valid meanings keeps both until its owners choose one.

Sheet D-01
17 terms

Arrears

arrears

Which tenants are in arrears. Credit control and finance count differently: credit control counts rent unpaid for arrears_days or more (the point where the reminder schedule starts); finance counts any rent unpaid after its due date, because it is already money the company does not have. Until one is made canonical, every answer shows both.

credit_control v1finance v1two meaningsterm

Head of Credit Control · Finance Controller

Band price

band_price

The rent a renewal or a new letting may be offered at without a person: the building's band for the home's size (low, middle, high) in force at the time asked, with top floors allowed floor_premium above the high end. Prices outside it are never set by the operator.

lettings v1term

Head of Lettings

Duplicate ticket

duplicate_ticket

A second open ticket for a fault that already has an open ticket: same home and category (or, for a common area, same building and category), opened within window_hours of the first (common_window_hours for a common area) while the first was still open. Two tickets raised by two different alarms are two faults on two pieces of equipment.

maintenance v2detector

Head of Maintenance

Ticket in SLA

in_sla

Tickets whose vendor attended inside the attendance SLA (emergency 4 hours, urgent 24, routine 120), among the tickets whose SLA ended in the period.

maintenance v1term

Head of Maintenance

Inspection overdue

inspection_overdue

A statutory building check (fire alarm, emergency lighting, legionella, lift certificate, gas safety) past its due date, not done and with nothing booked.

compliance v1detector

Head of Compliance

Vendor invoice without a matching ticket

invoice_without_ticket

A work invoice, not yet paid or held, that matches no ticket of the same vendor: neither its ticket field nor the job number written in its reference names a ticket that vendor was sent to (now or earlier: a vendor taken off a job after attending still bills for the visit). Monthly contract invoices have no ticket and are left out.

finance v2detector

Finance Controller

Lift out with no other lift

lift_outage_single

A lift fault lasting fault_minutes in a building where no other lift is in service: the only lift, or the remaining one while the other is out for planned work or its own fault. Residents on upper floors are stuck.

maintenance v1detector

Head of Maintenance

Long vacancy

long_vacancy

A home empty for longer than vacancy_days and not under renovation. The evidence says whether it is listed, at what rent, and the band it should be listed in.

lettings v1detector

Head of Lettings

Occupied home

occupied

A home with a lease running at the time asked (fixed term, or rolling month to month after it).

lettings v1term

Head of Lettings

Open ticket

open_ticket

A maintenance ticket opened and not yet closed, merged or cancelled at the time asked.

maintenance v1term

Head of Maintenance

Renewal offer not sent

renewal_not_sent

A lease ending within deadline_days with no renewal offer sent, where the tenant has not given notice and the lease is eligible for renewal. The evidence carries the band price the offer should go out at.

lettings v1detector

Head of Lettings

Renewal offer outside the band

renewal_out_of_band

A renewal offer still waiting for the tenant's answer whose rent is outside the band that was in force when it was sent. Homes on the top floors may be offered up to floor_premium above the band's top. Bands moved up on 1 October, so an offer is judged against the band of its own sending date.

lettings v2detector

Head of Lettings

Leases in the renewal window

renewal_window

Leases whose fixed term ends within window_days (the renewal window opens 90 days before the end; the offer must be out by 60 days before), with the offer status so far.

lettings v1term

Head of Lettings

Rent arrears (reminder due)

rent_arrears

A lease whose oldest unpaid rent is at least arrears_days old and whose next step on the arrears schedule has not been taken: a reminder at day 10, 20 and 30 (stage 1, 2, 3), and a legal review from day 45 (stage 4). Leases already handed to legal are left out. Payments are applied to the oldest charge first.

credit_control v1detector

Head of Credit Control

Ticket past its SLA

ticket_sla_breach

An open maintenance ticket that is losing its attendance SLA: no vendor dispatched at dispatch_share of the SLA ("no vendor"), or a vendor dispatched who has not attended by the SLA's end ("no show"). A vendor dispatched or re-dispatched late gets reattend_hours before the ticket counts again.

maintenance v1detector

Head of Maintenance

Vacant home

vacant

Which homes are vacant. Lettings counts a home as vacant when it is empty and available to let; finance counts every home that earns no rent, including homes closed for renovation. Until one is made canonical, every answer shows both.

lettings v1finance v1two meaningsterm

Head of Lettings · Finance Controller

Water alarm with no ticket

water_alarm_no_ticket

A water leak alarm still active after ticket_minutes with no ticket for it: none linked to the alarm, and no leak ticket for the same home (or, for a plant-room sensor, the same building's common areas) opened since.

maintenance v1detector

Head of Maintenance