Skip to Content

Pupil Premium for FYr 2019/20 (England)

Pupil Premium for FYr 2019/20 (England)

Added 15/02/2019 at 14:50 – PPG (Pupil Premium Grant) per-pupil for financial year 2019/20

Adopted from Care Premium: £2,300 per year

Deprivation Premium – Reception to Year 6: £1,320 per year

Deprivation Premium – Year 7 to 11: £935 per year

Early Years Premium: 53p per hour up to a maximum of £302.10 per year (53p up to a maximum of 570 hours per year)

LAC (Looked After Children) Premium: £2,300 per year

Service Child Premium: £300 per year

Added 14/02/2019 at 10:50 – Types of pupil premium for financial year 2019/20

The following information is based on the DfE specification for the financial year 2019/20 CSV download.

Deprivation pupil premium

This is reported in the DfE CSV download.

This is allocated to pupils on roll in the January 2019 school census or alternative provision census that are known to have been eligible for free school meals (FSM) on any pupil level census since summer 2013 (known as ‘FSM Ever 6’).

Service child pupil premium

This is reported in the DfE CSV download.

This is allocated to those pupils on roll in the January 2019 school census or alternative provision census who have been either:

  • recorded as a service child in either January 2014, January 2015, January 2016, January 2017 or January 2018; or
  • in receipt of a War Pension Scheme (WPS) or Armed Forces and Reserve Forces Compensation Scheme (AFCS) pension from the Ministry of Defence (MoD) as a result of injury, illness or death caused by service

Adopted from care pupil premium (also referred to as Post LAC pupil premium)

This is reported in the general DfE CSV downloads, but is not reported via the CSV files generated by the DfE search facility, as this pupil data is not intended to be passed between schools.

This allocated to pupils on roll in the January 2019 school census or alternative provision census who are recorded in January 2019 as either adopted from care or ceased to be looked after through a child arrangement order, special guardianship order or residence order.

Looked after children pupil premium

This is reported in the DfE CSV download where the pupil would have attracted one or more of the other pupil premiums.  It can be more accurately reported in the second general download than the first.

This allocated to children who have been recorded on the local authority SSDA903 return as looked after for 1 day or more between 1 April 2018 and 31 March 2019. This excludes children whose only episode(s) of care during the year was as a result of respite, or were on remand/committed for trial or sentence and accommodated by the local authority.

Due to the FSM and service child ever aspects used to allocate elements of the pupil premium, it is possible that some schools and local authorities may not know the identity of all the children for which they are being funded. For this reason the download was introduced to help schools and local authorities identify which of their pupils are eligible for pupil premium funding.

Further information on the pupil premium is available here (a link to a GOV.UK page).

Early years pupil premium (EYPP)

This is NOT reported in the DfE CSV download.

The early years pupil premium (EYPP) was introduced in April 2015 to allocate extra funding to providers of early years education to support disadvantaged 3- and 4-year-olds.

EYPP participation data is collected from early years providers via the school census, early years census and alternative provision census to allocate the EYPP. However as the funding is allocated directly to local authorities based on the data returned via the January census (meaning providers will be able to identify all of their eligible pupils from the data they have provided to the department), and as the eligibility, payment and distribution methodology is different from the school-age pupil premium, we will not be including details of children eligible for the EYPP in the pupil premium download.

Further information on the early years pupil premium is available here (a link to a GOV.UK page).

Added 13/02/2019 at 11:05 – Report definition files

Two versions of the report definition file for DfE FSM Ever 6 at Spring Census 2019 are available from My Account.  Please select the one(s) suitable for your school phase.

The file should be extracted from the ZIP before being imported via Reports | Import.

Spring Census 2019 Update

Spring Census Day 17th January 2019.

Information and documentation.

Preparing for the school census Primary, Nursery & Special Schools

Preparing for the census Secondary Schools.

Preparing for the census Independent

Producing the School Census All Through schools.

Producing the School Census Return (English Primary and Middle deemed Primary Schools)

Producing the School Census Secondary Schools.

Producing the School Census Special School.

Producing the School Census PRU.

Producing the School Independent.

Producing the School Level Annual School Census 2019.

Census 2019 Validation Errors Resolutions

Added 24/01/2019 at 12:30 – DOA and DOL should not be during school holidays

As many of you know, giving pupils dates of admissions and/or dates of leaving during school holidays is very likely to trigger validation failures.  I have asked the DfE about this and they have confirmed that both dates of admissions and dates of leaving should be dates when the pupil could attend.

With the above, we recommend that dates of admission and dates of leaving should not be during school holidays or on staff INSET days. 

Perhaps the most important implication is that setting the leaving date for pupils to the 31st August is very inadvisable and will almost certainly trigger validation failures.

Added 18/01/2019 at 15:15 – DfE Validation Error 1000 (Pupil reconciliation does not match number of pupils on roll)

Where this validation error occurs in a secondary school because there are more students in classes than on roll, one possible explanation is that one or more students have been timetabled for different classes for the chosen census period.  Such clashes can be identified via running School | Academic Structure | Curriculum Assignment by Students and searching with Acad Status set to ‘Timetable Unresolved Clash(es)’.

Added 18/01/2019 at 11:25 – Possible misalignment of Enrolment Status and ‘history of Enrolment Status changes’

We are able to confirm that the census information being submitted to the DfE is correct.

There are a small number of instances where the front end may not reflect what is saved in the underlying database. However when a school checks the detailed history (drawn from the underlying database) this is always correct and reflects any changes made by a school/user of SIMS. Information collected for Census is obtained from the underlying database and therefore only correct information will have been/are being submitted to the DfE.

Updated 18/01/2019 at 08:30 – Spring Returns 2019 Consolidate Patch

New for version 3 (ID 24592) – Available from SOLUS 3

CES Census 2019 (Catholic Schools in England and Wales)

No further changes, but was changed by version 1 (see below).

PLASC 2019 (Maintained Schools in Wales)

No changes.

School Census Spring 2019 (State Schools in England)

Important message

If Consolidate Patch 2 has not already been applied by all schools that are subject to School Census Spring 2019, then patch 3 must be applied instead.  Please see description of Patch 2 for further details.

Additional improvement

Now displays the corrected attendance range start date for schools with more than 3 terms a year.  This was a display issue only, as attendance is included in the census for the correct dates regardless of the display issue.  We deemed the correction necessary as some schools were unwilling to go ahead with providing the return file to the DfE while this confusion in the display was present.

SLASC 2019 (Independent Schools in England)

No changes.

ISC 2019 (Independent Schools Council)

No changes

Added 17/01/2019 at 15:25 – Validation Errors and Resolutions publication

You can click here to download this publication.

Errata

Validation query 1853

This query ask schools to check that when a pupil aged 3 or 4 is eligible for early years pupil premium and is recorded as FSM on census has a reason other than ‘RE (Receipt – economic)’ or ‘RB (Receipt – economic and other)’.

Our publication suggests:-

Select Tools | Statutory Returns | School Census – Early Years Pupil Premium Receipt panel. Ensure that the correct value is selected from the Basis for EYPP Eligibility drop-down list.

When it should suggest:-

Select Routines | Statutory Returns | School Census – Early Years Pupil Premium Receipt table in Early Years panel. Ensure that the correct value is selected from the Basis for EYPP Eligibility drop-down list.

Added 17/01/2019 at 11:15 – Validation Query 564Q (concerning pirmary admissions appeals)

Some customers have been concerned with regarding receiving the message “Please check: Primary admission appeals figures should be provided and are expected to be greater than zero” when they are in the good position where there have been no primary appeals regarding admissions. The DfE have kindly responded to this concern expressed on our forums.

Melanie Armstrong (DfE)

If the school did not have any appeals they are correct to recorded ‘0’ not blank. This validation was introduced in previous years due to unreporting of admission appeals. Therefore it is correct that if they recorded ‘0’ admission appeals the query will trigger and if this is the case they just need to confirm this in the notepad.

 

Added 16/01/2019 at 11:50 – Exams Embargo

Please note that we are investigating reports that the use of ‘Exams Embargo’ is preventing access to the School Census Spring 2019 application.  I will provide an update ASAP.

Update 11/01/2019 at 18:30 – Consolidated patch 2:  Required to resolve an issue relating to School Census Spring 2019.

Important message

The Consolidate Patch 2 (patch number 24579) must be applied by all schools that are subject to School Census Spring 2019.
Once the patch has been applied schools can be confident that any data entered for the following areas are retained.

  1. Top Up Funding (all school phases)
  2. Post Looked After Arrangements (all school phases)
  3. Update Early Years (primary phase only)
  4. Class Type (primary and all through phases only)
  5. Time in Unit (PRU phase only)

This patch has been made available via SOLUS 3. The patch has also been applied for all Capita Hosted schools.

Background Information

When School Census Spring 2019 is worked on for the first time and the return is not saved prior to running Calculate All Details, data entered in the 5 areas above, via the census application or previously entered directly using Tools | Statutory Returns Tools, will not be retained on save.

In some cases, the data can be restored by accepting the option provided to copy the data from the previous census. We apologise for any re-entry of data caused by this issue.

The Consolidate Patch 2 will prevent the issue occurring so it must be applied by all schools that are subject to School Census Spring 2019.

Please note: On some of our forums this issue has been linked with our filesets. For clarification, there is no link to filesets.

Why has the problem occurred?

To meet GDPR requirements, in the Autumn Release 2018, the Save routine within census, was modified to remove data that was no longer relevant. For example, historical Top Up Funding data. Unfortunately, there is a bug in our modification of the Save routine which means that the data removal includes the data for the current census return as well as the historical data.

 

 

Updated 09/01/2019 at 15:45 – Early Years, Top-up Funding and Post Looked After Arrangements data not being reported in the Census

Please note that we are investigating reports that under certain circumstances the said data is not be reported in the Census application.

Our investigations to date indicate that the problem for Top-up Funding and Post Looked After Arrangements can be avoided and rectified without loss of data that has been entered, but we are not yet sure that this is the case for the Early Years data.

At this point, our advice for entry of Early Years data is not to spend any further time on entering such data until we have had time for further investigation.

 

Update 09/01/2019 at 11:45 – Fileset for base release of the DfE’s validation and summary report

The DfE provided suppliers with the base release of its validation and summary report (version 1.2) just before Christmas.  We have included these files in fileset 1102.  We are sorry that this base release was not available to schools until the week before the Census and we will be discussing with the DfE how such late provision can be avoided in future.

Fileset 1102 is now available from SOLUS

Added 08/01/2019 at 15:20- Fileset 1102 released to schools via Solus 3 or click here for the manual update

 

Added 03/01/2019 at 15:20 – Fileset for base release of the DfE’s validation and summary report

The DfE provided suppliers with the base release of its validation and summary report (version 1.2) just before Christmas. We will be including these files in fileset 1102, which we expect to be able to make available by the middle of next week (week beginning 07/01/2019). We are sorry that this base release will not be available to schools until the week before the Census and we will be discussing with the DfE how such late provision can be avoided in future.

We expect to be able to provide a list of the DfE changes in the near future.

 

Added 18/12/2018 at 17:30 – Validation errors 2470 (4 year olds) and 2500 (15 year olds)

Please note that although the DfE has not acknowledge any change to the coding of these two age related validation errors, we can confirm that the DfE has corrected its coding of these validation rules in its base release of the validation.  This means that validation error 2470 will no longer appear for all four year olds and validation error 2500 will no longer appear for all 15 year olds.

We are continuing to investigate the changes made for the base release of the DfE validation and will provide full details ASAP.

We are planning to include this base release of the DfE validation in fileset 1102.  Unfortunately, fileset 1102 will also need to include the base release of the DfE summary report and as this has not yet been provided to suppliers we can only state that we expect to be able to provide fileset 1102 at some point in early January.

 

Updated 21/11/2018 at 16:25 – Fileset for first Beta of the DfE’s validation and summary report

We have made the DfE’s first Beta of their validation and summary report available from SOLUS 3 and from My Account.  Please see ‘SIMS Newsfeed – Series 1101 Filesets for SIMS Autumn Release 2018’ for further details and for the link in My Account for downloading the fileset.

Since we created this fileset the DfE has made a second Beta available and we are looking into whether or not we will provide this in a subsequent fileset or wait for the baselined release from the DfE, which is due in December.

 

ATTENTION – Spring Census 2019

Connect-Up has an applied Consolidated patch 2 this was required to resolve an issue relating to School Census Spring 2019.

This means that all schools MUST create a NEW census return.

Using the dummy census and amending the details will not work as the patch requires a new return.

CES Census 2019 (Catholic Schools in England and Wales)

KB-422783 – CES Return Error 1014
KBA-451521-D0Z7M3
Question
Routines | Statutory Returns | Schools CES Census

When running the CES Catholic Return error 1014 appears: “There are pupils without a religion”.

Answer
Unfortunately this error will not show for each individual student that does not have a religion. Run the Student Detail Report and check those that have ‘-‘ entered underneath Religion. The dash means they do not have one entered into their student record.

Go to to Focus | Student | Student Details and select the required student. In Panel 8 Ethnic/Cultural ensure that the correct Religion has been entered for the student for the duration of their time at the School.

In order to check this, click the ‘History’ button in Panel 8. Double click the orange bar next to Religion and a new window will pop-up. Then, locate the student’s Religion in the list and double click the orange bar. In the Start Date field, please enter the student’s Admission Date.

In Routines | Statutory Returns | Schools CES Census click ‘Create and Validate’ to resolve the error. It is also important to check the Student Detail Report once again, as the student’s should no longer have a ‘-‘ underneath Religion.

If no students have a ‘-‘ in the report then one of the Religions used in SIMS does not have an associated category. Go to Tools | Lookups | Maintain and open Home Religion. Each lookup that is currently active must have a category as the Catholic Education Service collect these. You will need to open each lookup that does not have a category and choose the suitable one. Once amended, please save and log out of SIMS so the changes take effect.

Log back in and ‘Create & Validate’ the return. Error 1014 should be resolved.

Updated 09/01/2019 at 11:20 – Fileset 1102 includes an improvement to the pupil detail report

The improvement to the pupil detail report ensures that the totals reported take account of the changes made by patch 24483.  All improvements provided by fileset 1101, including the correct to validation error 1005, are included in this new fileset.  Similarly, all improvements provided by fileset 1102 will be including an any future fileset in the 1100 series

Fileset 1102 is now available from SOLUS 3 and as a download from My Account.  Further details and the link to the download from Fileset_1102

Updated 17/12/2018 at 09:10 – Patch 24483 to correct mistakes related to enrolment status and to the classification of Polish ethnicity

This patch provides the following improvements.s

  1. Ensures that pupil enrolments status on census reference date is obtained from the history of changes rather than enrolment status as displayed for the current date.  This can be regarded as a relatively minor bug fix, as the old and new methods are unlikely to yield a different result.
  2. Ensures that pupils with an ethnicity of Polish are counted as ‘White Other’ rather than ‘Not Known’.  This is a more significant bug fix, as there are many pupils with an ethnicity of Polish attending Catholic schools.

Patch 24483 is available from SOLUS 3.  Further details are available from the Fileset_1102

Updated 21/11/2018 at 18:30 – Validation Error 1015 (The totals of pupils by ethnicity and pupils by religion are different)

Unfortunately, there was a mistake in our first version of the validation that will trigger this error message in most schools and there are no legitimate actions for schools to take to resolve this.

Our revised version of the validation corrects this mistake and has been included in Fileset 1101, which is now available from SOLUS 3 and as a download from My Account.  Further details and the link to the download from Fileset_1102

Added 08/11/2018 at 12:40 – Census reference date

  • England: 17/01/2019 (in line with School Census Spring 2019)
  • Wales: 15/01/2019 (in line with PLASC 2019)

Times for Spring Census

Details are required of all classes running at the selected time on census day (17 January 2019). If different parts of the school use different timetable structures, then systems should allow the school to return class information for the timetable structure that applies to Key Stage 1. For example, where lunch is at 12:00 hours for pupils following a primary timetable but at 13:00 hours for pupils following a secondary timetable, then the end of morning school should be taken to be 12:00 hours and not 13:00 hours. The ‘selected time’ is based on the last digit of a school’s departmental establishment number as follows:

2, 3 or 6 – The selected time is one hour after the start of afternoon school.
4, 7, 8 or 9 – The selected time is one hour after the start of morning school.
0, 1 or 5 – The selected time is one hour before the end of morning school.

Where the selected time is not appropriate to the school timetable: where the selected time is when the whole school or a large proportion of the school is in an assembly with the head teacher; schools can choose an hour/period that reflects a ‘normal’ class situation that applies at the selected time each Thursday of the term (see paragraph 2.1). Do not record unusual situations (such as class amalgamation or school closure) which may have occurred on census day due, for example, to staff training or absence, severe weather conditions or religious observances. Any group of pupils receiving instruction outside the normal class framework at the selected time, including pupils in a SEN unit or special class, are treated as a separate ‘class as taught’ unless this is an atypical or temporary arrangement

Fileset 1102 required for Spring Census 2019

Capita has released another Fileset_1102 to address changes made by the DfE in the upcoming census on the 17th January 2019

We will Fileset_1102be  deploying this Fileset to our supported customers but please ensure you have  listed in the statutory returns area of SIMS. (Routines | Statutory Returns | School Census)

If you do not have  listed please contact  the helpdesk on 0113 2105008

SIMS Returns – School Workforce Census (England)

School Workforce Census

 

Preparing for the School Workforce Census 2018

Producing the School Worforce Census 2018 

School Workforce Census Validation Errors

 

General Useful Links

Added 06/12/2018 at 16:00 – DfE deadline for submission

Please note that the DfE deadline for submission is Friday the 7th December.

Added 08/11/2018 at 10:00 – Validaty query 4100 (quilified teacher with teacher Number missing)

The DfE has updated validation query 4100 so that it check for a missing Teacher Number when ANY of the following are present.  Previously, it only looked for the presence of QTS.

  • QTS (Qualified Teacher Status)
  • QTLS (Qualified Teacher Learning and Skills)
  • EYTS (Early Years Teacher Status)

Updated 08/11/2018 at 09:40 – Countdown (0 working days)

It’s SWC 2018 reference day today (08/11/2018).

Added 11/10/2018 at 11:00 – Staff shared between schools

Following questions from customers, I asked the DfE what they recommend for schools to enter into their IMS for staff that are shared between schools and they have suggested reading throught section 4.7 of their ‘Schol Workforce Census 2018 Guide for schools including acemies within a Multi Academy Trust’.

4.7. Multiple records

More than one record for an individual member of the school workforce would be returned in the school workforce census in the following instances:

• when a person is in regular service at more than one school, either via a contract or, for teachers, employed under a service agreement. For example a teacher who works two days a week in one school and three in another would need more than one record. Both schools would be expected to submit a record that reflects the time spent by the teacher in their school

• when a person, teacher or support staff, ceases working at one school and begins working at another school during the period covered by the census (1 September 2017 to 8 November 2018). Both schools would be expected to submit a record that reflects the time spent in their school during that period

• A school or local authority may need to submit information for a member of staff for more than one contract, or period of employment under a service agreement, in the school workforce census. This would happen when

o they have more than one current contract, or are engaged to work at the school under more than one service agreement, at the Census day in one school. For example they have one part-time contract with the school as a midday supervisor and another part-time contract as an administrator, or

o they have one current contract, or are engaged to work at the school under a service agreement, at the Census Reference Date and finished another period of regular service in the previous academic year. For example, they were promoted on 1 January 2018 from deputy head teacher to head teacher and so both the old deputy head teacher contract and the current head teacher contract would be returned

In these cases there should be two contract or service agreements recorded for that school workforce member. There should never be two school workforce member records for the same individual in one return.

Added 16/07/2018 at 10:20 – Publications Documents

Please note that links to the relevant Publications documents are avaialble from the ‘SIMS Returns – School Workforce Census (England)‘ Hot Topic.

Added 04/05/2018 at 10:55 – Overview Presentation v1.1

Please note that version 1.1 of the overview presentation is available as a ZIP from School_Workforce_Census_2018_Overview_pptx

Version 1.1: Improved screenshots and explanations
Version 1.0: First version for customers.

CTF 18 (England and Wales) and CME files (England only)

Items related to the CTF import contact issue are excluded from the newsfeed, as specific information for that area is available from our CTF 17/18 Contact Issue newsfeed

 

Updated 20/09/2018 at 10:45 – Service child concerns (England only) – Patches Available

The Summer release added a grid for Service Children Concerns to the Addition Information panel of Pupil Details to allow schools to record concerns that the current school or previous school had regarding a child with a parent serving in the Armed Forces. The Concerns are held completely separately to the Service Children in Education flag, as it is quite possible for a pupil to have been a service child in the past but for them to no longer be a service child. If a record exists indicating a concern for an earlier date, it might be sensible for a school to add a record for a later date to indicate ‘no concerns’ on that date. It might also be sensible to enter a ‘no concern record’ when a pupil is currently a service child. However, it is not advisable to add ‘no concerns’ records for pupils who are not currently and have not previously been a service child, as this might be taken to indicate that they were previous a service child with a concern.

CTF 18 was updated to include the export and import of the Service Children Concerns but unfortunately there is an issue with our CTF 18 Export routine that results in ‘no concern’ records being added to the file when the Service Children Concerns table is blank. On import these become ‘no concern’ records for pupils who may never have been service children.  Two patches are available to support units on SOLUS 3 to deal with this issue.

  1. Patch 24298 corrects the coding mistake in CTF 18 Export so that ‘no concern’ is only included in the CTF file when ‘no concern’ has been entered by the exporting school.  This patch does not change CTF 18 Import, as there is no way for the software to distinguish between ‘no concerns’ included because of our mistake and the inclusion of legitimate ‘no concerns’.
  2. Patch 24313 removes any ‘no concerns’ records that are found in SIMS where a record does not also exist indicating an actual ‘concern’.

The Service Children Concerns are not included in information sent to the DfE in the School & Pupil Census returns.

Added 04/09/2018 at 12:40 – CME files for leavers (England only)

Some schools are concerned that they forgot to use CTF functionality to provide CME (Children Missing Education) files to their LA for pupils who left the school at the end of the academic year.  Although this may well be an issue for some of the schools in this position, it is also possible that this is not an issue.  There are two possible reasons why this may not be an issue.

  1. The government legislation for CME only insists on information being provided outside of normal phase transfers and many of the pupils who left the school at the end of the year may will have been for a normal phase transfer, e.g. leaving a primary school at the end of year 6 to join a secondary school for the start of year 7.  However, some LAs will always ask for the CME leavers information as end of phase transfer can be difficult to define, e.g. LAs with tradition independent schools may have pupils transferring from prep school to pupil schools at age 14.
  2. The government legislation for CME only insist on the information being provided and CTF is just one of several ways in which such information can be provided, e.g. some LAs provide a website for entering the necessary information.

Added 03/09/2018 at 17:15 – ULN and URN

On the 1st August the CTF version moved on by one year as normal. This means that CTF Export will provide CTF 18 format files, rather than CTF 17 format files, and CTF Import will accept CTF 17 and 18 format files, rather than CTF 16 and 17 format files. The main impact of introducing the CTF 18 format files is that the school’s URN (Unique Reference Number) is mandatory, in addition to the school’s Establishment Number (LA number + school number).

We understand that the CTF files provided via S2S for adding ULN (Unique Learner Number) for learners is still in CTF 16 format, that is no longer supported for CTF Import. The DfE will be dealing with this matter shortly, but for the moment we must caution against making manual changes to the file names and content of CTF files to ‘trick’ CTF Import into accepting them, as the formats for CTF 16 and CTF 18 are not compatible.

Added 02/08/2018 at 18:00 – The CTF 17 newsfeed will be maintained beyond it normal closure date of 1st  August

As you know, for all schools that have upgraded to the SIMS 7 Summer Release 2018, CTF Export will use the format for CTF 18 instead of CTF 17 from the 1st August.  My normal procedure would be to reflect this in the My Account notification area by making the newsfeed for CTF 17 unavailable.  However, this year I will leave the newsfeed for CTF 17 available so that all items related to our problem with CTF import of contact data is kept available from a single newsfeed.

I have added a link from this newsfeed to the CTF 17 newsfeed and I have also added a link from the CTF 17 newsfeed to this newsfeed.

Added 23/03/2018 at 12:10 – Change Requests 

After the Easter break my colleagues and I will be going through the change requests logged by customers to help decide what improvements would should be making in the future.  With that in mind I recommend you view existing change requests for CTF and add votes and new items to ensure that your wishes are taking into account.  I have outlined below some the methods I have found helpful for viewing and updating the change request for CTF.

Viewing CTF Change Requests

  1. Go to the My Account home page and click on Customer Services | View Change Requests.
  2. Select ‘CTF (Excluding NI)’ as the Product and add further filters as necessary before clicking on Search.
  3. Browse the existing change request and click on any where you want to Agree or Disagree.

Adding CTF Change Requests

  1. Either click the Change Request button in View Change Requests or go the My Account home page and click on Customer Services | Log a Change Request
  2. Make sure that you select ‘CTF (Excluding NI)’ as the Product and fill in the remaining fields as necessary.
  3. If you have any particular opinion as to whether your request should be looked at for SIMS 7 only or SIMS Primary only, you should ensure that you mention this in the description of the request.  If you don’t specify SIMS 7 or SIMS Primary we will take it that you are requesting for both.

 

Added 22/03/2018 at 09:00 – Overview Presentation

Please note that version 1.0 of the CTF 18 Overview presentation is available as a ZIP from My Account.  Most of the content of this presentation will be relevant to England only, as the WG has decided that the new items will not apply to school in Wales.

Sims Autumn Update 2018

 

 

26/11/2018 – Three Patches to delete data no longer collected by DfE Census
Given the recent position of the DfE no longer collecting Proficient in English (1.4.3.2), Pupil Country of Birth (1.4.3.3) and Pupil Nationality (1.4.3.4), full details available here: https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/720748/2018-19_School_Census_Business_and_Technical_Specifications_Version-v1.1.pdf Capita SIMS have release the following three patches in SOLUS3 to delete this data:

  • Patch 24423 – Deletes all records for Proficiency in English information for all past, present and future students. Where a student has multiple proficiency entries, the patch will remove all instances of this.
  • Patch 24433 – Deletes the National Identity for all past, present and future students.
  • Patch 24372 – Deletes the Country of Birth and where present the Nationality (actually called Nation inside the expanded Nationality and Passport Details record, only where passport details are blank) for all past, present and future students

01/11/2018 – SIMS Autumn 2018 Release Now Available
We are pleased to announce that the SIMS Autumn suite of software will be made available to customers by throughout today.  All the release notes have been published Click Here

School Census Autumn 2018

Publications

Preparing for the School Primary, Nursery, Special Phase

Preparing for the School Secondary Phase

Producing the School Census Nursery

Producing the School Census Middle-Primary

Producing the School Census English Secondary – PRUS – Post 16

Producing the School Census Special Phase

Producing the School Census all through

Validation Errors and Resolutions 2018-19 7.182

 

Generally Useful Links

 

 

 

Added 11/10/2018 at 12:40 DfE Validation Query 1767Q (Due to FSM protection we would not expect FSM periods to have an end date. Please provide a reason.)

The following excerpt from the lates DfE Update explains why some schools are receiving many incidents of validation query 1767Q.  It also describes the exception to the general rule regarding the exclusion FSM eligibility end date.  It is the exception form the general rule that prevented us from ignoring any end dates that have been entered by schools.

1767q – FSM end dates

5. We currently have a large number of occurrences of 1767q which triggers when an FSM end date is provided for a period of eligibility.

6. Following the introduction of the universal credit, any pupil who was eligible for FSM as at 31 March 2018 or became eligible after that date has protected status and will retain the eligibility until at least the end of summer 2023 and should continue to receive a free meal regardless of how a family’s circumstances might have changes. Please note: the protection is awarded to the individual child. If they move to live with another family member or is fostered or taken into their they will retain their protection.

7. At the end of summer 2023 the pupil will retain their FSM protection until they change phase of education. Therefore we would not expect fsm end dates to be provided for the majority of periods.

8. The only circumstances where an FSM end date should be provided are:

– A parent is aware of the protection but has stated that they do not wish their child to be recorded as fsm eligible.
– The parent qualified through support under the Immigration & Asylum Act 1999 or the guaranteed element of the pension credit and this has ended.

If either of the above apply, please provide a notepad explanation to this effect and the query will be ok’d. If none of the above apply, the fsm end date should be removed to resolve the query.

9. Please check for any occurrences of this query on your return(s) and amend as necessary.

Updated 09/10/2018 at 18:40 Possible problem with enrolment status history

We are investigating reports from several schools that statutory returns are reporting the wrong Enrolment Status for pupils where there have been changes to Enrolment Status.  We have not completed our investigations, but we think it is worth schools checking the reporting of Enrolment Status in the Census where Enrolment Status has been changed via menu route Routines | Pupil | Enrolment Status. (or for PRUs via the old menu route Tools | Statutory Returns | Update Provide Status).  If such problems have arisen where schools have changed between Enrolment Statuses indicated Guest and on roll, it would be possible for the return to ignore a pupil where it believes the student to be a Guest. A similar situation could arise if a pupil changes from/to Dual Subsidiary.

The problem described above is unlikely to be detected by the DfE validation.  We therefore strongly recommend that the reporting of Enrolment Status in School Census Autumn 2018 is checked for every pupil where Enrolment Status has been changed.  The feedback we have received from schools still suggests a very small scale problem with the data, but we are monitoring new cases to ensure that we get a full picture of the scale of the problem.

Added 08/10/2018 at 18:10 Validation error 1920 for sponsor-led academies that converted from schools

As you probably know, where our Census application detects that an academy was allocated a new Establishment Number when converting from a school, e.g. conversion from a school to a sponsor-led academy, we ensure that the DOA for each pupil is no earlier than the first date a pupil could attend the academy.  We now understand that there is an exception to this general rule, in that where a learning activity is reported that took place at the school that has been replaced, the DOA should be the DOA from the school that has been replaced regardless of when the Establishment Number changed.  Failure to take account of this exception will trigger validation error 1920 and the DfE will NOT accept a note on COLLECT to explain this.

We are looking into how we can help schools to deal with this situation.

Updated 09/10/2018 at 11:05 Possible problem with enrolment status history

We have received reports from a handful of schools that the Census is reporting the wrong Enrolment Status for pupils where multiple changes to Enrolment Status have taken place.  We have not yet had time to investigate this, but we think it is worth schools checking the reporting of Enrolment Status in the Census for pupils where they have made multiple changes to Enrolment Status.  If such problems have arisen where schools have changed between Enrolment Statuses indicated Guest and on roll, it would be possible for the Census to ignore a pupil where it believes the pupil to be a Guest.

This is probably a very small scale problem, but it is best to check where changes to Enrolment Statuses have taken place.

Added 11/10/2018 at 12:40 DfE Validation Query 1767Q (Due to FSM protection we would not expect FSM periods to have an end date. Please provide a reason.)

The following excerpt from the lates DfE Update explains why some schools are receiving many incidents of validation query 1767Q.  It also describes the exception to the general rule regarding the exclusion FSM eligibility end date.  It is the exception form the general rule that prevented us from ignoring any end dates that have been entered by schools.

1767q – FSM end dates

5. We currently have a large number of occurrences of 1767q which triggers when an FSM end date is provided for a period of eligibility.

6. Following the introduction of the universal credit, any pupil who was eligible for FSM as at 31 March 2018 or became eligible after that date has protected status and will retain the eligibility until at least the end of summer 2023 and should continue to receive a free meal regardless of how a family’s circumstances might have changes. Please note: the protection is awarded to the individual child. If they move to live with another family member or is fostered or taken into their they will retain their protection.

7. At the end of summer 2023 the pupil will retain their FSM protection until they change phase of education. Therefore we would not expect fsm end dates to be provided for the majority of periods.

8. The only circumstances where an FSM end date should be provided are:

– A parent is aware of the protection but has stated that they do not wish their child to be recorded as fsm eligible.
– The parent qualified through support under the Immigration & Asylum Act 1999 or the guaranteed element of the pension credit and this has ended.

If either of the above apply, please provide a notepad explanation to this effect and the query will be ok’d. If none of the above apply, the fsm end date should be removed to resolve the query.

9. Please check for any occurrences of this query on your return(s) and amend as necessary.

Updated 09/10/2018 at 18:40 Possible problem with enrolment status history

We are investigating reports from several schools that statutory returns are reporting the wrong Enrolment Status for pupils where there have been changes to Enrolment Status.  We have not completed our investigations, but we think it is worth schools checking the reporting of Enrolment Status in the Census where Enrolment Status has been changed via menu route Routines | Pupil | Enrolment Status. (or for PRUs via the old menu route Tools | Statutory Returns | Update Provide Status).  If such problems have arisen where schools have changed between Enrolment Statuses indicated Guest and on roll, it would be possible for the return to ignore a pupil where it believes the student to be a Guest. A similar situation could arise if a pupil changes from/to Dual Subsidiary.

The problem described above is unlikely to be detected by the DfE validation.  We therefore strongly recommend that the reporting of Enrolment Status in School Census Autumn 2018 is checked for every pupil where Enrolment Status has been changed.  The feedback we have received from schools still suggests a very small scale problem with the data, but we are monitoring new cases to ensure that we get a full picture of the scale of the problem.

Added 08/10/2018 at 18:10 Validation error 1920 for sponsor-led academies that converted from schools

As you probably know, where our Census application detects that an academy was allocated a new Establishment Number when converting from a school, e.g. conversion from a school to a sponsor-led academy, we ensure that the DOA for each pupil is no earlier than the first date a pupil could attend the academy.  We now understand that there is an exception to this general rule, in that where a learning activity is reported that took place at the school that has been replaced, the DOA should be the DOA from the school that has been replaced regardless of when the Establishment Number changed.  Failure to take account of this exception will trigger validation error 1920 and the DfE will NOT accept a note on COLLECT to explain this.

We are looking into how we can help schools to deal with this situation.

Updated 09/10/2018 at 11:05 Possible problem with enrolment status history

We have received reports from a handful of schools that the Census is reporting the wrong Enrolment Status for pupils where multiple changes to Enrolment Status have taken place.  We have not yet had time to investigate this, but we think it is worth schools checking the reporting of Enrolment Status in the Census for pupils where they have made multiple changes to Enrolment Status.  If such problems have arisen where schools have changed between Enrolment Statuses indicated Guest and on roll, it would be possible for the Census to ignore a pupil where it believes the pupil to be a Guest.

This is probably a very small scale problem, but it is best to check where changes to Enrolment Statuses have taken place.

Added 05/10/2018 at 15:40 Possible problem with enrolment status history

We have received reports from a handful of schools that the Census is reporting the wrong Enrolment Status for pupils where multiple changes to Enrolment Status have taken place on the same day.  We have not yet had time to investigate this, but we think it is worth schools checking the reporting of Enrolment Status in the Census for pupils where they have made multiple changes to Enrolment Status on the same day.  If such problems have arisen where schools have changed between Enrolment Statuses indicated Guest and on roll, it would be possible for the Census to ignore a pupil where it believes the pupil to be a Guest.

This is probably a very small scale problem, but it is best to check where changes to Enrolment Statuses have taken place.

Updated 05/10/2018 at 14:35 Multi-year learning aims (of interest to schools with sixth forms)

As many of you will know, school timetables are the main determinants of course lists and class memberships are the main determinants of course memberships. Both school timetables and class memberships are normally based on single academic years, so our course management functionality provides additional facilities to deal with courses for two or more years. These additional facilities include allowing the duration to be set to 2 weeks, 2-24 weeks, one year, two years, three years, four years or five years. They also include allowing the completion tolerance to be set to none, 1 day, 2 days, 3 days, 4 days, 1 week, 2 weeks, 3 weeks, 1 month, 2 months or 3 months.

For example, if duration is set to 2 years for a course membership that started on the 05/09/2016 the Expected End Date will be calculated to be the 31/07/2018 (the last possible day for academic year 2017/18) and School Census Autumn 2016 and 2017 will have reported the student’s learning aim Start Date as 05/09/2016 and Expected End Date as 31/07/2018. If the student completed the learning aim on 22/06/2018 and completion tolerance is set to 2 months, School Census Autumn 2018 will report the student’s learning aim Start Date as 05/09/2016, an Expected End Date of the 31/07/2018 and an Actual End Date of 22/06/2018. We believe that all these dates are fine from a DfE point of view, as the Start and Expected End Date do not change during the three Autumn Censuses where the student’s learning aim is reported and the Actual End Date is only reported when the Actual End Date has occurred (i.e. not in the future) *1

However, now that two year courses have become so general for schools we are looking into going a bit further in helping schools with this aspect of School Census Autumn. As things stand schools are likely to have to enter a Status of ‘Completed’ manually in the Census application for multiple year learning aims that have been completed. In the example above the school would need to enter a status of ‘Completed’ for School Census Autumn 2018. Although we have provided a bulk update facility in our Census application to help schools to set the appropriate learning aims status, we are now also looking into providing a patch to default the learning aim status to the most likely status.

If we are able to provide such a patch it will be released as part of consolidated patch 3.

*1 It is important to leave Status blank (even if it has a yellow background) in Maintain Course where an Actual End Date is included for the future. If a school does not leave the Status blank when the date is for the future and before the Expected End Date, the school will not be allowed to save.

 

Added 28/09/2018 at 16:30 Census Consolidated Patch V2 & Fileset 1006 are available

Census Consolidated Patch v2 for Summer Release 2018 (patch 24330) is necessary to correct the issue in the SIMS application for schools receiving error 1992 when running School Census. This error is incorrectly produced when a yr 12/13 student has left the school during the 2018/2019 academic year prior to the Census date even though hours are present.

Import of Fileset 1006 to provide version 1.4 of the DfE validation is necessary to correct the mistake in the DfE validation.

Added 25/09/2018 at 10:15 – Dealing with validation error 2712 in a school with a sixth form

Unfortunately, there are two actions necessary for dealing with validation error 2712.

  1. Application of ‘Census Consolidated Patch v1 for Summer Release 2018’ (patch 24323) is necessary to correct the mistake in the SIMS application.
  2. Import of Fileset 1006 to provide version 1.4 of the DfE validation is necessary to correct the mistake in the DfE validation.

We expect that both of the above will be available before the end of the week.

Added 24/09/2018 at 17:10 – Fileset 1006

The DfE has decided that version 1.3 will not be their final version of their validation file, as their new validation error 2712 is reporting ‘Full-time employment indicator is missing or invalid’ for all students with learning aims and not just those students with learning aims where ‘true’ or ‘false’ is missing for ‘full-time employment’.  The DfE COLLECT validation will report this error as intended and the DfE school validation will be corrected via version 1.4 so that it also reports this error as intended.

We will provide version 1.4 of the DfE validation via Fileset 1006 as soon as possible after the DfE issues this new version to suppliers.

I apologise for the confusing position that has arisen for school with sixth forms as I result of a bug in our software and a separate bug in the DfE validation file regarding reporting of ‘full-time employment’.

Updated 24/09/2018 at 14:45 – Post-16 employment and validation error 2712 (patch 24323)

As you probably know, our school census application determines whether or not a post-16 student is in full time employment or not by checking the Post-16 Employment grid in the Additional Information panel of Focus | Student | Student Details.  Where there is a current record of ’employment in school hours that is beyond 20 hours per week’, the student is in full time employment, otherwise they are not.  Where the software has determined that a post-16 student is in full time employment, our school census application is correctly reporting this as ‘true’.  However, where we should be reporting full time employment as ‘false’, we have incorrectly applied the ‘no date no tag’ rule.  This mistake on our part has not previously been noticed, but the new 2712 validation rule introduced in version 1.3 of the DfE validation, detects this as an error for each student with one or more learning aims that is not in full time employment, i.e. nearly all post-16 students.

The ‘Census Consolidated Patch v1 for Summer Release 2018’ (patch 24323) is being developed to correct this mistake, so that ‘false’ will be report in the return file for post-16 students who are not in full time employment.  We expect to be able to make this patch available to support units via SOLUS 3 before the end of the wee

Added 20/09/2018 at 16:35 – Eligibility for FSM

School Census Autumn 2018 reports on eligibility for FSM records that were current at any point during the period 18/05/2018 (the day after the School Census Summer reference date) to the 04/10/2018 (the School Census Autumn reference date), inclusive.  Protection of Eligibility for FSM came into force on the 01/04/2018.  This means that the DfE will expect no more than one Eligibility for FSM (in England) record per pupil and for that record to have a start date, but no end date.  The Census application will not report an Eligibility for FSM End Date, even if a school has added one, but good advice is not to even attempt to add an End Date, as there are far too many variables to take into account.  For example, the government might change its mind and keep the protection for early or later than 2022.  Moreover, even if the government keep to this 2022 protection date, individual pupil might receive protect for a considerably longer period.  A pupil who 5 years old on the 31/07/2018 would be 9 years old in 2012, but would continue to have protection until they are 11 years or older on the 31st July.

We believe that the problem for schools will be dealing with pupils who have joined from a previous school and a CTF from a previous school has not been imported.  Under those circumstances a school may want to make use of the ECS (Eligibility Checking Service), but this service has not yet been modified to take account of Eligibility for FSM protection.  ECS may indicate that the pupil who has joined the school would not be eligible for FSM if they applied on the date of the check, but that does not mean that they weren’t eligible when they applied early and still eligible because of the protection.  We think that this is unlikely to be a major issue for this Census, but may become a serious issue if the ECS continues to be unaware of the protection.

Added 20/09/2018 at 14:55 – Fileset 1005

Please note that the DfE did not send version 1.2 of their validation file to MIS suppliers, as problems were found by suppliers that required further fixing.  However, we have received version 1.3 and will be including this new version in Fileset 1005.  There should be no problem with updating to Fileset_1005 from Fileset 1003 or from Fileset 1004.

We have made Fileset 1005 available to Schools from SOLUS 3 and as a download from Fileset_1005.

The DfE has indicated that version 1.3 of their validation file includes the following improvements to errors/queries compared to version 1.1.

The DfE has told suppliers that version 1.3 of their school validation file will be the last version they make available for School Census Autumn 2018.  This means that once Fileset 1005 has been applied by a school, no further Filesets in the 1000 series will be necessary for School Census Autumn 2018.  Any further problem with the DfE validation will be dealt with via a DfE known issues list and, in some cases, by an improvement to the COLLECT validation.

Error/Query
Number

DfE Description of Change

1925 Bugfix, age calculation incorrect
2005 Update to error messages
2502 Bugfix, incorrectly nested criteria
2712 Rule added
3080 Update to error messages
3090 Update to error messages

Updated 17/09/2018 at 15:15 – Date of admission

As you know, we recommend that pupils are admitted on the first day they can attend the school and not on an earlier date that might have been defined as the start of the academic year but is not a day a pupil could attend the school, e.g. a holiday or a staff training day.  Failure to follow this advice can lead to DfE validation problems for School Census.  We believe that the following excerpt from the DfE School attendance Guidance for maintained schools, academies, independent schools and local authorities is in line with this recommendation.

..

Expected First Day of Attendance

Schools must enter pupils on the admission register and attendance register from the beginning of the first day on which the school has agreed, or been notified, that the pupil will attend the school. …

 

Updated 14/09/2018 at 13:10 – Fileset 1004 (Available)

Please note that, as you will have gathered from the item posted on the 10th September, version 1.1 will not be the final version of the DfE validation.  The DfE expects to be able to provide version 1.2 in the near future, but has not given us a firm date.  With the lack of a firm date in mind, we are considering going ahead with Fileset 1004 to deliver version 1.1 of the DfE validation, although this would be followed up by Fileset 1005 to deliver what the DfE hope to be their final version.

The DfE has provided suppliers with version 1.1 of their validation file and we made this available to schools from SOLUS 3 and as a download Fileset_1004

The DfE has indicated that version 1.1 of the validation file includes the following improvements to errors/queries compared to version 1.0.

Error/Query
Number

DfE Description of Change

1550 Error message updated
1700 Error message updated
1885 Error message updated
1970 No longer requires specific school types for intake ‘SPEC’
2002 Fixed bug where NC years E1, E2, N1, N2 was not handled correctly
2115 Error deleted
2190 Error message updated
2210 Error message updated
2706 Fixed typo and updated validation
2707 Fixed typo and updated validation
2708 Now called from Pupil Status module rather than Learning Aims module. Which fixes the case where no learning aims are supplied for a pupil

Updated 10/09/2018 at 15:15 – DfE Validation

Please note that we have contacted the DfE to let them know that the validation messages the following errors/queries are not in line with their validation specification.  The DfE have acknowledged our message are their technical people are looking into this.

Sequence DfE Current Message DfE Specified Message
1741 Based on Ministry of Defence criteria, service children (ie parents designated as personnel category 1 or 2) are not eligible for free school meals. Based on Ministry of Defence criteria, Service Children (parents designated as personnel category 1 or 2) are not eligible for free school meals
3080Q Please check: take up of school lunches for pupils in reception (plus pupils aged 4 in year X) is 50% or fewer. A reason must be provided why fewer than 50% of reception pupils took a school lunch on census day. Please check: Take up of school lunches for pupils in reception (plus pupils aged 4 in year ‘X’) is 50% or fewer. A reason must be provided why fewer than 50% of reception pupils took a school lunch on census day
3085Q check: take up of school lunches for pupils in year 1 (plus pupils aged 5 in year X) is 50% or fewer. A reason must be provided why fewer than 50% of pupils in year 1 took a school lunch on census day. Please check: Take up of school lunches for pupils in year 1 (plus pupils aged 5 in year ‘X’) is 50% or fewer.  A reason must be provided why fewer  than 50% of pupils in year 1 took a school lunch on census day
3090Q check: take up of school lunches for pupils in year 2 (plus pupils aged 6 in year X) is 50% or fewer. A reason must be provided why fewer than 50% of pupils in year 2 took a school lunch on census day. Please check: Take up of school lunches for pupils in year 2 (plus pupils aged 6 in year ‘X’) is 50% or fewer.  A reason must be provided why fewer than 50% of pupils in year 2 took a school lunch on census day

 

Updated 10/09/2018 at 09:15 – Overview Presentation v2.4

Please note that version 2.4 of the School Census Autumn 2018 Overview presentation is available as a ZIP from My Account.

  • Version 2.4: Version number displayed in top right hand corner of first slide only and a slide on Filesets added to Section 2
  • Version 2.3: Slides on Enrolment Status revised and Content slide added
  • Version 2.2: Cosmetic improvements
  • Version 2.1: DfE ‘messages’ added for validations
  • Version 2.0: Major revisions to reflect DfE removal of AP placements and migration related fields
  • Version 1.1: SIMS 7 screenshots added
  • Version 1.0: First version for customers

Added 30/08/2018 at 14:40 – Fileset 1003 

This Fileset is available to support units from SOLUS 3 and as a download from Fileset_1004 and includes the baseline DfE validation and summer report files.

Added 03/08/2018 at 11:50 – Fileset 1002 should be available today

Filset 1002 will be the same as Fileset 1001 except that it inscludes the correct files for use with PI reporting.

We expect the new fileset to be available before the end of the day.

Added 31/07/2018 at 11:45 – Fileset 1001 withdrawn

Unfortunately, Fileset 1001 has been withdrawn as it includes a file that causes a problem for one of the reports in Exams PI.

We will provided Fileset 1002 with the same content as Fileset 1001 except that the correct file for the Exams PI report will be included

Added 13/07/2018 at 11:00 – Publications Documents

Please note that links to the relevant Publications documents are avaialble from the ‘SIMS Returns – School Census‘ Hot Topic.

Added 06/07/2018 at 11:10 – DfE Validation and Summary Report

Unfortunately, the DfE Beta of their validation and summary report files was not supplied to us in time for inclusion in the SIMS 7 Summer Release 2018.  However, we are working on Fileset 1001, which will include the DfE Beta files.  Early next week, I will update this newsfeed with an expected release date for this fileset.

 

Added 15/06/2018 at 16:45 – Enrolment Status for PRUs

From the SIMS 7 Summer Release 2018 changing of Enrolment Status for PRUs will take place in just one area as it does for non-PRU schools, i.e. Routines | Pupil | Change Enrolment Status.  However, PRUs will be apple to choose ‘FE College’ and ‘Other Provider’, in addition to the Enrolments Statuses available to non-PRUs.

PRUs

  • Single Registration
  • Guest Pupil
  • Main – Dual Registration
  • Subsidiary – Dual Registration
  • FE College
  • Other Provider

Non-PRUs

  • Single Registration
  • Guest Pupil
  • Main – Dual Registration
  • Subsidiary – Dual Registration

Updated 30/05/2018 at 14:10 – Overview Presentation v2.3

Please note that version 2.3 of the School Census Autumn 2018 Overview presentation is available as a ZIP from My Account.

  • Version 2.3: Slides on Enrolment Status revised and Content slide added
  • Version 2.2: cosmetic improvements
  • Version 2.1: DfE ‘messages’ added for validations
  • Version 2.0: Major revisions to reflect DfE removal of AP placements and migration related fields
  • Version 1.1: SIMS 7 screenshots added
  • Version 1.0: First version for customers

Updated 24/04/2018 at 11:05 – Nationality and Country of Birth

Please note that Nationality and Country of Birth will be included in School Census for the last time in School Census Summer 2018 and will not be included in School Census Autumn 2018

We have agreed with the DfE the following way forward.

  1. Remove the tags and data from School Census 2018/19 return xml files.
  2. Remove the columns for this data from our School Census 2018/19 detail reports.
  3. Keep the existing functionality for recording this data in place.
  4. Ensure in a future release that this data can be completely removed to satisfy any GDPR requirements.
  5. Stay in line with the DfE specifications for CTF 18 so that this data is automatically exported and imported, but in a future release allow a school choice regarding import of this data.

The DfE has not yet made its final decision regarding inclusion of Proficiency in English for the Spring Census.

Updated 24/04/2018 at 10:10 – 9 Alternative Provision Placement Items

The DfE have informed us that the following data items are being removed from the baselined specification for School Census 2018/19.

  • Date of entry to the alternative provision placement
  • Primary reason for the alternative provision placement
  • URN for the alternative provision placement
  • UKPRN for the alternative provision placement
  • Type of setting for the alternative provision placement
  • Association for the alternative provision placement
  • Attendance pattern for the alternative provision placement
  • Sessions per week for the alternative provision placement
  • Date of leaving for the alternative provision placement

The DfE have no current plans for these items to be included in a future School Census.

We have agreed with the DfE the following way forward.

  1. Leave our new Alternative Provision data entry and storage functionality in place for the SIMS 7 Summer Release 2018, but with no further development.  This functionality may be removed for a future release, once we have had time to gauge its usefulness to customers
  2. Include this data in the XML Return file where it has been entered by schools, on the understanding that it will be deleted by the DfE on upload to COLLECT.
  3. The DfE to remove the 17 validation rules relating to these data items.
  4. The DfE to remove the reporting of these data item from its summary report.

If a school is considering making use of the Alternative Provision Placements functionality, they should take into account the following guidance from the DfE.

There is no requirement from the department for this data to be collected or held with school management information systems.

Should schools decide to collect, process or retain data on alternative provision placements for their own purposes, a lawful basis for this processing must be identified by the school, as outlined in the GDPR articles 6 and 9. See the link below for further guidance from the ICO concerning lawful bases for processing:

https://ico.org.uk/for-organisations/guide-to-the-general-data-protection-regulation-gdpr/lawful-basis-for-processing/#ib3

  • Added 06/04/2018 at 17:20 – EYPPE renamed EYPPR 

The DfE has acknowledge that, at the point that they collect EYPP data in the Census, the EYPP funding has already been allocated to schools.  With this in mind, the DfE has changed the current EYPPE (Early Years Pupil Premium Eligibility) label to EYPPR (Early Years Pupil Premium Received).

The DfE does not expect this to change the two year old’s reported for this field, but it should avoid some confusion.  The reporting of the Reason for Eligibility in the Census will continue as previously.

Added 05/04/2018 at 14:50 – Waste of Resources 

Please note that we have informed the DfE of the quite large amount of resources we have wasted in providing functionality for the dozen items the DfE is removing from their specification.  Those resource could have been spent on enhancing other aspects of SIMS to benefit customers.  We have asked for an agenda item at the next DfE suppliers meeting where we can look at how we can ensure that this doesn’t happen again.

Added 05/04/2018 at 11:00 – 9 Alternative Provision Placement Items 

The DfE have informed us that the following data items are being removed from the baselined specification for School Census 2018/19.

  • Date of entry to the alternative provision placement
  • Primary reason for the alternative provision placement
  • URN for the alternative provision placement
  • UKPRN for the alternative provision placement
  • Type of setting for the alternative provision placement
  • Association for the alternative provision placement
  • Attendance pattern for the alternative provision placement
  • Sessions per week for the alternative provision placement
  • Date of leaving for the alternative provision placement

The DfE have no current plans for these items to be included in a future School Census.

We have agreed with the DfE the following way forward.

  1. Leave our new Alternative Provision data entry and storage functionality in place for the SIMS 7 Summer Release 2018, but with no further development.  This functionality may be removed for a future release, once we have had time to gauge its usefulness to customers
  2. Include this data in the XML Return file where it has been entered by schools, on the understanding that it will be deleted by the DfE on upload to COLLECT.
  3. The DfE to remove the 17 validation rules relating to these data items.
  4. The DfE to remove the reporting of these data item from its summary report.

Added 26/03/2018 at 18:30 – Significant Changes to the DfE Specification 

The DfE has contacted suppliers to warn us of significant changes to the baselined specification for School Census in 2018/19. With this in mind I have withdrawn my School Census Autumn 2018 Overview presentation. Some of you will know that we expected some late changes to the DfE specification, but we now understand that these changes are likely to be more extensive than we expected. We should be able to provide more details of the changes next week.

Added 22/03/2018 at 20:35 – Attendance Code ‘E’  

This is just a reminder that the DfE definition of Attendance Code ‘E’ is ‘Authorised absence as pupil is excluded, with no alternative provision made’ and therefore should not be used for sessions where an alternative provision has been arranged for the pupil.

Added 30/01/2018 at 12:00 – UAT (User Acceptance Testing) Workshop for School Census Autumn 2018 and SWC (School Workforce Census) 2018 

Our UAT workshop will take place in our Bedford office on Wednesday the 2nd May, starting at 10am in the morning and finishing around 3pm in the afternoon.  This workshops provides customers with an opportunity to test the changes we have made to the software for School Census Autumn 2018 and SWC 2018 and is not a suitable event for colleagues who need general training in these areas.

You can apply to take part in the workshop via My Account.  We recommend early application as places at the event are likely to be taken up quickly.

Added 19/12/2017 at 14:25 – Post-16 Learning Aims 

The following is not a change to the specification for Learning Aims, but you may find it helpful to know that there will be an amendment to the QN list to take account of the following ‘bands’ of technical level work placements.

   Substantial work placement    Number of hours in placement 
   Band 1    315 to 329
   Band 2    330 to 344
   Band 3    345 to 359
   Band 4    360 to 374
   Band 5    375 to 389
   Band 6    390 to 404
   Band 7    405 to 419
   Band 8    420 to 434
   Band 9    435 to 449
   Band 10    450 to 464
   Band 11    465 to 479
   Band 12    480 to 494
   Band 13    495 plus

Added 19/12/2017 at 14:00 – Service Child indicator 

From School Census Autumn 2018 onwards, Service Child indicator will be collected in all three School Censuses each year, rather then just in School Census Spring.

Added 19/12/2017 at 13:55 – Special Educational Needs (SEN) Status (DfE refer to this as SEN Provision) 

The SEN Status of “Statement” (code “S”) has been removed, as it is discontinued from the 1st April 2018.

 

Updated 22/11/2017 at 14:35 – Expected change to the post-16 aspects of the Census

The only change we are now expecting for the post-16 aspects of School Census is an extension to the list of QNs available to schools.