[MyQuery]
3117 "jgriffin" "Enrollment Counts" "Enrollment Counts between two dates"
[END]
[MyQueryTables]
3117 3118 1 "EACH" "Student" no
3117 3120 2 "FIRST" "Person" no
3117 3122 3 "FIRST" "EntryWithdrawl" no
3117 3126 4 "FIRST" "EntryWithdrawlCodes" no
3117 3128 5 "FIRST" "EnrollStatus" no
3117 3131 6 "FIRST" "RoomCatalog" no
3117 3133 7 "FIRST" "StuSpecialNeeds" no
3117 3135 8 "FIRST" "SPEDStatus" no
[END]
[MyQueryWhere]
3117 "WHERE" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3127 "" 3126 1
3117 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3130 "" 3128 1
3117 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 3132 "" 3131 1
3117 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/02/2003" "" 3177 "" 3122 2
3117 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "03/26/2004" "" 3178 "" 3122 3
3117 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3119 "" 3118 1
3117 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3121 "" 3120 1
3117 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3125 "" 3122 1
3117 "OUTER-JOIN WHERE" "" "StuSpecialNeeds" "StudentID" "=" "Student" "StudentID" "" "" 3134 "" 3133 1
3117 "OUTER-JOIN WHERE" "" "SPEDStatus" "SPEDStatusSeq" "=" "StuSpecialNeeds" "SPEDStatusSeq" "" "" 3136 "" 3135 1
[END]
[MyQueryFields]
3117 3142 "SPEDStatus" "Description" "" "X(50)" "SPED Status" no 6
3117 3143 "SPEDStatus" "StateCode" "" "X(3)" "SPED Code" no 7
3117 3146 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
3117 3147 "Person" "LastName" "" "x(15)" "Last Name" no 2
3117 3148 "Person" "FirstName" "" "x(15)" "First Name" no 3
3117 3149 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
3117 3150 "Student" "GradeLevel" "" "X(2)" "GL" no 4
3117 3151 "EntryWithdrawl" "EntryWithdrawlDate" "" "99/99/9999" "Withdrawl Date" no 8
3117 3182 "EnrollStatus" "EnrollStatusCode" "" "X" "Enroll Status Code" no 9
[END]
[MyQuerySort]
3117 3183 "EnrollStatus" "EnrollStatusCode" yes "Count" 1 "" "" no
3117 3153 "Person" "FirstName" no "" 4 "" "" no
3117 3154 "Person" "LastName" no "" 3 "" "" no
3117 3161 "SPEDStatus" "StateCode" yes "Count" 2 "" "" no
[END]
[MyQueryDocs]
3117 3155 2 "Portrait" 0 "" ""
3117 3156 6 "Portrait" 0 "" ""
3117 3157 1 "Portrait" 0 "" ""
3117 3158 4 "" 0 "" ""
[END]