[sims] SWC and "role must be at least 0" when editing some staff records - anyone else?

[pete]

Our finance team are going through the SWC currently and have discovered two personnel records (one a teacher, the other non-teaching staff) that need amending.

However, when they go to alter the record (even doing something as simple as adding a test middle name), they get an error of:

 

"role must be at least 0" in the bottom left corner.

 

....but just for those two records. Other personnel records are unaffected.

 

Checking the records, the associated contracts have correctly assigned roles and finance have attempted to redo the contracts to ensure they're correct.

 

This is apparently affecting other schools and waiting on a SQL script from SIMS and has problem ID: PRB19016

[Esteban_Child_of_the_Sun]

in the SIMS database, each person has an aggregate_role value.

Student is 1

Contact is 2

Employee is 8

System Manager User is 16

etc.

So if someone had an aggregate role of 24 (8+16) it would mean they were an employee and a user. There is a glitch somewhere in the system that thinks it is removing a role from some people records who don't have that role, e.g. if the applicant role (128) was erroneously removed from the above example the person would have a role of -104 (24 - 128). This is what the error is referring to.