[MyQuery]
7711 "lpattonq" "Guardian Information" "Guardian Information"
[END]
[MyQueryTables]
7711 7712 1 "EACH" "Student" no
7711 7714 2 "FIRST" "Person" no
7711 7716 3 "FIRST" "EntryWithdrawl" no
7711 7721 4 "FIRST" "EntryWithdrawlCodes" no
7711 7723 5 "FIRST" "EnrollStatus" no
7711 7775 6 "FIRST" "addressPerson" no
7711 7774 7 "FIRST" "Address" no
7711 7726 8 "FIRST" "Phone" no
7711 7729 9 "FIRST" "GuardianStudent" no
7711 7763 10 "FIRST" "bPerson" yes
7711 7732 11 "FIRST" "bPhone" yes
7711 7735 12 "FIRST" "cPhone" yes
7711 7738 13 "FIRST" "bGuardianStudent" yes
7711 7765 14 "FIRST" "cPerson" yes
7711 7742 15 "FIRST" "dPhone" yes
7711 7745 16 "FIRST" "ePhone" yes
[END]
[MyQueryWhere]
7711 "Where" "" "addressPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 7776 "" 7775 1
7711 "WHERE" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 7777 "" 7774 1
7711 "WHERE" "" "bPerson" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7764 "" 7763 1
7711 "WHERE" "" "cPerson" "PersonSeq" "=" "bGuardianStudent" "PersonSeq" "" "" 7766 "" 7765 1
7711 "OUTER-JOIN WHERE" "" "Phone" "PersonSeq" "=" "Student" "personSeq" "" "" 7728 "" 7726 1
7711 "OUTER-JOIN WHERE" "" "GuardianStudent" "studentId" "=" "Student" "StudentID" "" "" 7730 "" 7729 1
7711 "AND" "" "GuardianStudent" "RelationshipSeq" "=" "" "" "2" "" 7731 "" 7729 2
7711 "OUTER-JOIN WHERE" "" "bPhone" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7733 "" 7732 1
7711 "AND" "" "bPhone" "PhoneTypeSeq" "=" "" "" "7" "" 7734 "" 7732 2
7711 "OUTER-JOIN WHERE" "" "cPhone" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7736 "" 7735 1
7711 "AND" "" "cPhone" "PhoneTypeSeq" "=" "" "" "9" "" 7737 "" 7735 2
7711 "OUTER-JOIN WHERE" "" "bGuardianStudent" "studentId" "=" "Student" "StudentID" "" "" 7739 "" 7738 1
7711 "AND" "" "bGuardianStudent" "PersonSeq" "<>" "GuardianStudent" "PersonSeq" "" "" 7740 "" 7738 2
7711 "AND" "" "bGuardianStudent" "RelationshipSeq" "=" "" "" "1" "" 7741 "" 7738 3
7711 "OUTER-JOIN WHERE" "" "dPhone" "PersonSeq" "=" "bGuardianStudent" "PersonSeq" "" "" 7743 "" 7742 1
7711 "AND" "" "dPhone" "PhoneTypeSeq" "=" "" "" "3" "" 7744 "" 7742 2
7711 "OUTER-JOIN WHERE" "" "ePhone" "PersonSeq" "=" "bGuardianStudent" "PersonSeq" "" "" 7746 "" 7745 1
7711 "AND" "" "ePhone" "PhoneTypeSeq" "=" "" "" "57" "" 7747 "" 7745 2
7711 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7713 "" 7712 1
7711 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7715 "" 7714 1
7711 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 7717 "" 7716 2
7711 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 7718 "" 7716 3
7711 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7719 "" 7716 1
7711 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 7720 "" 7716 4
7711 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7722 "" 7721 1
7711 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7724 "" 7723 2
7711 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7725 "" 7723 1
7711 "AND" "" "Phone" "PhoneTypeSeq" "CAN-DO" "" "" "1" "" 7727 "" 7726 2
[END]
[MyQueryFields]
7711 7778 "Address" "StreetNo" "" "x(8)" "Stu Street No" no 5
7711 7779 "Address" "Address1" "" "X(25)" "Address1" no 6
7711 7780 "Address" "Address2" "" "X(25)" "Address" no 7
7711 7781 "Address" "City" "" "X(25)" "City" no 8
7711 7782 "Address" "State" "" "X(2)" "State" no 9
7711 7783 "Address" "ZipCode" "" "X(10)" "Zip Code" no 10
7711 7767 "Person" "MiddleInitial" "" "X(1)" "Stu Middle Name" no 4
7711 7768 "bPerson" "LastName" "" "x(15)" "Last Name" no 13
7711 7769 "bPerson" "FirstName" "" "x(15)" "First Name" no 14
7711 7770 "bPerson" "workPlace" "" "x(40)" "Workplace" no 15
7711 7771 "cPerson" "LastName" "" "x(15)" "Last Name" no 18
7711 7772 "cPerson" "FirstName" "" "x(15)" "First Name" no 19
7711 7773 "cPerson" "workPlace" "" "x(40)" "Workplace" no 20
7711 7748 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7711 7749 "Person" "LastName" "" "x(15)" "Stu Last Name" no 2
7711 7750 "Person" "FirstName" "" "x(15)" "Stu First Name" no 3
7711 7752 "Phone" "PhoneNo" "" "X(15)" "Home Phone" no 12
7711 7753 "bPhone" "PhoneNo" "" "X(15)" "Mom Cell" no 16
7711 7754 "cPhone" "PhoneNo" "" "X(15)" "Mom Work" no 17
7711 7755 "dPhone" "PhoneNo" "" "X(15)" "Dad Cell" no 21
7711 7756 "ePhone" "PhoneNo" "" "X(15)" "Dad Work" no 22
[END]
[MyQuerySort]
7711 7757 "Person" "FirstName" no "" 3 "" "" no
7711 7758 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
7711 7760 6 "Portrait" 0 "" ""
7711 7761 1 "Portrait" 0 "" ""
7711 7762 4 "" 0 "" ""
7711 7759 2 "Portrait" 0 "" ""
[END]