[MyQuery]
5217 "lpattonq" "Detention Posting" "Detention Posting"
[END]
[MyQueryTables]
5217 5218 1 "EACH" "Student" no
5217 5220 2 "FIRST" "Person" no
5217 5222 3 "FIRST" "EntryWithdrawl" no
5217 5226 4 "FIRST" "EntryWithdrawlCodes" no
5217 5228 5 "FIRST" "EnrollStatus" no
5217 5231 6 "FIRST" "RoomCatalog" no
5217 5233 7 "EACH" "StuDiscipline" no
5217 5242 8 "FIRST" "Punishments" no
[END]
[MyQueryWhere]
5217 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 5219 "" 5218 1
5217 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5221 "" 5220 1
5217 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 5223 "" 5222 2
5217 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 5224 "" 5222 3
5217 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 5225 "" 5222 1
5217 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5227 "" 5226 1
5217 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5229 "" 5228 2
5217 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5230 "" 5228 1
5217 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 5232 "" 5231 1
5217 "WHERE" "" "StuDiscipline" "StudentID" "=" "Student" "StudentID" "" "" 5234 "" 5233 1
5217 "WHERE" "" "Punishments" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 5243 "" 5242 1
5217 "AND" "" "Punishments" "PunishmentSeq" "=" "StuDiscipline" "PunishmentSeq" "" "" 5244 "" 5242 2
5217 "AND" "" "StuDiscipline" "ActualPunishmentUnitValue" "<" "StuDiscipline" "PunishUnitValue" "" "" 5280 "" 5233 2
5217 "AND" "" "Punishments" "PunishmentDescr" "=" "" "" "Detention" "" 5281 "" 5242 3
[END]
[MyQueryFields]
5217 5278 "StuDiscipline" "PunishUnitValue" "" ">>9.99" "Hours Assigned" no 7
5217 5252 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5217 5253 "Person" "LastName" "" "x(15)" "Last Name" no 2
5217 5254 "Person" "FirstName" "" "x(15)" "First Name" no 3
5217 5256 "Student" "GradeLevel" "" "X(2)" "Grade Level" no 4
5217 5257 "StuDiscipline" "OffenseDate" "" "99/99/9999" "Offense Date" no 5
5217 5260 "Punishments" "PunishmentDescr" "" "X(8)" "Consequence" no 6
5217 5279 "StuDiscipline" "ActualPunishmentUnitValue" "" ">>9.99" "Hours Served" no 8
[END]
[MyQuerySort]
5217 5271 "Person" "FirstName" no "" 4 "" "" no
5217 5272 "Person" "LastName" no "" 3 "" "" no
5217 5273 "StuDiscipline" "OffenseDate" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
5217 5274 2 "Portrait" 0 "" ""
5217 5275 6 "Portrait" 0 "" ""
5217 5276 1 "Portrait" 0 "" ""
5217 5277 4 "" 0 "" ""
[END]