This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sasixp:spring_report_queries [2006/11/15 08:30] ginac created |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ==== Spring Records Collection Queries ==== | ||
- | |||
- | The following queries will help review SASI data due on the Spring report for accuracy. | ||
- | |||
- | NOTE: In queries that contain “ “ there is a space between each quotation mark. | ||
- | |||
- | == Check for Blank State Testing Identifier == | ||
- | DISPLAY ASTU LastName FirstName Passport | ||
- | |||
- | == Check Responsible Division/ | ||
- | DISPLAY ASTU LastName FirstName UserCd2 UserCd3 | ||
- | |||
- | The UserCd2 (Residency Cd) field should be blank or 094 (Washington Co.) unless student resides in Johnson County, TN in which the code will be 888. | ||
- | |||
- | The UserCd3 (Tuition Tag) field should be blank unless student resides in Johnson County, TN in which the code will be 10. | ||
- | |||
- | == Check Responsible School == | ||
- | DISPLAY ASTU LastName FirstName UserNum5 | ||
- | |||
- | The UserNum5 field should be blank unless student resides in Johnson County, TN in which the code will be 9999. | ||
- | |||
- | == Check Enter Code/Leave Code/Date == | ||
- | DISPLAY AENR ASTU LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF TransYear = XXXX | ||
- | |||
- | Most all E1’s should fall on the first day of the school year. If not, please check for accuracy. | ||
- | |||
- | Also check leave codes for accuracy. | ||
- | |||
- | == Check Ethnic Code == | ||
- | DISPLAY ASTU LastName FirstName EthnicCode# | ||
- | |||
- | Every student should have an Ethnic Code. | ||
- | |||
- | == Check Gender == | ||
- | DISPLAY ASTU LastName FirstName Gender | ||
- | |||
- | Make sure all males are marked M (Male) and all females are marked F (Female). | ||
- | |||
- | == Check Birthdate == | ||
- | DISPLAY ASTU LastName FirstName Birthdate | ||
- | |||
- | Check the Birth Date field for accuracy, in particularly the year of birth. | ||
- | |||
- | == Check Free/ | ||
- | DISPLAY ASTU LastName FirstName FreeMeals# IF FreeMeals <> " " | ||
- | |||
- | This query will give you a list of all students who have either Free or Reduced marked in the Meals field. | ||
- | |||
- | == Check Limited English Proficiency/ | ||
- | DISPLAY AHLN ASTU LastName FirstName EngProf Language3 IF EngProf <> " " | ||
- | |||
- | If the EngProf (ESL) field in the Student Atom is greater than blank, the Language3 (Language Spoken to Student at Home) field in the Home Language Atom must be something other than English. | ||
- | |||
- | == Check Migrant == | ||
- | DISPLAY ASTU LastName FirstName Migrant if Migrant <> " " | ||
- | |||
- | Students should be marked Migrant unless they have a certificate of eligibility provided by the state of Virginia. | ||
- | |||
- | == Check Homeless == | ||
- | DISPLAY ASTU LastName FirstName Homeless IF Homeless <> " " | ||
- | |||
- | == Check Gifted == | ||
- | DISPLAY AGAT ASTU LastName FirstName GateDate General Specified# Visual PsyMotor if GateDate <> " " | ||
- | |||
- | The GateDate field should reflect the student’s date of referral. | ||
- | |||
- | == Check Title 1 == | ||
- | DISPLAY ASTU LastName FirstName UserCd7 if UserCd7 <> " " | ||
- | |||
- | This should be blank for all students in middle or high school or any other school that is not a Title I school. | ||
- | |||
- | == Check GED Program Code == | ||
- | DISPLAY ASTU LastName FirstName Grade UserCd4# if UserCd4 IN [5,8,9] | ||
- | |||
- | The UserCd4 (Diploma Tag) field should contain one of the two (GED, GED/ISAEP, not GAD) if they are in a GED program only. This should be blank for students in elementary or middle school. | ||
- | |||
- | == Check Aggregate Days Absent == | ||
- | DAILY - Elementary and Middle ONLY | ||
- | |||
- | Display ASTU AATD ID LN FN AbsDate AbsCode1 AbsCode2 IF AbsDate > LeaveDate AND LeaveDate > " " | ||
- | |||
- | PERIOD - High Schools ONLY | ||
- | |||
- | Display ASTU AATP ln fn id status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " " | ||
- | |||
- | Due to a bug in SASI, if a student is marked absent, then withdrawn before the last absence date, those absences are still counted against the school. | ||
- | |||
- | == Check Non Public FTE == | ||
- | DISPLAY ASTU LastName FirstName PctApport IF PctApport <> " " | ||
- | |||
- | Students containing a percentage amount in this field must be part time students taking two courses or less at your school. | ||
- | |||
- | |||