I am busy changing the world

You can use this SQL query to get all the students that do not have parent account linked to them in PowerSchool: SELECT s.LASTFIRST, s.STUDENT_NUMBER, s.FAMILY_IDENT, s.FATHER,                                           u.SSIS_FATHER_EMAIL, s.MOTHER, u.SSIS_MOTHER_EMAIL FROM students s INNER JOIN u_studentsuserfields u ON s.DCID = u.STUDENTSDCID WHERE s.DCID not in (SELECT g.STUDENTSDCID FROM guardianstudent g)        AND s.ENROLL_STATUS = 0;

Part I - Overview, Create or Update PowerSchool Parent accounts using PHP cURL Earlier this year I had a chance to work on a project which is creating a Single Log-In system for Parents using the PowerSchool data. Unlike other kind of users in PowerSchool (Students, Teacher) Parents cannot be bind to an Active Directory server (Yes, my life would be easier if they support LDAP for Parent accounts!), they are stored in a separate place in the database. After searching around for a while, I recognized that the only way for me to build a Single Log-In system for Parents is using the PowerSchool API and implement the SAML 2.0 protocol. The purpose of PowerSchool supporting this protocol is for developers to create a Single Sign-On layer for customized apps to use PowerSchool as an Identity Provider . To learn the PowerSchool API and to implement the SAML protocol which I never heard before is not a big deal to me as a developer, but in the limited amount of time, I was not sure i...

You can use this php snippet to get all the parent accounts from your PowerSchool SIS's Oracle database: $ php get_parent_accounts.php