Longest waiting by status

Why this matters

The longest wait is the figure most often asked for after the total. This report names the longest-waiting client in each status, so you can answer the question and check that client’s entry straight away.

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 status, from Awaiting Triage to Removed.

ColumnMeaning
StatusThe status
PatientsThe number of entries in that status
Longest WaitingThe client who has waited longest. If two have waited equally long, the one who joined first
ListThat client’s waiting list
Weeks WaitingWeeks on the list. For review patients, counted from the last attended date
Breach DateThe breach date, adjusted for any suspension
PriorityUrgent, Soon or Routine

A status with no entries shows a dash. Rows where the client has breached are highlighted in red.

The CSV file has the columns Status, Patients, Longest Waiting, List, Weeks Waiting, Breach Date and Priority.

What to watch for

The longest wait is across all lists Each row picks one client from every list you include. To find the longest wait on one list, select it in Waiting Lists.

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.