- Filename
- CSWW_FTE_and_Headcount_rates_2019.csv
- Geographic levels
- Local authority; National; Regional
- Time period
- 2017 to 2019
Variable names and descriptions
Variable names and descriptions for this file are provided below:
| Variable name | Variable description |
|---|
| absence_rate_fte | Absence rate throughout year (FTE) |
| agency_cover_fte | Number of agency workers at 30 Sept of which covering vacancies (FTE) |
| agency_cover_headcount | Number of agency workers at 30 Sept of which covering vacancies (Headcount) |
| agency_cover_rate_fte | Agency cover rate (FTE) |
| agency_cover_rate_headcount | Agency cover rate (Headcount) |
| agency_fte | Number of agency workers at 30 Sept (FTE) |
| agency_headcount | Number of agency workers at 30 Sept (Headcount) |
| agency_worker_rate_fte | Agency worker rate (FTE) |
| agency_worker_rate_headcount | Agency worker rate (Headcount) |
| case_holders_fte | Number of caseholders (FTE) |
| caseload_fte | Average caseload (FTE) |
| cases | Number of cases held |
| leaver_fte | Number of children and family social workers leaving during year (FTE) |
| leaver_headcount | Number of children and family social workers leaving during year (Headcount) |
| social_worker_fte | Number of children and family social workers at 30 Sept (FTE) |
| social_worker_headcount | Number of children and family social workers at 30 Sept (Headcount) |
| turnover_fte | Turnover rate (FTE) |
| turnover_headcount | Turnover rate (Headcount) |
| vacancy_fte | Vacancies at 30 Sept (FTE) |
| vacancy_rate_fte | Vacancy rate (FTE) |
| working_days_lost_fte | Number of days of work missed due to sickness absence during year (FTE) |
Footnotes
Turnover rates have been calculated as follows: 100 * ( Number of leavers during the year / Number of children's social workers at 30 September)
Headcount is a count of all distinct children and family social workers: where a social worker holds more than one post only one record is counted.
Full-time Equivalent (FTE) figures are calculated by aggregating the total number of hours that social workers are contracted to work and dividing by the standard hours for their grade. FTE figures exclude social workers for whom FTE information was missing or not known.
Agency worker rates have been calculated as follows: 100 * { Number of agency workers / (Number of children's social workers + Number of agency workers) } and are based on a snapshot at 30 September.
Children and family social worker vacancies including vacancies covered by agency workers, on a FTE basis only.
Absence rate has been calculated as follows: 100 * {Number of days missed due to sickness absence/ ( FTE number of children’s social workers x 253)}, where 253 is the number of working days in a year accounting for bank holidays. The number of days sickness is counted during year ending 30 September.
Vacancy rates have been calculated as follows: 100 * { FTE number of vacancies / (FTE number of children's social workers + FTE number of vacancies)} and are based on a snapshot at 30 September.
Leavers are social workers who left a child and family social worker post at a local authority in the year ending 30 September. This includes social workers who are staying at a local authority, but moving to a non-child and family role, for example moving to adult social care.
Social workers included in this table are those registered with the Health and Care Professionals Council and either work in a local authority in a children’s services department or, if working in an authority where the services are joined up, work exclusively on children and families work.