[MyQuery]
3342 "lpattonq" "Enrolled Students Shop Week" "Enrolled Students Shop Week"
[END]
[MyQueryTables]
3342 3343 1 "EACH" "Student" no
3342 3345 2 "FIRST" "Person" no
3342 3347 3 "FIRST" "EntryWithdrawl" no
3342 3351 4 "FIRST" "EntryWithdrawlCodes" no
3342 3353 5 "FIRST" "EnrollStatus" no
3342 3356 6 "FIRST" "RoomCatalog" no
3342 3376 7 "FIRST" "StuTechEd" no
3342 3386 8 "FIRST" "SchoolTechedWeeks" no
[END]
[MyQueryWhere]
3342 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 3354 "" 3353 2
3342 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3355 "" 3353 1
3342 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 3357 "" 3356 1
3342 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3344 "" 3343 1
3342 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3346 "" 3345 1
3342 "AND" "" "SchoolTechedWeeks" "TechEdWeekSeq" "=" "StuTechEd" "TechEdWeekSeq" "" "" 3388 "" 3386 2
3342 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3352 "" 3351 1
3342 "WHERE" "" "SchoolTechedWeeks" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 3387 "" 3386 1
3342 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 3348 "" 3347 2
3342 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 3349 "" 3347 3
3342 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3350 "" 3347 1
3342 "Where" "" "StuTechEd" "StudentID" "=" "Student" "StudentID" "" "" 3377 "" 3376 1
[END]
[MyQueryFields]
3342 3366 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
3342 3367 "Student" "GradeLevel" "" "X(2)" "GL" no 4
3342 3363 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
3342 3364 "Person" "LastName" "" "x(15)" "Last Name" no 2
3342 3365 "Person" "FirstName" "" "x(15)" "First Name" no 3
3342 3389 "SchoolTechedWeeks" "TechEdWeekDesc" "" "X(8)" "Shop Week" no 6
[END]
[MyQuerySort]
3342 3370 "Person" "FirstName" no "" 3 "" "" no
3342 3371 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
3342 3372 2 "Portrait" 0 "" ""
3342 3373 6 "Portrait" 0 "" ""
3342 3374 1 "Portrait" 0 "" ""
3342 3375 4 "" 0 "" ""
[END]