Workforce Census 2022

Census Day: 3rd November 2022

Deadline for data submissions: 2nd December 2022

The School Workforce Census or SWC is necessary to inform the Department for Education of staff pay bills, staff turnover and staff absences.  This guide outlines what data is required for the Workforce Census and shows where necessary data can be entered into ScholarPack.

The DfE provides lots of guidance on their website you can use to help you complete the Workforce Census. You can search for information and find links to more help from this page. If you've resolved all your errors and are ready to submit your census, take a look at the DfE’s notepad entries for COLLECT queries guide for help with what explanations to submit for any existing queries.

For further advice and support, please see HERE for the DfE census guides. 

 

All personnel added into ScholarPack that have a current contract will be automatically included in the work force census unless you have manually selected to exclude them (to see how to exclude members of staff, please see the 'Removing staff from the census' section within this article)

Accuracy of data is crucial and you should ensure all staff are aware of Privacy Notices

 

Am I required to submit a Workforce Census?

The following school types will be required to participate in the Workforce Census:

School types required to submit a return	School types NOT required to submit a return
Maintained Nursery	Early Years Settings
Primary Schools	Privately Funded Independent Schools
Secondary Schools	Non-Maintained Special Schools
Maintained Special Schools	Sixth Form Colleges
Pupil Referral Units	Other Alternative Provision Providers
Academies (includes free schools, studio schools, UTCs and AP academies)	FE Establishments
City Technology Colleges	Secure Units
Academy Special Schools	Hospital Schools and Other Miscellaneous Establishments

 

School Workforce Level (Individual) data collected

• Staff Details
• Contract/Service Agreements
• Curriculum

School Level (Headcount) data collected

• Teacher Vacancies
• Staff Information

Changes since the last Workforce Census

There are no major changes since the previous collection, though the guidance has been updated in several aspects:

• Guidance on School Business Leaders has been clarified, see section 4.3, 7.2.5,
  7.5 and 7.5 of the DfE guide.
• Guidance on Disability has been clarified, see section 7.1.9 of the DfE guide.

What data is required?

√ - Mandatory data item for this type of staff
# - Optional data item for this type of staff
X - Data item not applicable for this type of staff

This information can also be found in section 6.1.2 of the DfE guide

	Contracted Teachers	Agency/SA Teachers	Contracted Teaching Assistants	Leadership, Non-Teacher	Other Contracted Support Staff	Notes
1. Staff Details
Teacher Number	√	√	√	√	√	Mandatory for non-teachers. if applicable
Family Name	√	√	√	√	√
Given Name	√	√	√	√	√
Former Family Names	√	#	√	#	#
NI Number	√	√	√	√	√
Gender	√	√	√	√	√
Date of Birth	√	√	√	√	√
Ethnic Code	√	√	√	√	√
Disability	√	√	√	√	√
QTS	√	√	√	#	#	Also required for Advisory Teachers
QTLS	√	√	√	#	#	Also required for Advisory Teachers
EYTS	√	√	√	#	#	Also required for Advisory Teachers
HLTA Status	√	#	√	√	√	Required for Contracted TAs and contracted Support Staff, even if they also are Agency/SA Teachers
QTS Route	√	√	#	#	#	Mandatory for all staff who, in the last year, have taken up their first position since qualifying as a teacher. May also be returned for other staff as well.
Newly Qualified Teacher	√	√	X	X	X
2. Contract/Service Agreement
Contract/Service Agreement Type	√	√	√	√	√
Start Date	√	√	√	√	√
End Date	√	√	√	√	√
Post	√	√	√	√	√
Date of Arrival in School	√	√	√	#	#	Only mandatory for teachers and teaching assistants who joined the school from 1/9/2009.
Pay Review Date	√	√	X	X	X	Applicable only to teachers
Pay Range	#	#	#	√	#	This data item is not mandatory but the department desires it, if available
Pay Framework	√	√	X	X	X	Applicable only for Leadership teachers
Pay Range Minimum and Pay Range Maximum	√	√	X	X	X	Applicable only for Leadership teachers paid on leadership pay range
Base Pay	√	√	√	√	√	Not mandatory if 'Daily Rate' = ‘Y’. NB: Daily rate only applies to agency/SA teachers
Safeguarded Salary	√	X	X	X	X
Daily Rate*	X	√	X	X	X	Required for current Agency/SA Teachers even if they have an expired 'PRM', 'FXT', or 'TMP' Teacher contract. Not required for centrally employed local authority staff
Reason for Leaving	√	#	√	#	#	Required for Contracted TAs even if they also are Agency/SA Teachers.
Destination	√	#	√	#	#	Required for Contracted TAs even if they also are Agency/SA Teachers
Origin	√	#	√	#	#	Mandatory for contracts starting from 1/9/2009 Required for Contracted TAs even if they also are Agency/SA Teachers.
Role Identifier	√	√	√	√	√
Hours worked per week	√	√	√	√	√
FTE Hours per week	√	√	√	√	√
Weeks per year	√	√	√	√	√	Not required if 'Daily Rate' = ‘Y’. NB: Daily rate only applies to Agency/SA Teachers
Category of Additional Payment	√	√	√	√	X	Not required if “Daily Rate” = ‘Y’. NB: Daily rate only applies to Agency/SA Teachers
Additional Payment Amount	√	√	√	√	X	Not required if “Daily Rate” = ‘Y’. NB: Daily rate only applies to Agency/SA Teachers
Pay Start Date	√	√	X	X	X	Not required if 'Daily Rate' = ‘Y’. Only required for Category ‘TL3.
Pay End Date	√	√	X	X	X	Not required if 'Daily Rate' = ‘Y’. Only required for Category ‘TL3.
3. Absence
First Day	√	#	√	#	#	Required for Contracted TAs even if they also are Agency/SA Teachers.
Last Day	√	#	√	#	#
Working Days Lost	√ (for sickness and pregnancy related absences only)	#	√ (for sickness and pregnancy related absences only)	#	#
Absence Category	√	#	√	#	#
4. Curriculum
Subject Code	√	√	√	X	X	Not required for centrally employed local authority staff
Hours	√	√	√	X	X	Not required for centrally employed local authority staff
NC Year Group	√	√	√	X	X	Not required for centrally employed local authority staff
5. Qualification
Qualification Code	√	√	√	√	#
Class of Degree	√	#	#	#	#	Mandatory where ‘Date of Arrival’ is equal to or greater than 1 August 2013
Subject Code	√	√	√	√	#

 

*When Daily Rate applies pay data (that is, the payments and additional payments modules) are not
required.

 

Staff Data Capture Sheets

To ensure your staff data is complete and up to date you can ask staff members to complete a basic personal information sheet. This can be downloaded via Admin>Personnel>Download Data Capture Sheet.

Data held outside of ScholarPack

Some schools may not hold all necessary data in the system to complete the Workforce Census as contract information may be stored on the local authority’s HR or payroll systems - if this is the case please contact your local authority for further advice. If you have partial census data in ScholarPack and have another system (HR/Payroll) that contains the remainder, you will need to contact the DfE help desk to discuss how this should be submitted.

Who’s Included?

The following, if they are in regular service, are examples of those for whom school workforce level data should be returned:

• Teachers employed by the school, both with and without QTS, EYTS or QTL
• Support staff employed directly by the school
• Teachers working at the school who have been supplied by an agency or a local authority if the local authority is acting like a supply agency
• Staff on paid or unpaid absence, whether long or short term
• Teachers on the School Direct (salaried) Programme, the Overseas Trained
• Teacher Programme (OTTP) and the Teach First programme
• 'Teaching Assistants' comprise support staff in the classroom for learning and pupil support (e.g. HLTAs, TAs, special needs support staff, nursery assistants and minority ethnic/bilingual support assistants)
• 'Non Teacher School Leaders' include School Business Managers and other non teaching school leaders

Who’s Not Included?

School workforce level data does not need to be returned for the following:

• Temporary staff with service of less than 28 days
• Casual staff without contracts employed on an ad hoc basis
• Trainee teachers on teaching practice
• Trainee teachers on a School-Centred Initial Teacher Training (SCITT) programme
• Staff working in extended school service provision, for example breakfast and after
  school clubs, Sure Start and Children’s Centres. Note that staff engaged in the
  normal running of the school, such as cleaners, must be included regardless of
  when they work, for example before, after, or during the normal school day
• Staff employed by the local authority that provide support to schools for example
  peripatetic music teachers, advisory teachers, educational psychologists,
  educational welfare officers (information on these will be submitted by the local
  authority)
• Governors and voluntary staff
• Staff for whom there is no role identifier code that equates to the function they
  carry out, for example clerk to governors, school crossing patrol staff and school
  improvement partners
• Staff whose contracts finished prior to 1 September last year

Every school will be expected to have a SENCO and to have a headteacher or executive headteacher. If this is a combined role within the school, for example the Head is also the SENCO then a note will need to put on COLLECT for queries 6540Q and 6550Q

 

Headcount data (on the day) is required for supply teachers who have a contract or are employed under a service agreement with a school for less than 28 days (occasional teachers) that are in school on census day.

Headcount data is also required for support staff who are not employed directly by the school or LA who are in school on census day, i.e. contract cleaners or outsourced IT technicians.

 

Data does not need to be returned for the following if they are not in school on the
census day:

• temporary staff with service of less than 28 days and who are not expected to
  complete service of 28 days or more
• casual staff without contracts employed on an ad hoc basis.

If these staff are in school on census day then head count data should be reported for
them.

 

‘Other support staff’ incorporates support staff that are non classroom based: matrons, nurses, medical staff, librarians, technicians, bursars and other administration/clerical staff, premises and catering staff.

School Workforce Level Data

The majority of the staff information that will be collected for the Workforce Census can be updated in bulk in the Staff Group Updater area, providing the admin user has HR permissions. This can be located in Admin > Personnel > Staff Group Updater.

For more information on the Staff Group Updater click this link:

Staff Group Updater

Please Note: When using the Staff Group Updater to input or change contract information this will only affect the Main Contract. Additional contracts must be altered manually via the staff profile area.

 

Personal Details

To enter or amend details you will need to access a staff member’s profile through Admin > Personnel > Staff > Select a Staff Member > Personal Details (cog next to staff name), or you can alternatively update everyone’s information in bulk through the Staff Group Updater.

• Family name
• Given name
• Former family names (where applicable and available)
• Date of Birth
• Gender
• Disability
• National Insurance Number
• Ethnic Code
• Qualified Teacher Status (QTS/EYTS or QTLS)
• Qualified Teacher Route
• Teacher Number – If a teacher number cannot be located please leave blank and submit a note to the DfE or your Local Authority.
• Higher Level Teaching Assistant Status (HLTA)
• Newly Qualified Teacher (Yes-1st Year, Yes-2nd year, No)

All fields highlighted in red are mandatory and dependent on the staff members role at the school may be collected for the Workforce Census.

 

Contract Data

To enter or edit details you can access each staff member’s profile through Admin > Personnel > Staff > Select a Staff Member > Contracts, or you can alternatively update some fields in everyone’s information in bulk using the Staff Group Updater.

You can have multiple contracts open at the same time for one account and one should be set as the 'Main Contract'. To create an additional contract, please click on the black cogwheel in the contracts header.

All fields highlighted in red are mandatory and dependent on the staff members role at the school may be collected for the Workforce Census.

 

It is considered best practice to give each contract a name. You could for example name each contract with the associated job role i.e ‘teacher contract’.

The census will be collecting all contract data where the end date is after 1st September.

Each contract must have a base pay (or daily rate) and hours recorded.

Contracts with neither base pay/daily rate or hours recorded should be regarded as occasional employment and must be recorded in the school level module if the member of staff is present on census day.

 

Contract Type

• If a staff member has a contract with a school then one of the following values must be selected from the codeset: permanent, fixed term, or temporary.

Contract Dates

• The contract dates must be in the format of DD/MM/YYYY.
• Start date and end date (or blank)

Post

• The classroom teacher post may be used to record teachers on the main or the upper pay range
• Unqualified teachers must be recorded in the post of classroom teacher
• Executive head teacher should be used for a head teacher who directly leads two or more schools in a federation or partnership agreement.
• Support staff based in the classroom for learning and pupil support must be assigned the post of Teaching Assistant
• Two posts have been created to replace the previously existing post of 'Support
  Staff'. These are 'Leadership - non Teacher' and 'Other Support Staff'. Schools and local
  authorities are not expected to return the Qualification or Additional Payment modules for
  'Other Support Staff'

Role Identifier

• This list is provided directly by the DfE. If a role cannot be located please select the role that has the closest description to your role type.

Date of Arrival in School

• The arrival date must be in the format of DD/MM/YYYY and must be provided for all teachers and teaching assistants that started their current period of continuous service with the school on or after 1 September 2009. Its is optional for other support staff.
• Used to show the start of the current period of continuous service.

Pay Review Date

• For contracted teachers and Agency/SLA teachers this should be the most recent determination of a teacher’s pay since 1st September (the review may not have taken place by the time of the school workforce census, so the previous year's determination should be entered).

Pay Range

• For non-teachers this will be either “National Joint Council (Local Government Services)” or “Other”. For teachers this will depend on their post and whether or not they have crossed the threshold to the upper pay range. Academies that use their own pay range should assign “Other”.
• The Leadership Pay Range should only be used for staff in leadership positions (head teachers, executive head teachers, deputy heads and assistant heads) and not for classroom teachers.

Pay Framework (Leadership members only)

• Contracts starting before 01/09/2014 will default to the Pre 2014 framework, whereas contracts starting after this date will link to the 2014 framework.

Pay Range Minimum and Pay Range Maximum (Leadership members only)

• Every leadership teacher paid on the leadership pay scale will have a basic salary range
  within which they can expect to be paid while they remain in the same post at the same
  school.

Origin (Where From)

• If an employee has a new contract and has not changed job role please ensure you choose ‘Not Applicable – Change of Contract’ from the available options. You will need to supply this information for teachers and teaching assistants if the contract start date is later than the 1st September 2009.

Reason for Leaving

• Reason for leaving is separate from Destination and indicates the reason for a teacher or
  teaching assistant ending their period of employment with the school or local authority.
• Examples include Voluntary Redundancy, Compulsory Redundancy, Left for other
  teaching post.
• Reason for leaving must be provided for all contracted teachers and teaching assistants
  that left during the previous academic year (from 1st September). It is not required for other staff, such as agency staff

Destination

• Required for all teachers and teaching assistants if they have a finished contract and the contract end date is after 1st September.

Daily Rate

• Only required for Agency/SLA teachers. If daily rate is 'Yes' then hours worked per week and FTE hours per week must be provided. If daily rate is provided, no base pay is needed.

Base Pay

• Please ensure when inputting your base pay that no special characters are used, such as the ‘£’ symbol. The Base Pay is the employee’s gross actual annual salary.
• It should not include any additional payments or allowances.
• The pay of part-time or term time only staff must not be adjusted upwards to the pay of a full-time equivalent member of staff.
• If any elements of the salary are safeguarded these must be reflected in the base pay.
• Necessary for all staff not paid by daily rates.

Safe Guarded Salary

• Only required for contracted teachers.

Category of Additional Payments

• The actual amount paid should be given. Any one off payments should show the amount received in full
• Should include all additional payments earned
• TLR3 payments need to be reported separately from other TLR payments
• This data is not required for the post of 'Other Support Staff'

Additional Payment Amount

• The annual actual amount should be given.

Pay Start Date

• For TLR3 payments

Pay End Date

• For TLR3 payments

Hours Worked Per Week

• This number should be no more than one decimal place (e.g. 32.5). The hours per week represents how many actual hours the employee works. The standard directed hours per week for teachers is 32.5.
• Hours are recorded as decimal figures, not as hours and minutes (27.5 means 27 and a
  half hours).

FTE Hours Per Week

• This number should be no more than one decimal place (e.g. 32.5). The FTE hours per week represents how many hours a full time person would be completing. FTE hours per week may vary.

Weeks Per Year

• Records the number of weeks per year the member of staff is paid, including any paid holiday.
• If someone is on a term-time only contract for 37 weeks per year but receives their pay in
  twelve monthly instalments, it is 37 weeks not 52 that should be entered.

Absences

Absence data is required for teachers and teaching assistants employed directly by schools. Absence information is optional for agency/service agreement teachers, leadership staff who are not teachers and for 'other support staff'. The census will be collecting absence data for teachers and teaching assistants active during last year.

To enter this data please go to Admin > Personnel > Manage Staff Attendance.

The census will be looking for the first and last day of each absence, working days lost and the absence category for all contracted teachers and teaching assistants.

Information is required on any activity or circumstances, except for training, that takes a
teacher or teaching assistant away from normal duties with their usual employer for half a
day or more.

For help using the Manage Staff attendance module, please click on the link below.

Manage Staff Attendance

 

Qualifications

Information is required on the type and subject of certain qualifications held by all
teachers and by non-teaching school leaders in regular service. Qualification information
is not required for 'Other Support Staff' but some systems may return this data to the
department if it is present. All qualifications graded Level 4 or above (higher than A-level) should be supplied.

The SENCO qualification must be recorded where present for any SENCOs.

Contracted teaching staff will need to declare their class of degree if their school arrival date is from 1st August 2013.

For all teachers, the following information is required:

• Their initial teacher training qualification for example, PGCE, BEd, Certificate in
  Education
• for those with a PGCE, information on prior degrees
• for those without QTS (or QTLS or EYTS) or those trained overseas, all
  qualifications relevant to their engagement as a teacher
• any subsequent qualifications gained relevant to their job as a teacher that appear on the list below. 

Information is required on previous degrees as well as on PGCEs.

To enter employee qualifications you will need to go to Admin > Personnel > Staff > Staff Profile > Qualifications and click on the black cog. All qualifications provided in the drop down box are supplied directly from the DfE common basic data sets.

 

For non-teaching school leaders, information about their degree or about any other
qualifications listed below should be provided.

Qualifications in England, Wales and Northern Ireland are grouped into levels from entry
level to level 8. The following qualifications, which are graded at level 4 or above (that is,
those higher than A-level) should be included.

• Post-graduate Certificate in Education (PGCE)
• BEd or other first degree combined with teacher qualifications
• Certificate in Education or equivalent
• Doctorate, for example PhD
• Master’s Degree, for example MSc, MEd
• Postgraduate certificates and diplomas
• Other first degree (that is degrees other than BEd or other first degree combined with teacher qualifications) such as BA and BSc
• Graduate certificates and diplomas
• Diplomas of higher education and further education
• Foundation degrees
• Higher national diplomas
• Certificates of higher education
• Non-UK teaching qualification

School Level Data (Headcounts)

Teacher Vacancies

The census will be collecting information about each vacant or temporarily filled teaching post on census day including:

• Vacancy Post
• Vacancy Temporarily Filled
• Vacancy Advertised
• To input this information you will need to go to Admin > Census > Workforce Census > Vacancies.

Staff Information

A headcount of occasional staff members in service on census day (4th November) should be recorded. To input this information you will need to go to Admin > Census > Workforce Census > Occasional Teachers

• Input occasional teacher count
• Input other staff head count

If the count is ‘zero’ then please enter 0. If you completed your Workforce Census with ScholarPack last year you may see your count from the previous census when accessing this area please amend this.

 

Removing staff from the census

If you go to Admin > Personnel > Staff, on each account you will see a note specifying if that account ‘will be included in the workforce census’.

To exclude an account simply click on the green note saying ‘[Account Name] will be included in the workforce census’ and the note will then change to red text saying ‘[Account Name] will be excluded from the workforce census’

Where do I find my Workforce Census?

To complete and download your Workforce Census, go to Admin > Census > Workforce Census

You are able to access this area when the 'Census Status' is showing as Live. 

Validating your census File

Once you have ensured that all necessary information is complete, go to Admin > Census > Workforce Census> Calculate Full Census Return to validate your information. Any errors or queries will be displayed here.

Example:

 

Generating your census file

Once you have checked the validity of your data you will be able to generate a summary of the information in Admin > Census > Workforce > Generate Census Summary. We recommend also printing out this summery so you are able to manually work through each figure and tick off if correct, this can be then signed off by your Head Teacher. Once you are happy that the summary of information is correct, you will need to click on Download Census File from the main census page.

This file will download to your computer (to your chosen destination) and you will be required to either send this information to your Local Authority, or upload directly to the DfE Collect Portal. If you are unsure we recommend you contact your Local Authority for more information.

 

For further advice and support, please see the attached link to the DfE census documentation:

DfE Workforce Census