1a. Does your Trust report HR metrics such as Sickness, Appraisals and Turnover through the Trust’s Data Warehouse?
1b. If so, are these metrics pre-calculated and loaded into the Data Warehouse, or calculated within the Data Warehouse?
2a – Does your organisation use a self-service method to allow managers to acquire data of HR metrics such as Sickness, Appraisals, Turnover
2aa. Yes – Managers self-serve through one of these methods (Please select the one most commonly used)
2b – Do these Self-Service methods include a drill down option e.g. to view staff that are absent, or need appraising
3a – Does the self-service options considered above allow HR metrics to be calculated for a combination of department and staff group, such as shown in Tab 1?
3b – Does the self-service options considered above allow HR metrics to be calculated for a combination of staff group and band, such as in the table below?
4a – Does your Trust refresh HR metrics within your monthly Board Report for previous months
4b – If the Answer to 4a is Yes, what is the maximum number of months that data is refreshed for?
4c – How is the data referred to in 4b refreshed?
5a – Approximately how many hours does it take to produce the metrics required for the monthly NHS England and Improvement Workforce KPIs
5b – Approximately how many hours does it take to produce the HR metrics required for your Trust’s board report?
5c – If it was necessary to produce monthly sickness rates by cost centre and band, for the last 12 months, as per Tab 3 how many hours would that take. An estimation is fine, there is no need to produce the data
Recruitment Metrics
6a – What system is used most frequently for Recruitment in your organisation e.g. TRAC, NHS Jobs, ESR
6b – Are recruitment metrics recorded within the Trust’s data warehouse?
6c – Are these metrics pre-calculated and loaded into the Data Warehouse or calculated within the Data Warehouse
6d – If calculated within the Data Warehouse, can these metrics be broken down by Department, Staff Group etc
