The query below will list your school's denials on their Portal Authorizations by their teacher.


  • LIST STU AUT TCH STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.CU TCH.TE AUT.CD? AUT.ST? BY STU.CU STU.LN IF ( AUT.EED = NULL OR AUT.EED >= "06/04/2020" ) AND AUT.ST = 2


If you change the AUT.ST =  "2" to a "1", you will get the students who accepted the authorization.



If you would like to search for one type of authorization, you can use the query below.


  • LIST STU AUT TCH STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.CU TCH.TE AUT.CD? AUT.ST? BY STU.CU STU.LN IF ( AUT.EED = NULL OR AUT.EED >= "06/04/2020" ) AND AUT.CD = "P" AND AUT.ST = 2


If you change the AUT.ST =  "2" to a "1", you will get the students who accepted the authorization.


If you change the AUT.CD =  "P" for Photo Release, or "I" for Internet Release, or "F" for Field Trip Permission, or "H" for Student Handbook, etc.



You could run the query below to KEEP only students who are missing an authorization.  After keeping them, you can run a query for a mailer or a phone call, etc.


SKIP STU AUT IF ( AUT.EED = NULL OR AUT.EED >= "06/04/2020" ) AND AUT.CD = "P"


Change the AUT.CD to look for a particular authorization.  ( AUT.EED = NULL OR AUT.EED >= "06/04/2020" ) is looking for authorizations with no end date or an end date of the last day of school.