[MyQuery]
3300 "lpattonq" "Enrolled Students SPED" "Enrolled Students SPED"
[END]
[MyQueryTables]
3300 3301 1 "EACH" "Student" no
3300 3303 2 "FIRST" "Person" no
3300 3305 3 "FIRST" "EntryWithdrawl" no
3300 3309 4 "FIRST" "EntryWithdrawlCodes" no
3300 3311 5 "FIRST" "EnrollStatus" no
3300 3314 6 "FIRST" "RoomCatalog" no
3300 3316 7 "FIRST" "StuSpecialNeeds" no
3300 3318 8 "FIRST" "SPEDStatus" no
[END]
[MyQueryWhere]
3300 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 3306 "" 3305 2
3300 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 3307 "" 3305 3
3300 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3308 "" 3305 1
3300 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3302 "" 3301 1
3300 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3304 "" 3303 1
3300 "WHERE" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3310 "" 3309 1
3300 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 3312 "" 3311 2
3300 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3313 "" 3311 1
3300 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 3315 "" 3314 1
3300 "Where" "" "StuSpecialNeeds" "StudentID" "=" "Student" "StudentID" "" "" 3317 "" 3316 1
3300 "WHERE" "" "SPEDStatus" "SPEDStatusSeq" "=" "StuSpecialNeeds" "SPEDStatusSeq" "" "" 3319 "" 3318 1
3300 "AND" "" "SPEDStatus" "StateCode" "<>" "" "" "00" "" 3320 "" 3318 2
[END]
[MyQueryFields]
3300 3325 "SPEDStatus" "Description" "" "X(50)" "SPED Status" no 6
3300 3326 "SPEDStatus" "StateCode" "" "X(3)" "SPED Code" no 7
3300 3329 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
3300 3330 "Person" "LastName" "" "x(15)" "Last Name" no 2
3300 3331 "Person" "FirstName" "" "x(15)" "First Name" no 3
3300 3332 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
3300 3333 "Student" "GradeLevel" "" "X(2)" "GL" no 4
[END]
[MyQuerySort]
3300 3336 "Person" "FirstName" no "" 3 "" "" no
3300 3337 "Person" "LastName" no "" 2 "" "" no
[END]
[MyQueryDocs]
3300 3341 4 "" 0 "" ""
3300 3338 2 "Portrait" 0 "" ""
3300 3339 6 "Portrait" 0 "" ""
3300 3340 1 "Portrait" 0 "" ""
[END]