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;
tlough
Fri, 08/10/2012 - 10:10am
Permalink
Same Request
I'm looking for this too.
niti9999
Wed, 12/12/2012 - 5:38pm
Permalink
same request
and also a list of parents who don't create account yet.
cheripettus
Thu, 08/28/2014 - 5:38pm
Permalink
Parent Portal report
Me too - would like to send a letter to parents who haven't signed up yet.
cheripettus
Thu, 08/28/2014 - 5:46pm
Permalink
Found it! - parent portal query
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;