Definitions / overdue_follow_up
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