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