School Workforce Census 2017 Docuementation

census day: 2 November 2017

Preparing for the School Workforce Census 2017

Producing the School Workforce Census 2017

School Workforce Census Validation Errors and Resolutions guide

A powerpoint highlighting changes for 2017.


School Workforce Census



Added 14/11/2017 at 12:10 – Deadline for upload to COLLECT

Please note that the DfE deadline for uploading an acceptable return to COLLECT is Friday 1st December, but you should note that where your LA or support unit is involved with providing the return to the DfE, they may well have an earlier deadline date.


Added 06/11/2017 at 14:40 – Academies with 0 Validation Errors and Queries 


Where 0 validation errors and queries are being reported for an academy, it is worth checking the detail reports to find out if any historical information is being reported, e.g. absences.  If historical information is missing for an academy, the most likely reason is that the software is confused regarding the date the academy opened.  The SWC software uses the date the URN changed as entered in School Details to determine the date the academy opened, so the first thing I would try to get around the problem is to enter something in the previous URN field (from a Census point of view it doesn’t matter what is entered in the previous URN field as long as it is not the same as the current URN) and then enter the date the academy opened in the date the URN changed field.

If you find that you have to do this even when the URN has not changed (where the academy was not formed from an existing school) this would be a bug in the software that should be reported to you help desk.  Obviously, a school could work around the issue as described above, but if the issue is found to exist I would be obliged if it was reported to the help desk to ensure that it is fixed for the future.

Added 03/11/2017 at 14:50 – DfE validation errors 6220 and 6240

The DfE has confirmed that there is a mistake in their school validation which results in validation errors 6220 and 6240 be triggered for the following JACS 3 codes when they are actually fully acceptable codes.  The DfE will not be providing any further update to their school validation to correct these mistakes.

A000 Medicine & dentistry
B000 Subjects allied to medicine
C000 Biological sciences
D000 Veterinary sciences, agriculture & related subjects
F000 Physical sciences
H000 Engineering
J000 Technologies
K000 Architecture, building & planning
L000 Social studies
M000 Law
N000 Business & administrative studies
P000 Mass communications & documentation
Q000 Linguistics, classics & related subjects
R000 European languages, literature & related subjects
T000 Eastern, Asiatic, African, American & Australasian languages, literature & related subjects
V000 Historical & philosophical studies
W000 Creative arts & design
X000 Education
Y000 Combined/general subject unspecified


The Enumeration date for the 2017 SWC is Thursday 2nd November. Please note that where the return date falls on a school holiday data schools should base their snapshot data on the next working day, where practicable. Counts of occasional staff and of third party support staff should be based on the next working day and curriculum data should be based on a typical week.


Please find here a SIMS report definition which can be used to check data to be collected from staff

Please download the file to a given location on your network and then import it to SIMS via Reports > Import.

You will then find the report in the Staff Focus.

The report name is Staff Checking Sheet for Partial SWC v3.

Download and unzip.



The school workforce census is a statutory data collection that takes place each autumn. You must complete statutory censuses by law unless there’s a good reason not to.

The census collects data on all teaching and support staff in regular employment, including those working for:

  • local authorities on central contracts
  • local-authority-maintained schools
  • academies
  • free schools, including:
    • studio schools
    • university technical colleges
  • pupil referral units (local authority establishments that provide education for children who can’t attend a mainstream school)

Local authorities are responsible for:

  • co-ordinating and approving the submission of census data from all their maintained schools
  • submitting data for centrally employed school staff

Academies are responsible for submitting and approving their own census data.

Local authorities, local-authority-maintained schools and academies should issue privacy notices to all members of staff. Privacy notices inform staff members about the details of the census and their rights under the Data Protection Act.


Added 19/03/2017 at 18:50 – Changes to the DfE Specification compared to 2016

  1. CBDS (Common Basic Dataset) numbers corrected
    Agency and Third Party Support Staff number changed from 200567 to 200648.
    Disability Indicator number changed from 400320 to 400362
  2. Definition of Pay Data
    A line has been added to note 11 to define what is meant by Pay Data,
    “the contents of the Payments and Additional Payments modules, unless Daily rate = Yes”
  3. End Dates for Fixed Term Contracts
    Business rules for section 3.1 and 5.3 have been modified to indicate that Fixed Term Contracts must always have end dates.
  4. Qualification Subjects
    A line has been added to note 27 to indicate that JACS (Joint Academic Council) codes 2.0 has been superseded by JACS codes 3.0.
  5. XML Encoding Version
    Now indicates encoding UTF-8 to define the character set that can be included.