[MyQuery]
5189 "apsimg9408" "Covid Class Lists" "Covid Class Lists"
[END]
[MyQueryTables]
5189 5190 1 "EACH" "StuPriSchoolYear" no 0
5189 5192 2 "EACH" "StuRequest" no 0
5189 5196 3 "EACH" "StuTermCourse" no 0
5189 5200 4 "FIRST" "SchoolCourse" no 0
5189 5202 5 "FIRST" "Course" no 0
5189 5204 6 "FIRST" "CourseSection" no 0
5189 5207 7 "FIRST" "Student" no 0
5189 5209 8 "FIRST" "Person" no 0
5189 5211 9 "FIRST" "SchoolProfile" no 0
5189 5213 10 "FIRST" "SchoolTerm" no 0
5189 5216 11 "FIRST" "EntryWithdrawl" no 0
5189 5220 12 "FIRST" "EntryWithdrawlCodes" no 0
5189 5222 13 "FIRST" "EnrollStatus" no 0
5189 5225 14 "FIRST" "Terms" no 0
5189 5248 15 "FIRST" "MasterSchoolSchedule" no 0
5189 5246 16 "FIRST" "StuSchedule" no 0
5189 5253 17 "FIRST" "SchoolPeriods" no 0
5189 5258 18 "FIRST" "StuTechEd" no 0
5189 5260 19 "FIRST" "SchoolTechedWeeks" no 0
[END]
[MyQueryWhere]
5189 "OUTER-JOIN WHERE" "" "StuTechEd" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 5259 "" 5258 1
5189 "OUTER-JOIN WHERE" "" "SchoolTechedWeeks" "TechEdWeekSeq" "=" "StuTechEd" "TechEdWeekSeq" "" "" 5261 "" 5260 1
5189 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 5212 "" 5211 1
5189 "WHERE" "" "SchoolTerm" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 5214 "" 5213 1
5189 "AND" "" "SchoolTerm" "SchoolTermSeq" "=" "StuTermCourse" "SchoolTermSeq" "" "" 5215 "" 5213 2
5189 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5221 "" 5220 1
5189 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "07/01/2018" "" 5217 "" 5216 2
5189 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/30/2019" "" 5218 "" 5216 3
5189 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "StuRequest" "StudentID" "" "" 5219 "" 5216 1
5189 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5223 "" 5222 1
5189 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5224 "" 5222 2
5189 "WHERE" "" "Terms" "TermSeq" "=" "SchoolTerm" "TermSeq" "" "" 5226 "" 5225 1
5189 "WHERE" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "" "" "41" "" 5191 "" 5190 1
5189 "WHERE" "" "StuRequest" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 5193 "" 5192 1
5189 "AND" "" "StuRequest" "isScheduled" "=" "" "" "yes" "" 5194 "" 5192 2
5189 "AND" "" "StuRequest" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 5195 "" 5192 3
5189 "AND" "" "StuTermCourse" "CalendarYearSeq" "=" "StuRequest" "CalendarYearSeq" "" "" 5197 "" 5196 2
5189 "AND" "" "StuTermCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 5198 "" 5196 3
5189 "WHERE" "" "StuTermCourse" "StudentID" "=" "StuRequest" "StudentID" "" "" 5199 "" 5196 1
5189 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 5201 "" 5200 1
5189 "Where" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 5203 "" 5202 1
5189 "WHERE" "" "CourseSection" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 5205 "" 5204 1
5189 "AND" "" "CourseSection" "CourseSectionSeq" "=" "StuTermCourse" "CourseSectionSeq" "" "" 5206 "" 5204 2
5189 "WHERE" "" "Student" "StudentID" "=" "StuRequest" "StudentID" "" "" 5208 "" 5207 1
5189 "WHERE" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5210 "" 5209 1
5189 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "" "" "1" "" 5240 "" 5190 2
5189 "AND" "" "Terms" "TermAbbr" "=" "" "" "Q1" "" 5241 "" 5225 2
5189 "WHERE" "" "StuSchedule" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 5247 "" 5246 1
5189 "WHERE" "" "MasterSchoolSchedule" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 5249 "" 5248 1
5189 "AND" "" "MasterSchoolSchedule" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 5250 "" 5248 2
5189 "AND" "" "MasterSchoolSchedule" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 5251 "" 5248 3
5189 "AND" "" "StuSchedule" "ScheduleSeq" "=" "MasterSchoolSchedule" "ScheduleSeq" "" "" 5252 "" 5246 2
5189 "WHERE" "" "SchoolPeriods" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 5254 "" 5253 1
5189 "AND" "" "SchoolPeriods" "SchoolPeriodsSeq" "=" "StuSchedule" "SchoolPeriodsSeq" "" "" 5255 "" 5253 2
[END]
[MyQueryFields]
5189 5262 "SchoolTechedWeeks" "CycleWeek" "" "X" "Team" no 10 0
5189 5263 "SchoolTechedWeeks" "TechEdWeekDesc" "" "X(8)" "Team Description" no 11 0
5189 5227 "CourseSection" "CourseSecDesc" "" "x(2)" "Sectionid" no 7 0
5189 5228 "Course" "CourseTitle" "" "X(15)" "Courseid" no 6 0
5189 5256 "SchoolPeriods" "PeriodTitle" "" "X(8)" "Period" no 9 0
5189 5229 "Student" "SASID" "" "X(10)" "Studentid" no 2 0
5189 5230 "SchoolProfile" "SchoolCode" "" "X(3)" "organizationid" no 1 0
5189 5231 "Terms" "TermAbbr" "" "X(2)" "Term" no 8 0
5189 5242 "Person" "LastName" "" "x(15)" "Last Name" no 3 0
5189 5243 "Person" "FirstName" "" "x(15)" "First Name" no 4 0
5189 5244 "Student" "GradeLevel" "" "X(2)" "Grade Level" no 5 0
[END]
[MyQuerySort]
5189 5232 "Course" "CourseTitle" no "" 1 "" "" no
5189 5233 "Person" "FirstName" no "" 5 "" "" no
5189 5234 "Person" "LastName" no "" 4 "" "" no
5189 5245 "Student" "GradeLevel" no "" 3 "" "" no
5189 5235 "Terms" "TermAbbr" no "" 2 "" "" no
[END]
[MyQueryDocs]
5189 5236 2 "Portrait" 0 "" ""
5189 5237 6 "Portrait" 0 "" ""
5189 5238 1 "Portrait" 0 "" ""
5189 5239 4 "" 0 "" ""
[END]