[MyQuery]
6303 "lpattonq" "Enrolled Students Special Program Status" "Enrolled Students Special Program Status"
[END]
[MyQueryTables]
6303 6304 1 "EACH" "Student" no
6303 6306 2 "FIRST" "Person" no
6303 6308 3 "FIRST" "EntryWithdrawl" no
6303 6312 4 "FIRST" "EntryWithdrawlCodes" no
6303 6314 5 "FIRST" "EnrollStatus" no
6303 6317 6 "FIRST" "RoomCatalog" no
6303 6339 7 "FIRST" "SchoolProfile" no
6303 6341 8 "FIRST" "DOEField" no
6303 6342 9 "FIRST" "StuDOEField" no
6303 6344 10 "FIRST" "DOEFieldValue" no
[END]
[MyQueryWhere]
6303 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 6305 "" 6304 1
6303 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 6307 "" 6306 1
6303 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2004" "" 6309 "" 6308 2
6303 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2005" "" 6310 "" 6308 3
6303 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 6311 "" 6308 1
6303 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 6313 "" 6312 1
6303 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 6315 "" 6314 2
6303 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 6316 "" 6314 1
6303 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 6318 "" 6317 1
6303 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 6340 "" 6339 1
6303 "WHERE" "" "StuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 6343 "" 6342 1
6303 "WHERE" "" "DOEFieldValue" "DOEFieldValueSeq" "=" "StuDOEField" "DOEFieldValueSeq" "" "" 6345 "" 6344 1
6303 "WHERE" "" "DOEField" "DOEName" "=" "" "" "Special Program Status" "" 6346 "" 6341 1
6303 "AND" "" "StuDOEField" "DOEFieldSeq" "=" "DOEField" "DOEFieldSeq" "" "" 6347 "" 6342 2
[END]
[MyQueryFields]
6303 6326 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
6303 6327 "Person" "LastName" "" "x(15)" "Last Name" no 2
6303 6328 "Person" "FirstName" "" "x(15)" "First Name" no 3
6303 6329 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
6303 6330 "Student" "GradeLevel" "" "X(2)" "GL" no 4
6303 6348 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 6
6303 6349 "DOEFieldValue" "DOEValueDescr" "" "x(30)" "Description" no 7
6303 6350 "DOEFieldValue" "DOEValueCode" "" "x(8)" "DOE Code" no 8
[END]
[MyQuerySort]
6303 6333 "Person" "FirstName" no "" 3 "" "" no
6303 6334 "Person" "LastName" no "" 2 "" "" no
6303 6351 "SchoolProfile" "SchoolName" yes "Count" 1 "SchoolProfile" "SchoolName" no
[END]
[MyQueryDocs]
6303 6335 2 "Portrait" 0 "" ""
6303 6336 6 "Portrait" 0 "" ""
6303 6337 1 "Portrait" 0 "" ""
6303 6338 4 "" 0 "" ""
[END]