Parent Portal Report

Is there a way to get a list of parents/guardians who have an account set up for the Parent Portal?
deb

I'm looking for this too.

and also a list of parents who don't create account yet.

Me too - would like to send a letter to parents who haven't signed up yet.

From a helpful user on Yahoo groups, here is the SQL query to find out who has a parent portal account. You need SQL Reports 4 to run it. Then you can export it to Excel or PDF.

select
students.lastfirst,
students.student_number,
guardian.lastname,
guardian.firstname,
pcas_emailcontact.emailaddress
from
students
join guardianstudent on students.dcid = guardianstudent.studentsdcid
join guardian on guardianstudent.guardianid = guardian.guardianid
join pcas_account on guardian.accountidentifier = pcas_account.pcas_accounttoken
join pcas_emailcontact on pcas_account.PCAS_AccountID = pcas_emailcontact.pcas_accountid
order by
students.lastfirst;

Subscribe to Comments for "Parent Portal Report"