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

Parent/student auditor relationship is not sustainable #12

Closed txoof closed 2 years ago

txoof commented 2 years ago

Parent email addresses are stored in a custom table that does not connect 1:1 with the guardianid table.

All matches have to go through first/last name. First/last names in guardians and custom table are inconsistent.

This means that using guardian ID for an org defined id will not intrinsically work.

Alternatives:

For read only option, it will be necessary to only create accounts for parents that pass the first/last match. Need to document this heavily so we can fix this for parents without accounts. Need advice as to where on the SIS front end this data is entered.

txoof commented 2 years ago

Removed all Parent relationships from enrolment. Longterm solution involves cleaning up data and moving to the guardian contacts model in SIS.