This is an old revision of the document!
EOY Report Queries
NOTE: For ALL of these Queries, you MUST check the "Show Inactive Records" at the bottom left of the query screen.
Check English Proficiency, Language, and Birth Country
DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3 CntryCode IF EngProf <> " "
Check Enter/Leave Code and Date
DISPLAY AENR ASTU PermNum LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF TransYear = "2006"
Check Ethnic Code
DISPLAY ASTU PermNum LastName FirstName EthnicCode#
Check for Blank StateID
DISPLAY ASTU PermNum LastName FirstName StateID
Check Free/Reduced Meals
DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " "
Check Gender
DISPLAY ASTU PermNum LastName FirstName Gender
Check GATE atom
DISPLAY AGAT ASTU LastName FIrstName GateDate General Specified# Visual PsyMotor IF GateDate <> " "
Check Grad Plan
DISPLAY ASTU PermNum LastName FirstName Grade PastSecond IF Grade = "12"
Check Grad/Other Completer
DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 InstrSet IF Grade = "12"
Check Grade
DISPLAY ASTU PermNum LastName FirstName Grade
Check Hidden Absences (Elem/Middle)
DISPLAY AATD ASTU PermNum LastName FirstName 2,Status AbsDate AllDayAbs IF AbsDate > LeaveDate AND LeaveDate > " "
Check Hidden Absences (High)
DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " "
Check Homeless
DISPLAY ASTU PermNum LastName FirstName Homeless IF Homeless = "X"
Check KG Readiness
DISPLAY ASTU PermNum LastName FirstName BirthDate IF BirthDate > "100101" and Grade = "KG"
Check Migrant
DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = "X"
Check Non-Public FTE
DISPLAY ASTU PermNum LastName FirstName PctApport IF PctApport <> " "
Check PK EXP Time
DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# UserNum1 if Grade = "PK"
Check Responsible Division/Tuition Paid
DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3
Check Responsible School
DISPLAY ASTU PermNum LastName FirstName UserCd2 UserNum5
Check Retention Flag
DISPLAY ASTU PermNum LastName FirstName NextGrade IF NextGrade <> " "
Check Serving Division/Serving School
DISPLAY ASTU PermNum LastName FirstName UserCd3 AltId1 AltId2
Check Student Name
DISPLAY ASTU PermNum LastName FirstName MiddleName
Check Summer Dropout
DISPLAY AENR ASTU 2, Status PermNum LastName FirstName EffDate 1,EnterCode 1,LeaveCode TransYear IF TransYear IN [05,06] AND LeaveCode = " " AND 2,Status = "N"
Check Summer Dropout 2
DISPLAY AENR ASTU 2, Status PermNum LastName FirstName EffDate 1,EnterCode 1,LeaveCode TransYear IF TransYear = "06" AND EnterDate > "100206" AND 2,EnterCode = "E1" AND 2,Status <> "N"
Check Summer Dropout 3
DISPLAY ASTU PermNum LastName FirstName Retain IF Retain <> " "
Check Title I
DISPLAY ASTU PermNum LastName FirstName Grade UserCd7 IF UserCd7 <> " "
Check Truancy Conferences
DISPLAY ACNF ASTU ACNR LastName FirstName ReportDate Descript IF DescCode = "ATT"
Check Unique Local Student ID
DISPLAY ASTU PermNum LastName FirstName
Check W8 Reason
DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF LeaveCode = "W8"
Check W8 Reason 2
DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF UserCd1 <> " "
Page Tools
