This is a collection of queries related to Student Success tables 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.
Texas Student Success Queries
At-Risk Student Listing by Specific Date
Lists At-Risk students by specific date and includes Campus, Student ID, Student Name, Grade Level, At-Risk ID, At-Risk Description and At-Risk Start Date
LIST STU ARI ARC STU.SC STU.ID STU.NM STU.GR ARI.IID ARC.SDE ARI.SD IF ARI.SD >= ##/##/20## AND ARI.ED = NULL
UNPS CE 00145
Lists Student State ID, Student Last Name, Student First Name, Birthdate, Gender, GradeLevel
LIST STU CID LN FN BD GN GR
(After extracting to Excel add an additonal column for CE and ID)
GATE Student Listing by Grade Level
Lists GATE students includes Campus, Student ID, Student Name, Grade Level, GATE Start Date and GATE End Date by Grade Level
LIST STU GTE STU.SC STU.ID STU.NM STU.GR GTE.PSD GTE.EED BY STU.GR IF GTE.PSD # NULL AND GTE.PEED = NULL
Texas Student Total Queries
EO English Learner Student Listing
Displays total counts English Learner students by school and language fluency designation
TOTAL STU SC LF BY SC LF IF LF # 98