[MyQuery]
6259 "lpattonq" "Enrolled Students Migrant" "Enrolled Students Migrant"
[END]
[MyQueryTables]
6259 6260 1 "EACH" "Student" no
6259 6262 2 "FIRST" "Person" no
6259 6264 3 "FIRST" "EntryWithdrawl" no
6259 6268 4 "FIRST" "EntryWithdrawlCodes" no
6259 6270 5 "FIRST" "EnrollStatus" no
6259 6273 6 "FIRST" "RoomCatalog" no
6259 6295 7 "FIRST" "Migrant" no
6259 6297 8 "FIRST" "SchoolProfile" no
[END]
[MyQueryWhere]
6259 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 6261 "" 6260 1
6259 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 6263 "" 6262 1
6259 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2004" "" 6265 "" 6264 2
6259 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2005" "" 6266 "" 6264 3
6259 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 6267 "" 6264 1
6259 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 6269 "" 6268 1
6259 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 6271 "" 6270 2
6259 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 6272 "" 6270 1
6259 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 6274 "" 6273 1
6259 "WHERE" "" "Migrant" "MigrantSeq" "=" "Student" "MigrantSeq" "" "" 6296 "" 6295 1
6259 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 6298 "" 6297 1
6259 "AND" "" "Migrant" "MigrantCode" "=" "" "" "01" "" 6299 "" 6295 2
[END]
[MyQueryFields]
6259 6282 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
6259 6283 "Person" "LastName" "" "x(15)" "Last Name" no 2
6259 6284 "Person" "FirstName" "" "x(15)" "First Name" no 3
6259 6285 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
6259 6286 "Student" "GradeLevel" "" "X(2)" "GL" no 4
6259 6300 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 6
6259 6301 "Migrant" "MigrantDesc" "" "X(50)" "Migrant Status Description" no 7
[END]
[MyQuerySort]
6259 6289 "Person" "FirstName" no "" 3 "" "" no
6259 6290 "Person" "LastName" no "" 2 "" "" no
6259 6302 "SchoolProfile" "SchoolName" yes "Count" 1 "SchoolProfile" "SchoolName" no
[END]
[MyQueryDocs]
6259 6291 2 "Portrait" 0 "" ""
6259 6292 6 "Portrait" 0 "" ""
6259 6293 1 "Portrait" 0 "" ""
6259 6294 4 "" 0 "" ""
[END]