[MyQuery]
5088 "lpattonq" "1 in Conduct and 1 in Effort" "1 in Conduct and 1 in Effort"
[END]
[MyQueryTables]
5088 5089 1 "EACH" "Student" no
5088 5091 2 "FIRST" "Person" no
5088 5093 3 "FIRST" "EntryWithdrawl" no
5088 5097 4 "FIRST" "EntryWithdrawlCodes" no
5088 5099 5 "FIRST" "EnrollStatus" no
5088 5102 6 "FIRST" "RoomCatalog" no
5088 5127 7 "EACH" "StuGrades" no
5088 5122 8 "EACH" "StuGradeConduct" no
5088 5123 9 "EACH" "StuGradeEffort" no
5088 5134 10 "FIRST" "ConductCodes" no
5088 5136 11 "FIRST" "EffortCodes" no
[END]
[MyQueryWhere]
5088 "WHERE" "" "EffortCodes" "EffortCodesSeq" "=" "StuGradeEffort" "EffortCodesSeq" "" "" 5137 "" 5136 1
5088 "WHERE" "" "ConductCodes" "ConductCodesSeq" "=" "StuGradeConduct" "ConductCodesSeq" "" "" 5135 "" 5134 1
5088 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 5606 "" 5093 4
5088 "AND" "" "EffortCodes" "EffortCode" "=" "" "" "1" "" 5138 "" 5136 2
5088 "AND" "" "ConductCodes" "ConductCode" "=" "" "" "1" "" 5139 "" 5134 2
5088 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 5090 "" 5089 1
5088 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5092 "" 5091 1
5088 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 5094 "" 5093 2
5088 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 5095 "" 5093 3
5088 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 5096 "" 5093 1
5088 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5098 "" 5097 1
5088 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5100 "" 5099 2
5088 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5101 "" 5099 1
5088 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 5103 "" 5102 1
5088 "WHERE" "" "StuGradeEffort" "StuGradesSeq" "=" "StuGrades" "StuGradesSeq" "" "" 5124 "" 5123 1
5088 "WHERE" "" "StuGrades" "StudentId" "=" "Student" "StudentID" "" "" 5128 "" 5127 1
5088 "WHERE" "" "StuGradeConduct" "StuGradesSeq" "=" "StuGrades" "StuGradesSeq" "" "" 5129 "" 5122 1
[END]
[MyQueryFields]
5088 5463 "EffortCodes" "EffortCode" "" "X(8)" "Effort Code" no 6
5088 5109 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5088 5110 "Person" "LastName" "" "x(15)" "Last Name" no 2
5088 5111 "Person" "FirstName" "" "x(15)" "First Name" no 3
5088 5112 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
5088 5113 "Student" "GradeLevel" "" "X(2)" "GL" no 4
5088 5464 "EffortCodes" "EffortCodeDescr" "" "X(50)" "Description" no 7
5088 5465 "ConductCodes" "ConductCode" "" "X(8)" "Conduct Code" no 8
5088 5466 "ConductCodes" "ConductCodeDescr" "" "X(50)" "Description" no 9
[END]
[MyQuerySort]
5088 5116 "Person" "FirstName" no "" 3 "" "" no
5088 5117 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
5088 5118 2 "Portrait" 0 "" ""
5088 5119 6 "Portrait" 0 "" ""
5088 5120 1 "Portrait" 0 "" ""
5088 5121 4 "" 0 "" ""
[END]