Definitions / no_show
No-show
A booked patient who did not come. Operations and the commissioning contract count it differently, so a question about no-shows gets both numbers.
Unit: appointments · parameters: short notice hours 2 · also said as: no show, no-shows, did not attend, dna, did-not-attend, missed appointment, missed appointments
Operations
Head of operations (operations) · version 1, changed 2026-11-02
The patient did not arrive and did not cancel; the clinic marked them absent.
First version.
SELECT a.id AS appointment_id, a.clinic_id, a.start_at, 'no-show' AS how
FROM appointments a
WHERE a.no_show_at IS NOT NULL AND a.no_show_at <= {now}
AND a.start_at >= {period_start} AND a.start_at < {period_end}
Tests: count_between
Commissioning
Head of finance (finance) · version 1, changed 2026-11-02
The contract with the health fund counts a cancellation less than short_notice_hours before the start as a no-show as well, because the slot cannot be reused.
First version.
SELECT a.id AS appointment_id, a.clinic_id, a.start_at,
CASE WHEN a.no_show_at IS NOT NULL THEN 'no-show' ELSE 'cancelled at short notice' END AS how
FROM appointments a
WHERE a.start_at >= {period_start} AND a.start_at < {period_end}
AND ((a.no_show_at IS NOT NULL AND a.no_show_at <= {now})
OR (a.cancelled_at <= {now} AND a.cancelled_at > a.start_at - to_hours({short_notice_hours})))
Tests: count_between