[MyQuery]
3531 "hopkimg9408" "Next Years Homeroom New" "Next Years Homeroom"
[END]
[MyQueryTables]
3531 3532 1 "EACH" "StuPriSchoolYear" no 0
3531 3535 2 "FIRST" "Student" no 0
3531 3538 3 "FIRST" "Person" no 0
3531 3540 4 "FIRST" "EntryWithdrawl" no 0
3531 3544 5 "FIRST" "EntryWithdrawlCodes" no 0
3531 3546 6 "FIRST" "EnrollStatus" no 0
3531 3549 7 "FIRST" "RoomCatalog" no 0
3531 3551 8 "FIRST" "Teacher" no 0
3531 3566 9 "FIRST" "gradeLevel" no 0
[END]
[MyQueryWhere]
3531 "WHERE" "" "gradeLevel" "gradeLevelSeq" "=" "StuPriSchoolYear" "gradeLevelSeq" "" "" 3567 "" 3566 1
3531 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "" "" "1" "" 3533 "" 3532 2
3531 "WHERE" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "" "" "1" "" 3534 "" 3532 1
3531 "AND" "" "Student" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 3536 "" 3535 2
3531 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3537 "" 3535 1
3531 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3539 "" 3538 1
3531 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/02/2015" "" 3541 "" 3540 2
3531 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2016" "" 3542 "" 3540 3
3531 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3543 "" 3540 1
3531 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3545 "" 3544 1
3531 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 3547 "" 3546 2
3531 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3548 "" 3546 1
3531 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "StuPriSchoolYear" "RoomCatalogSeq" "" "" 3550 "" 3549 1
3531 "OUTER-JOIN WHERE" "" "Teacher" "Homeroom" "=" "RoomCatalog" "RoomCatalogSeq" "" "" 3552 "" 3551 1
[END]
[MyQueryFields]
3531 3553 "Teacher" "PrintName" "" "X(20)" "Teacher's Name" no 5 0
3531 3554 "RoomCatalog" "RoomCode" "" "X(8)" "Next Year's Homeroom" no 4 0
3531 3555 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
3531 3556 "Person" "LastName" "" "x(15)" "Last Name" no 2 0
3531 3557 "Person" "FirstName" "" "x(15)" "First Name" no 3 0
3531 3568 "gradeLevel" "GradeLevel" "" "X(2)" "Grade Level" no 6 0
[END]
[MyQuerySort]
3531 3558 "Person" "FirstName" no "" 3 "" "" no
3531 3559 "Person" "LastName" no "" 2 "" "" no
3531 3560 "RoomCatalog" "RoomCode" yes "Count" 1 "" "" yes
[END]
[MyQueryDocs]
3531 3561 1 "Portrait" 0 "" ""
3531 3562 4 "" 0 "" ""
3531 3563 2 "Portrait" 0 "" ""
3531 3564 6 "Portrait" 0 "" ""
[END]