[MyQuery]
1087 "cpsimg9408" "Next Years School and Grade Level" "Next Years School and Grade Leve"
[END]
[MyQueryTables]
1087 1088 1 "EACH" "StuPriSchoolYear" no 0
1087 1091 2 "FIRST" "Student" no 0
1087 1094 3 "FIRST" "Person" no 0
1087 1096 4 "FIRST" "EntryWithdrawl" no 0
1087 1100 5 "FIRST" "EntryWithdrawlCodes" no 0
1087 1102 6 "FIRST" "EnrollStatus" no 0
1087 1105 7 "FIRST" "RoomCatalog" no 0
1087 1107 8 "FIRST" "Teacher" no 0
1087 1109 9 "FIRST" "gradeLevel" no 0
1087 1124 10 "FIRST" "SchoolProfile" no 0
[END]
[MyQueryWhere]
1087 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "" "" "1" "" 1089 "" 1088 2
1087 "WHERE" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "" "" "25" "" 1090 "" 1088 1
1087 "AND" "" "Student" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 1092 "" 1091 2
1087 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 1093 "" 1091 1
1087 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 1095 "" 1094 1
1087 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2015" "" 1097 "" 1096 2
1087 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2016" "" 1098 "" 1096 3
1087 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 1099 "" 1096 1
1087 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 1101 "" 1100 1
1087 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 1103 "" 1102 2
1087 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 1104 "" 1102 1
1087 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "StuPriSchoolYear" "RoomCatalogSeq" "" "" 1106 "" 1105 1
1087 "OUTER-JOIN WHERE" "" "Teacher" "Homeroom" "=" "RoomCatalog" "RoomCatalogSeq" "" "" 1108 "" 1107 1
1087 "WHERE" "" "gradeLevel" "gradeLevelSeq" "=" "StuPriSchoolYear" "gradeLevelSeq" "" "" 1110 "" 1109 1
1087 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 1125 "" 1124 1
[END]
[MyQueryFields]
1087 1113 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
1087 1114 "Person" "LastName" "" "x(15)" "Last Name" no 2 0
1087 1115 "Person" "FirstName" "" "x(15)" "First Name" no 3 0
1087 1116 "gradeLevel" "GradeLevel" "" "X(2)" "Grade Level" no 4 0
1087 1126 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 5 0
[END]
[MyQuerySort]
1087 1117 "Person" "FirstName" no "" 2 "" "" no
1087 1118 "Person" "LastName" no "" 1 "" "" no
[END]
[MyQueryDocs]
1087 1120 1 "Portrait" 0 "" ""
1087 1121 4 "" 0 "" ""
1087 1122 2 "Portrait" 0 "" ""
1087 1123 6 "Portrait" 0 "" ""
[END]