Changes to organisations, workforce roles and data collection can impact the reporting of data. This page documents significant events which may disrupt the availability, continuity or accuracy of data.
19 May 2023
The decision has been made to put the proposed changes to the NHS Scotland Workforce dashboard, as outlined below, on hold for the time being. This is to allow for an internal review of terminology and metric selection.
April 2023
Turnover rate has previously been defined in the NHS Scotland Workforce Dashboard as (Total number of leavers over period / Total number employed at start of period) x 100. Whilst our definitions for joiners and leavers will remain unchanged, we will be changing our definition for turnover rate to (Total number of leavers over period / Average number employed over period) x 100, as this is in keeping with the definition which is listed in other sources [1, 2, 3]. There can be variation in how this definition is interpreted, especially within healthcare [4, 5]. For clarity, we define leavers to be individuals who were employed within NHS Scotland in a specific job role and Health Board at time point n and were not employed in that same job role and Health Board at timepoint n+1.
Separately, we will be including "true" leaver and joiner metrics which exclude individuals who move between job family, sub job family / specialty, Agenda for Change Band / Grade, whole-time / part-time, or contract type. In the case of the true leaver definition, this differs from our definition of leaver in that, for example, those changing job family or Agenda for Change Band but retain employment within the same Health Board will be counted as leavers but not as true leavers.
Example 1
Employee A was in a General Psychiatry consultant post in NHS Grampian as of 31 March 2018. By 31 March 2019, Employee A was working as a General Psychiatry consultant in NHS Lothian. Employee A is counted as a leaver (since they have changed NHS board) but not as a true leaver (since they have retained employment within NHS Scotland). Similarly, Employee A is counted as a joiner but not as a true joiner.
Example 2
Employee B was in a Band 5 Adult nursing post in NHS Ayrshire & Arran as of 31 March 2016. By 31 March 2017, Employee B was working as a Band 6 Adult nurse in NHS Greater Glasgow and Clyde. Employee B is counted as a leaver (since they have changed NHS board and AfC band) but not as a true leaver (since they have retained employment within NHS Scotland). Similarly, Employee B is counted as a joiner but not as a true joiner.
Example 3
Employee C was in a Band 5 occupational therapy post in NHS Tayside as of 31 March 2021. By 31 March 2022, Employee C had no current employment within NHS Scotland. Employee C is counted as both a leaver and a true leaver.
Both the true joiner and true leaver metrics have been provided to workforce planners over the last year as management information and, following positive feedback about their added value, we are now making them publicly available.
Using the new definition for turnover rate, together with our definition for true leavers, we will also be adding an additional metric to the publication - the true turnover rate.
The above changes will come into effect as of June 2023, and the ten years of historical turnover data available in the Turnover page of the dashboard will be updated to ensure consistency and allow comparison. Users should therefore expect slight changes to the historic turnover rate values. The largest change to be noted when drawing comparisons to the previous definition for turnover rate (as used in the March 2023 publication for data up to and including December 2022) is observed for the turnover rate for headcount as of 31 March 2021 which has gone from 5.7% to 5.5%.
March 2023
Over the last few years, Boards in NHS Scotland have adopted the JobTrain system to manage recruitment activity. Most Boards have also moved to using data from JobTrain to complete the national quarterly vacancy surveys. Following recent discussions with some data suppliers, we have become aware of variation in how JobTrain data is being processed and analysed to provide us with survey returns.
From our initial investigations, the largest variation arises in the calculation of vacancy length, which is carried out when reporting the number of vacancies in categories according to how long a post has been vacant, e.g., Vacant less than three months, Vacant between three and six months, etc.
NES is already working with the National Recruitment Reporting short life working group on the use of JobTrain data and definitions. We will continue to work with this group and with data providers in all Boards as we conduct a fuller review of vacancy data in line with our responsibilities for quality assuring administrative data.
We will post fuller plans for the review in due course, but we are highlighting this intention to our users now. In the meantime, we advise caution when using statistics relating to length of vacancy, and if you have any questions or would like to discuss vacancy data with us then please get in touch.
Data from many systems are used to report NHS workforce data. In November 2021, NES has completed the first phase of our new data warehouse, with historic and current NHSScotland employment data now warehoused and a new data model developed to support our publication reports.
The implementation of the warehouse will affect users of the NHSScotland Workforce Official Statistics publication in two main ways.
Changes to reports
In conjunction with the data warehouse project, we reviewed the outputs of the NHSScotland Workforce Official Statistics publication with a group of stakeholders and experts in user experience. After successfully testing with some of our end users, we will be publishing new reports in our next release. The largest change is the introduction of a new single NHSScotland workforce dashboard which will replace most of the previous dashboards and the Excel tables. This dashboard has improved navigation, filtering, table (including export functionality) and chart views of the workforce data.
Changes to data
As part of the development of the data warehouse we reviewed historic employment data and made numerous improvements to how this data is processed and reported. As a result of these improvements there will be some minor differences between the statistics published from the warehouse compared with previously published statistics. This means that this publication will contain a planned revision of employment data (which has impacts on vacancy rate and turnover measures), and sickness absence data.
The changes mentioned above will affect the NHSScotland Workforce Official Statistics released on 7 December 2021 (30 September 2020 census).
The above changes do not affect the Psychology Services Workforce and CAMHS Workforce publications.
August 2021
We have completed a review into the Location of Service Delivery and Country of Qualification data in the NHSScotland Workforce publication to ensure it meets the Official Statistics standard. This means checking the Trustworthiness, Quality and Value as outlined in the Code of Practice for Statistics.
We have analysed the feedback provided by users and a short summary of the outcome of this review, and how it will affect Official Statistics reporting, is below. Full details, including proposed plans, are available.
Please get in touch with us if you have any questions.
Location of Service Delivery (LoSD)
In its current state, LoSD has reduced value to our users because of the quality of data. However, reporting grouped location data would be of value to many users if it can be robust. This is something that has also been recognised in other projects.
In order to understand and assess the requirements for reporting location groupings in more detail we propose running a workshop with key stakeholders. Whilst this assessment is undertaken, we will continue to publish LoSD with a note identifying that it is under review.
Country of Qualification (CoQ)
Responses from data providers highlighted that there are two places which CoQ can be sourced: (i) the professional body section in eESS and (ii) the GMC interface. The first is currently used to report the data. Respondents overwhelmingly do not use CoQ data from this source for reporting or analysis because there is no business need.
We will report CoQ data as it is sourced in the forthcoming Workforce Official Statistics publication (30 June census released 7 September). Thereafter, these data will not be released as part of the publication. We will continue to monitor information requests which could be answered using these data.
Throughout 2020 and 2021 there have been significant challenges in collecting data on the workforce as it adapted and grew in response to the COVID-19 pandemic. The majority of the reported data in the three publications are extracted from administrative systems such as e:EES, the HR system used by most of the NHS Boards, National Payroll systems, and the CAMHS and Psychology Workforce databases.
There are additional data we report that are collected using bespoke data collection systems, such as vacancies and nursing agency data which are collected using a manual survey completed by the NHS Boards. As this required some manual input from the Boards when they had many other pressures, some indicated that they would not be able to supply these data.
The full detail on data provided is available.
The specific impacts of COVID-19 on the workforce numbers are hard to estimate for a number of reasons. For example, some staff were employed on bank contracts whereas others were not added to local HR systems, which meant that they are not included in the workforce staff in post figures. For a further explanation of this please see the NHSScotland Workforce annual report released in June 2021.
Public Health Scotland was formed on 1 April 2020. This Special NHS Board was formed of staff and functions previously based in NHS Health Scotland and NHS National Services Scotland (NSS). Changes to staff numbers in these organisations can be seen in the data from the 30 June 2020 census date. This change affects the NHSScotland Workforce official statistics publication.
June 2020
The Data Group have undertaken an assessment of the publication of granular age data in collaboration with Information Governance. In summary, we acknowledge that the age of workforce staff should be treated as a protected characteristic and is personal data in accordance with data protection law. For this reason, from the 2 June 2020 publication (31 March 2020 census date), we have removed the data available at a level below NHSScotland and staff group. A full assessment is available.
It is important that we continue to supply colleagues working in workforce planning, reporting and intelligence with the appropriate level of age information so that their work is undisrupted. Therefore, Management Information dashboards with full age data are available to authenticated individuals via TDI.
This has been communicated with our colleagues and stakeholders across NHS Boards and the Scottish Government. If you require to access the age data, please get in touch by emailing the Datagroup@nes.scot.nhs.uk.
Prior to September 2018, staff recorded as Locum Appointment in Training (LAT) and Locum Appointment in Service (LAS) were excluded from national workforce statistics. Following the quality assurance exercise which identified historical local recording issues with these staff, there was a broader discussion between ISD and NHS Boards on the merits of including these locum posts in national statistics.
Since NHS Boards view these locums as a key component of the medical workforce, it was agreed to change the reporting cohort so that such staff are included from 30 September 2018 onwards. This change impacts trend data for both the Doctor in Training grade (due to inclusion of staff on a LAT grade) and 'Other' grade (due to inclusion of staff on a LAS grade).
Agency locums are not included in these employment figures.
These changes affect the NHSScotland Workforce official statistics publication.
In July 2018, the Scottish Government announced a change in the employment model for Doctors in Training (DiT). Under the new arrangements, trainees will continue to occupy and move between training posts across all NHS Boards as part of their training, but for administrative purposes, 22 employers are being reduced to four, with trainees benefitting from having one employer for the duration of their training programme. This will apply initially to Junior Doctors, but will later include Dentists in Training. The change in employment model came into force on 1 August 2018.
Turas People was created to support implementation of the lead employer arrangements across Scotland by enabling information to be easily shared across systems and users.
Prior to the lead employer model, DiTs were recorded in SWISS by their board of placement. After implementation, they were recorded under their board of employment. To continue to report by board of placement, data from SWISS are linked to data from Turas People. The methodology of how we do this is available.
This change affects data released from December 2018 onwards in the NHSScotland Workforce official statistics publication (30 September 2018 census).
In August 2022, NES became the lead employer for Vocational Dental Practitioners (VDPs). This change resulted in VDP data coming from SWISS and Turas People. Previously these data were obtained from Turas training programme management only.
From 30 September 2022, the NHSScotland workforce official statistics dashboard reports VDPs for the first time. They are recorded under their employer board, NHS Education for Scotland, community dentistry specialty, and other grade.
In the Dentists table, VDPs are reported under their board of placement. This is identified using the education provider (dental practice) available in Turas People. There are multiple dental practices across Scotland that share the same name but have different locations which has prevented us from assigning them a postcode. As a result, there has been an increase in ‘Unknown’ SIMD.