Definitions / late_cancellation
Late cancellation
A booking cancelled close to its start. Operations draws the line at 24 hours (the slot can still be offered); the patient charter draws it at 48 hours (the notice it asks patients to give).
Unit: appointments · parameters: operations hours 24, charter hours 48 · also said as: late cancellation, late cancellations, late cancel, short notice cancellation, cancelled late
Operations
Head of operations (operations) · version 1, changed 2026-11-02
Cancelled less than operations_hours before the start.
First version.
SELECT a.id AS appointment_id, a.clinic_id, a.start_at, a.cancelled_at
FROM appointments a
WHERE a.cancelled_at <= {now} AND a.cancelled_at > a.start_at - to_hours({operations_hours})
AND a.start_at >= {period_start} AND a.start_at < {period_end}
Tests: count_between
Charter
Head of patient experience (patient experience) · version 1, changed 2026-11-02
Cancelled less than charter_hours before the start.
First version.
SELECT a.id AS appointment_id, a.clinic_id, a.start_at, a.cancelled_at
FROM appointments a
WHERE a.cancelled_at <= {now} AND a.cancelled_at > a.start_at - to_hours({charter_hours})
AND a.start_at >= {period_start} AND a.start_at < {period_end}
Tests: count_between