Business Intelligence Hub

CYC Workforce Profile

 

Date Produced: 18/11/2022

Contents

1.      Key Performance Indicators. 2

1.1        Staff Headcount (snapshot). 2

1.2        Staff FTE’s. 2

1.3        Average Sickness Days per FTE (rolling 12 months). 3

1.4        Number of New Starters. 3

1.5        Number of Leavers. 4

1.6        Leaving Reasons (% of Leavers). 4

1.7        Total Turnover % (rolling 12 months). 4

1.8        Number of Voluntary Leavers. 5

1.9        Voluntary Turnover % (rolling 12 months). 5

1.10      Work With York YTD – Total Assignments. 6

1.11      Work with York – Long Term Assignments (over 12 months). 6

1.12      Work with York – Current Assignments. 6

2.      Equalities Profiling. 7

2.1        Gender. 7

2.2        Sexual Orientation. 7

2.3        Age. 7

2.4        Ethnicity. 7

2.5        Disability. 8

2.6        Disability Type (of declared disability). 8

1.                 Key Performance Indicators

Below are tables containing details of KPI figures for 2019/20, 2020/21, 2021/22 and to Q2 2022/23. Councillors, casual and school staff have been excluded from these figures so as to only account for core CYC staff, historic data has been mapped to match the current Directorate structure except for 2019/20 figures for the new Adults & Children’s directorate as we could not map the data back accurately.  The majority of the data within this report is available publicly on the York Open Data platform - www.yorkopendata.org

 

1.1              Staff Headcount (snapshot)

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

2590

2552

2500

2523

Adult Social Care and Integration

N/A

386

358

351

Children and Education

N/A

394

389

395

Corporate Services

218

214

212

210

Customer and Communities

613

594

576

592

Place

865

862

865

874

Public Health

96

100

109

107

 

1.2              Staff FTE’s

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

2144.4

2116.9

2095.6

2113.9

Adult Social Care and Integration

N/A

307.6

294.2

289.6

Children and Education

N/A

317.3

307.7

314.9

Corporate Services

198.3

194.8

194.9

194.2

Customer and Communities

438.9

424.7

418.6

427.8

Place

783.4

785.1

790.7

800.4

Public Health

74.8

78.1

89.4

87.1

 

1.3              Average Sickness Days per FTE (rolling 12 months)

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

11.6

8.8

11.8

13.0

Adult Social Care and Integration

N/A

18.3

16.0

18.7

Children and Education

N/A

7.1

12.1

16.4

Corporate Services

7.8

4.9

6.6

6.1

Customer and Communities

14.8

5.6

6.9

7.1

Place

7.6

8.8

14.2

14.6

Public Health

7.0

6.5

8.3

10.2

Benchmark – LGA (Public Sector)

8.4

7.1

N/A

N/A

Benchmark – LGA  (Public Sector – Y&H)

10.0

8.0

N/A

N/A

 

1.4              Number of New Starters

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

325

194

365

233

Adult Social Care and Integration

N/A

15

88

38

Children and Education

N/A

59

65

48

Corporate Services

27

15

25

16

Customer and Communities

80

38

68

62

Place

107

53

94

64

Public Health

8

14

24

5

 

1.5              Number of Leavers

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

290

267

385

217

Adult Social Care and Integration

N/A

75

84

43

Children and Education

N/A

46

74

45

Corporate Services

25

22

30

17

Customer and Communities

69

51

81

56

Place

79

61

92

54

Public Health

1

12

22

2

 

1.6              Leaving Reasons (% of Leavers)

City of York Council (exc. schools)

2019/20

2020/21

2021/22

2022/23 to Q2

Died in Service

1-2%

1-2%

<1%

2.4%

Dismissal - end of contract

4%

7%

3%

1-2%

Dismissal - lack of capability

2%

1&%

1-2%

<1%

Dismissal - misconduct

1-2%

1-2%

<1%

<1%

Dismissal - probationary period

0%

<1%

0%

<1%

Not known

2%

3%

3%

0%

Redundancy

3%

1-2%

4%

1-2%

Resignation

66%

50%

68%

72%

Retirement

18%

19%

20%

17%

Retirement - Ill Health

1-2%

1-2%

<1%

1-2%

Settlement Agreement

1-2%

<1%

<1%

0%

TUPE Transfer Out

<1%

14%

0%

<1%

 

1.7              Total Turnover % (rolling 12 months)

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

11.3%

10.7%

15.4%

16.3%

Adult Social Care and Integration

N/A

19.6%

23.2%

23.2%

Children and Education

N/A

13.4

18.5%

21.0%

Corporate Services

11.5%

10.2%

14.3%

14.9%

Customer and Communities

11.4%

8.4%

14.0%

15.5%

Place

9.4%

7.0%

10.7%

12.1%

Public Health

2.7%

12.3%

21.4%

13.3%

Benchmark – LGA (Public Sector)

N/A

9.0%

N/A

N/A

Benchmark – LGA  (Public Sector – Y&H)

N/A

9.0%

N/A

N/A

 

 

 

 

 

1.8              Number of Voluntary Leavers

Voluntary Turnover occurs when an employee willingly chooses to leave their position, including retirement and resignation. 

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

198

138

259

150

Adult Social Care and Integration

N/A

20

51

34

Children and Education

N/A

32

53

28

Corporate Services

17

13

21

11

Customer and Communities

53

35

60

42

Place

44

34

59

2

Public Health

1

4

15

15

 

1.9              Voluntary Turnover % (rolling 12 months)

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

7.7%

5.6%

10.4%

10.7%

Adult Social Care and Integration

N/A

5.6%

14.1%

15.6%

Children and Education

N/A

9.0%

13.5%

13.1%

Corporate Services

7.8%

6.0%

10.0%

9.6%

Customer and Communities

8.7%

5.8%

10.4%

10.8%

Place

5.2%

3.9%

6.7%

7.6%

Public Health

2.7%

4.1%

14.6%

9.5%

 

1.10          Work With York YTD – Total Assignments

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

1082

986

996

539

Adult Social Care and Integration

N/A

159

117

89

Children and Education

N/A

186

165

120

Corporate Services

67

24

64

17

Customer and Communities

134

69

71

66

Place

412

335

330

245

Public Health

7

199

248

2

 

 

1.11          Work with York – Long Term Assignments (over 12 months)

Directorate

2019/20

2020/21

2021/22

2022/23 to Q2

City of York Council (exc. schools)

111

110

126

103

Adult Social Care and Integration

N/A

12

14

13

Children and Education

N/A

24

22

9

Corporate Services

 0

2

1

1

Customer and Communities

8

10

8

11

Place

47

62

57

68

Public Health

0

0

24

1

 

1.12          Work with York – Current Assignments

Directorate

2019/20

2020/21

2021/22

2022/23 Q2

City of York Council (exc. schools)

423

434

486

346

Adult Social Care and Integration

79

39

66

63

Children and Education

100

68

84

68

Corporate Services

 14

5

14

8

Customer and Communities

49

25

43

39

Place

179

142

198

166

Public Health

2

155

81

2

 

2.                 Equalities Profiling

The tables below summary the City of York Council’s equalities profile. These were produced using a snapshot of available data taken on 30th September 2022. Councillors, casual and school staff have been excluded.  Age data is provided by The local government earnings and demography survey (LGEDS) 2019/20 with all York and National figures used taken from the 2011Census.

 

2.1              Gender

 

2019/20

2020/21

2021/22

2022/23 to Q2

 

Male

Female

Male

Female

Male

Female

Male

Female

City of York Council

36.4%

63.6%

37.8%

62.3%

38.0%

62.0%

37.6%

62.4%

Public Sector

33.7%

66.3%

33.7%

66.3%

33.7%

66.3%

33.7%

66.3%

York

49.0%

51.0%

49.0%

51.0%

49.0%

51.0%

49.0%

51.0%

National

49.4%

50.6%

49.4%

50.6%

49.4%

50.6%

49.4%

50.6%

2.2              Sexual Orientation

 

2019/20

2020/21

2021/22

2022/23 to Q2

Heterosexual

96.6%

96.2%

95.6%

95.3%

Non-Heterosexual

3.4%

3.8%

4.4%

4.7%

 

2.3              Age

 

16-24

25-34

35-49

50-64

65+

2019/20

CYC

2.6%

12.0%

37.0%

45.4%

3.0%

Y&H

5.1%

13.8%

35.6%

42.7%

2.8%

England & Wales

4.7%

14.7%

35.7%

41.3%

3.5%

2020/21

CYC

2.6%

12.7%

34.9%

46.5%

3.2%

Y&H

5.1%

13.8%

35.6%

42.7%

2.8%

England & Wales

4.7%

14.7%

35.7%

41.3%

3.5%

2021/22

CYC

3.3%

13.2%

33.3%

46.2%

4.1%

Y&H

5.1%

13.8%

35.6%

42.7%

2.8%

England & Wales

4.7%

14.7%

35.7%

41.3%

3.5%

2022/23 to Q2

CYC

3.6%

12.7%

33.0%

46.2%

4.4%

Y&H

5.1%

13.8%

35.6%

42.7%

2.8%

England & Wales

4.7%

14.7%

35.7%

41.3%

3.5%

 

2.4              Ethnicity

 

 

2019/20

2020/21

2021/22

2022/23 Q2

White - British

BME

White - British

BME

White - British

BME

White - British

BME

City of York Council

95.0%

5.0%

93.8%

6.2%

93.7%

6.3%

93.4%

6.6%

Public Sector

89.9%

10.1%

89.9%

10.1%

89.9%

10.1%

89.9%

10.1%

Public Sector – Y&H

94.7%

5.3%

94.7%

5.3%

94.7%

5.3%

94.7%

5.3%

York

90.2%

9.8%

90.2%

9.8%

90.2%

9.8%

90.2%

9.8%

National

80.5%

19.5%

80.5%

19.5%

80.5%

19.5%

80.5%

19.5%

 

 

 

2.5              Disability

 

 

2019/20

2020/21

2021/22

2022/23 to Q2

Not Disabled

Disabled

Not Disabled

Disabled

Not Disabled

Disabled

Not Disabled

Disabled

City of York Council

95.3%

4.7%

95.2%

4.8%

93.6%

6.4%

93.3%

6.7%

Public Sector

95.0%

5.0%

N/A

N/A

N/A

N/A

N/A

N/A

Public Sector – Y&H

96.3%

3.7%

N/A

N/A

N/A

N/A

N/A

N/A

York

85.0%

15.0%

85.0%

15.0%

85.0%

15.0%

85.0%

15.0%

National

82.0%

18.0%

82.0%

18.0%

82.0%

18.0%

82.0%

18.0%

 

2.6              Disability Type (of declared disability)

 

2019/20

2020/21

2021/22

2022/23 to Q2

Learning disability

10.3%

10.8%

9.4%

13.9%

Long-standing illness

33.6%

33.3%

35.2%

31.4%

Mental illness

3.4%

3.3%

7.8%

10.2%

Physical

11.2%

10.0%

10.2%

8.8%

Sensory

5.2%

5.8%

7.8%

9.5%

Other

36.2%

36.7%

29.7%

26.3%

 

Note: The equalities data in these tables is based on staff information held by HR.  Over 18% of staff have not provided information for Disability and Ethnicity, and over 30% for Religion or Sexual Orientation.