RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

Overdue follow-up

A follow-up after a hospital discharge that is late. Booking calls it overdue when it is not booked three days after the notice; clinicians call it overdue when the follow-up's own deadline has passed without a visit.

Unit: discharges · parameters: book within days 3 · also said as: overdue follow-up, overdue follow up, late follow-up, follow-up overdue, follow ups overdue

Booking

Head of booking (booking) · version 1, changed 2026-11-02

Notice received at least book_within_days ago and no booking recorded by now (last 45 days).

First version.

SELECT d.id AS discharge_id, d.patient_id, d.clinic_id, d.notified_at
FROM discharges d
WHERE d.notified_at <= {now} - to_days({book_within_days}) AND d.notified_at >= {now} - INTERVAL 45 DAY
  AND (d.booked_at IS NULL OR d.booked_at > {now})

Tests: count_between

Clinical

Medical director (clinical governance) · version 1, changed 2026-11-02

The follow-up was due by discharge + follow_up_within_days, that day has passed, and the patient has not been seen since the discharge (last 45 days).

First version.

SELECT d.id AS discharge_id, d.patient_id, d.clinic_id, d.discharged_at + to_days(d.follow_up_within_days) AS due_by
FROM discharges d
WHERE d.discharged_at + to_days(d.follow_up_within_days) <= {now} AND d.notified_at >= {now} - INTERVAL 45 DAY
  AND NOT EXISTS (SELECT 1 FROM appointments a WHERE a.patient_id = d.patient_id AND a.start_at >= d.discharged_at
                    AND a.completed_at <= {now})

Tests: count_between