The Clinical Psychology Services (CPS) Workforce Database is a national web-based database that captures data on all staff delivering clinical care in Psychology services in NHSScotland. The database was released in 2006 and allows users to update records stored in the database in real-time.
A range of demographic, registration, occupation and absence information for staff are entered and updated in the database by lead clinicians or administrative staff. A database extract is taken by NES approximately 14 days after each census date.
What data are published
Aggregated staff in post and absence data extracted from the database are released as part of the Psychology Services Workforce in NHSScotland publication for four quarterly census dates: 31 March, 30 June, 30 September and 31 December. Prior to extraction, NES work closely with clinicians and administrative staff to ensure a high level of accuracy.
A range of demographic, occupation and absence data are collected for staff which are used to produce the following key information in the publication:
The Glossary provides definitions.
Data are available annually at September census from 2006 to 2010, and quarterly from March 2011.
The database holds data on staff who are employed in a clinical role in the psychology workforce:
To be included in the data extract for the publication a person must be in an active post and not working on a Bank contract type. More specifically, the following conditions are met:
A key measure in the publication is the number of Psychology Service workforce per 100,000 people by NHS Board. The workforce data are derived from the database, and population data are sourced from the National Records of Scotland population estimates which are updated annually.
A number of steps are in place to ensure that these data are reported accurately.
The CPS database is a dynamic operational system in which the data can change over time due to their live status and potential additional updates made by the service. Accuracy of coding is crucial to the quality and credibility of the data. The responsibility for data accuracy lies with the service providing the data. However, NES seeks to minimise data inaccuracies by maintaining lists of data providers and regularly supplying them with instructions on how to access the system and maintain the data held.
The above quality assurance processes result in accurate information being released as part of the Psychology Services Workforce in NHSScotland publication. Therefore it is unlikely that any significant issues with the data quality would arise after publication.
As the database are manually updated by Boards, the data may not be updated before the date of the final extract due to job transfers, unavailability of data from sub teams, staff sickness etc. The data providers are aware of this, and make their updates as close as possible to the data extract dates. Any large data quality concerns are noted.
This system allows NES to report the number of staff employed in Clinical Psychology Services. This is likely different from the number of staff working at any given time (for example due to rostering or absences).
Only long term sickness data (sickness absence of more than 3 months) are available. Short term sickness absence cannot be reported.