[MyQuery]
2069 "lpattonq" "GPA by Town" "GPA by Town"
[END]
[MyQueryTables]
2069 2070 1 "EACH" "Student" no
2069 2072 2 "FIRST" "Person" no
2069 2074 3 "FIRST" "EntryWithdrawl" no
2069 2079 4 "FIRST" "EntryWithdrawlCodes" no
2069 2081 5 "FIRST" "EnrollStatus" no
2069 2084 6 "FIRST" "RoomCatalog" no
2069 2086 7 "FIRST" "Terms" no
2069 2089 8 "FIRST" "SchoolTerm" no
2069 2123 9 "FIRST" "Scale" no
2069 2118 10 "FIRST" "GPACalc" no
2069 2112 11 "FIRST" "StuCreditGPA" no
2069 2128 12 "FIRST" "TownCodes" no
[END]
[MyQueryWhere]
2069 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 2071 "" 2070 1
2069 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 2073 "" 2072 1
2069 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 2075 "" 2074 2
2069 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 2076 "" 2074 3
2069 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 2077 "" 2074 1
2069 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 2078 "" 2074 4
2069 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 2080 "" 2079 1
2069 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 2082 "" 2081 2
2069 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 2083 "" 2081 1
2069 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 2085 "" 2084 1
2069 "WHERE" "" "Terms" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 2088 "" 2086 1
2069 "WHERE" "" "SchoolTerm" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 2090 "" 2089 1
2069 "AND" "" "SchoolTerm" "TermSeq" "=" "Terms" "TermSeq" "" "" 2091 "" 2089 2
2069 "AND" "" "SchoolTerm" "CalendarYearSeq" "=" "" "" "1" "" 2092 "" 2089 3
2069 "WHERE" "" "StuCreditGPA" "StudentID" "=" "Student" "StudentID" "" "" 2113 "" 2112 1
2069 "AND" "" "StuCreditGPA" "GPACalcSeq" "=" "GPACalc" "GPACalcSeq" "" "" 2117 "" 2112 2
2069 "WHERE" "" "GPACalc" "ScaleSeq" "=" "Scale" "ScaleSeq" "" "" 2119 "" 2118 1
2069 "AND" "" "GPACalc" "DeletedFlag" "=" "" "" "False" "" 2122 "" 2118 2
2069 "WHERE" "" "Scale" "ScaleCode" "=" "" "" "4.0" "" 2125 "" 2123 1
2069 "AND" "" "GPACalc" "TestRun" "=" "" "" "False" "" 2126 "" 2118 3
2069 "AND" "" "GPACalc" "CalendarYearSeq" "=" "SchoolTerm" "CalendarYearSeq" "" "" 2127 "" 2118 4
2069 "Where" "" "TownCodes" "TownCodesSeq" "=" "Student" "TownCodesSeq" "" "" 2129 "" 2128 1
2069 "AND" "" "StuCreditGPA" "DeletedFlag" "=" "" "" "FALSE" "" 2184 "" 2112 3
[END]
[MyQueryFields]
2069 2098 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 2
2069 2099 "Person" "LastName" "" "x(15)" "Last Name" no 3
2069 2100 "Person" "FirstName" "" "x(15)" "First Name" no 4
2069 2101 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 6
2069 2102 "Student" "GradeLevel" "" "X(2)" "GL" no 5
2069 2130 "TownCodes" "City" "" "X(25)" "City" no 1
2069 2185 "StuCreditGPA" "YTDRank" "" "->,>>>,>>9" "YTD Rank" no 8
2069 2186 "StuCreditGPA" "YTDGPA" "" "->>,>>9.999" "YTDGPA" no 7
[END]
[MyQuerySort]
2069 2105 "Person" "FirstName" no "" 3 "" "" no
2069 2106 "Person" "LastName" no "" 2 "" "" no
2069 2131 "TownCodes" "City" yes "Count" 1 "" "" yes
[END]
[MyQueryDocs]
2069 2107 2 "Portrait" 0 "" ""
2069 2108 6 "Portrait" 0 "" ""
2069 2109 1 "Portrait" 0 "" ""
2069 2110 4 "" 0 "" ""
[END]