Validate Memberships & Database Diagnostics

Validate Memberships and Database Diagnostics are key housekeeping routines that perform a collection of checks and fixes which are applied to the SIMS database when they are run. These processes ensure that all group memberships are brought into line with Academic Year boundaries. These routines can be run by SIMS users with the SIMS System Manager permission.

Validate Memberships

Tools > Validate Memberships

Validate Memberships will check any changes that have been made to group memberships or other data that affects the group membership rules within SIMS, and automatically applies corrections where it encounters an issue. Validate Memberships should be run monthly as a minimum, although if your SIMS is Hosted by Scomis this is automatically run for you on a weekly basis. For more information on Validate Memberships please see this guide: Validating Memberships using DBDiagnose

Database Diagnostics

Tools > System Diagnostics > Database Diagnostics

Similar to Validate Memberships, Database Diagnostics will check every record in SIMS against its specific validation checks. Once it has completed, it will list all of its checks (under Tools > System Diagnostics > Database Diagnostics) and provide any warnings. These warnings are then either fixed automatically or will need to be resolved manually in SIMS by the user.

Please note: Both of these routines may take some time to complete in SIMS.net. Therefore, we recommend that these are run during a quiet time (i.e. out of school hours) to prevent impact to SIMS users.

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

How do I add an hourly rate to Sims .net Personnel?

ByscomisWR

Go to Tools>Staff>Pay Related>New Enter a code, description, Hours Worked and Weeks Worked as required. If the pay pattern will be the same for all staff on this service term it may be entered here by clicking on the Pay Pattern button – split the weeks worked for the year between the months until the total…

Error when entering leaving date of a pupil

ByAnnabel Tuohy

If you are entering the leaving date for a pupil, you may get an error message such as “Invalid DOL” or “Invalid Scenario” If you get any sort of error message, make sure the leaving date you are entering and any of the previous leaving dates in School History are all on school days and…

What Are Interventions and How To Use Them

Byvicky.leavy

SIMS Interventions enables schools to enrol pupil/students, who are not achieving or behaving as expected, on a course of intervention measures. It is possible to allocate additional resources, monitor the use of these resources and gauge how these resources affect Key Performance Indicators, as well as record the cost of the resources. This enables schools…

FMS Salary Commitments for all Teachers – are showing incorrectly.

ByDiane Semple

When all staff in a particular service term in FMS are showing incorrectly, this is usually due to a new pay award being entered into SIMS Personnel. Earlier in the year, for budgeting purposes, the known or anticipated % pay increase for September may have been added in FMS. Once the pay award is entered…

SIMS Personnel Annual Increments for Teaching Staff

Byanita.belworthy

As the majority of our schools have not moved from Points salaries within SIMS Personnel, users have asked if they are going to have to manually update each Teacher’s salary in September as the service terms do not appear within the Annual Increment routine now. We are pleased to tell you that you can follow…

How to record an address with no postcode (PO Box).

ByVerity.Ridge

Schools can provide the department with their addresses in whichever format their data is held within their MIS – either; BS7666 address format, (SAON, PAON, post town or other address items) or; address line 1 to 5. Postcode is mandatory for either format. Whilst every effort must be made to obtain these pupil details, the…