[MyQuery] 2952 "lpattonq" "DOE Student Discipline Record" "DOE Student Discipline Record" [END] [MyQueryTables] 2952 2953 1 "EACH" "Student" no 2952 2955 2 "FIRST" "Person" no 2952 2957 3 "FIRST" "EntryWithdrawl" no 2952 2961 4 "FIRST" "EntryWithdrawlCodes" no 2952 2963 5 "FIRST" "EnrollStatus" no 2952 2966 6 "FIRST" "RoomCatalog" no 2952 2986 7 "EACH" "StuDiscipline" no 2952 2988 8 "FIRST" "Offenses" no 2952 3014 9 "FIRST" "OffenseType" no 2952 2990 10 "FIRST" "Punishments" no 2952 3002 11 "FIRST" "StuSpecialNeeds" no 2952 3004 12 "FIRST" "SPEDStatus" no 2952 3007 13 "FIRST" "AdminAction" no [END] [MyQueryWhere] 2952 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 2954 "" 2953 1 2952 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 2956 "" 2955 1 2952 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 2958 "" 2957 2 2952 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 2959 "" 2957 3 2952 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 2960 "" 2957 1 2952 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 2962 "" 2961 1 2952 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 2964 "" 2963 2 2952 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 2965 "" 2963 1 2952 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 2967 "" 2966 1 2952 "Where" "" "StuDiscipline" "StudentID" "=" "Student" "StudentID" "" "" 2987 "" 2986 1 2952 "WHERE" "" "Offenses" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 2989 "" 2988 1 2952 "WHERE" "" "Punishments" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 2991 "" 2990 1 2952 "OUTER-JOIN WHERE" "" "StuSpecialNeeds" "StudentID" "=" "Student" "StudentID" "" "" 3003 "" 3002 1 2952 "OUTER-JOIN WHERE" "" "SPEDStatus" "SPEDStatusSeq" "=" "StuSpecialNeeds" "SPEDStatusSeq" "" "" 3005 "" 3004 1 2952 "OUTER-JOIN WHERE" "" "AdminAction" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 3008 "" 3007 1 2952 "AND" "" "AdminAction" "AdminActionSeq" "=" "StuDiscipline" "AdminActionSeq" "" "" 3009 "" 3007 2 2952 "WHERE" "" "OffenseType" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 3015 "" 3014 1 2952 "AND" "" "OffenseType" "OffenseTypeSeq" "=" "Offenses" "OffenseTypeSeq" "" "" 3016 "" 3014 2 2952 "AND" "" "Offenses" "OffenseSeq" "=" "StuDiscipline" "OffenseSeq" "" "" 3018 "" 2988 2 2952 "AND" "" "Punishments" "PunishmentSeq" "=" "StuDiscipline" "PunishmentSeq" "" "" 3019 "" 2990 2 2952 "AND" "" "OffenseType" "OffenseTypeDescr" "=" "" "" "DOE" "" 3084 "" 3014 3 [END] [MyQueryFields] 2952 2973 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 4 2952 2974 "Person" "LastName" "" "x(15)" "Last Name" no 5 2952 2975 "Person" "FirstName" "" "x(15)" "First Name" no 6 2952 2976 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 3 2952 2977 "Student" "GradeLevel" "" "X(2)" "Grade Level" no 9 2952 2992 "StuDiscipline" "OffenseDate" "" "99/99/9999" "Offense Date" no 1 2952 2993 "Student" "SASID" "" "X(10)" "SASID" no 7 2952 2994 "Student" "DateOfBirth" "" "99/99/9999" "D.O.B." no 8 2952 2995 "Punishments" "PunishmentDescr" "" "X(8)" "Consequence" no 10 2952 2996 "StuDiscipline" "ToBeServedStartDate" "" "99/99/9999" "Start date" no 11 2952 2997 "StuDiscipline" "DateServedEnd" "" "99/99/9999" "Date Returned to School" no 12 2952 2998 "StuDiscipline" "ToEndServerdate" "" "99/99/9999" "Date Eligible to Return to School" no 13 2952 2999 "StuDiscipline" "ActualPunishmentUnitValue" "" ">>9.99" "Number of School Days Missed" no 14 2952 3006 "SPEDStatus" "StateCode" "" "X(3)" "SPED Status" no 15 2952 3010 "AdminAction" "AdminActionDescr" "" "X(30)" "Administrative Action" no 16 2952 3011 "StuDiscipline" "AdminActionComments" "" "X(30)" "Administrative Action Comments" no 17 2952 3012 "StuDiscipline" "OffenseComments" "" "X(30)" "DOE Incident Num/Victims/Offenders" no 18 2952 3013 "Offenses" "OffenseDescr" "" "X(30)" "Incident" no 2 [END] [MyQuerySort] 2952 3001 "Offenses" "OffenseDescr" no "" 2 "" "" no 2952 2980 "Person" "FirstName" no "" 4 "" "" no 2952 2981 "Person" "LastName" no "" 3 "" "" no 2952 3000 "StuDiscipline" "OffenseDate" no "Count" 1 "" "" no [END] [MyQueryDocs] 2952 2982 2 "Portrait" 0 "" "" 2952 2983 6 "Portrait" 0 "" "" 2952 2984 1 "Portrait" 0 "" "" 2952 2985 4 "" 0 "" "" [END]