[MyQuery]
7660 "lpattonq" "Course Grades and Absences" "Course Grades and Absences"
[END]
[MyQueryTables]
7660 7661 1 "EACH" "StuGrades" no
7660 7662 2 "FIRST" "SchoolCourse" no
7660 7666 3 "FIRST" "SchoolCourseDept" no
7660 7668 4 "FIRST" "Department" no
7660 7671 5 "FIRST" "Course" no
7660 7673 6 "FIRST" "GradeHeading" no
7660 7676 7 "FIRST" "Grade" no
7660 7678 8 "FIRST" "Student" no
7660 7681 9 "FIRST" "Person" no
7660 7683 10 "FIRST" "EntryWithdrawl" no
7660 7688 11 "FIRST" "EntryWithdrawlCodes" no
7660 7690 12 "FIRST" "EnrollStatus" no
[END]
[MyQueryWhere]
7660 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 7672 "" 7671 1
7660 "AND" "" "GradeHeading" "GradeHeadingAbbr" "=" "" "" "FAvg" "" 7674 "" 7673 2
7660 "WHERE" "" "GradeHeading" "GradeHeadingSeq" "=" "StuGrades" "GradeHeadingSeq" "" "" 7675 "" 7673 1
7660 "WHERE" "" "Grade" "GradeSeq" "=" "StuGrades" "GradeSeq" "" "" 7677 "" 7676 1
7660 "WHERE" "" "Student" "StudentID" "=" "StuGrades" "StudentId" "" "" 7679 "" 7678 1
7660 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7682 "" 7681 1
7660 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2005" "" 7684 "" 7683 3
7660 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7685 "" 7683 1
7660 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2004" "" 7686 "" 7683 2
7660 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 7687 "" 7683 4
7660 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7689 "" 7688 1
7660 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7691 "" 7690 2
7660 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7692 "" 7690 1
7660 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 7663 "" 7662 1
7660 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "12" "" 7664 "" 7662 2
7660 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 7665 "" 7662 3
7660 "Where" "" "SchoolCourseDept" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 7667 "" 7666 1
7660 "WHERE" "" "Department" "DepartmentSeq" "=" "SchoolCourseDept" "DepartmentSeq" "" "" 7669 "" 7668 1
[END]
[MyQueryFields]
7660 7697 "Person" "FirstName" "" "x(15)" "First Name" no 3
7660 7698 "Grade" "GradeCode" "" "X(5)" "Grade" no 7
7660 7699 "Course" "CourseDescr" "" "X(40)" "Description" no 6
7660 7710 "StuGrades" "NumCourseAbsences" "" ">>>9" "Absenses" no 8
7660 7693 "Student" "GradeLevel" "" "X(2)" "GL" no 4
7660 7694 "Course" "CourseTitle" "" "X(15)" "Course ID" no 5
7660 7695 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7660 7696 "Person" "LastName" "" "x(15)" "Last Name" no 2
[END]
[MyQuerySort]
7660 7700 "Course" "CourseTitle" yes "Count" 1 "" "" no
7660 7701 "Grade" "GradeCode" no "" 2 "" "" no
7660 7702 "Person" "FirstName" no "" 4 "" "" no
7660 7703 "Person" "LastName" no "Count" 3 "" "" no
[END]
[MyQueryDocs]
7660 7704 2 "Portrait" 0 "" ""
7660 7705 6 "Portrait" 0 "" ""
7660 7706 1 "Portrait" 0 "" ""
7660 7707 4 "" 0 "" ""
[END]