This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
sasixp:eoy_report_queries [2007/07/26 15:36] ginac |
sasixp:eoy_report_queries [2007/07/26 15:50] ginac |
||
---|---|---|---|
Line 5: | Line 5: | ||
The following queries will help review SASI data due on the End of Year report for accuracy. | The following queries will help review SASI data due on the End of Year report for accuracy. | ||
- | NOTES: | + | Notes: |
- | - In queries that contain | + | - In queries that contain |
- 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. | ||
- | === Check for Blank State Testing Identifier (M) === | + | |
+ | |||
+ | |||
+ | === *Check for Blank State Testing Identifier (M) === | ||
DISPLAY ASTU PermNum LastName FirstName StateID | DISPLAY ASTU PermNum LastName FirstName StateID | ||
- | === Check Unique Local Student Identifier (M) === | + | === *Check Unique Local Student Identifier (M) === |
DISPLAY ASTU PermNum LastName FirstName | DISPLAY ASTU PermNum LastName FirstName | ||
- | === Check Responsible Division/ | + | === *Check Responsible Division/ |
DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3 | DISPLAY ASTU PermNum LastName FirstName UserCd2 UserCd3 | ||
Line 30: | Line 33: | ||
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/ | === Check Serving Division/ | ||
Line 37: | Line 38: | ||
The Serving Div (AltID1) and the Serving Sch (AltID2) field’s should be blank if the Tuition Tag (UserCD3) is blank (no tuition). | The Serving Div (AltID1) and the Serving Sch (AltID2) field’s should be blank if the Tuition Tag (UserCD3) is blank (no tuition). | ||
- | |||
=== Check Active Status (M) === | === Check Active Status (M) === | ||
Line 43: | Line 43: | ||
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 51: | ||
- | 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 | + | DISPLAY ASTU PermNum LastName FirstName |
- | 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. | 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. | ||
Line 103: | Line 93: | ||
- | Check Limited English Proficiency/ | + | === Check Limited English Proficiency/ |
- | + | DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3 | |
- | DISPLAY AHLN ASTU PermNum LastName FirstName EngProf Language3 | + | |
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 101: | ||
- | 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. | The GateDate field should reflect the student’s date of referral. | ||
- | + | === 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/ | The UserCd4 (Diploma Tag) field should contain one of the two (GED(5), GED/ | ||
- | Check Graduate/ | + | === Check Graduate/ |
+ | 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). | 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). | ||
- | + | === 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 |
- | DISPLAY ACLS | + | |
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 136: | ||
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, | |
- | DISPLAY ACLH ASTU ACRS 2, | + | |
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 149: | ||
- | Check Dual Enrollment (Classes) | + | === Check Dual Enrollment (Classes) |
- | + | DISPLAY ACLS | |
- | DISPLAY ACLS | + | |
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 156: | ||
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 169: | ||
- | Check CTE Finisher (M) | + | === Check CTE Finisher (M) === |
- | + | DISPLAY AVOC ASTU PermNum LastName FirstName | |
- | DISPLAY AVOC ASTU PermNum LastName FirstName | + | |
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 = " | |
- | DISPLAY ASTU PermNum LastName FirstName LeaveCode UserCd1 IF LeaveCode | + | |
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 | ||
+ | DISPLAY AENR ASTU 2,Status PermNum | ||
- | Check Summer Dropouts (M) | + | DISPLAY AENR ASTU 2,Status PermNum |
- | + | ||
- | DISPLAY ASTU PermNum LastName FirstName | + | |
- | + | ||
- | DISPLAY AENR ASTU 2,Status PermNum | + | |
- | + | ||
- | DISPLAY AENR ASTU 2,Status PermNum | + | |
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 195: | ||
- | Check Aggregate Days Present/ | + | === Check Aggregate Days Present/ |
- | + | DISPLAY AATD | |
- | DISPLAY AATD | + | |
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/ | + | === Check Aggregate Days Present/ |
- | + | DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate AllDayAbs IF PeriodDate > LeaveDate AND LeaveDate > " " | |
- | DISPLAY AATP ASTU PermNum LastName FirstName 2,Status PeriodDate | + | |
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 208: | ||
- | Check Retention Flag (M) | + | === Check Retention Flag (M) === |
- | + | DISPLAY ASTU PERMNUM | |
- | DISPLAY ASTU PERMNUM | + | |
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 | |
- | DISPLAY ACNF | + | |
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 222: | ||
- | 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 | + | DISPLAY ASTU PermNum LastName FirstName |
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 > " | |
- | DISPLAY ASTU PermNum LastName FirstName BirthDate if BirthDate > " | + | |
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 | |
- | DISPLAY ASTU PermNum LastName FirstName | + | |
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 | |
- | DISPLAY ACRS | + | |
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 = " | |
- | DISPLAY ASTU PermNum LastName FirstName InstrSet UserCd6 UserCd6# | + | |
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. | ||