[MyQuery]
809 "lpattonq" "Enrolled Students English Language Learner" "Enrolled Students English Language Learner"
[END]
[MyQueryTables]
809 810 1 "EACH" "Student" no
809 812 2 "FIRST" "Person" no
809 814 3 "FIRST" "EntryWithdrawl" no
809 818 4 "FIRST" "EntryWithdrawlCodes" no
809 820 5 "FIRST" "EnrollStatus" no
809 823 6 "FIRST" "RoomCatalog" no
809 844 7 "FIRST" "StuLanguage" no
809 843 8 "FIRST" "BilingualEdStatus" no
[END]
[MyQueryWhere]
809 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 811 "" 810 1
809 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 813 "" 812 1
809 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 815 "" 814 2
809 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 816 "" 814 3
809 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 817 "" 814 1
809 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 819 "" 818 1
809 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 821 "" 820 2
809 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 822 "" 820 1
809 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 824 "" 823 1
809 "Where" "" "StuLanguage" "StudentID" "=" "Student" "StudentID" "" "" 845 "" 844 1
809 "WHERE" "" "BilingualEdStatus" "BilingualEdStatusSeq" "=" "StuLanguage" "BilingualEdStatusSeq" "" "" 847 "" 843 1
809 "AND" "" "BilingualEdStatus" "StateAbbr" "<>" "" "" "00" "" 848 "" 843 2
809 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 1963 "" 814 4
[END]
[MyQueryFields]
809 830 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
809 831 "Person" "LastName" "" "x(15)" "Last Name" no 2
809 832 "Person" "FirstName" "" "x(15)" "First Name" no 3
809 833 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
809 834 "Student" "GradeLevel" "" "X(2)" "GL" no 4
809 846 "BilingualEdStatus" "StateAbbr" "" "X(6)" "English Language Learner" no 7
[END]
[MyQuerySort]
809 849 "BilingualEdStatus" "StateAbbr" yes "Count" 1 "" "" no
809 837 "Person" "FirstName" no "" 3 "" "" no
809 838 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
809 839 2 "Portrait" 0 "" ""
809 840 6 "Portrait" 0 "" ""
809 841 1 "Portrait" 0 "" ""
809 842 4 "" 0 "" ""
[END]