[MyQuery] 10097 "BCarraherSIS" "Course Lists with Guardian Email Addresses" " Course Lists with Guardian Email Addresses" [END] [MyQueryTables] 10097 10098 1 "EACH" "StuRequest" no 0 10097 10156 2 "FIRST" "StuTermCourse" no 0 10097 10101 3 "FIRST" "SchoolCourse" no 0 10097 10104 4 "FIRST" "Course" no 0 10097 10141 5 "FIRST" "CourseSection" no 0 10097 10162 6 "FIRST" "MasterSchoolSchedule" no 0 10097 10106 7 "FIRST" "Student" no 0 10097 10108 8 "FIRST" "Person" no 0 10097 10110 9 "FIRST" "EntryWithdrawl" no 0 10097 10114 10 "FIRST" "EntryWithdrawlCodes" no 0 10097 10116 11 "FIRST" "EnrollStatus" no 0 10097 10131 12 "EACH" "GuardianStudent" no 0 10097 10133 13 "FIRST" "bPerson" yes 0 10097 10135 14 "FIRST" "EmailPerson" no 0 [END] [MyQueryWhere] 10097 "WHERE" "" "CourseSection" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 10142 "" 10141 1 10097 "WHERE" "" "GuardianStudent" "studentId" "=" "StuRequest" "StudentID" "" "" 10132 "" 10131 1 10097 "WHERE" "" "bPerson" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 10134 "" 10133 1 10097 "WHERE" "" "EmailPerson" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 10136 "" 10135 1 10097 "WHERE" "" "StuRequest" "isScheduled" "=" "" "" "Yes" "" 10099 "" 10098 1 10097 "AND" "" "StuRequest" "CalendarYearSeq" "=" "" "" "28" "" 10100 "" 10098 2 10097 "WHERE" "" "SchoolCourse" "CalendarYearSeq" "=" "StuRequest" "CalendarYearSeq" "" "" 10102 "" 10101 1 10097 "AND" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 10103 "" 10101 2 10097 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 10105 "" 10104 1 10097 "Where" "" "Student" "StudentID" "=" "StuRequest" "StudentID" "" "" 10107 "" 10106 1 10097 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 10109 "" 10108 1 10097 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/29/2018" "" 10111 "" 10110 2 10097 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2019" "" 10112 "" 10110 3 10097 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "StuRequest" "StudentID" "" "" 10113 "" 10110 1 10097 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 10115 "" 10114 1 10097 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 10117 "" 10116 1 10097 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 10118 "" 10116 2 10097 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 10140 "" 10110 4 10097 "WHERE" "" "StuTermCourse" "CalendarYearSeq" "=" "StuRequest" "CalendarYearSeq" "" "" 10157 "" 10156 1 10097 "AND" "" "Course" "CourseTitle" "=" "" "" "E1011" "" 10167 "" 10104 2 10097 "AND" "(" "GuardianStudent" "LivesWStudent" "=" "" "" "True" "" 10143 "" 10131 2 10097 "AND" "" "StuTermCourse" "StudentID" "=" "StuRequest" "StudentID" "" "" 10158 "" 10156 2 10097 "AND" "" "StuTermCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 10159 "" 10156 3 10097 "AND" "" "CourseSection" "CourseSectionSeq" "=" "StuTermCourse" "CourseSectionSeq" "" "" 10161 "" 10141 2 10097 "WHERE" "" "MasterSchoolSchedule" "CalendarYearSeq" "=" "StuRequest" "CalendarYearSeq" "" "" 10163 "" 10162 1 10097 "AND" "" "MasterSchoolSchedule" "CourseSectionSeq" "=" "CourseSection" "CourseSectionSeq" "" "" 10164 "" 10162 2 10097 "AND" "" "MasterSchoolSchedule" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 10165 "" 10162 3 10097 "AND" "" "GuardianStudent" "ReceivesMail" "=" "" "" "True" ")" 10166 "" 10131 3 [END] [MyQueryFields] 10097 10137 "bPerson" "LastName" "" "x(15)" "Last Name" no 8 0 10097 10138 "bPerson" "FirstName" "" "x(15)" "First Name" no 9 0 10097 10139 "EmailPerson" "EmailAddress" "" "x(30)" "Email Address" no 10 0 10097 10119 "Course" "CourseTitle" "" "X(15)" "Course ID" no 1 0 10097 10120 "Course" "CourseName" "" "X(10)" "Name" no 2 0 10097 10121 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 4 0 10097 10122 "Student" "GradeLevel" "" "X(2)" "GL" no 5 0 10097 10123 "Person" "LastName" "" "x(15)" "Last Name" no 6 0 10097 10124 "Person" "FirstName" "" "x(15)" "First Name" no 7 0 10097 10144 "CourseSection" "CourseSecDesc" "" "x(2)" "Course Sec" no 3 0 [END] [MyQuerySort] 10097 10125 "Course" "CourseTitle" yes "Count" 1 "" "" no 10097 10145 "CourseSection" "CourseSecDesc" yes "Count" 2 "" "" no 10097 10126 "Person" "FirstName" no "" 4 "" "" no 10097 10127 "Person" "LastName" no "" 3 "" "" no [END] [MyQueryDocs] 10097 10128 2 "" 0 "" "" 10097 10129 6 "" 0 "" "" 10097 10130 4 "" 0 "" "" [END]