Redlands Unified School District

--This will keep students that have one or more parent portal accounts capable of viewing them.

KEEP STU PWS PWA IF PWS.AID # NULL AND PWA.TY = "P"

To get a simple list of the students with a parent portal account, run the following query after the KEEP query:

LIST STU SN NM GR

Remember to click on the RESET button after you’re done with the KEEP query.

--Skip Students with Parent Portal Accounts to find those that don’t

SKIP STU PWS PWA IF PWS.AID # NULL AND PWA.TY = "P"

To get a simple list of students without a parent portal account, run the following query after the SKIP query:

LIST STU SN NM GR

Remember to click on the RESET button after you’re done with the SKIP query.

--Portal Account Type Counts

TOTAL STU PWS PWA PWA.TY BY PWA.TY IF STU.TG = " " AND PWS.AID # NULL

This query will give you the total number of parent and student portal accounts.

P=Parent account 

S=Student account

Remember that one student can have multiple parent portal accounts.

--To get a list of students whose parents have completed the Data Confirmation process, you would query from the Information Confirmation Log table or ICL table. You're looking for students whose parent have the "FinalDataConf" table completed.  Below is the query:

LIST STU ICL STU.ID STU.NM STU.GR ICL.TC ICL.DT IF ICL.TC : "final"

--To get a total number of students whose parents have completed the Data Confirmation process, use this query:

TOTAL ICL IF ICL.TC : "final"

Thank you Stephen Burks, Bellflower Unified School District