There are several steps taken to add value, improve data quality and assist classification of staff groups prior to publication.
- Only staff who have a contracted full time equivalent (FTE) greater than zero are extracted from ESR.
- The data is divided into a separate non-medical dataset and a medical and dental dataset using medical pay scales as the initial determining field.
- Successive tests using corroborative fields within the data confirm or reclassify records between the medical and non-medical sets.
- Fields within the data are used to determine the grade of the medical staff.
- Occupation codes are used to classify non-medical staff into staff groups, and these are checked to ensure that the grades of staff are appropriate to their role. Where it is not, a new staff group is assigned based on other information within the person’s record. Where that is not possible the person is classed as having an unknown staff group.
- Each job of each person is allocated to the organisation where they work. This can differ to the trust holding their record.
- The data is matched against earnings data. Where a person is not earning, or they are not a recent starter in post, the record is not included in statistics showing staff who provide services.
- The data is split into classifications based on the organisation staff work in. This determines whether a job is shown as at an NHS Trust or CCG, at an NHS Support Organisation or Central Body, or is an Independent Healthcare Provider that is using ESR. This also determines which publication a record is included in.
Last edited: 25 May 2021 8:56 am