Unrelate staff record if record is closed and not for current year
Currently, if a staff record contains any field entry for a school (whether closed or not) it will show up under that school as "related to that school."
I.E. Staff member has a primary school (STF.PSC) of 223 and has an STJ record that has an end date in 2019 for school 221 (STJ.SCL) and a current year open STJ at school 223 (STJ.SCL). In the Staff listing, on the staff page with "Only records related to this school" checked, this staff member will show up in the list for school 223 AND 221 even though the 221 record is a couple years old and has an end date.
I propose that if a staff member has a CLOSED STJ or STA from a prior year, that staff record is no longer related to the school(s) listed in the CLOSED STJ or STA. The staff member should only be related to current year and/or open STJ/STA for the School specified. In the above example, that would be 223
P.S. We like to keep prior year STJ and STA records for historical data WITHOUT having to switch years.
-
Camden Ray commented
This would be great!