NHS QUESTIONS

How Do NHS Teams Validate an Elective Waiting List?

Compare the dashboard with the trust’s records for the same month-end. Check which pathways each list includes and whether each open pathway counts once. Send any differences you can’t explain from the reporting rules to the team that can check the source record.

For a team reporting on consultant-led elective care in England, that might mean finding out why the dashboard shows 1,246 pathways when the trust submitted 1,240. Here’s how you can work through that kind of gap.

  
Agree what you’re counting

Start with the same list and the same date

At a monthly review, a reporting analyst sees 1,246 on the trust’s elective waiting list dashboard. The submitted month-end figure is 1,240. The gap is six. The analyst starts by checking whether both reports count the same thing.

For consultant-led referral to treatment (RTT) reporting, an incomplete pathway is one that is still waiting for treatment to start at month-end. The figures count pathways. One person can have more than one pathway if they are waiting for care for different conditions. That’s why counting unique patients answers a different question.

The analyst matches the trust, specialties, month-end date and inclusion rules in both reports. If the dashboard normally shows today’s list, they use the saved month-end data for the comparison. The NHS England RTT statistics guidance explains what the published measures cover.

Put the date next to the number

Label the figure with the date the list represents, the services it covers and whether it counts pathways or people. Keep the dashboard’s refresh time separate.

  
Find the difference

Trace the extra rows back to the pathway records

In this example, the analyst compares the two lists inside the trust’s approved reporting environment using the pathway identifier used in its reporting data. The submitted list has 1,240 pathways. All 1,240 appear on the dashboard, but six appear twice.

The report pulls appointment history into its waiting list view. Linking the pathway to its appointments creates one row per appointment. A pathway with two appointments then appears twice in the report. Both appointments belong in the history. For this particular count, each pathway should contribute once.

The analyst corrects the reporting calculation and checks it again against the same month-end data. The dashboard now shows 1,240. They also check a previous month, so they can see whether the fix holds for another reporting period.

Check the source before correcting a record

Two rows for one person can represent two genuine pathways. If a discrepancy remains after you’ve checked the report, send it to the team that can verify the pathway in the source system.

  
Review the source records

Send each exception to the right team

Some discrepancies really do need a closer look at the pathway. You might find an open pathway with activity that suggests it has ended, or a pathway with conflicting dates. Flag what you found and let the trust’s validation team check the source record under its local elective access policy.

The NHS England waiting list validation toolkit describes technical, administrative and clinical validation. A report can flag a possible problem. The team then decides who should review it and whether it calls for an administrative correction or clinical review.

What to record for each exception
  • The pathway reference and date of the snapshot, in the trust’s approved system.
  • The reason it was flagged and the source record someone needs to review.
  • The team responsible for the review and the agreed next step.
  • The outcome and whether the exception still appears when you rerun the check.

Describe what you can see

“Two rows share this pathway reference” gives a reviewer something to check. “Remove duplicate” assumes you already know what should happen.

  
Make the next review easier

Show the total and the work still open

Even when the totals agree, some pathways may still need a closer look. Keep those open checks visible alongside the total. For a specialty review, a manager may need the number of open pathways and how many checks are outstanding. The validation team needs to know which records it’s expected to look at.

If you use IntelliFront BI, you can build a dashboard from an approved reporting dataset and use it to show the snapshot date, pathway totals by specialty and outstanding exceptions by type. Keep patient-level review in the trust’s approved workflow, with access limited to the people who need it.

When comparing against NHS England’s published RTT figures, check that the month, provider, specialty grouping and measure match. Use your trust’s submitted data to investigate individual records. The published totals can help you check the headline figure.

Repeat the check after a fix

Rerun the same comparison before closing an exception. A corrected report should agree with the source records for the same date and scope.

  
Your next step

Try it with one specialty and one month

Pick one specialty and take its dashboard and submitted figures from the same month-end. Check what each figure counts. If the totals differ, trace one discrepancy to the records behind it and write down how you resolved it. You’ll have a check a colleague can repeat at the next review.

If you’re evaluating IntelliFront BI, use the guide to plan which discrepancies the dashboard should help colleagues investigate. The NHS pharmacy reporting evaluation shows how to test a shared view with the people who use and maintain it.

Download the IntelliFront BI Internal Evaluation Guide

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software