[MyQuery]
4450 "lpattonq" "Enrolled_Students_Report_DOE" "Enrolled_Students_Report_DOE"
[END]
[MyQueryTables]
4450 4451 1 "EACH" "Student" no
4450 4453 2 "FIRST" "Person" no
4450 4455 3 "FIRST" "EntryWithdrawl" no
4450 4459 4 "FIRST" "EntryWithdrawlCodes" no
4450 4461 5 "FIRST" "EnrollStatus" no
4450 4464 6 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
4450 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 4452 "" 4451 1
4450 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 4454 "" 4453 1
4450 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2014" "" 4456 "" 4455 2
4450 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2015" "" 4457 "" 4455 3
4450 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 4458 "" 4455 1
4450 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 4460 "" 4459 1
4450 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 4462 "" 4461 2
4450 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 4463 "" 4461 1
4450 "AND" "" "Student" "ReportToDoe" "=" "" "" "No" "" 4485 "" 4451 2
4450 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 4465 "" 4464 1
[END]
[MyQueryFields]
4450 4471 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
4450 4472 "Person" "LastName" "" "x(15)" "Last Name" no 2
4450 4473 "Person" "FirstName" "" "x(15)" "First Name" no 3
4450 4474 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
4450 4475 "Student" "GradeLevel" "" "X(2)" "GL" no 4
4450 4484 "Student" "ReportToDoe" "" "yes/no" "Report To DOE" no 6
[END]
[MyQuerySort]
4450 4478 "Person" "FirstName" no "" 3 "" "" no
4450 4479 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
4450 4480 2 "Portrait" 0 "" ""
4450 4481 6 "Portrait" 0 "" ""
4450 4482 1 "Portrait" 0 "" ""
4450 4483 4 "" 0 "" ""
[END]