I would like to use SQL to build a report showing students who have withdrawn and whose contacts still have the Data Access flag enabled. Could you please let me know which tables and fields I should reference?
Solved! Go to Solution.
Hi!
I believe it's on the Guardians table and the field is AllowWebAccess to see which guardians still have access.
The table has studentID so I would join on studentID and then filter on enroll status and allow web access
Hi!
I believe it's on the Guardians table and the field is AllowWebAccess to see which guardians still have access.
The table has studentID so I would join on studentID and then filter on enroll status and allow web access