Workforce Profile Appendix 1 Workforce Profile by Quarter

Workforce Profile Appendix 1 Workforce Profile by Quarter Workforce Profile by Pay Band 200 Band 5 30 140 Headcount 152. 36 183 150. 77 153 186 189 153. 23 60 190 120 80 Band 4 35 160 100 Band 3 40 180 Band 2 WTE Band 6 25 Band 7 20 Band 8 - Range A 35 15 10 40 20 5 0 Quarter 1 2014/2015 Quarter 2 2014/2015 Quarter 3 2014/2015 Quarter 4 2014/2015 0 2 16 22 22 Band 8 - Range B 24 Band 8 - Range C 20 19 10 3 5 Band 8 - Range D Non-AFC 5 VSM Total Staff Workforce Profile by Quarter and by Pay Band graph- headcount includes all GP’s, Lay Members and other non-banded employees on the payroll. Workforce Profile Pay Band table only includes staff on agenda for change and very senior manager pay scales. 1

Overall Turnover (%) – Comparison Appendix 1 Staff Turnover Comparison (%) 12. 00% Quarter 1 – 2014/2015 Quarter 2 – 2014/2015 Turnover (% of FTE) 11. 21 4. 59 5. 58 2. 49 Turnover (% of Headcount) 9. 82 3. 55 5. 30 2. 30 National CCG Average (%)* 2. 91* 10. 00% 8. 00% Quarter 1 2014/2015 Quarter 2 2014/2015 Quarter 3 2014/2015 2. 49% 0. 00% National CCG Average (%)* 2. 30% 5. 58% 5. 30% 4. 59% 11. 21% 2. 00% 3. 55% 4. 00% Turnover (% of Headcount) 9. 82% 6. 00% Turnover (% of FTE) Quarter 3 – 2014/2015 Quarter 4 – 2014/2015 *Figure based on average rolling national CCG annual turnover % Quarter 4 2014/2015 During the 12 months January 2014 to December 2014 an average of 1. 8 employees left each CCG nationally. During the same period an average of 5. 6 employees joined each CCG nationally Leaving Reason – Q 4 2014/2015 Leavers End of Fixed Term Contract 1 End of Fixed Term Contract – Other 4 Redundancy – Compulsory 4 Retirement Age 6 Voluntary Early Retirement – With Actuarial Reduction 4 Voluntary Resignation – Lack of Opportunities 2 Voluntary Resignation – Other / Not Known 14 Voluntary Resignation – Promotion 7 Voluntary Resignation – Relocation 3 Voluntary Resignation – Work/Life Balance 4 Leaving Reasons 8% 2% End of Fixed term Contract 8% End of Fixed term Contract Other Redundancy - Compulsory 6% 8% Retirement Age 14% 12% 8% 4% 29% Voluntary Early Retirement - With Actuarial Reduction Voluntary Resignation - Lack of Opportunities Voluntary Resignation - Other / Not Known Voluntary Resignation Promotion Voluntary Resignation Relocation Voluntary Resignation - Work/Life Balance 2

Quarterly Recruitment Activity Comparison Appendix 1 Vacancies Posted 20 18 Quarter Vacancies Posted Quarter 1 – 2014/2015 8 Quarter 2 – 2014/2015 7 Quarter 3 – 2014/2015 19 Quarter 4 – 2014/2015 15 16 14 12 Vacancies Posted 19 10 15 8 7 4 8 6 Quarter 1 2014/2015 Quarter 2 2014/2015 2 0 Quarter 3 2014/2015 Quarter 4 2014/2015 Quarterly Sickness Absence Comparison (%) 3. 5 3 2. 5 2 Absence (%) National Average (%) 1. 5 Quarter 2 2014/2015 1. 49 Quarter 1 2014/2015 1. 41 0. 82 0. 5 0. 96 1 Quarter 3 2014/2015 Quarter 4 2014/2015 0 Period Absence (%) National Average (%) Quarter 1 (2014/2015) 0. 96 2. 34 Quarter 2 (2014/2015) 0. 82 2. 39 Quarter 3 (2014/2015) 1. 41 2. 87 Quarter 4 (2014/2015) 1. 49 2. 53* *Data unavailable – estimation based on average of other quarters Source: Health & Social Care Information Centre http: //www. hscic. gov. uk/article/2021/Website-Search? q=CCG+Absence&area=both 3

Professional Registrations Appendix 1 Professional Registrations 20 18 16 14 12 10 8 6 4 2 0 No of Employees Registered 18 4 4 General Medical Council General Pharmaceutical Council Professional Body No of Registered Employees General Medical Council 4 General Pharmaceutical Council 4 Nursing & Midwifery Council 18 Nursing and Midwifery Council Registration Status 20 18 18 16 Registration Status No of Employees Expired 0 12 Expiry within 1 month 1 10 Expiry within 2 months 4 Expiry within 3 months 3 No concern 18 14 No of Employees 8 6 4 4 3 1 2 0 Expired 4 Expiry within 1 Expiry within 2 Expiry within 3 No concern months