Building searches to track appointments

Building searches to track appointments

You may wish to run some searches on your appointment book to understand provision and uptake of appointments, as well as other markers of appointments. EMIS Web provides two different modules to achieve this, each with a different purpose and set of options. There is a third in-built option required by the NHS which is the General Practice Workload Tool.

  1. Population Reporting - the main search and reporting functionality in EMIS is capable of identifying where patients have been booked into slots in the appointment book. Reports are able to extract detailed information about the appointment booking. This may be useful where you are looking for all patients who were booked into a particular slot type or with a specific session holder (clinician).
  2. Appointment Reporting - the Appointments module has a feature which can be very useful in displaying the overall picture of appointment slots; how many were offered, used, unused, cancelled. This data can be broken down in many different ways and may be too complicated to view on screen within EMIS. With specific search criteria, these reports can help to understand exactly how appointment slots are used.
  3. General Practice Workload Tool - we've separated this from the Appointment Reporting, although it sits in the same module. The information displayed is mandated by the NHS, but does not readily present a realistic picture of how your appointment book is used. The Standardised GP Appointment Categories introduced in 2020 attempted to address this shortcoming to make the data from each Practice more meaningful when combined at higher organisational levels such as ICS or nationwide. The latest version of the GPWT does allow for viewing data based on National Slot Categories.
This article will demonstrate how to build reports in both Population Reporting and Appointment Reporting.

When viewing any returned appointment data it should be borne in mind that the figures are only as accurate as how the slots have been used. This applies to the National Slot Mapping work undertaken by the Practice, where every locally created slot is assigned one of 27 national categories. It also applies to each slot type and how they are used; if a non-diabetic patient is booked into a slot marked for diabetics, this could skew the data, and staff should be trained how to correctly change slot types based on the appointment they are booking. The appropriate use of slot types will help the bigger picture conversations about appointment provision.


Population Reporting



      

There are plenty of criteria to choose from. A selection are described below.
  1. Appointment Date - set a date range for the search. This is definitely recommended to ensure the search doesn't pick up every slot ever (potentially over a decade ago). Depending on the requirements, aim for a maximum of about 3 years - notwithstanding the COVID-19 pandemic, most appointment books are likely to change significantly over this period. With longer date ranges consider setting the search to be based on all patients rather than currently registered.
  2. Current slot status - useful if you're looking for patients who attended appointments or even did not attend.
  3. Slot type - choose a local slot or slots to refine criteria. Useful for tracking flu clinics.
  4. National Slot Category - useful for searches related to IIF, in particular for EHCH-04 and ACC-08. 
  5. Booking method - useful to track whether patients were booked by a member or staff or online.
  6. Wait/Consult times - look for appointments which were more than a defined length of time (eg: 20 minutes), or track the number patients affected by clinics running late by x minutes.

Appointment Reporting



The key difference here is that all slots are in scope as opposed to only those that have been booked. There is also no 'based on' population as the report could look at all slots ever. The report only returns numbers and unlike a Population Reporting Aggregate report does not allow you to view patients included by the criteria.

There are two types of report available Slot and Session. The main focus of this section will be Slot Reports. 

Session reports are simpler reports which can count the number of sessions across a given timeframe or held by an individual. These might be useful for tracking the number of locum sessions across a time range, or monitoring session provision across a week; the limitation is that a session report can only show that a session exists and not how long it is. With forward planning the use of Session Categories make session reports even more useful to track the type of sessions being run (eg: triage/duty/visit/clinic). 

Slot Reports allow for the breakdown of vast quantities of appointment data. To begin a Slot Report, give the report a name and description - descriptions are especially useful to remind yourself as well as others what the report is looking for.
Move onto the Filter Data page where the Add Filter button reveals a number of similar options to Population Reporting. This is essentially the search criteria.


  1. Appointment Date - longer time ranges are more feasible here as the report layout can divide the output into bins. Ranges of 2-3 years are easily achievable.
  2. Appointment time - for narrowing down the report to looking at just early morning, or late evening for example.
  3. Slot Properties - more than just Current slot status. Choose by slot duration, whether it was offered as bookable online (different from an appointment being booked online), whether a slot was booked, blocked, or still available, DNA appointments.
  4. Wait/Consult times - look for appointments which were more than a defined length of time (eg: 20 minutes), or track where clinics have been running late.
  5. Session Holder - limit by user(s) or user type.
The Report Format page is where the layout can be manipulated. It allows for the filtered data to be broken down into whatever categories are needed.

Sometimes it may be helpful to make a copy of a Slot Report, then adjust the report format to display a different set of data without having to rebuild the filter data component.

    • Related Articles

    • Greener inhaler prescribing searches

      Primary Care IT has collaborated with Greener Practice to produce supporting searches for their asthma toolkit. The searches are freely available to all healthcare organisations, and are available for both EMIS Web and SystmOne. Once requested, ...
    • 015 Childhood Vaccination Searches

      The current version of Childhood Vaccinations is v3 Children born Sep - Aug The childhood vaccination schedule has been updated a number of times in the past decade, reflecting the introduction of new vaccines as well as evidence based alterations to ...
    • 016 Seasonal Influenza searches

      The latest version is 016 Seasonal Influenza 2024-25 (v5.0) This collection of searches has been designed to support Practices running a call/recall programme for their seasonal influenza campaign. Built in line with the Enhanced Service criteria, ...
    • 005. COVID vaccination programme searches

      The current version of COVID vaccination programme searches is v10.2 Introduction and installation Primary Care IT has released a suite of searches to support the COVID vaccination programme. A video version of this guide can be found here. Priority ...
    • 034D Eligible for RSV vaccination searches

      This folder (v1) sits within 034 Eligibility. The new vaccination programme against Respiratory Syncytial Virus (RSV) goes live in September 2024. In preparation for this new line of work, Primary Care IT has produced this folder of searches to ...