[MyQuery]
7824 "lpattonq" "All Guardian Information" "All Guardian Information"
[END]
[MyQueryTables]
7824 7825 1 "EACH" "Student" no
7824 7827 2 "FIRST" "Person" no
7824 7829 3 "FIRST" "EntryWithdrawl" no
7824 7834 4 "FIRST" "EntryWithdrawlCodes" no
7824 7836 5 "FIRST" "EnrollStatus" no
7824 7839 6 "FIRST" "addressPerson" no
7824 7841 7 "FIRST" "Address" no
7824 7843 8 "FIRST" "Phone" no
7824 7846 9 "EACH" "GuardianStudent" no
7824 7849 10 "FIRST" "bPerson" yes
7824 7851 11 "FIRST" "bPhone" yes
7824 7896 12 "FIRST" "cPhone" yes
7824 7900 13 "FIRST" "Relationship" no
[END]
[MyQueryWhere]
7824 "Where" "" "Relationship" "RelationshipSeq" "=" "GuardianStudent" "RelationshipSeq" "" "" 7901 "" 7900 1
7824 "AND" "" "cPhone" "PhoneTypeSeq" "<>" "bPhone" "PhoneTypeSeq" "" "" 7898 "" 7896 2
7824 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7837 "" 7836 2
7824 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7838 "" 7836 1
7824 "Where" "" "addressPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 7840 "" 7839 1
7824 "WHERE" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 7842 "" 7841 1
7824 "OUTER-JOIN WHERE" "" "Phone" "PersonSeq" "=" "Student" "personSeq" "" "" 7844 "" 7843 1
7824 "AND" "" "Phone" "PhoneTypeSeq" "CAN-DO" "" "" "1" "" 7845 "" 7843 2
7824 "OUTER-JOIN WHERE" "" "GuardianStudent" "studentId" "=" "Student" "StudentID" "" "" 7847 "" 7846 1
7824 "OUTER-JOIN WHERE" "" "bPerson" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7850 "" 7849 1
7824 "OUTER-JOIN WHERE" "" "bPhone" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7852 "" 7851 1
7824 "OUTER-JOIN WHERE" "" "cPhone" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 7897 "" 7896 1
7824 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7826 "" 7825 1
7824 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7828 "" 7827 1
7824 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 7830 "" 7829 2
7824 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 7831 "" 7829 3
7824 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7832 "" 7829 1
7824 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 7833 "" 7829 4
7824 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7835 "" 7834 1
[END]
[MyQueryFields]
7824 7902 "Relationship" "RelationshipDescr" "" "X(25)" "Description" no 12
7824 7899 "cPhone" "PhoneNo" "" "X(15)" "Phone 2" no 16
7824 7869 "Address" "StreetNo" "" "x(8)" "Stu Street No" no 5
7824 7870 "Address" "Address1" "" "X(25)" "Address1" no 6
7824 7871 "Address" "Address2" "" "X(25)" "Address" no 7
7824 7872 "Address" "City" "" "X(25)" "City" no 8
7824 7873 "Address" "State" "" "X(2)" "State" no 9
7824 7874 "Address" "ZipCode" "" "X(10)" "Zip Code" no 10
7824 7875 "Person" "MiddleInitial" "" "X(1)" "Stu Middle Name" no 4
7824 7876 "bPerson" "LastName" "" "x(15)" "Last Name" no 13
7824 7877 "bPerson" "FirstName" "" "x(15)" "First Name" no 14
7824 7882 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7824 7883 "Person" "LastName" "" "x(15)" "Stu Last Name" no 2
7824 7884 "Person" "FirstName" "" "x(15)" "Stu First Name" no 3
7824 7885 "Phone" "PhoneNo" "" "X(15)" "Home Phone" no 11
7824 7886 "bPhone" "PhoneNo" "" "X(15)" "Phone 1" no 15
[END]
[MyQuerySort]
7824 7890 "Person" "FirstName" no "" 3 "" "" no
7824 7891 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
7824 7892 6 "Portrait" 0 "" ""
7824 7893 1 "Portrait" 0 "" ""
7824 7894 4 "" 0 "" ""
7824 7895 2 "Portrait" 0 "" ""
[END]