search

American-School-of-the-Hague / psd2l-plugin

PowerQueries for PowerSchool SIS for use with Data Export Manager (DEM)
GNU General Public License v3.0
3 stars 3 forks source link

Remove TEACHERS table in favor of USERS.DCID #3

Closed txoof closed 2 years ago

txoof commented 2 years ago

The TEACHERS table has been deprecated by powerschool. We should remove this in favor of USERS.DCID or something similar.

It is imperative that whatever we use remains the same value that is in the TEACHERS.TEACHERNUMBER field. Changing this in brightspace is not an option at this point.

https://github.com/txoof/PowerQuery/blob/a95e43839d1a95dc7b993b03ddad802326b4f25a/BS_Users_Enrollments/queries_root/07_u_t_inactive.named_queries.xml#L35

txoof commented 2 years ago

See also https://github.com/txoof/PowerQuery/blob/main/BS_Users_Enrollments/queries_root/07_u_f_inactive.named_queries.xml https://github.com/txoof/PowerQuery/blob/main/BS_Users_Enrollments/queries_root/08_e_t.named_queries.xml