[MyQuery]
5738 "lpattonq" "Below 90 grade with 1 in Effort and Conduct" "Below 90 grade with 1 in Effort and Conduct"
[END]
[MyQueryTables]
5738 5739 1 "EACH" "StuGrades" no
5738 5740 2 "FIRST" "SchoolCourse" no
5738 5749 3 "EACH" "Course" no
5738 5751 4 "FIRST" "GradeHeading" no
5738 5754 5 "FIRST" "Grade" no
5738 5757 6 "FIRST" "Student" no
5738 5759 7 "FIRST" "Person" no
5738 5761 8 "FIRST" "EntryWithdrawl" no
5738 5766 9 "FIRST" "EntryWithdrawlCodes" no
5738 5768 10 "FIRST" "EnrollStatus" no
5738 5786 11 "FIRST" "StuGradeConduct" no
5738 5788 12 "FIRST" "ConductCodes" no
5738 5790 13 "FIRST" "StuGradeEffort" no
5738 5792 14 "FIRST" "EffortCodes" no
[END]
[MyQueryWhere]
5738 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 5741 "" 5740 1
5738 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "12" "" 5742 "" 5740 2
5738 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 5743 "" 5740 3
5738 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 5750 "" 5749 1
5738 "AND" "" "GradeHeading" "GradeHeadingAbbr" "=" "" "" "T1" "" 5752 "" 5751 2
5738 "WHERE" "" "GradeHeading" "GradeHeadingSeq" "=" "StuGrades" "GradeHeadingSeq" "" "" 5753 "" 5751 1
5738 "WHERE" "" "Grade" "GradeSeq" "=" "StuGrades" "GradeSeq" "" "" 5756 "" 5754 1
5738 "WHERE" "" "Student" "StudentID" "=" "StuGrades" "StudentId" "" "" 5758 "" 5757 1
5738 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5760 "" 5759 1
5738 "AND" "" "ConductCodes" "ConductCode" "=" "" "" "1" "" 5794 "" 5788 2
5738 "AND" "" "EffortCodes" "EffortCode" "=" "" "" "1" "" 5795 "" 5792 2
5738 "Where" "" "StuGradeEffort" "StuGradesSeq" "=" "StuGrades" "StuGradesSeq" "" "" 5791 "" 5790 1
5738 "WHERE" "" "EffortCodes" "EffortCodesSeq" "=" "StuGradeEffort" "EffortCodesSeq" "" "" 5793 "" 5792 1
5738 "Where" "" "StuGradeConduct" "StuGradesSeq" "=" "StuGrades" "StuGradesSeq" "" "" 5787 "" 5786 1
5738 "WHERE" "" "ConductCodes" "ConductCodesSeq" "=" "StuGradeConduct" "ConductCodesSeq" "" "" 5789 "" 5788 1
5738 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 5762 "" 5761 3
5738 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 5763 "" 5761 1
5738 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 5764 "" 5761 2
5738 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 5765 "" 5761 4
5738 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5767 "" 5766 1
5738 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5769 "" 5768 2
5738 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5770 "" 5768 1
5738 "AND" "" "Grade" "UnWeighted" "<" "" "" "90" "" 5798 "" 5754 2
[END]
[MyQueryFields]
5738 5796 "EffortCodes" "EffortCode" "" "X(8)" "Effort Code" no 8
5738 5797 "ConductCodes" "ConductCode" "" "X(8)" "Conduct Code" no 9
5738 5771 "Course" "CourseDescr" "" "X(40)" "Description" no 6
5738 5772 "Student" "GradeLevel" "" "X(2)" "GL" no 4
5738 5773 "Course" "CourseTitle" "" "X(15)" "Course ID" no 5
5738 5774 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5738 5775 "Person" "LastName" "" "x(15)" "Last Name" no 2
5738 5776 "Person" "FirstName" "" "x(15)" "First Name" no 3
5738 5777 "Grade" "GradeCode" "" "X(5)" "Grade" no 7
[END]
[MyQuerySort]
5738 5778 "Course" "CourseTitle" yes "Count" 3 "" "" no
5738 5779 "Grade" "GradeCode" no "" 4 "" "" no
5738 5780 "Person" "FirstName" no "" 2 "" "" no
5738 5781 "Person" "LastName" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
5738 5782 2 "Portrait" 0 "" ""
5738 5783 6 "Portrait" 0 "" ""
5738 5784 1 "Portrait" 0 "" ""
5738 5785 4 "" 0 "" ""
[END]