skip to main content

NHSScotland pharmacy workforce survey (managed sector)

NES collects employment information on the NHS pharmacy workforce, sometimes referred to as the Managed Sector to differentiate it from community pharmacy.

The managed sector pharmacy workforce are directly employed by NHS Scotland and include staff who work within pharmacy services at a hospital, NHS Board, and the Pharmaceutical Special Service.

Data source

A survey is sent out to NHS Boards to collect aggregated information on employment, vacancies, locums, posts currently at risk, and disestablished posts.

Employment information for the managed pharmacy workforce are also available in SWISS. They are reported quarterly in the NHS Scotland Workforce official statistics publication under the Pharmacy sub job family (Other Therapeutic Services staff group). However, detail of the discipline (e.g pharmacist, pharmacy support worker etc) is only available in the annual survey.

Methods

Data are available annually on 30 September census from 2011.

Inclusion and breakdowns

Staff are included in this survey if they are employed by NHS Scotland on a permanent contract. 

Pharmacy leads at each NHS Board are asked to complete the excel-based survey for the workforce position at 30 September each year. The survey collects information for the following disciplines:

  • Pharmacists including those on the provisional register.
  • Pharmacy technicians and pre-registration trainee pharmacy technicians (both year 1 and year 2).
  • Pharmacy support workers.
  • Administrative and clerical staff including roles in Business / Logistics / IT Managers, Office Managers, and Data Analysts.
  • Non-AfC posts, e.g. Director’s of Pharmacy.
  • Other posts not elsewhere classified.

Staff on secondments are reported under their NHS Board of employment, rather than board of placement.

Data are collected by division:

  • NHS Acute Hospital,
  • NHS Mental Health and Community Hospitals,
  • NHS Board Central Staff, and
  • NHS Board Primary Care Staff.

Territorial Boards record the level of staffing for each service within their Board, whereas staff at Special Health Boards are recorded under central staff service.

Definitions

vacancy is defined as: A post which has been cleared for advert after being through the redeployment process (internal or external advert) and remains a vacancy until an individual starts in the post. 

The number of vacancies at the census date are recorded as Whole Time Equivalent depending on the length of vacancy: vacant less than 3 months, vacant for 3 months and more, vacancy length unknown. 

For vacancies, additional conditions are applied:

  • if a post is filled by a locum/agency staff, it is still vacant;
  • if a member of staff on leave, and it is filled by a permanently employed member of staff, then it is not vacant; and
  • if a post is ‘empty’ at the census date, but it has been recruited into it then it is recorded as vacant until the new recruit starts.

From September 2021, establishment is calculated by employment plus total vacancy (in whole time equivalent). Prior to September 2021, establishment was entered by data providers. There are a small number of cases where the establishment does not equal the sum of employment and total vacancy. 

A locum is someone employed on a contractual basis through an agency, rather than having a permanent salaried position.

Disestablished posts are posts are those that are no longer funded as part of the core establishment.

At risk posts are those being considered removed from the core establishment.

Employment per 100,000 population are reported using the Mid-year population estimates: time series data:

Workforce per 10,000 population = (Employment / Population) * 10,000

Mid-year populations are published annually with estimates provided for the previous year. For example, in 2024 the mid-2023 population estimates were published. As a result, any census point published without a corresponding population estimate will be marked as provisional and the latest available population estimate will be used until the correct year has been published. The time series takes into account any revisions or corrections over the year. 

 

What data are published?

  • The number of staff employed by NHS board, division, discipline, and agenda for change band.
  • The number of vacant posts and vacancy rate by NHS board, division, discipline, and agenda for change band.
  • The number of locum and agency staff, posts currently at risk, and posts disestablished by NHS board, division, discipline, and agenda for change band.

Data quality

Several steps are in place to ensure that these data are reported accurately.

  1. Ahead of this survey being supplied to Boards, the Data Group work with the NES Pharmacy directorate to ensure the data being collected and the guidance for completion are accurate and relevant. The Pharmacy directorate are in touch with key stakeholders within this service in NHSScotland.
  2. An excel survey is provided to NHS Boards in the middle of September each year to complete for their pharmacy workforce at 31 September. The survey is completed by people working in the service and signed off by the director of pharmacy at each Board. Boards are asked to supply the data by end of October.
  3. Once these data have been returned to NES, each survey is checked for any completion errors or missing information and compared with previous figures for consistency. When required, NES clarify any potential issues with data providers. 4.These data are then processed to combine all extracts together and updated in reporting software, PowerBI. The report is then checked to ensure the values are shown accurately and any additional points of clarity are noted in notes pages or interactive tooltips.
  4. These data are part of the two-week early release quality assurance process where the outputs are made available to the directors of pharmacy to confirm as accurate. Communication with NHS Boards over this period allows us to confirm or update any of these data ahead of release to the public.

This collection allows NES to report the number of staff employed at a census date. This will be different from the number of staff working at any given time (for example, due to rostering or absences).

It is not possible to use the main administrative system of employment data (SWISS) since the occupational coding structure does not include the occupations in the survey. The use of administrative data would help reduce the burden on survey respondents by supplementing or replacing survey items and is something that NES is investigating.

It is not possible to track the progression of staff or calculate turnover using the survey because the data is aggregated.

Quality assurance and limitations