[MyQuery]
671 "apsimg9408" "ConnectEDU_Course_file" "ConnectEDU_Course_file"
[END]
[MyQueryTables]
671 672 1 "EACH" "Student" no 0
671 674 2 "FIRST" "Person" no 0
671 676 3 "FIRST" "EntryWithdrawl" no 0
671 681 4 "FIRST" "EntryWithdrawlCodes" no 0
671 683 5 "FIRST" "EnrollStatus" no 0
671 686 6 "EACH" "StuGrades" no 0
671 688 7 "EACH" "GradeHeading" no 0
671 691 8 "EACH" "GradeHeadingTerm" no 0
671 693 9 "EACH" "SchoolTerm" no 0
671 695 10 "FIRST" "Terms" no 0
671 697 11 "EACH" "Grade" no 0
671 699 12 "EACH" "SchoolProfile" no 0
671 701 13 "FIRST" "SchoolCourse" no 0
671 703 14 "FIRST" "Course" no 0
671 705 15 "EACH" "Transcript" no 0
671 708 16 "EACH" "TranscriptCredit" no 0
[END]
[MyQueryWhere]
671 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "false" "" 673 "" 672 1
671 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 675 "" 674 1
671 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2010" "" 677 "" 676 2
671 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/14/2011" "" 678 "" 676 3
671 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 679 "" 676 1
671 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 680 "" 676 4
671 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 682 "" 681 1
671 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 684 "" 683 2
671 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 685 "" 683 1
671 "WHERE" "" "StuGrades" "StudentId" "=" "Student" "StudentID" "" "" 687 "" 686 1
671 "AND" "" "GradeHeading" "isTermGrade" "=" "" "" "yes" "" 689 "" 688 2
671 "WHERE" "" "GradeHeading" "GradeHeadingSeq" "=" "StuGrades" "GradeHeadingSeq" "" "" 690 "" 688 1
671 "WHERE" "" "GradeHeadingTerm" "GradeHeadingSeq" "=" "GradeHeading" "GradeHeadingSeq" "" "" 692 "" 691 1
671 "WHERE" "" "SchoolTerm" "SchoolTermSeq" "=" "GradeHeadingTerm" "SchoolTermSeq" "" "" 694 "" 693 1
671 "WHERE" "" "Terms" "TermSeq" "=" "SchoolTerm" "TermSeq" "" "" 696 "" 695 1
671 "WHERE" "" "Grade" "GradeSeq" "=" "StuGrades" "GradeSeq" "" "" 698 "" 697 1
671 "WHERE" "" "SchoolProfile" "SchoolProfileSeq" "=" "GradeHeading" "SchoolProfileSeq" "" "" 700 "" 699 1
671 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 702 "" 701 1
671 "Where" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 704 "" 703 1
671 "OUTER-JOIN WHERE" "" "Transcript" "StudentID" "=" "Student" "StudentID" "" "" 706 "" 705 1
671 "AND" "" "Transcript" "SchoolCourseSeq" "=" "SchoolCourse" "SchoolCourseSeq" "" "" 707 "" 705 2
671 "OUTER-JOIN WHERE" "" "TranscriptCredit" "StudentID" "=" "Student" "StudentID" "" "" 709 "" 708 1
671 "AND" "" "TranscriptCredit" "TranscriptSeq" "=" "Transcript" "TranscriptSeq" "" "" 710 "" 708 2
671 "AND" "" "SchoolTerm" "SchoolProfileSeq" "=" "GradeHeading" "SchoolProfileSeq" "" "" 795 "" 693 2
671 "AND" "" "Terms" "SchoolProfileSeq" "=" "SchoolTerm" "SchoolProfileSeq" "" "" 797 "" 695 2
671 "AND" "" "Grade" "CalendarYearSeq" "=" "SchoolTerm" "CalendarYearSeq" "" "" 798 "" 697 2
[END]
[MyQueryFields]
671 711 "Student" "LASID" "" "X(32)" "LASID" no 2 0
671 712 "Student" "SASID" "" "X(10)" "SASID" no 3 0
671 713 "Grade" "GradeCode" "" "X(5)" "Term Grade" no 9 0
671 714 "SchoolProfile" "SchoolCode" "" "X(3)" "School!Code" no 1 0
671 715 "Course" "CourseName" "" "X(10)" "Course Name" no 6 0
671 716 "Course" "CourseTitle" "" "X(15)" "Course Title" no 7 0
671 717 "SchoolCourse" "CurriculumLevel" "" "9" "Curriculum Level" no 8 0
671 718 "Transcript" "GradeCode" "" "X(8)" "Final Grade" no 10 0
671 719 "TranscriptCredit" "AttemptedCredits" "" "->>,>>9.999" "Attempted Credits" no 12 0
671 720 "TranscriptCredit" "Credits" "" "->>,>>9.999" "Earned Credits" no 11 0
671 790 "SchoolTerm" "SchoolTermSeq" "" ">>>>>>9" "School Term Seq" no 4 0
671 794 "SchoolTerm" "TermSeq" "" ">,>>>,>>9" "Term Seq" no 5 0
[END]
[MyQuerySort]
671 722 "Course" "CourseTitle" no "" 4 "" "" no
671 796 "SchoolTerm" "CalendarYearSeq" no "" 2 "" "" no
671 791 "SchoolTerm" "SchoolTermSeq" no "" 3 "" "" no
671 723 "Student" "StudentID" no "" 1 "" "" no
[END]
[MyQueryDocs]
671 725 2 "Portrait" 0 "" ""
671 726 6 "Portrait" 0 "" ""
671 727 1 "Portrait" 0 "" ""
671 728 4 "" 0 "" ""
[END]