Spring 2017 School Census Bulletin

This bulletin lists the latest information regarding the School Census. It contains links to relevant documentation and information on the latest filesets, patches and errors.
We are running School Census Presentations on the 9, 10 and 11 January at various locations.  Click here for Primary and here for Secondary (please note these are combined Primary & Secondary presentations)

We are also running a School Census webinar on the 12 January for those subscribing to our WebTrain Service or this can be purchased as a one-off for £45

For further information or to book on the training please email scomis@devon.gov.uk or call 01392 385300

 

Census Date: 19 January 2017

For DfE and LA Return Dates and Advice click here

Latest Census Information

Date Description
20/01/2017 PAON is either invalid or not in the expected position

Capita have received the following message from the DfE.

“I can confirm that we have identified an issue with COLLECT, this will only affect schools where they have at least one pupil who has more than one address.  A fix has been provided but at present is being tested before we implement into the ‘live’ environment.”

We will update this bulletin as soon as we are informed the fix is implemented in Collect.

 

19/01/2017 Latest Updates from Capita

Added 19/01/2017 at 09:45 – Special deemed PRU Schools

Create and Validate is failing in Special deemed PRU Schools with the error message “The school census cannot be created as invalid SEN records have been found for the following students ..’. This occurs because of a mistake in our coding and can be dealt with via patch 22692, which is available from SOLUS.

Added 18/01/2017 at 13:20 – Table 19 of the DfE Summary Report

The DfE have acknowledged that their calculation of the percentage of pupils who are persistent absentees (i.e. over absence rate of 10% or more) is incorrect and should be ignored.

 05/01/2017  Latest updates from Capita

Added 04/01/2017 at 15:25 – Problem with Classes for YTI E1 or E2

Unfortunately, there is a mistake in our coding for the Classes panel in the School Census Spring application that means that schools cannot enter information for Type, Key Stage or Activity when the YTI has been set to E1 or E2.  Missing Class Activity data will result in validation error 1170 being triggered.  We are now looking into how we can deal with this issue.

Added 04/01/2017 at 15:00 – Validation Error 9999

Unfortunately, there is a mistake in the DfE coding of validation rule 9999 when applied to Admissions Appeals that means the validation error will be incorrectly triggered for all Primary and Middle deemed Primary Schools with a Governance of Voluntary Added, Foundation or Academy.  We have alerted the DfE to this issue.

23/12/2016 Latest fileset 502

For hosted and upgrade schools this will be applied. For non-hosted schools you will need to download and import.

Download the file here

This fileset provides the following improvements.

DfE Validation

Query 564Q – Please check: Primary admission appeals figures should be provided and greater than zero
1) Now looks at the correct data item

Error 640 – Infant appeals upheld plus Infant appeals rejected should match the number of Infant appeals heard
2) Error message corrected

Error 1848 – Early years pupil premium must be recorded for 4 year olds in E1, E2, N1 or N2
3) Error message corrected
4) Now takes account of E1 and E2 in criteria

Error 1861 – Early years pupil premium must only be recorded for 3 or for 4 year olds that are in Nursery provision, E1, E2, N1 or N2.
5) Error message corrected
6) Now takes account of E1 and E2 in criteria

Error 1867 – Learner is aged under 16 years as at 31 August 2016 and not eligible for bursary funding.
7) Error message corrected so that it now refers to 2016 rather than 2015

Error 1868 – Learner is aged 20 years or over as at 31 August 2016 and not eligible for bursary funding.
8) Error message corrected so that it now refers to 2016 rather than 2015

Query 2960 – Opening time is expected to be within the range 06:00 to 09:00.
9) Calculation of time values corrected

Query 2965 – Closing time is expected to be within the range 16:00 to 20:00.
10) Now looks at the correct data item
11) Calculation of time values corrected

Error 3095 – The nationality must be as stated by the parent/guardian or child. If one nationality record is either ‘refused’, ‘not yet obtained’ or ‘not known’ no additional nationalities can be returned.
12) Rule added

Error 5140 – Proficiency in English is missing or invalid for child in reception and above with language not equal to ENG (English) or ENB (believed to be English).
13) Now includes BSL (British Sign Language) in the list of languages where Proficiency in English does not have to be provided

Error 5160 – Class information is missing.
14) Now looks at correct context

Error 5180 – Child’s funded hours not provided or out of the range 0 to 25 to the nearest 0.5 for pupils aged 4 in nursery provision.
15) Funded hours range for 4 year olds changed from 0-15 to 0-25

Summary Report

Report Header
16) Release date now included

Table 3: Pupils on roll in each national curriculum year group [ALL schools]
17) Corrected to include NCyearGroups E1 and E2

Table 7: Proficiency in English [ALL schools]
18) Now excluded BSL (British Sign Language) from non-English speakers

Table 11: Funded hours for pupils on roll aged 2, 3 and 4 years [Not for: Non-maintained special schools and city technology college]
19) Date corrected

Table 12: Early years pupil premium – nursery schools [For: Schools with phase ‘NS’ only] [used for funding]
20) Corrected to include NCyearGroups E1 and E2

Table 12A: Early years pupil premium [For: Secondary, middle-deemed primary, middle-deemed secondary, secondary, all-through, special and PRU] [used for funding]
21) Corrected to include NCyearGroups E1 and E2

Table 16: Number of fixed period exclusions by reason and SEN provision in the 2016 summer term (terms 5 and 6) [Not for: Nursery school]
22) Corrected to remove ‘in care’ from description

Table 17: Number of permanent exclusions by reason and SEN provision in the 2016 summer term (terms 5 and 6) [Not for: Nursery school]
23) Corrected to remove ‘in care’ from description

Table 18: Number of lunchtime exclusions by reason and SEN provision in the 2016 summer term (terms 5 and 6) [Not for: Nursery school]
24) Corrected to remove ‘in care’ from description

Table 19: Attendance information for the 2016 autumn term (terms 1 and 2) for all pupils aged between 5 and 15 years as at 31/08/2016 [Not for: Nursery]
25) Corrected to remove five rows from the table and brought in line with the DfE specification

Table 21A: Secondary admission appeals [For: Middle-deemed secondary, secondary and all-through with appropriate age range]
26) Corrected by adding “Secondary” to the title

Table 27: Pupil reconciliation [Not for: Nursery school, special and PRU]
27) Corrected to include NCyearGroups E1 and E2

15/12//2016 Latest fileset 501

For hosted and upgrade schools this will be applied. For non-hosted schools you will need to download and import.

Download the file here

Documentation (click to download the relevant manual)

DFE School_census_2016_to_2017_guide_v1_5

School Census 2016/2017 Validation Errors and Resolution Guide

School-census-2016-to-2017-notepad-entries-autumn

Preparing for the School Census Spring 2017 Return English Primary, Nursery and Special Phase Schools Applicable to 7.172 onwards

Preparing for the School Census Spring 2017 Return English Secondary

Producing the School Census Spring 2017 return (English Nursery Schools) Applicable to 7.172 onwards

Producing the School Census Spring 2017 return (English Primary)

Producing the School Census Spring 2017 return (English Secondary and Middle Deemed Secondary Schools) Applicable to 7.172 onwards

Producing the School Census Spring 2017 return (English Special Schools) Applicable to 7.172 onwards

Producing the School Census Spring 2017 return (English Pupil Referral Units) Applicable to 7.172 onwards

Producing the School Census Spring 2017 return (English All Through)

 

 

 

 

Jan

Posted in Bulletin.