Teachers AtSchool Filter not working

[Ghislain Hachey]

Also modify teacher filter options to only include useful ones.

GH

[Brian Lewis]

AtSchool checks for a TeacherSurvey record at the nominated school; this is across any survey year. If InYear is also specified the TeacherSurvey record must match the school and year.

So probably the issue here is that some systems have TeacherAppointment records, but not teacherSurvey.

[Brian Lewis]

Resolution here is SQL to migrate historic appointments into TeacherSurvey.

[Brian Lewis]

Stored proc

[pTeacherAdmin].[CreateSurveysFromAppointments]

created, deployed and executed in FEDEMIS-TEST