Knowledge Base

User Tools

Site Tools

You are here: Knowledge Base » sasixp » eoy_report_queries
sasixp:eoy_report_queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
sasixp:eoy_report_queries [2007/07/26 15:36]
ginac 		sasixp:eoy_report_queries [2016/05/16 10:37]
jlester removed
Line 5: Line 5:
 The following queries will help review SASI data due on the End of Year 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.  Those that have an (M) next to them can be check by doing a matrix as well.  The following queries will help review SASI data due on the End of Year 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.  Those that have an (M) next to them can be check by doing a matrix as well. 
  
-NOTES:   +Notes: 
-  - In queries that contain “ “ there is a space between each quotation mark.+  - In queries that contain " " there is a space between each quotation mark.
   - For queries that begin with XXXX ASTU, where XXXX indicates different file names, link ASTU to XXXX by dragging Stulink from the XXXX column to the field above the second column.   - For queries that begin with XXXX ASTU, where XXXX indicates different file names, link ASTU to XXXX by dragging Stulink from the XXXX column to the field above the second column.
   - All schools must run all queries to make sure nothing is in the fields that don’t apply.   - All schools must run all queries to make sure nothing is in the fields that don’t apply.
Line 30: Line 30:
  
 The Resp. Sch (usernum5) should be blank unless student resides in Johnson County, TN (usercd2) in which the code will be 8888. The Resp. Sch (usernum5) should be blank unless student resides in Johnson County, TN (usercd2) in which the code will be 8888.
- 
- 
  
 === Check Serving Division/School (M) === === Check Serving Division/School (M) ===
Line 37: Line 35:
  
 The Serving Div (AltID1) and the Serving Sch (AltID2) field’s should be blank if the Tuition Tag (UserCD3) is blank (no tuition).  If the Tuition Tag is greater than blank the Serving Div and Serving Sch fields should contain the appropriate data.   The Serving Div (AltID1) and the Serving Sch (AltID2) field’s should be blank if the Tuition Tag (UserCD3) is blank (no tuition).  If the Tuition Tag is greater than blank the Serving Div and Serving Sch fields should contain the appropriate data.  
- 
  
 === Check Active Status (M) === === Check Active Status (M) ===
Line 43: Line 40:
  
 If student does not have an Enter or Leave Code their status must be N.  Do a matrix to check that every student without an enter/leave code is tagged with an N (no show).   If student does not have an Enter or Leave Code their status must be N.  Do a matrix to check that every student without an enter/leave code is tagged with an N (no show).  
- +=== Check Enter Code/Leave Code/Date (M) ===
- +
-Check Enter Code/Leave Code/Date (M) +
 DISPLAY AENR ASTU PermNum LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF  TransYear = “06”   DISPLAY AENR ASTU PermNum LastName FirstName 1,EnterCode 1,LeaveCode EffDate IF  TransYear = “06”  
  
Line 54: Line 48:
  
  
-Check Ethnic Code (M) +=== Check Ethnic Code (M) === 
- +DISPLAY ASTU PermNum LastName FirstName EthnicCode#
- DISPLAY ASTU PermNum LastName FirstName EthnicCode#+
  
 Every student should have an Ethnic Code. Every student should have an Ethnic Code.
  
  
-Check Gender (M) +=== Check Gender (M) === 
- +DISPLAY ASTU PermNum LastName FirstName Gender
- DISPLAY ASTU PermNum LastName FirstName Gender+
  
 Make sure all male students are marked M (Male) and all female students are marked F (Female). Make sure all male students are marked M (Male) and all female students are marked F (Female).
  
  
-Check Birthdate (M) +=== Check Birthdate (M) === 
- +DISPLAY ASTU PermNum LastName FirstName Grade Birthdate 
- DISPLAY ASTU PermNum LastName FirstName Grade Birthdate +
 Check the Birth Date field for accuracy, in particularly the year of birth. Check the Birth Date field for accuracy, in particularly the year of birth.
  
- +=== Check Grade Level (M) === 
-Check Grade Level (M) +DISPLAY ASTU PermNum LastName FirstName Grade
- +
- DISPLAY ASTU PermNum LastName FirstName Grade+
  
 Check that there are no grades outside of your school’s grade range. Check that there are no grades outside of your school’s grade range.
  
  
-Check Disability Code (M) +=== Check Disability Code (M) === 
- +DISPLAY ASTU PermNum LastName FirstName InstrSet IF InstrSet <> “ “
- DISPLAY ASTU PermNum LastName FirstName InstrSet IF InstrSet <> “ “+
  
 All special education students should have a primary disability code (InstrSet). All special education students should have a primary disability code (InstrSet).
  
  
-Check Free Meals +=== Check Free Meals === 
- +DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " "
- DISPLAY ASTU PermNum LastName FirstName FreeMeals# IF FreeMeals <> " "+
  
- DISPLAY ASTU PermNum LastName FirstName Homeless IF Homeless = “X”+DISPLAY ASTU PermNum LastName FirstName Homeless IF Homeless = “X”
  
- DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = “X”+DISPLAY ASTU PermNum LastName FirstName Migrant IF Migrant = “X”
  
 These queries will give you a list of all students who have either Free or Reduced lunch, are tagged Homeless, or are tagged Migrant, which indicates a disadvantaged student.  Check that these lists are accurate.  Though Homeless and Migrant aren’t a part of the EOY report they do affect the Disadvantaged flag.   These queries will give you a list of all students who have either Free or Reduced lunch, are tagged Homeless, or are tagged Migrant, which indicates a disadvantaged student.  Check that these lists are accurate.  Though Homeless and Migrant aren’t a part of the EOY report they do affect the Disadvantaged flag.  
Line 103: Line 90:
  
  
-Check Limited English Proficiency/Home Language/Country of Birth (M) +=== Check Limited English Proficiency/Home Language/Country of Birth (M) === 
- +DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3  CntryCode IF EngProf <> " "
- DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3  CntryCode IF EngProf <> " "+
  
 Link ASTU by dragging Stulink from the AHLN column to the field above the second column. Link ASTU by dragging Stulink from the AHLN column to the field above the second column.
Line 112: Line 98:
  
  
-Check Gifted +=== Check Gifted ===
 DISPLAY AGAT ASTU LastName FirstName GateDate General Specified# Visual PsyMotor if GateDate <> " " 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 student has been placed in the Gifted program.  The PsyMotor field indicates students who are talented through Technical/Practical Arts. The GateDate field should reflect the student’s date of referral.  Any other field should contain information only if student has been placed in the Gifted program.  The PsyMotor field indicates students who are talented through Technical/Practical Arts.
  
- +=== Check Title 1 (All Schools) === 
-Check Title 1 (All Schools) +DISPLAY ASTU PermNum LastName FirstName Grade UserCd7 if UserCd7 <> " "
- +
- DISPLAY ASTU PermNum LastName FirstName Grade UserCd7 if UserCd7 <> " "+
  
 Middle/High make sure nothing is in this field for grades greater than 02. Middle/High make sure nothing is in this field for grades greater than 02.
  
  
-Check GED Program Code (All Schools) +=== Check GED Program Code (All Schools) === 
- +DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 IF UserCd4 IN [5,8,9]
- DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 IF  UserCd4 IN [5,8,9]+
  
 The UserCd4 (Diploma Tag) field should contain one of the two (GED(5), GED/ISAEP(8), not GAD(9)) if they are in a GED program regardless of grade.  Elem/Middle make sure nothing is in this field. The UserCd4 (Diploma Tag) field should contain one of the two (GED(5), GED/ISAEP(8), not GAD(9)) if they are in a GED program regardless of grade.  Elem/Middle make sure nothing is in this field.
  
  
-Check Graduate/Other Completer+=== Check Graduate/Other Completer === 
 +DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 InstrSet IF Grade = “12”
  
- DISPLAY ASTU PermNum LastName FirstName Grade UserCd4# UserCd4 InstrSet IF Grade = “12” 
-  
 The UserCd4 (Diploma Tag) field should be greater than blank if grade = 12.  If Diploma Tag = 3, 7, or 10 student must have Disability Code (InstrSet).  If Diploma Tag = 10, or 11 student must be a senior. The UserCd4 (Diploma Tag) field should be greater than blank if grade = 12.  If Diploma Tag = 3, 7, or 10 student must have Disability Code (InstrSet).  If Diploma Tag = 10, or 11 student must be a senior.
  
- +=== Check Graduation Plan(M) === 
-Check Graduation Plan(M) +DISPLAY ASTU PermNum LastName FirstName Grade PostSecond IF Grade = “12”
- +
- DISPLAY ASTU PermNum LastName FirstName Grade PostSecond IF Grade =  “12”+
  
 The GradPln (PostSecond) field should be greater than blank if grade = 12. The GradPln (PostSecond) field should be greater than blank if grade = 12.
  
  
-Check Advanced Placement (Classes) +=== Check Advanced Placement (Classes) === 
-     +DISPLAY ACLS  ASTU AMST ACRS  2,Status  PermNum  LastName  FirstName  UserNum2  Title IF  NonAcadem = "A"
- DISPLAY ACLS  ASTU AMST ACRS  2,Status  PermNum  LastName  FirstName   UserNum2  Title IF  NonAcadem = "A"+
  
 Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column.   Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column.  
Line 155: Line 133:
 If a student is currently enrolled in an AP course they must have 1, 2, or 3 marked in the UserNum2 field in the Student atom.  This query’s accuracy depends on the AP courses being marked with an A (Advanced Placement) in the N/H field in the Course atom. If a student is currently enrolled in an AP course they must have 1, 2, or 3 marked in the UserNum2 field in the Student atom.  This query’s accuracy depends on the AP courses being marked with an A (Advanced Placement) in the N/H field in the Course atom.
  
- DISPLAY ASTU PermNum LastName FirstName UserNum2 IF UserNum2 <> “ “+DISPLAY ASTU PermNum LastName FirstName UserNum2 IF UserNum2 <> “ “
  
 This query is for middle/elem schools to make sure nothing is in the Advanced Placement (UserNum2) field in the Student atom. This query is for middle/elem schools to make sure nothing is in the Advanced Placement (UserNum2) field in the Student atom.
  
  
-Check Advanced Placement (Class History) +=== Check Advanced Placement (Class History) === 
-  +DISPLAY ACLH ASTU ACRS 2,Status  PermNum LastName FirstName UserNum2 Title IF  NonAcadem = "A"
- DISPLAY ACLH ASTU ACRS 2,Status  PermNum LastName FirstName UserNum2  Title IF  NonAcadem = "A"+
  
 Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column.   Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column.  
Line 169: Line 146:
  
  
-Check Dual Enrollment (Classes) +=== Check Dual Enrollment (Classes) === 
- +DISPLAY ACLS  ASTU AMST ACRS  2,Status PermNum LastName FirstName Title CollArea1 IF  CollArea1 <> " "
- DISPLAY ACLS  ASTU AMST ACRS  2,Status PermNum LastName FirstName Title  CollArea1 IF  CollArea1 <> " "+
  
 Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column.   Link ASTU to ACLS by dragging StuLink from the ACLS file to field above the second column, then link AMST by dragging ClassLink from the ACLS file to the field above the third column, then link ACRS by dragging Course from the AMST file to the field above the fourth column.  
Line 177: Line 153:
 If a student is currently enrolled in a Dual Enrollment course they must be on this list.  This query’s accuracy depends on each Dual Enrollment course being marked greater than blank in the Dual Enrollment (CollArea1) field in the Course atom. If a student is currently enrolled in a Dual Enrollment course they must be on this list.  This query’s accuracy depends on each Dual Enrollment course being marked greater than blank in the Dual Enrollment (CollArea1) field in the Course atom.
  
- DISPLAY ACRS Title CollArea1 IF CollArea1 <> “ “+DISPLAY ACRS Title CollArea1 IF CollArea1 <> “ “
  
 This query is for middle/elem to check the Course file to make sure no courses are marked as dual enrollment courses. This query is for middle/elem to check the Course file to make sure no courses are marked as dual enrollment courses.
  
  
-Check Dual Enrollment (Class History) +=== Check Dual Enrollment (Class History) === 
- +DISPLAY ACLH ASTU ACRS 2,Status PermNum LastName FirstName Title CollArea1 IF  CollArea1 <> " "
- DISPLAY ACLH ASTU ACRS 2,Status PermNum LastName FirstName Title  CollArea1 IF  CollArea1 <> " "+
  
 Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column.   Link ASTU by dragging StuLink from the ACLH file to the field above the second column, and then link ACRS by dragging Course from the ACLH file to the field above the third column.  
Line 191: Line 166:
  
  
-Check CTE Finisher (M) +=== Check CTE Finisher (M) === 
- +DISPLAY AVOC ASTU PermNum LastName FirstName  CarTech  Technical  CmpStat  CipNo
- DISPLAY AVOC ASTU PermNum LastName FirstName  CarTech  Technical   CmpStat  CipNo+
  
 This is a list of students who have one or the other markings in the Vocation Ed atom.  Use this list to verify that they are marked correctly. This is a list of students who have one or the other markings in the Vocation Ed atom.  Use this list to verify that they are marked correctly.
  
  
-Check W8 Reason (M) +=== Check W8 Reason (M) === 
- +DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF LeaveCode = "W8"
- DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF LeaveCode  = "W8"+
  
 All students with a droupout (W8) code must have a W8 Reason in the UserCd1 field. All students with a droupout (W8) code must have a W8 Reason in the UserCd1 field.
  
- DISPLAY ASTU PermNum LastName FirstName UserCd1 LeaveCode IF UserCd1 <>  “ “+DISPLAY ASTU PermNum LastName FirstName UserCd1 LeaveCode IF UserCd1 <> “ “
  
 No student should have a W8 Reason code if they are not dropouts. No student should have a W8 Reason code if they are not dropouts.
 +=== Check Summer Dropouts (M) ===
 +DISPLAY ASTU PermNum LastName FirstName  Retain IF  Retain <> " "
  
 +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"
  
-Check Summer Dropouts (M) +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 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"+
  
 Link ASTU by dragging StuLink from the AENR file to the field above the second column. Link ASTU by dragging StuLink from the AENR file to the field above the second column.
Line 222: Line 192:
  
  
-Check Aggregate Days Present/Absent (Elem/Middle) (Hidden Abs query) +=== Check Aggregate Days Present/Absent (Elem/Middle) (Hidden Abs query) === 
- +DISPLAY AATD  ASTU PermNum LastName FirstName 2,Status AbsDate  AllDayAbs IF AbsDate > LeaveDate AND LeaveDate > " "
- DISPLAY AATD  ASTU PermNum LastName FirstName 2,Status AbsDate  AllDayAbs IF AbsDate > LeaveDate AND LeaveDate > " "+
  
 Link ASTU by dragging StuLink from the AATD file to the field above the second column. Link ASTU by dragging StuLink from the AATD file to the field above the second column.
  
-Check Aggregate Days Present/Absent (High) (Hidden Abs query) +=== Check Aggregate Days Present/Absent (High) (Hidden Abs query) === 
- +DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " "
- DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate  AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " "+
  
 Link ASTU by dragging StuLink from the AATP file to the field above the second column. Link ASTU by dragging StuLink from the AATP file to the field above the second column.
Line 237: Line 205:
  
  
-Check Retention Flag (M) +=== Check Retention Flag (M) === 
- +DISPLAY ASTU PERMNUM  LastName  FirstName  NextGrade IF NextGrade <> " "
- DISPLAY ASTU PERMNUM  LastName  FirstName  NextGrade IF NextGrade <> " "+
  
 If a student is to repeat their current grade next year or will not be promoted until after summer school completion they should have their current grade in the NextGrade field indicating that he/she is Retained. If a student is to repeat their current grade next year or will not be promoted until after summer school completion they should have their current grade in the NextGrade field indicating that he/she is Retained.
  
  
-Check Truancy Conferences +=== Check Truancy Conferences === 
- +DISPLAY ACNF  ASTU ACNR LastName  FirstName  ReportDate  Descript IF  DescCode = ATT AND ReportDate > 081606
- DISPLAY ACNF  ASTU ACNR LastName  FirstName  ReportDate  Descript IF   DescCode = ATT+
  
 Link ASTU by dragging StuLink from the ACNF column to the field above the second column, then link ACNR by dragging DescCode from the ACNF column to the field above the third column. Link ASTU by dragging StuLink from the ACNF column to the field above the second column, then link ACNR by dragging DescCode from the ACNF column to the field above the third column.
Line 253: Line 219:
  
  
-Check Non Public FTE (M) +=== Check Non Public FTE (M) === 
- +DISPLAY ASTU PermNum LastName FirstName PctApport IF PctApport <> " "
- DISPLAY ASTU PermNum 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. Students containing a percentage amount in this field must be part time students taking two courses or less at your school.
 Check First Year In Ninth Grade (High) Check First Year In Ninth Grade (High)
  
- DISPLAY ASTU PermNum LastName FirstName  NextTrack IF Grade = "09"+DISPLAY ASTU PermNum LastName FirstName  NextTrack IF Grade = "09"
  
 All 9th graders must have either 1,2,3, or 4 entered into the 9thTrk (NextTrack) field. All 9th graders must have either 1,2,3, or 4 entered into the 9thTrk (NextTrack) field.
  
  
-Check Kindergarten Readiness Assessment  +=== Check Kindergarten Readiness Assessment === 
- +DISPLAY ASTU PermNum LastName FirstName BirthDate if BirthDate > "100101" and Grade = "KG"
- DISPLAY ASTU PermNum LastName FirstName BirthDate if BirthDate > "100101"  and Grade = "KG"+
  
 If a student is on this list email those names to jrhea@wcs.k12.va.us indicating whether or not those students were administered the readiness assessment. If a student is on this list email those names to jrhea@wcs.k12.va.us indicating whether or not those students were administered the readiness assessment.
  
  
-Check Early College School Program Code  +=== Check Early College School Program Code === 
- +DISPLAY ASTU PermNum LastName FirstName  AttPrmCode IF  AttPrmCode <> " "
- DISPLAY ASTU PermNum LastName FirstName  AttPrmCode IF  AttPrmCode <> " "+
  
 This query gives you a list of students who have either signed the Early College Scholar Agreement (1) or have earned the Early College Scholar Certificate (2) This query gives you a list of students who have either signed the Early College Scholar Agreement (1) or have earned the Early College Scholar Certificate (2)
  
  
-Check Distance Learning  +=== Check Distance Learning === 
- +DISPLAY ACRS  Title  Category IF Category <> " "
- DISPLAY ACRS  Title  Category IF Category <> " "+
  
 This list gives you the courses in the Course atom that are flagged as distance learning. This list gives you the courses in the Course atom that are flagged as distance learning.
  
  
-Check PK Experience Code/PK Weekly Time Code +=== Check PK Experience Code/PK Weekly Time Code === 
- +DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# UserNum1 if Grade = "PK"
- DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6#   UserNum1 if Grade = "PK"+
  
 All PK students must have a PK Experience Code and PK Weekly Time Code. All PK students must have a PK Experience Code and PK Weekly Time Code.
  
  
-Check Student Name +=== Check Student Name === 
- +DISPLAY ASTU PermNum LastName FirstName MiddleName
- DISPLAY ASTU PermNum LastName FirstName MiddleName+
  
 Every student should have a first, middle, and last name if applicable. Every student should have a first, middle, and last name if applicable.
  
  

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki