Error calculating non-Catholic religions – Patch 23611

Unfortunately, an error has been identified with the reporting of non-Catholic pupil religions. This error is corrected with patch 23611. The error occurs when there are extra lookup codes for a religion category. For instance, if the lookup of Baptist is created with the category of Christian, only pupils with the lookup code Christian will be counted. Baptist will not be counted.

If your school has access to SOLUS 3 please call your SIMS helpdesk and ask for access to the patch. If you are unsure of the contact details for your helpdesk ring 0844 893 8000 or email

If your school does not have access to SOLUS 3 download the file and unzip it to your desktop. It contains the patch files and a pdf document with instructions on how to apply the patch with DBUpgrade.

When you have applied the patch, create and validate the census and open the summary report. The totals of non-Catholic pupils by year group (questions 52 – 119, columns 3 and 4) should be the same as the breakdown of non-Catholic pupils religions (120 – 129).

SIMS Quickstart guide

Click on links to see relevant sections in the main guidance.

Before completing the Census

  1. Ensure that all data in the modules is up to date (more...)
  2. Check that CES lookups have been assigned. To maintain lookups go to
    Tools->Statutory Return Tools->Update CES Census Lookups (more...)
  3. Set up a folder in which to save the files (more...)
  4. Ensure that everything is ready by doing a dry run (more...)

Completing the Census

  1. Go to Routines->Statutory returns->Schools CES Census (more...)
  2. Click 'New' to start a Census return (more...)
  3. Complete Panel 2 (School Information) and click on 'Calculate All Details' (more...)
  4. Check figures in all remaining panels and correct any errors (more...)
  5. Refer to hover-over help information (more...)
  6. Save the form at frequent intervals (more...)
  7. When you have finished, click on 'Create & validate' (more...). Errors and warnings will be displayed.
  8. Click on 'Summary Report' and check every answer (more...)
  9. If further changes are needed return to step 6
  10. When checking has been completed to the satisfaction of the head teacher, click on 'authorise' (more...)

Checking the Census

You should check all of the information in your Census report. The following errors are often caused by set-up problems in SIMS:

  • Zero or very low numbers of Catholic pupils
  • Zero Catholic teachers
  • Zero Catholic support staff

If your report shows any of the above then you may need to adjust your SIMS lookup tables. Please call the Census helpdesk if you need assistance. (more...)

Upload the XML file

Your Census return created several files with CES in the middle of their filenames. Typical filenames are:


Please submit the file with the extension .xml (the one without '_report' at the end of the name).

If you cannot remember the exact location of the folder containing these files, you can find it in SIMS by going to Routines | Statutory Returns | Schools CES Census and looking for the CES Census Folder field at the top of the screen (you may need to click the Browse button to see it).


© 2018 Catholic Education Service