[MyQuery]
4439 "wvtimg9408" "Student Tech Shop Info New" "New Student Tech Shop Info"
[END]
[MyQueryTables]
4439 4440 1 "EACH" "Student" no 0
4439 4442 2 "FIRST" "Person" no 0
4439 4444 3 "FIRST" "EntryWithdrawl" no 0
4439 4448 4 "FIRST" "EntryWithdrawlCodes" no 0
4439 4450 5 "FIRST" "EnrollStatus" no 0
4439 4453 6 "FIRST" "RoomCatalog" no 0
4439 4455 7 "FIRST" "StuTechEd" no 0
4439 4457 8 "FIRST" "SchoolTechedWeeks" no 0
4439 4460 9 "EACH" "StuDOEField" no 0
4439 4462 10 "FIRST" "DOEField" no 0
4439 4465 11 "FIRST" "DOEFieldValue" no 0
4439 4467 12 "FIRST" "TechEd" no 0
[END]
[MyQueryWhere]
4439 "WHERE" "" "StuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 4461 "" 4460 1
4439 "AND" "" "DOEField" "DOEName" "BEGINS" "" "" "DOE 043" "" 4463 "" 4462 2
4439 "WHERE" "" "DOEField" "DOEFieldSeq" "=" "StuDOEField" "DOEFieldSeq" "" "" 4464 "" 4462 1
4439 "WHERE" "" "DOEFieldValue" "DOEFieldValueSeq" "=" "StuDOEField" "DOEFieldValueSeq" "" "" 4466 "" 4465 1
4439 "WHERE" "" "TechEd" "techEdSeq" "=" "StuTechEd" "techEdSeq" "" "" 4468 "" 4467 1
4439 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 4441 "" 4440 1
4439 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 4443 "" 4442 1
4439 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/31/2016" "" 4445 "" 4444 2
4439 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/13/2017" "" 4446 "" 4444 3
4439 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 4447 "" 4444 1
4439 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 4449 "" 4448 1
4439 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 4451 "" 4450 2
4439 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 4452 "" 4450 1
4439 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 4454 "" 4453 1
4439 "Where" "" "StuTechEd" "StudentID" "=" "Student" "StudentID" "" "" 4456 "" 4455 1
4439 "AND" "" "SchoolTechedWeeks" "TechEdWeekSeq" "=" "StuTechEd" "TechEdWeekSeq" "" "" 4458 "" 4457 2
4439 "WHERE" "" "SchoolTechedWeeks" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 4459 "" 4457 1
[END]
[MyQueryFields]
4439 4469 "TechEd" "Chapter74" "" "yes/no" "Chapter 74" no 9 0
4439 4470 "TechEd" "CipNo" "" "9999999" "Cip Number" no 10 0
4439 4471 "TechEd" "TechEdCode" "" "X(8)" "Tech Ed Code" no 11 0
4439 4472 "DOEFieldValue" "DOEValueCode" "" "x(8)" "Code" no 7 0
4439 4473 "DOEFieldValue" "DOEValueDescr" "" "x(30)" "Description" no 8 0
4439 4474 "Person" "FirstName" "" "x(15)" "First Name" no 3 0
4439 4475 "SchoolTechedWeeks" "TechEdWeekDesc" "" "X(8)" "Shop Week" no 6 0
4439 4476 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5 0
4439 4477 "Student" "GradeLevel" "" "X(2)" "GL" no 4 0
4439 4478 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
4439 4479 "Person" "LastName" "" "x(15)" "Last Name" no 2 0
4439 4480 "TechEd" "TechEdDescr" "" "X(30)" "Description" no 12 0
[END]
[MyQuerySort]
4439 4481 "Person" "FirstName" no "" 3 "" "" no
4439 4482 "Person" "LastName" no "Count" 2 "" "" no
4439 4483 "Student" "GradeLevel" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
4439 4484 2 "Portrait" 0 "" ""
4439 4485 6 "Portrait" 0 "" ""
4439 4486 1 "Portrait" 0 "" ""
4439 4487 4 "" 0 "" ""
[END]