Waiting list summary

Why this matters

The Waiting List Summary puts every list on one page: how many clients are in each status, how many have breached, and how long the longest and average waits are. It is the figure set most often asked for at a management meeting or in a monthly return.

Options

OptionChoices
FormatsView, CSV, PDF
DatesNone: the report shows the lists as they are now
FiltersUsers (the users assigned to the entry), Waiting Lists, Status, Priority, Locations

See Running Reports for the steps.

What it contains

One row per waiting list, in name order, with a Total row at the end.

ColumnMeaning
ListThe waiting list
TypeOPD, Inpatient or Day Case
Triage, Waiting, W&S, Review, Attended, Suspended, RemovedThe number of entries in each status
ActiveEntries still on the list: Awaiting Triage, Waiting, Waiting and Scheduled, Scheduled for Review and Suspended
BreachedActive entries past their breach date
Longest Wait (wks)The longest wait among the active entries, in weeks
Average Wait (wks)The average wait among the active entries, in weeks, to one decimal place

Lists with any breached entries are highlighted in red.

The CSV file has the columns List, Type, one column per status with its full name, Active, Breached, Longest Wait (weeks) and Average Wait (weeks).

What to watch for

Attended and Removed counts keep growing They include every entry ever closed on the list. Only Active, Breached and the wait columns are limited to clients still on the list.

Counts are lower than the list itself shows Unless you have Can view All Appointments, the report only includes entries with an assigned user. See Running Reports.