ESR Analysis Tool
What is the resource?
The ESR analysis tool has been developed and used by David Priscott, head of workforce planning and education at NHS Plymouth since 2007, to efficiently use electronic staff record (ESR) information to support workforce planning.
The tool generates workforce skill mix trees and age profiles from a single data download from ESR.
The pivot tables in the spreadsheet allow users to instantly examine different management levels, produce graphs for any level of an entire trust, directorates to individual budgets and produce graphically consistent charts. Additionally the data can be filtered for staff group, bands and occupational code.
As well as showing the skill mix tree, it automatically calculates skill mix data for the percentage of staff band 5 and above, plus the percentage of staff band 8 and above. It integrates directly with the Workforce Reconfiguration Tool, quantifying the current workforce, against which proposed changes can be qualitatively and quantitatively evaluated. All doctors, dentists and directors (non AFC) are all placed together in band 9 for ease of function and to maintain confidentiality.
The ESR Analysis Tool has been rigorously tested by NHS Plymouth since 2007 and has proved robust and effective in providing baseline data for minimal effort. We would welcome your feedback and comments on your experiences with the tool to help us improve the resource.
What's in the resource?
- A user guide that details how to download the single report from ESR, enter it into the spreadsheet and check integrity
- Pivot tables for the skill mix and age profile on the current workforce that can be utilised as the baseline for further workforce planning.
Who is it useful for?
The tool is intended for use by workforce planners to support consistent and accurate information supply to managers, service leads, directors and the trust board.
How can it help me and my organisation?
The tool gives a very clear picture of the skill mix and age profile of the whole or any part of the organisation, which can then be used to enable effective forward planning of workforce needs.
Who can I contact about the resource?
Email David.Priscott@plymouth.nhs.uk. For feedback or suggestions for future releases, email workforceprojectsteam@skillsforhealth.org.uk.
|
Six Steps 
