Workforce Information and Quality Team

Workforce Information and Quality Team

There are two main elements to the Team’s work:

Workforce Information:

Ensuring that the intended business benefits of the ESR Data Warehouse (to meet central and strategic reporting requirements for statistical reporting and planning purposes) are achieved.

Ensuring the database structure and reporting capabilities of the Data Warehouse are fit for purpose.

Maintaining appropriate data items and value sets within ESR, and therefore in the local and supra-trust level reporting tools, to comply with legislative, NHS dataset and user requirements.

Data Quality:

Analyse, assess and where necessary take or enable corrective action to improve the integrity of the data held on ESR, ensuring that it is capable of delivering the intended business benefits.

Ensure that appropriate guidance on the availability and usage of the ESR data and value-sets is made available to users whether responsible for data entry or reporting.



The team is currently working on a range of initiatives

A range of activities are underway in relation to Workforce Information:

The implementation of the Business Intelligence reporting tool for use with the ESR Data Warehouse (DWBI) was successfully completed in April 2015 and after a period of dual-running the Discoverer reporting tool was decommissioned at the end of August 2015. Work continues with the User community to ensure that they are able to meet their reporting needs using DWBI. The first set of Dashboards that were agreed by a Data Warehouse User Group (DWUG) working party are live as is a Workforce Minimum Data Set Dashboard that the HSCIC required; these being built and maintained by the ESR NHS Central Team. Further discussions with the DWUG representatives will determine additional reporting requirements and priorities going forward.

Working with the Health and Social Care Information Centre (HSCIC) and other stakeholders to ensure that key value-sets such as Occupation Codes, Job Roles and Area of Work meet requirements, and that guidance is available to assist in the selection and entry of the appropriate values.

Continuing the review of ESR value-sets to ensure that they comply with the latest National Workforce Dataset (NWD) requirements, but also working with HSCIC to ensure that the published NWD values and guidance themselves are corrected where necessary. Comparison of the value-sets has been completed and a process of iterative review by HSCIC and the Workforce Information Review Group (WIRG) will lead to changes where necessary.

Final version of the DWBI reports by which the HSCIC will extract the required Workforce Minimum Data Set (WMDS) for ESR-using organisations have been produced and confirmed as ready for operational use.

A number of initiatives are progressing; many with a view to improving data quality on ESR:  

  • Working with HSCIC and other parties on a series of Data Quality Roadshows to be held across England and Wales during 2015-16. A broad range of topics, both national and local to be covered as well as opportunities for delegates to ask questions.
  • Engagement with NHS England and others continues to establish the appropriate values and guidance regarding Equality & Diversity monitoring. A position paper has been published and further work to determine the required standards continues.
  • The team continues to support the joint HSCIC/ESR Workforce Validating Engine (WoVEn) process to improve data quality in a range of key data items - by supporting the HR/Recruitment Special Interest Group which is responsible for determining the data items and validation rules included, and liaising with the ESR Data Analysis Team who provide the data outputs to the HSCIC for further processing in the WoVEn tool.
  • An ESR BI Data Quality Dashboard report is available for use to complement the WoVEn tool and this continues to be developed to cover more data items and additional validation tests.
  • The Occupation Code and Job Role Data Verifier Dashboard enables the identification of conflicting Position data. This functionality remains available within ESR BI and will be reprovided as a DWBI Dashboard. These tools are maintained to take account of changed LOV's and revised guidance.
  • Working with NHS Employers to determine future requirements for recording more details regarding Apprenticeships on ESR.
  • Supporting the HEE Standardisation Programme in particular looking at data sets, definitions and making effective use of DWBI reporting.

Team objectives for the coming year

  • Support users of the DWBI reporting tool to increase the benefits gained from the enhanced reporting functionality for Data Warehouse users.
  • Ensure that ESR continues to support Workforce Policy (e.g. Working Longer, Apprenticeships, Diversity & Inclusion.)
  • Continue to assist the HSCIC in the ongoing review of Workforce Classifications (Occupation Codes, Job Roles and Area of Work) across agreed groups of staff, and to assess and promote uptake of the revised classifications.
  • Maintain and develop the delivery of Data Validation reports in partnership with the HSCIC for use at local and supra-Trust levels as appropriate. These may be either short or long term reporting tools.
  • Engage in national and regional user group forums to promote and develop data quality reports and guidance materials with a view to improving data quality in key areas.
  • Liaise with HSCIC to develop and deliver the planned Data Quality Roadshow events.
  • Ensure delivery of both user-led and centrally defined enhancements to the Data Warehouse as requested by users so it remains fit for purpose.
  • Ensure delivery of enhancements to ESR with regard to legal requirements, NWD, WMDS, user-led and centrally defined data items and value-sets.
  • Continue to develop the ESR BI Data Quality Dashboard for local users to cover additional data items and checks.
  • Review and maintain organisational hierarchy mapping within the Data Warehouse to meet reporting needs.

Data Analysis

There are two main elements to the Team’s work:

Data Extract and Analysis:

Supporting initiatives to improve the quality of data in ESR by providing data extracts, data analysis and reporting to key national stakeholders including Health and Social Care Information Centre (HSCIC) and Department of Health; it also provides data and searches to support NHS Protect’s counter-fraud work.

Solution Deployment Support:

Supporting the delivery of strategic development projects and promoting use of the solution and workforce data across the NHS; including the one-off bulk loading of data supplied by organisations. The team also analyses data to assess the utilisation and potential benefit returns from developments to the solution.



The team is currently working on a range of initiatives

There are a number of data quality initiatives being undertaken by the team in order to further improve key data within ESR. These include reporting on current interfaces in place, such as GMC and NMC. This helps to improve data quality between ESR and 3rd party systems, maximising the benefit to organisations. Data Quality reports have also been developed to support initiatives such as the use of Total Rewards Statements. All these reports seek to increase the quality of data held within ESR to allow for accurate reporting at both a local and national level.

The team provides HSCIC with up-to-date and timely data extracts which are used in the production of the WoVEn Data Quality reports.

We continue to support the central Data Load facility. This allows us to provide one-off bulk loads of competency data relating to both the position requirements and the employee. We also offer, subject to resources, a Data Load service for the one-off update of records to support solution deployment (e.g. e-Learning and Self-Service User Accounts, Supervisor information and Appraisals.)

For Solution Deployment Support, we are currently analysing the uptake and utilisation of a number of developments deployed into ESR, including the automated IAT solution, Auto User Creation Functionality, Workforce Management Report, Self-Service, e-Learning and Disclosure and Barring Service.

The team is also involved in a number of external project initiatives, including working with NHS Protect, providing assistance in the investigations into their four main areas of work: Counter-Terrorism, Bursary Fraud, False Qualifications and Serious Organised Crime Agency (SOCA) Alerts.



Team objectives for the coming year

  • Maintain the data cleansing process between ESR and Professional Registration Bodies to facilitate the performance of interfaces with ESR.
  • Continue to develop, implement and maintain KPI measurements to demonstrate the take-up of ESR functionality to assist in the highlighting of the benefits obtained through full system usage.
  • Continue to support the utilisation of ESR in relation to current functionality and new developments via data cleansing, data loading and / or data reporting.