[MyQuery]
5411 "lpattonq" "Detention Letters" "Detention Letters"
[END]
[MyQueryTables]
5411 5412 1 "EACH" "Student" no
5411 5414 2 "FIRST" "Person" no
5411 5416 3 "FIRST" "EntryWithdrawl" no
5411 5420 4 "FIRST" "EntryWithdrawlCodes" no
5411 5422 5 "FIRST" "EnrollStatus" no
5411 5425 6 "FIRST" "RoomCatalog" no
5411 5427 7 "EACH" "StuDiscipline" no
5411 5430 8 "FIRST" "Punishments" no
5411 5449 9 "FIRST" "addressPerson" no
5411 5451 10 "FIRST" "AddressType" no
5411 5453 11 "FIRST" "Address" no
[END]
[MyQueryWhere]
5411 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 5413 "" 5412 1
5411 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5415 "" 5414 1
5411 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 5417 "" 5416 2
5411 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 5418 "" 5416 3
5411 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 5419 "" 5416 1
5411 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5421 "" 5420 1
5411 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5423 "" 5422 2
5411 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5424 "" 5422 1
5411 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 5426 "" 5425 1
5411 "WHERE" "" "StuDiscipline" "StudentID" "=" "Student" "StudentID" "" "" 5428 "" 5427 1
5411 "AND" "" "StuDiscipline" "ActualPunishmentUnitValue" "<" "StuDiscipline" "PunishUnitValue" "" "" 5429 "" 5427 2
5411 "WHERE" "" "Punishments" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 5431 "" 5430 1
5411 "AND" "" "Punishments" "PunishmentSeq" "=" "StuDiscipline" "PunishmentSeq" "" "" 5432 "" 5430 2
5411 "AND" "" "Punishments" "PunishmentDescr" "=" "" "" "Detention" "" 5433 "" 5430 3
5411 "Where" "" "addressPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 5450 "" 5449 1
5411 "Where" "" "AddressType" "AddressTypeSeq" "=" "addressPerson" "AddressTypeSeq" "" "" 5452 "" 5451 1
5411 "Where" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 5454 "" 5453 1
[END]
[MyQueryFields]
5411 5434 "StuDiscipline" "PunishUnitValue" "" ">>9.99" "Hours Assigned" no 7
5411 5435 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5411 5436 "Person" "LastName" "" "x(15)" "Last Name" no 2
5411 5437 "Person" "FirstName" "" "x(15)" "First Name" no 3
5411 5438 "Student" "GradeLevel" "" "X(2)" "Grade Level" no 4
5411 5439 "StuDiscipline" "OffenseDate" "" "99/99/9999" "Offense Date" no 5
5411 5440 "Punishments" "PunishmentDescr" "" "X(8)" "Consequence" no 6
5411 5441 "StuDiscipline" "ActualPunishmentUnitValue" "" ">>9.99" "Hours Served" no 8
5411 5455 "Student" "MailParentName" "" "X(50)" "Parent Name" no 9
5411 5456 "Address" "StreetNo" "" "x(8)" "Street No" no 10
5411 5457 "Address" "Address1" "" "X(25)" "Address1" no 11
5411 5458 "Address" "Address2" "" "X(25)" "Address" no 12
5411 5459 "Address" "AptNo" "" "X(8)" "Apt No" no 13
5411 5460 "Address" "City" "" "X(25)" "City" no 14
5411 5461 "Address" "State" "" "X(2)" "State" no 15
5411 5462 "Address" "ZipCode" "" "X(10)" "Zip Code" no 16
[END]
[MyQuerySort]
5411 5442 "Person" "FirstName" no "" 4 "" "" no
5411 5443 "Person" "LastName" no "" 3 "" "" no
5411 5444 "StuDiscipline" "OffenseDate" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
5411 5445 2 "Portrait" 0 "" ""
5411 5446 6 "Portrait" 0 "" ""
5411 5447 1 "Portrait" 0 "" ""
5411 5448 4 "" 0 "" ""
[END]