This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
sasixp:eoy_report_queries [2007/05/17 16:40] GINAC |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ==== EOY Report Queries ==== | ||
- | |||
- | NOTE: For ALL of these Queries, you **MUST** check the "Show Inactive Records" | ||
- | |||
- | == Check English Proficiency, | ||
- | DISPLAY | ||
- | |||
- | == Check Enter/Leave Code and Date == | ||
- | DISPLAY AENR ASTU PermNum LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF TransYear = " | ||
- | |||
- | == Check Ethnic Code == | ||
- | DISPLAY ASTU PermNum LastName FirstName EthnicCode# | ||
- | |||
- | |||
- | == Check for Blank StateID == | ||
- | DISPLAY ASTU PermNum LastName FirstName StateID | ||
- | |||
- | == Check Free/ | ||
- | 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 | ||
- | |||
- | == Check Grad/Other Completer == | ||
- | DISPLAY ASTU PermNum | ||
- | |||
- | == Check Grade == | ||
- | DISPLAY ASTU PermNum LastName FirstName Grade | ||
- | |||
- | == Check Hidden Absences (Elem/ | ||
- | 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 = " | ||
- | |||
- | == Check KG Readiness == | ||
- | DISPLAY ASTU PermNum LastName FirstName BirthDate IF BirthDate > " | ||
- | |||
- | == Check Migrant == | ||
- | DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = " | ||
- | |||
- | == Check Non-Public FTE == | ||
- | DISPLAY ASTU PermNum LastName FirstName PctApport IF PctApport <> " " | ||
- | |||
- | == Check PK EXP Time == | ||
- | DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# | ||
- | |||
- | == Check Responsible Division/ | ||
- | DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3 | ||
- | |||
- | == Check Responsible School == | ||
- | DISPLAY ASTU PermNum LastName FirstName UserCd2 UserNum5 | ||
- | |||
- | == Check Retention Flag == | ||
- | DISPLAY ASTU PermNum | ||
- | |||
- | == Check Serving Division/ | ||
- | DISPLAY ASTU PermNum LastName FirstName | ||
- | |||
- | == 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 = " | ||
- | |||
- | == Check Summer Dropout 2 == | ||
- | DISPLAY AENR ASTU 2, Status PermNum LastName FirstName EffDate 1,EnterCode 1,LeaveCode TransYear IF TransYear = " | ||
- | |||
- | == Check Summer Dropout 3 == | ||
- | DISPLAY ASTU PermNum LastName FirstName | ||
- | |||
- | == Check Title I == | ||
- | DISPLAY ASTU PermNum | ||
- | |||
- | == Check Truancy Conferences == | ||
- | DISPLAY ACNF ASTU ACNR LastName FirstName ReportDate Descript IF DescCode = " | ||
- | |||
- | == Check Unique Local Student ID == | ||
- | DISPLAY ASTU PermNum LastName FirstName | ||
- | |||
- | == Check W8 Reason == | ||
- | DISPLAY ASTU PermNum | ||
- | |||
- | == Check W8 Reason 2 == | ||
- | DISPLAY ASTU PermNum | ||
- | |||