sasixp:eoy_report_queries
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
sasixp:eoy_report_queries [2007/05/17 16:38] GINAC created |
— (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 | ||
| - | |||
sasixp/eoy_report_queries.1179434312.txt.gz · Last modified: 2007/05/17 16:38 by GINAC
Page Tools
