[MyQuery]
7590 "lpattonq" "Discipline By Race" "Discipline By Race"
[END]
[MyQueryTables]
7590 7591 1 "EACH" "Student" no
7590 7593 2 "FIRST" "Person" no
7590 7595 3 "FIRST" "EntryWithdrawl" no
7590 7599 4 "FIRST" "EntryWithdrawlCodes" no
7590 7601 5 "FIRST" "EnrollStatus" no
7590 7604 6 "FIRST" "RoomCatalog" no
7590 7606 7 "EACH" "StuDiscipline" no
7590 7615 8 "FIRST" "Punishments" no
7590 7618 9 "FIRST" "StuSpecialNeeds" no
7590 7620 10 "FIRST" "SPEDStatus" no
7590 7651 11 "FIRST" "StuEthnicX" no
7590 7653 12 "FIRST" "EthnicRaceCodes" no
[END]
[MyQueryWhere]
7590 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7592 "" 7591 1
7590 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7594 "" 7593 1
7590 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2004" "" 7596 "" 7595 2
7590 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2005" "" 7597 "" 7595 3
7590 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7598 "" 7595 1
7590 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7600 "" 7599 1
7590 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7602 "" 7601 2
7590 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7603 "" 7601 1
7590 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 7605 "" 7604 1
7590 "Where" "" "StuDiscipline" "StudentID" "=" "Student" "StudentID" "" "" 7607 "" 7606 1
7590 "WHERE" "" "Punishments" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 7616 "" 7615 1
7590 "AND" "" "Punishments" "PunishmentSeq" "=" "StuDiscipline" "PunishmentSeq" "" "" 7617 "" 7615 2
7590 "OUTER-JOIN WHERE" "" "StuSpecialNeeds" "StudentID" "=" "Student" "StudentID" "" "" 7619 "" 7618 1
7590 "OUTER-JOIN WHERE" "" "SPEDStatus" "SPEDStatusSeq" "=" "StuSpecialNeeds" "SPEDStatusSeq" "" "" 7621 "" 7620 1
7590 "Where" "" "StuEthnicX" "StudentID" "=" "Student" "StudentID" "" "" 7652 "" 7651 1
7590 "WHERE" "" "EthnicRaceCodes" "EthnicRaceCodesSeq" "=" "StuEthnicX" "EthnicRaceCodesSeq" "" "" 7654 "" 7653 1
7590 "AND" "" "Punishments" "PunishmentDescr" "=" "" "" "In-School Suspension" "" 7659 "" 7615 3
[END]
[MyQueryFields]
7590 7625 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 3
7590 7626 "Person" "LastName" "" "x(15)" "Last Name" no 4
7590 7627 "Person" "FirstName" "" "x(15)" "First Name" no 5
7590 7628 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 2
7590 7629 "Student" "GradeLevel" "" "X(2)" "Grade Level" no 6
7590 7630 "StuDiscipline" "OffenseDate" "" "99/99/9999" "Offense Date" no 1
7590 7633 "Punishments" "PunishmentDescr" "" "X(8)" "Consequence" no 7
7590 7638 "SPEDStatus" "StateCode" "" "X(3)" "SPED Status" no 8
7590 7656 "EthnicRaceCodes" "StateCode" "" "X(3)" "State!Code" no 9
7590 7657 "EthnicRaceCodes" "Description" "" "X(50)" "Description" no 10
[END]
[MyQuerySort]
7590 7658 "EthnicRaceCodes" "StateCode" no "" 1 "" "" no
7590 7644 "Person" "FirstName" no "" 3 "" "" no
7590 7645 "Person" "LastName" no "" 2 "" "" no
[END]
[MyQueryDocs]
7590 7647 2 "Portrait" 0 "" ""
7590 7648 6 "Portrait" 0 "" ""
7590 7649 1 "Portrait" 0 "" ""
7590 7650 4 "" 0 "" ""
[END]