skip to main content

Data Source

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:

  • Medical
  • Nursing
  • Psychology
  • Occupational Therapy
  • Teachers
  • Social workers
  • Child and Adolescent Psychotherapy
  • Family Therapy
  • Speech & Language Therapy
  • Dietetics
  • Art Therapy
  • Music Therapy
  • Physiotherapy
  • Other – including Healthcare Assistants

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:

  • Posts that were approved for recruitment but not yet advertised as at the census date 
  • Posts that were approved for recruitment but not yet advertised as at the census date

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.

Data Sources

Data Quality and Voluntary Application of the Code of Practice

Data Quality

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.

  • NES has a strong background in producing workforce statistics and has recently expanded its team of analysts. Several members of the new NES data team have previously worked either in the ISD Workforce Intelligence team or in other ISD teams responsible for producing National Statistics. They have brought knowledge and experience of the data and a firm grasp of the requirements for producing official and national statistics.
  • Throughout the transition period, NES has maintained contact with key NSS and ISD colleagues involved in workforce intelligence and workforce information systems.
  • The Head of Profession for Statistics for NHS NSS, NHS24 and the Scottish Ambulance Service is now also Head of Profession for NES.
  • NES receives support and training from the NSS ISD Statistical Governance Team


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:

  • Shadow colleagues in the ISD Workforce Intelligence team
  • Study and discuss the standard operating procedures relating to each aspect of data processing and analysis
  • Understand and continue to apply the quality assurance processes to the input and output data
  • Become familiar with data systems and the data processing codebase


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.