https://help.powerschool.com/t5/Community-Forum/How-can-I-use-SQL-to-find-out-which-contacts-have-the-Data/m-p/543941#M26872 <P>Hi!</P><P>&nbsp;</P><P>I believe it's on the&nbsp;Guardians table and the field is AllowWebAccess to see which guardians still have access.</P><P>&nbsp;</P><P>The table has studentID so I would join on studentID and then filter on enroll status and allow web access</P> Wed, 09 Apr 2025 20:36:26 GMT kkentk12 2025-04-09T20:36:26Z https://help.powerschool.com/t5/Community-Forum/How-can-I-use-SQL-to-find-out-which-contacts-have-the-Data/m-p/543918#M26870 <P>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?</P> Wed, 09 Apr 2025 16:55:10 GMT https://help.powerschool.com/t5/Community-Forum/How-can-I-use-SQL-to-find-out-which-contacts-have-the-Data/m-p/543918#M26870 eden_cheng 2025-04-09T16:55:10Z https://help.powerschool.com/t5/Community-Forum/How-can-I-use-SQL-to-find-out-which-contacts-have-the-Data/m-p/543941#M26872 <P>Hi!</P><P>&nbsp;</P><P>I believe it's on the&nbsp;Guardians table and the field is AllowWebAccess to see which guardians still have access.</P><P>&nbsp;</P><P>The table has studentID so I would join on studentID and then filter on enroll status and allow web access</P> Wed, 09 Apr 2025 20:36:26 GMT https://help.powerschool.com/t5/Community-Forum/How-can-I-use-SQL-to-find-out-which-contacts-have-the-Data/m-p/543941#M26872 kkentk12 2025-04-09T20:36:26Z