How can I use SQL to find out which contacts have the Data Access flag turned on?

[eden_cheng]

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?

[kkentk12 · Accepted 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