RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

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