RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

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