[MyQuery]
5349 "lpattonq" "Failure Letters" "Failure Letters"
[END]
[MyQueryTables]
5349 5350 1 "EACH" "StuGrades" no
5349 5351 2 "FIRST" "SchoolCourse" no
5349 5360 3 "FIRST" "Course" no
5349 5362 4 "FIRST" "GradeHeading" no
5349 5365 5 "FIRST" "Grade" no
5349 5368 6 "FIRST" "Student" no
5349 5370 7 "FIRST" "Person" no
5349 5372 8 "FIRST" "EntryWithdrawl" no
5349 5377 9 "FIRST" "EntryWithdrawlCodes" no
5349 5379 10 "FIRST" "EnrollStatus" no
5349 5398 11 "FIRST" "addressPerson" no
5349 5400 12 "FIRST" "AddressType" no
5349 5397 13 "FIRST" "Address" no
[END]
[MyQueryWhere]
5349 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 5361 "" 5360 1
5349 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuGrades" "SchoolCourseSeq" "" "" 5352 "" 5351 1
5349 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "12" "" 5353 "" 5351 2
5349 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 5354 "" 5351 3
5349 "AND" "" "GradeHeading" "GradeHeadingAbbr" "=" "" "" "T1" "" 5363 "" 5362 2
5349 "WHERE" "" "GradeHeading" "GradeHeadingSeq" "=" "StuGrades" "GradeHeadingSeq" "" "" 5364 "" 5362 1
5349 "AND" "" "Grade" "UnWeighted" "<=" "" "" "65" "" 5366 "" 5365 2
5349 "WHERE" "" "Grade" "GradeSeq" "=" "StuGrades" "GradeSeq" "" "" 5367 "" 5365 1
5349 "WHERE" "" "Student" "StudentID" "=" "StuGrades" "StudentId" "" "" 5369 "" 5368 1
5349 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 5371 "" 5370 1
5349 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 5373 "" 5372 3
5349 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 5374 "" 5372 1
5349 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 5375 "" 5372 2
5349 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "SchoolCourse" "SchoolProfileSeq" "" "" 5376 "" 5372 4
5349 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 5378 "" 5377 1
5349 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 5380 "" 5379 2
5349 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 5381 "" 5379 1
5349 "OUTER-JOIN WHERE" "" "addressPerson" "studentId" "=" "StuGrades" "StudentId" "" "" 5399 "" 5398 1
5349 "WHERE" "" "AddressType" "AddressTypeSeq" "=" "addressPerson" "AddressTypeSeq" "" "" 5401 "" 5400 1
5349 "WHERE" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 5402 "" 5397 1
5349 "AND" "" "Address" "AddressTypeSeq" "=" "AddressType" "AddressTypeSeq" "" "" 5403 "" 5397 2
[END]
[MyQueryFields]
5349 5382 "Course" "CourseDescr" "" "X(40)" "Course Name" no 6
5349 5383 "Student" "GradeLevel" "" "X(2)" "GL" no 4
5349 5384 "Course" "CourseTitle" "" "X(15)" "Course ID" no 5
5349 5385 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
5349 5386 "Person" "LastName" "" "x(15)" "Last Name" no 2
5349 5387 "Person" "FirstName" "" "x(15)" "First Name" no 3
5349 5388 "Grade" "GradeCode" "" "X(5)" "Grade" no 7
5349 5404 "Address" "StreetNo" "" "x(8)" "Street No" no 8
5349 5405 "Address" "Address1" "" "X(25)" "Address1" no 9
5349 5406 "Address" "Address2" "" "X(25)" "Address 2" no 10
5349 5407 "Address" "AptNo" "" "X(8)" "Apt No" no 11
5349 5408 "Address" "City" "" "X(25)" "City" no 12
5349 5409 "Address" "State" "" "X(2)" "State" no 13
5349 5410 "Address" "ZipCode" "" "X(10)" "Zip Code" no 14
[END]
[MyQuerySort]
5349 5391 "Person" "FirstName" no "" 4 "" "" no
5349 5392 "Person" "LastName" no "Count" 3 "" "" no
[END]
[MyQueryDocs]
5349 5393 2 "Portrait" 0 "" ""
5349 5394 6 "Portrait" 0 "" ""
5349 5395 1 "Portrait" 0 "" ""
5349 5396 4 "" 0 "" ""
[END]