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.LN PWA.FN PWA.LC PWA.LDT PWA.CD STU.SC STU.LN STU.FN STU.ID STU.GR


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