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 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 : "firstname.lastname@example.org"
(Replace "email@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