[MyQuery] 3977 "gdrsdimg9408" "iStudent Accounts Enrolled" "iStudent Accounts Enrolled" [END] [MyQueryTables] 3977 3978 1 "EACH" "CalendarYear" no 0 3977 3980 2 "FIRST" "gradeLevel" no 0 3977 3982 3 "EACH" "StuPriSchoolYear" no 0 3977 3986 4 "FIRST" "Student" no 0 3977 3988 5 "FIRST" "Person" no 0 3977 3990 6 "EACH" "Users" no 0 3977 4007 7 "FIRST" "EntryWithdrawl" no 0 3977 4009 8 "FIRST" "EntryWithdrawlCodes" no 0 3977 4011 9 "FIRST" "EnrollStatus" no 0 [END] [MyQueryWhere] 3977 "WHERE" "" "CalendarYear" "AcademicYear" "=" "" "" "2014-2015" "" 3979 "" 3978 1 3977 "WHERE" "" "gradeLevel" "GradeLevel" "=" "" "" "12" "" 3981 "" 3980 1 3977 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "" "" "1" "" 3983 "" 3982 3 3977 "WHERE" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "CalendarYear" "CalendarYearSeq" "" "" 3984 "" 3982 1 3977 "AND" "" "StuPriSchoolYear" "gradeLevelSeq" "=" "gradeLevel" "gradeLevelSeq" "" "" 3985 "" 3982 2 3977 "WHERE" "" "Student" "StudentID" "=" "StuPriSchoolYear" "StudentID" "" "" 3987 "" 3986 1 3977 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3989 "" 3988 1 3977 "OUTER-JOIN WHERE" "" "Users" "PersonSeq" "=" "Person" "PersonSeq" "" "" 3991 "" 3990 1 3977 "WHERE" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 4008 "" 4007 1 3977 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 4010 "" 4009 1 3977 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 4012 "" 4011 1 3977 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/27/2014" "" 4013 "" 4007 2 3977 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/19/2015" "" 4014 "" 4007 3 3977 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 4015 "" 4011 2 [END] [MyQueryFields] 3977 3992 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0 3977 3993 "Person" "FirstName" "" "x(15)" "First Name" no 2 0 3977 3994 "Person" "LastName" "" "x(15)" "Last Name" no 3 0 3977 3995 "Users" "UsersID" "" "x(10)" "User Id" no 4 0 3977 3996 "gradeLevel" "GradeLevel" "" "X(2)" "Grade Level" no 5 0 3977 3997 "Users" "ForcePasswordChange" "" "yes/no" "Yes indicates hasnt logged in yet" no 6 0 3977 3998 "Users" "LastPasswordChangeDate" "" "99/99/9999" "Last Password change" no 7 0 3977 3999 "Users" "Active" "" "yes/no" "Active" no 8 0 3977 4016 "EnrollStatus" "EnrollStatusDescr" "" "X(15)" "Status" no 9 0 [END] [MyQuerySort] 3977 4000 "Person" "FirstName" no "" 2 "" "" no 3977 4001 "Person" "LastName" no "" 1 "" "" no 3977 4002 "Student" "StudentID" no "" 3 "" "" no [END] [MyQueryDocs] 3977 4003 2 "Portrait" 0 "" "" 3977 4004 6 "Portrait" 0 "" "" 3977 4005 1 "Portrait" 0 "" "" 3977 4006 4 "" 0 "" "" [END]