Skip to content
Data Provider: Welsh Government Experimental Statistics NHS staff vacancies by organisation, staff group and date

Estimates of NHS Wales vacancies based on the difference between budgeted and actual staff numbers. Negative vacancy rates can occur where the number of staff in post exceeded the budgeted number of staff.

None
Measure[Filtered]
Date[Filtered]
Measure1
Organisation[Filter]
Staff group[Filter]
Click here to sortAll organisationsClick here to sortBetsi CadwaladrClick here to sortPowysClick here to sortHywel DdaClick here to sortSwansea BayClick here to sortCwm Taf MorgannwgClick here to sortAneurin BevanClick here to sortCardiff and ValeClick here to sortPublic Health WalesClick here to sortVelindreClick here to sortWelsh Ambulance Services NHS TrustClick here to sortHealth Education and Improvement WalesClick here to sortDigital Health and Care WalesClick here to sortNHS Wales Shared Services Partnership
All staff groups5.79.811.46.85.43.04.6-0.412.05.36.07.416.26.6
Medical and dental (excluding trainees)9.915.927.416.76.85.714.6-4.133.56.20.02.3.The data item is not applicable1.4
Nursing, midwifery and health visiting (registered)Data for 31 December 2022 amended in August 2023.7.412.319.08.83.55.97.32.115.89.912.00.0.The data item is not applicable11.4
Nursing, midwifery and health visiting (support)5.98.42.18.57.64.14.60.5.The data item is not applicable11.4.The data item is not applicable.The data item is not applicable.The data item is not applicable.The data item is not applicable
Administration, estates and facilitiesThe administration and estates, and health care assistants and other support staff\' staff groups have been combined in this table.5.18.84.93.37.2-0.61.50.08.55.310.27.616.26.9
Scientific, therapeutic and technical3.06.015.94.43.70.81.6-3.814.01.357.413.3.The data item is not applicable-10.5
Ambulance4.3.The data item is not applicable.The data item is not applicable-156.30.3.The data item is not applicable.The data item is not applicable.The data item is not applicable.The data item is not applicable.The data item is not applicable4.5.The data item is not applicable.The data item is not applicable.The data item is not applicable

Metadata

Title

NHS staff vacancies, by staff group

Last update

17 April 2024 17 April 2024

Next update

July 2024

Publishing organisation

Welsh Government

Source 1

NHS electronic staff record

Source 2

Workforce Services, NHS Wales Shared Services Partnership

Contact email

stats.healthinfo@gov.wales

Designation

Experimental statistics

Lowest level of geographical disaggregation

Local health boards

Geographical coverage

Wales

Languages covered

English and Welsh

Data licensing

You may use and re-use this data free of charge in any format or medium, under the terms of the Open Government License - see http://www.nationalarchives.gov.uk/doc/open-government-licence

General description

NHS Wales vacancy statistics are published as experimental statistics as the underpinning data collection process is newly created and continues to be under development while it is being embedded uniformly across all NHS organisations. These statistics include only those staff directly employed by NHS Wales.
The statistics exclude primary care contractors such as General Medical Practitioners and Dental Practitioners.


Data collection and calculation

A ‘vacancy’ is defined as the difference between the number of funded full-time equivalent (FTE) posts as recorded on the finance general ledger, and the number of FTE staff in post as recorded on the Electronic Staff Record (ESR) at a point in time. The vacancy rate is the number of vacancies divided by the number of funded FTE posts recorded on the general ledger.
Staff groups are determined by the subjective code which is a data item in both the finance general ledger and ESR. It has the same defined list of values which should be applied consistently between both sources.
The data collection process was designed and will be developed further in consultation with all NHS organisations.
These statistics are published as there is wide public interest. All stakeholders are invited to provide feedback on their suitability and quality as this new process is being developed.

Frequency of publication

Quarterly

Data reference periods

Quarterly

Rounding applied

Full-time equivalents are rounded to the nearest whole number, and the vacancy rate to 1 decimal place.

Revisions information

There are no planned revisions.

Keywords

Staff; NHS, vacancy

Statistical quality

These statistics are published with a data quality statement that highlights a number of data quality issues. Taken in isolation, some of the issues have the effect of over-estimating of the number of vacancies and some have the effect of under-estimating the number of vacancies. When all the known issues are considered as a whole, it is thought that the issues which result in an under-estimate of the number of vacancies at the Wales-level, have a greater effect on the statistics than the over-estimating effects.

Data quality statement:
1) The methodology has been applied consistently across the majority of NHS organisations. It is known that one local health board was unable to supply the number of funded FTE posts through the finance general ledger, but supplied the number of paid FTE staff in post through the finance general ledger as an approximation. This is likely to result in the under-reporting of vacancies in this health board as the number of paid FTE staff is likely to be lower than the number of budgeted FTE staff.
2) The data collection method also resulted in two other health boards reporting a very low number of vacancies across some staff groups. The reasons for this are being investigated but the data provided is unlikely to be a fully-accurate reflection of vacancies at the time and means that there was a likely under-reporting of vacancies in these health boards.
3) Any staff recorded as doctors in training, dentists in training, or pre-registration pharmacists, are not included in this release. There are complexities in counting ‘vacancies’ of these types of posts as local health boards hold a budget for these staff but the majority will be employed by NHS Wales Shared Services Partnership through the Single Lead Employer scheme. Health boards can also employ staff coded as trainees directly, without them being formal trainees through the Single Lead Employer. Measuring vacancies of these types of staff will be developed in future months, but the ‘up-take’ of these types of posts may be more accurately measured using ‘fill rates’ which are collected by Health Education and Improvement Wales.
4) There can be a negative number of vacancies or vacancy rate if the staff in post number on ESR exceeds the budgeted number of staff through finance general ledger. This can happen where an NHS organisation knowingly over-recruits and/or where certain non-recurrent or short-term post funding is not included in the finance general ledger. Where funding for posts exists but is not recorded on the finance general ledger and staff are employed through that funding, the number of vacancies reported would be an under-estimate of the actual number of vacancies in the reference period.
5) The number of vacancies in the medical and dental staff group may be over-estimated due to differences in how FTEs are counted between the finance general ledger and ESR. A full-time member of this staff group may count as 1 FTE on ESR through their contract defined as 10 sessions per week. However, in practice some staff may work 12 sessions per week and may be recorded as 1.2 FTE on the finance general ledger. This would create a ‘vacancy’ of 0.2 through this data collection process, but in practice there was no vacancy as the staff member worked longer than their contracted hours.
6) FTE staff in post numbers on ESR do not normally include bank, agency, contractors or other non-payroll staff. This may result in a small over-estimate of the number of vacancies and vacancy rate as there may have been staff delivering services but not recorded on ESR on the reference date.
7) Vacancies for ‘administration and estates’, and ‘health care assistants and other support staff’ have been published as a combined staff group for 31 December 2022 as there may be some inconsistencies in how certain staff roles are coded between these two staff groups across NHS organisations.
8) Data for 31 December 2022 does not include the Finance Delivery Unit or the NHS Wales Health Collaborative (which are hosted by Public Health Wales), where just under 180 FTE staff were employed. It is planned that these units will be included in future editions of this statistical release.
9) As staff move posts, updates to FTEs per subjective code may be more timely on the finance general ledger than they are to the staff in post numbers through ESR. Therefore, there may be a small discrepancy in the number of vacancies reported and the actual number of vacancies on the reference date.
10) Not all services within local health boards aim to recruit the full number of FTE budgeted staff. Some services may choose to use their staff budget flexibly to deliver their priorities and/or may choose to use their pool of temporary staff (nurse bank, locums, agency) flexibly throughout the year as demands on the service change. Therefore, a small number of reported ‘vacancies’ are planned in some circumstances.
11) Allocating staff to a subjective code in both the finance general ledger and on ESR involve manual processes and may result in a small number of staff having a mismatch of subjective codes between the two sources.
12) There are likely to be seasonal effects on the number of vacancies and the vacancy rate, which particularly effects ‘medical and dental’ and the ‘registered nursing, midwifery and health visiting’ staff groups as newly qualified staff graduate (and become available for recruitment) at certain times in the year only.