Lookup Tables

There are three lookups that need to have categories added to them for the CES Census:

Lookup TableCategory
Pupil religionRoman Catholic
Staff religionRoman Catholic
Staff ethnicityTraveller of Irish / Gypsy / Roma Heritage

Because these categories are not present as part of the standard SIMS lookups the CES Census needs to be told where they are.

If you have used SIMS CES Census before then these lookups will be set up and linked to the CES Census. You can now move on to "Step 3: setting up a folder in which to save files".

If you have not used SIMS CES Census before then the SIMS Autumn upgrade should have installed any missing categories for you and linked them automatically to the CES Census.

You should, however, check that the update has set up your lookups correctly. Therefore, the first time you run the CES Census using SIMS you will need to follow these two steps:

1. Check SIMS Lookups

Click here for greater detail and screenshots for this step.

Follow the Tools | Lookups | Maintain route and check the three lookups:

In Description, type ethnicity and in Data Area type Staff. Click Search, highlight the resulting 'Ethnicity - Staff' field and click Open. Scroll down the list of values and check whether 'Traveller of Irish / Gypsy / Roma Heritage' is present.

In Description, type Religion and in Data Area type Staff. Click Search, highlight the resulting 'Religion - Staff' field and click Open. Scroll down the list of values and check whether 'Roman Catholic' or 'Catholic' is present.

In Description, type Home Religion and in Data Area type Student. Click Search, highlight the resulting 'Home Religion - Student' field and click Open. Scroll down the list of values and check whether 'Roman Catholic' or 'Catholic' is present.

If any of the above values are missing, see Click here for detailed instructions on how to add them.

2. Check CES Census Lookups

Click here for greater detail and more screenshots for this step.

Follow the route: Tools | Statutory Return Tools | Update CES Census Lookups

The SIMS lookups will appear in the drop down menu at the right hand side of each category for which they refer (see screen below).

If any of these drop down menus do not have a value selected, then they have not been matched to the CES Census. In this case, click here for detailed instructions on how to complete the process. Screen 1 above shows a set of matched CES lookups.

You should only need to perform these two steps the first time you run the SIMS CES Census application.

 
 

© 2016 Catholic Education Service