SQL for Contacts

JimW9
PowerSchool Champion
PowerSchool Champion

SQL for Contacts

I have SQL query for pulling the Check Boxes on the Contacts page.  So far I have the following.

 

  • Custody
  • Lives With
  • School Pickup
  • Emergency Contact
  • Receives Mail

My question is, there is a check box labeled     Data Access     and I cannot seem to find the table to join to the others to pull that information.  It may be right in front of my eyes but I am missing it?  Any help would be greatly appreciated.

 

Have a wonderful day!!!!!!!!!!!!!!!

 

1 Reply
NinaRi
Community Support Expert
Community Support Expert

Hi @JimW9 ,

 

Thank you for reaching out in the PowerSchool Community!  SQL statements are not provided by the PowerSchool Development Team. Therefore, we will not be able to determine the names of the tables and checkboxes.  You can find out more about what is supported for PowerSchool SIS here

 


Nina R.