This query provides a list of Parent Portal Accounts that have their Weekly Progress Report notification set to on or off
On:
LIST STU PWS PWA PNP STU.ID STU.NM STU.GR PWA.EM PNP.SPE PNP.DW PNP.TM PNP.ELS IF PNP.SPE = 1
Off:
LIST STU PWS PWA PNP STU.ID STU.NM STU.GR PWA.EM PNP.SPE PNP.DW PNP.TM PNP.ELS IF PNP.SPE = 0
LIST STU PWS PWA PNP STU.ID STU.NM STU.GR PWA.EM PNP.SPE PNP.DW PNP.TM PNP.ELS IF PNP.SPE = 0