[MyQuery]
7525 "lpattonq" "Bio by Course" "Bio by Course"
[END]
[MyQueryTables]
7525 7526 1 "EACH" "Student" no
7525 7528 2 "EACH" "StuRequest" no
7525 7530 3 "FIRST" "SchoolCourse" no
7525 7534 4 "FIRST" "Course" no
7525 7536 5 "FIRST" "CourseSection" no
7525 7538 6 "FIRST" "SchoolCourseDept" no
7525 7540 7 "FIRST" "Department" no
7525 7542 8 "FIRST" "Person" no
7525 7544 9 "FIRST" "EntryWithdrawl" no
7525 7548 10 "FIRST" "EntryWithdrawlCodes" no
7525 7550 11 "FIRST" "EnrollStatus" no
7525 7553 12 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
7525 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7527 "" 7526 1
7525 "WHERE" "" "StuRequest" "StudentID" "=" "Student" "StudentID" "" "" 7529 "" 7528 1
7525 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "1" "" 7532 "" 7530 3
7525 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 7533 "" 7530 1
7525 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 7535 "" 7534 1
7525 "WHERE" "" "CourseSection" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 7537 "" 7536 1
7525 "Where" "" "SchoolCourseDept" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 7539 "" 7538 1
7525 "WHERE" "" "Department" "DepartmentSeq" "=" "SchoolCourseDept" "DepartmentSeq" "" "" 7541 "" 7540 1
7525 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7543 "" 7542 1
7525 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 7545 "" 7544 2
7525 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 7546 "" 7544 3
7525 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7547 "" 7544 1
7525 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7549 "" 7548 1
7525 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7551 "" 7550 1
7525 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7552 "" 7550 2
7525 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 7554 "" 7553 1
7525 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 7531 "" 7530 2
7525 "AND" "" "Course" "CourseTitle" "=" "" "" "345" "" 7573 "" 7534 2
7525 "AND" "" "CourseSection" "CourseSecDesc" "=" "" "" "01" "" 7574 "" 7536 2
[END]
[MyQueryFields]
7525 7555 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 3
7525 7556 "Person" "LastName" "" "x(15)" "Last Name" no 5
7525 7557 "Person" "FirstName" "" "x(15)" "First Name" no 4
7525 7558 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 10
7525 7559 "Student" "GradeLevel" "" "X(2)" "GL" no 8
7525 7560 "Course" "CourseTitle" "" "X(15)" "Course" no 1
7525 7561 "Student" "Gender" "" "Male/Female" "Gender" no 7
7525 7562 "CourseSection" "CourseSecDesc" "" "x(2)" "Section" no 2
7525 7575 "Student" "DateOfBirth" "" "99/99/9999" "D.O.B." no 6
7525 7576 "Student" "SASID" "" "X(10)" "SASID" no 9
[END]
[MyQuerySort]
7525 7563 "Course" "CourseName" no "" 1 "" "" no
7525 7564 "Course" "CourseTitle" no "" 2 "" "" no
7525 7565 "CourseSection" "CourseSecDesc" no "" 3 "" "" no
7525 7566 "Person" "FirstName" no "" 6 "" "" no
7525 7567 "Person" "LastName" no "" 5 "" "" no
[END]
[MyQueryDocs]
7525 7569 2 "Portrait" 0 "" ""
7525 7570 6 "Portrait" 0 "" ""
7525 7571 1 "Portrait" 0 "" ""
7525 7572 4 "" 0 "" ""
[END]