CAMHS workforce data reported by NES is sourced from several systems. It covers a range of information on the staff in post employed by NHSScotland, vacancies and Staff in training.
Staff in Post: The data is extracted from the Child and Adolescent Mental Health Service Workforce Database which is a web based Oracle database that captures data on all staff delivering clinical care in specialist CAMH services in NHS Scotland. The source data are collected and verified by CAMHS lead clinicians. NES Data group work closely with these clinicians to ensure a high level of accuracy. Workforce information is shown as at the current census date and is available annually at September census dates from 2006. Quarterly information is available from March 2011 onwards.
Population data is updated annually from NRS (National Records of Scotland) Population estimates.
The database holds data of staff who are employed in a clinical role in CAMHS workforce. Staff employed in Paediatrics but not in CAMHS are not included.
Staff employed in the following multi-disciplinary professional groups are included in the database:
Vacancy data is collected quarterly directly from NHSScotland CAMHS for the census date. NES Datagroup works closely with lead Clinicians in CAMHS for quality assurance of data provided.
Data is collected on:
Sickness Absence data is extracted from Child and Adolescent Mental Health Service Workforce Database.
Staff in training data is sourced from NES Turas. Extracts are obtained for Psychology trainees and Medical Psychiatry Level 4 Trainees.
CAMHS workforce information is sourced from Child and Adolescent Mental Health Service Workforce Database which is updated directly by staff employed in NHSScotland CAMHS. This is a dynamic operational systems in which the data can change over time due to their live status and potential additional updates made by NHS Boards.
It is recognised that the published information does not always reflect the data used at board and regional level when planning and presenting the workforce. Accuracy of coding is crucial to the quality and credibility of the data and NES seeks to minimise such data inaccuracies. However, responsibility for data accuracy lies with the NHS Boards providing the data.
Workforce information may change slightly over time when NHS Boards make updates to databases to resolve issues that have been identified. Changes will not be made to previously published data, as part of the regular publication process, where there is little impact on the figures at a national level.
The NES Data Group continue to work with stakeholders on a number of data quality improvement projects and the published information will change over time to reflect these changes.
Voluntary Application of the Code of Practice
Since the publication of workforce statistics on 3 December 2019, NES has been named in legislation as a producer of official statistics. For the December 2019 publication NES voluntarily applied the UK Statistics Authority's Code of Practice for Statistics and worked to ensure full continuity in producing the NHS Workforce statistics according to the three pillars of the code of practice.
Having confidence in the people and organisations that produce statistics and data.
Using data and methods that produce assured statistics.
Throughout these early stages of the transfer of responsibilities, NES has worked closely with colleagues in ISD in order to:
NES has used the same data sources used by ISD for publishing workforce statistics prior to the transfer of responsibilities. The ISD Standard Operating processes have also been adhered to, and the existing codebase and processing tools have been used and only modified to improve performance or to implement ongoing, operational improvements.
Producing statistics that support society’s need for information.
NES has produced all the quarterly statistics updates expected by stakeholders and in the established reporting formats. NES has begun to work with various stakeholders and project groups who would previously have been supported by ISD. This will ensure NES remains informed about stakeholder interests and priorities and can be responsive to changes and new requirements, as well as leading innovation and improvement in close consultation with current and potential users.