SIMS – Error Appearing within Post-16 Programme of Study. – Subquery returned more than 1 value.
This error is known to appear for a few different reasons but currently this error is caused by a student or students who have withdrawn from a course or more without a reason being recorded against them. To find out which students are causing this error to appear within SIMS you will need to load the Post-16 Programme of Study page and select half of the students before running the Calculate All Programmes of Study process. If the error does not appear the student or students that are causing this error are in the other half of the student list. You will need to repeat this process until you have found all of the students that cause this error to appear.
After you have found the students you will need to load the students courses by clicking on their names within the Post-16 Programme of Study page, before clicking on any of the courses that appear with the Withdrawn status. You can also open these courses through Tools > Academic Management > Course Manager > Maintain Course. Once you have loaded one of the courses you will need to go to the Memberships and Results section to locate the student, before clicking on the Reason box and entering the reason the student withdrew from the course before saving the course page itself.
After you have done this for all of the students that are causing this error to appear, you should be able to rerun the Post-16 Programme of Study page without any issues.
Error 1887 Leavers who have repeated year 13 for COVID-19 reasons
We are receiving help desk cases and seeing threads on our forums reporting validation errors for leavers in academic year 2021/22 who have repeated year 13. We have found an explanation for one of these validation failures (error 1887) and there is good reason to believe that it may explain other validation failures for students who left in the previous academic year when they were repeating Year 13.
When Create & Validate is run in the Census application (Routines | Statutory Returns | School Census) it checks for Repeating Year 13 ticks in Update Funding and Monitoring (Tools | Statutory Returns Tools | Update Funding and Monitoring) for Academic Year 2021/2022.
It expects to find that those students have three-year learning aims. It then attempts to follow the DfE’s specification by splitting both the student’s leaning aims and the student’s programme of study into ‘normal’ learning aims and a ‘normal’ programme of study PLUS ‘special’ one year learning aims and programme of study for the ‘repeated’ year. However, it actual finds that the learning aims have already been ‘split’ into two by Update Course Memberships (Tools | Academic Management | Course Manager | Update Course Membership). This confuses Create & Validate so that none of the students learning aims are included in the return file.
We understand that the number of students eligible for this repeating of year 13 is small for each school. This means that there is a relatively simple solution available as described below.
- Use the Programme of Study and Learning Aims detail report in the School Census application to identify the Year 13 leavers who have a Programme of Study without Learning Aims. We understand from the DfE that this will be a small number of students.
- For each of the students identified, open each of student’s courses in the Maintain Course application (Tools | Academic Management | Course Manager | Maintain Course), find the two membership records in the Membership and Results panel. Extend the first of these records to cover the three years and protect it. Delete the second on these records.
- Open Post-16 Programme of Study (Tools | Academic Management | Course Manager | Post-16 Programme of Study) and ensure that Autumn Census 2022 is selected. Calculate the Programme of Study for each of the students identified.
- Run Recalculate in the Learning Aims panel of the Census application.
- Run Create & Validate in the Census application
Issue when using ‘Populate from Exams’ in Update Prior Attainment
Please note that there is an issue which results in the clicking of the ‘Populate from Exams’ button in Tools | Statutory Returns Tools | Update Prior Attainment failing to take account of external exam results. This is likely to be significant for the census for any school that stores external exam result for students.
A solution for this issue as part of Consolidated Database Patch 1 for the SIMS Summer Release 2022.
Funding & Monitoring:- Repeating Post 16 Year of Study
In addition to the above issues identified by ESS we have had several other errors occurring as a result of students repeating Y12 or Y13 Year of study.
Tools | Statutory Returns Tools | Update Funding and Monitoring
- This lists pupils who are on roll on census day and those who left the schools between 01/08/2022 and 31/07/2023.
- The Repeating Year 13 column has been renamed to Repeating Post-16 Year.
- A Starting New Program column has been added but only becomes editable when Repeating Post-16 Year has been ticked for pupil taught in year 12 it can be left unticked to indicate that the programme will be continuing or ticked to indicate that the earlier programme has been completed and a new programme started.
- When a Year 13 student is ticked it will automatically indicate that the earlier programme has been completed and a new programme started.
We have had a number of instances where starting a new programme has been ticked which then causes errors for some students. Check the detailed report, Post 16 Programme of Study and Learning Aims Report, to ensure that the student programme is correct if the programme shows it has completed incorrectly then remove the tick to update the programme of study to continuing.
Webinar recording, power point and further resources 5th October 2022
We highly encourage colleagues to watch webinar recording on the Secondary & Post 16 Census