User Tools

Site Tools


sasixp:spring_report_queries

This is an old revision of the document!


Spring Records Collection Queries

The following queries will help review SASI data due on the Spring report for accuracy. Be sure to always select “Show Inactive Records” when performing these queries as inactive students are to be included in this report.

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/Tuition Paid Code

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/Reduced Meals

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/Home Language

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. Any other field should contain information ONLY if the student is actually in the Gifted program.

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. As a result there is a state funding penalty. No student should have absences after their withdrawal date. If you find these errors, you will need to contact the SASI administrator in the central office - you will not be able to fix these on your own.

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.

sasixp/spring_report_queries.1163597445.txt.gz · Last modified: 2006/11/17 09:11 (external edit)