Due to late changes by the Department for Education to its specification regarding the date range for the funding of 4-year-old’s ESS have issued Consolidated Database Patch D and Fileset 2002 which will need to be applied to all schools SIMS databases prior to completion of the Spring 2022 Census.
Scomis will apply this patch and import the 2002 fileset to all SIMS databases held on our Hosted Platform on the weekend of 18th/19th December 2021.
We will also make Consolidated Database Patch D and fileset 2002 available to all locally hosted SIMS Schools through Solus3 at this time. As always we remind all locally hosted schools to ensure a full back up is taken prior to applying the patch.
This consolidated database patch is required for all state schools in England that are legally required to provide a School Census returns to the DfE that includes data for 4 year old’s taught in year E1, E2, N1 or N2.
This patch is available via SOLUS 3.
It is essential that schools subject to this very late DfE change to the specification for School Census Spring 2022 apply Consolidated Database Patch D  or above before uploading their XML return file to DfE COLLECT.
There are two aspects to this consolidated database patch.
1. Improvements already provided via Consolidated Database Patch C for Autumn Release 2021
All improvements previously provided via Consolidated Database Patch C for Autumn Release 2021 will be included in Patch D.
You can click here to view the content of the Consolidated Database Patch C for Autumn Release 2021.
2. Issues that are dealt with for the first time in Consolidated Database Patch D for the Autumn Release 2021
Issue i: Where a post-16 pupil in England was on roll for the first part of the previous academic year, was then a guest for part, but not all of the remaining previous academic year, the School Census Autumn 2021 application is failing to included the qualification and non-qualification hours for the previous academic year. This issue triggers DfE validation error 1886 when it checks that qualification and non-qualification hours are provided for the previous year when learning aims are provided for the previous year.
Solution: After application of this consolidated database patch, qualification and non-qualification hours are included where a pupil was on role for first part of the previous year, even if they returned to the school as a guest for a period that ended before the end of that previous academic year.
Issue ii: Following a very late change to the DfE specification for School Census Spring 2022, the date of birth range for identifying children as subject to DfE funding for 4 year old’s taught in year E1, E2, N1 or N2 has been reduced from 01/09/2016 – 31/08/2017 to 01/01/2017 – 31/08/2017.
Solution: After application of this consolidated database patch, Tools | Statutory Returns Tools | Update Early Years and the Early Years panel of Routines | Statutory Returns | School Census [Spring 2022] will take account of the reduced date range for funding 4 year old’s taught in year E1, E2, N1 or N2. Please note that Fileset 2002 or above will be required for the ‘report criteria’ text in the relevant early years detail reports to reflect this very late change to the DfE specification.
Issue iii: Where a Catholic school in Wales has indicated, via menu route Tools | Statutory Returns Tools | Update CES Census Lookups, that a member of staff has an ethnicity of ‘White Irish’ AND that member of staff is part of the leadership group, the calculation of the Leadership Group panel in Routines | Statutory Returns | Schools CES Census should default to ‘White Irish’ for that member of staff.
Before application of this patch this is not happening, and the calculation defaults the ethnicity to whatever has been entered in that member of staff’s Personnel record. Catholic schools in Wales can work around this by replacing the calculated ethnicity by ‘White Irish’ ethnicity as indicated via Tools | Statutory Returns Tools | Update CES Census Lookups.
This is irrelevant for schools in England, as ‘White Irish’ is available from a member of staff’s Personnel record
Solution: After application of this patch the calculation of the ethnicity for the Leadership Group panel in Routines | Schools CES Census Lookups for Catholic schools in Wales will take account of any ‘White Irish’ ethnicity indicated via menu route Tools | Statutory Returns Tools | Update CES Census Lookups.