This is an old revision of the document!
NOTE: For ALL of these Queries, you MUST check the "Show Inactive Records" at the bottom left of the query screen.
DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3 CntryCode IF EngProf <> " "
DISPLAY AENR ASTU PermNum LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF TransYear = "2006"
DISPLAY ASTU PermNum LastName FirstName EthnicCode#
DISPLAY ASTU PermNum LastName FirstName StateID
DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " "
DISPLAY ASTU PermNum LastName FirstName Gender
DISPLAY AGAT ASTU LastName FIrstName GateDate General Specified# Visual PsyMotor IF GateDate <> " "
DISPLAY ASTU PermNum LastName FirstName Grade PastSecond IF Grade = "12"
DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 InstrSet IF Grade = "12"
DISPLAY ASTU PermNum LastName FirstName Grade
DISPLAY AATD ASTU PermNum LastName FirstName 2,Status AbsDate AllDayAbs IF AbsDate > LeaveDate AND LeaveDate > " "
DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " "
DISPLAY ASTU PermNum LastName FirstName Homeless IF Homeless = "X"
DISPLAY ASTU PermNum LastName FirstName BirthDate IF BirthDate > "100101" and Grade = "KG"
DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = "X"
DISPLAY ASTU PermNum LastName FirstName PctApport IF PctApport <> " "
DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# UserNum1 if Grade = "PK"
DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3
DISPLAY ASTU PermNum LastName FirstName UserCd2 UserNum5
DISPLAY ASTU PermNum LastName FirstName NextGrade IF NextGrade <> " "
DISPLAY ASTU PermNum LastName FirstName UserCd3 AltId1 AltId2
DISPLAY ASTU PermNum LastName FirstName MiddleName
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"
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"
DISPLAY ASTU PermNum LastName FirstName Retain IF Retain <> " "
DISPLAY ASTU PermNum LastName FirstName Grade UserCd7 IF UserCd7 <> " "
DISPLAY ACNF ASTU ACNR LastName FirstName ReportDate Descript IF DescCode = "ATT"
DISPLAY ASTU PermNum LastName FirstName
DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF LeaveCode = "W8"
DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF UserCd1 <> " "