This is a collection of queries related to Parent and Student Portals that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

List of Parent and Student Portal Activity

Provides a list of portal accounts and login activity


LIST PWA PWS STU PWA.AID PWA.EM PWA.AST PWA.TY PWA.PID PWA.LC PWA.LDT PWA.CD STU.SC STU.LN STU.FN STU.ID STU.GR


EML:  List of Email Data That Was Sent to an Email Address for Aeries Admins

Provides a list of entries with Email information for Aeries Admins to investigate based on a "Sent To:" Email Address


LIST EML EID TN UN SCL DT FAD TAD SUB (( DTS )) IF TAD : "parent.brown@example.com"

(Replace "parent.brown@example.com" with Email Address "Sent To:")


AUT:  Authorizations on a Specific Date

List of students with Authorizations effective on a specific date


LIST STU AUT STU.ID STU.NM AUT.CD AUT.CD? AUT.ST AUT.ST? IF AUT.SDT <= ##/##/2018 AND ( AUT.EED = NULL OR AUT.EED >= ##/##/20## )

(use the same date in both date fields)


AUT:  Authorization Date and Time Stamp with Authorization Code and Information

Provides a list of Authorization data with a Date and Time Stamp


LIST AUT SC SN TY CO DT SQ ST (( CAST(SDT AS DATETIME) )) CD TA EED SRC


FRE:  List of Parent Responses to the Income Survey

If a district decides to gather information using the Income Survey available in Parent Data Confirmation, the data collected can be tracked/identified/queried by the value placed in the Source (FRE.SRC) field.


LIST STU FRE STU.SC STU.ID STU.NM FRE.CD FRE.SRC FRE.ESD FRE.EED FRE.PIR FRE.PDT FRE.MO IF FRE.SRC = PDC


Military: List of pending students as listed on the Military Audit page

LIST STU ICL PRS STU.SC STU.ID STU.NM STU.GR PRS.DT PRS.TY PRS.CD PRS.ST PRS.UN PRS.ID STU.LD STU.TG BY ICL.SC IF PRS.TY = 2 AND PRS.ST = P AND PRS.DT > 07/01/2022 AND ICL.TC = "FinalDataConf" AND ICL.DT > 7/1/2022