Skip to Content

Category: Articles

SIMS Returns – School Workforce Census 2017

 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

 

 

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.

Summer Census 2017

Please find below the information on creating and publishing the summer 2017 Pupil Census which will be held on Thursday 18th of May.

Your SIMS version will need to be 7.174 (can be seen via help/about SIMS) and the latest fileset issued by the DfE is 602, which will be deployed automatically to your server over the next couple of days but please ensure you have this fileset before you complete and publish your census.

Capita has released  Fileset_602 to address changes made by the DfE in the upcoming census on the 18th May 2017

Added 15th May 2017 at 16:00 Problem with DfE validation query 2010Q

This validation should be counting how many pupils are not taught in the normal year for their age and then dividing this by the total number of pupils to identify the situation where more than 10% of pupils are taught outside of the normal year for their age.  Unfortunately, this validation can be triggered incorrectly in schools with nursery age pupils, as the DfE coding will count all nursery age pupils that aren’t taught in E1 or E2 as not taught in the normal year for their age.

We believed that the DfE were going to provide an update to their school validation to deal with this sort of mistake, but we now understand that this will not happen and that the schools involved will have to ignore the query in these circumstances.

 

PRIOR TO RUNNING YOUR CENSUS PLEASE ENSURE THAT YOU RUN TOOLS | VALIDATE MEMBERSHIPS AS THIS WILL ENSURE YOUR CENSUS REPORT AND DATA FILE CONTAIN THE LATEST INFORMATION.

Please find the user guides below which provides information on preparing and producing the autumn 2016 census return.

New Data collected and changes to existing data:

Resources to support the production of the summer census are now available from the web site.

Key dates for the summer census are:

  • Census reference date: 18/05/2017
  • Attendance collection: 01/01/2017 – 16/04/2017 (inc)
    • Only pupils aged 4 to 15 on 31/08/2016
  • Exclusion collection: 01/09/2016 – 31/12/2016 (inc)
  • FSM eligibility records: 20/01/2017 – 18/05/2017 (inc)
  • Secondary Schools Learning Support: 01/08/2016 – 18/05/2017 (inc)
  • The return will include information on all pupils on roll on census reference date and leavers with
    • attendance in the Spring Term 2017
    • and/or, exclusions in the Autumn Term 2016
    • and/or, learner support to report since the start of the 2016/17 academic year

Important Changes to the Summer Census

Known Issues

  • Validation query 1870Q is being reported where it does not seem to apply.  We have reported this to the DfE.

Essential docs:

Preparing for the Census (Primary & Special Schools)

Preparing for the Census (Secondary & PRU)

Preparing for the Independent Schools Statutory Returns 2017

Preparing for Census (Post 16)

Producing the Summer Census:

Producing the School Census (English Nursery Schools)

Producing Summer Census Primary

Producing Summer Census Secondary

Producing Summer Census Special

Producing School Census Reports

 

Errors and Validation:

Census Validation Errrors

Please ensure you check the Essential Reading section of our simscrowd.net website for any last minute information on census day before you publish your census to the local authority or DfE.

If you have any questions please don’t hesitate to contact us on 0113 2105008.

FMS Year End Information for Schools

With schools now preparing for their end of year for finance, we have put together a list of the Leeds City Council Documents to which you may find of use.

Also enclosed on this page is the FMS User Manual Version 6.140 which is a user guide on using the different areas within the FMS software.

Year End Documentation for Schools:

FMS Version (6.140) FMS User Manual

Closedown 2014-15 School OSL&OSD Form

Closedown 2014-15 schools SIMS_FMS

CLOSURE OF ACCOUNTS 201415 (Schools on FMS LEEDS)

Dealing with School Closures (Enforced Closures)

As a school you may have to make the decision to close school this could be for example if the boiler breaks down or due to adverse weather conditions.

Please read through the guidance information attached to this article on how to record this information within SIMS Attendance. This has to be recorded as an enforced closure.

 

Entering an Enforced School Closure in Sims Document

School Census 2015 Known Errors

This page contains error codes for the January 2015 school census, further details to follow…

 

2170 (New SEN Codes)

With the new SEN codes being updated it has been found that the need types have to be updated as the old codes appear in red.

For example those children on the codes of Behavioural Emotional and Social Difficulties has been replaced with alternative codes and we strongly suggest you check through each child on this codeset.

2020Q  (Pupils taught out of year)

This error is currently being investigated by Capita as it appears this error is triggered for leavers in the previous term.

The Fix for this error will be included in a new Fileset 187.

 

 

January School Census 2015 Newspage

Connect-Up Support have put together the January School Census 2015 news page to help you locate the documents required to complete the January School Census 2015.

All changes have been outlined in these documents and we strongly advise you to read these documents.

This includes the class time information on what time to do your school census, national curriculum years DOB chart and the funded hour’s table of entitlement.

Further Important Pupil Premium Information can be viewed within our other online article displayed below this article.  

The January Census 2015 is an important census as this looks at your funding for the next academic year. Changes outlined are adopted from care changes, school dinners taken and changes to the codes for special educational needs.

Schools will need to be on Version 7.161 to complete the school census and Fileset 187 (the fileset is displayed when browsing for the census return.)

The documents we have included are as follows, you can click on each option to view;

1) A Preparing Census return guide (this covers primary schools and special schools)

2) A Producing Census return guide (each separate guide is labelled accordingly to the schools phase, one for primary, specials and PRU’s.)
3) An FAQ document for statutory returns
4) DFE School Census guide version 1.8
5) QRS School Census Producing School Census Reports

If you require any further advice or information then please do not hesitate to contact our support team on 0113 2105008.

Please note that the latest fileset 187 has been deployed to all Connect-Up Supported Schools. 

We have included some useful screenshots below of this information;

 Number Of Free School Meals Taken On Census Day:

Enter the Number of free school meals taken on census day by pupils, in
any year, who are eligible for Free School Meals.

  • Pupils should be included only if they meet the Free School Meals eligibility
    criteria (i.e. in respect to family income).
  • If your school has pupils of a young age, do not include pupils taking
    school meals in Reception, Year 1 and Year 2, if they are not eligible for
    Free School Meals in respect to family income, e.g. they are receiving a
    Universal Infant School Meal only.

Time to do the Census based on your DfE Code;

Selected Time on Census Day (Added 12/01/2015)

The DfE has indicated that the Selected Time information provided in their guidance documents was incorrect and will be corrected by bringing it into line with the information in their specification.

Last digit of DFE number Selected time
4, 7, 8 or 9 The selected time is one hour after the start of afternoon school
0, 1 or 5 The selected time is one hour after the start of morning school
2, 3 or 6 The selected time is one hour before the end of morning school

 

National Curriculum Years for 2015 after 31/08/2013

 

 

 

 

 

 

 

 

 

Funded Hours Table for 2,3,4 year olds

 

 

 

 

 

 

Extended Services Explained

You can access these through Focus | School | School Details

Description:

• Before school childcare and/or activities for school-age children (term-time).
• After school childcare and/or activities for school-age children (term-time
• Childcare and/or activities, for school-age children during school holidays.
• Childcare integrated with a nursery education place for three and four year olds (term time).
• Childcare during school holidays for three and four year olds in nursery education.
• Other forms of childcare including any form of childcare not covered by codes above.
• Childcare or activities for school-age children are offered 8am – 6pm 5 days per week, all year round.
• Childcare for 3 & 4 yr olds in nursery education is offered 8am – 6pm 5 days per week, all year round.
• Childcare for children up to three years old, 5 days a week, all year round.
• Childcare or activities is for children are offered in partnership with other schools
• Childcare or activities are offered in partnership with external providers
• Study support, sports, arts, music, ICT and/or volunteering opportunities for pupils outside sch hrs.
• Community use of school’s sports, arts, ICT or other facilities and spaces
• Information sessions for all parents of pupils entering Reception and Year 7.
• Parenting groups using structured manual-based parenting programmes.
• Specialised support, including for parents whose children have problems with attendance/behaviour.
• Information on national/local advice and support for parents
• Any other parenting/family support which does not use structured manuals, a parents room, etc.
• Adult education (excluding family learning i.e. without children)
• Family learning (parents/carers/other adult family members and children learning together)
• Health/therapeutic services, health promotion activities and physical therapies for the community.
• Social care services for the community
• Other advice and support services (e.g. financial, benefit and employment advice) for the community.
• Work with health professionals to support your pupils
• Work with social care professionals to support your pupils
• Other category of extended service in your school which are not covered by other codes

updated 15/01/2015

The School Workforce Census 2014 Information Page

Changes Compared to SWC 2013 (Added 28/01 17:45)

Census Reference Date 6th November 2014

Collection of information for PRUs is now the same as for other schools as the period when the staff in PRUs were centrally employed is now irrelevant.

QTS route now to be included for all staff who, since the previous school workforce census, have taken up their first position since qualifying as a teacher, regardless of when they qualified

School Direct and School Direct (salaries) now included in the range of QTS routes.

Base pay now has to be included even if (non statutory) Pay Spines and Points are included. Validation rule 4540 has been adjusted to take account of this.

The DfE expects there to be less instances when Pay Spine and Points are included.

‘Advanced Skills Teacher’ and ‘Excellent Teacher’ pay scales have been superseded by ‘Leading Practitioner’. Validation rules 4500 and 4505 have been removed to take account of this.

New validation queries added.

Check that birth dates are not defaulting to 1 January

Check that salaries are above the minimum wage and below the local government maximum

Check that staff are not recorded as working more than 48 hours per week

New validation error added

Check that Weeks Per Year is not greater than 53

 

Important changes to the Pupil Premium

Read more