[MyQuery]
1043 "lpattonq" "Guardians Receives Mail" "Guardians Receives Mail by School"
[END]
[MyQueryTables]
1043 1227 1 "EACH" "GuardianStudent" no
1043 1050 2 "FIRST" "Person" no
1043 1208 3 "FIRST" "Student" no
1043 1210 4 "FIRST" "EntryWithdrawl" no
1043 1212 5 "FIRST" "EntryWithdrawlCodes" no
1043 1214 6 "FIRST" "EnrollStatus" no
1043 1076 7 "FIRST" "SchoolProfile" no
1043 1216 8 "FIRST" "bPerson" yes
1043 4857 9 "FIRST" "Relationship" no
1043 4861 10 "FIRST" "LegalStatus" no
[END]
[MyQueryWhere]
1043 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 1213 "" 1212 1
1043 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 1215 "" 1214 1
1043 "WHERE" "" "bPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 1217 "" 1216 1
1043 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 1218 "" 1210 2
1043 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/05/2001" "" 1219 "" 1210 3
1043 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 1220 "" 1210 4
1043 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 1221 "" 1214 2
1043 "WHERE" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 1223 "" 1076 1
1043 "WHERE" "" "Person" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 1228 "" 1050 1
1043 "WHERE" "" "Student" "StudentID" "=" "GuardianStudent" "studentId" "" "" 1229 "" 1208 1
1043 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 1230 "" 1210 1
1043 "WHERE" "" "GuardianStudent" "ReceivesMail" "=" "" "" "True" "" 4823 "" 1227 1
1043 "Where" "" "Relationship" "RelationshipSeq" "=" "GuardianStudent" "RelationshipSeq" "" "" 4858 "" 4857 1
1043 "Where" "" "LegalStatus" "LegalStatusSeq" "=" "GuardianStudent" "LegalStatusSeq" "" "" 4862 "" 4861 1
1043 "AND" "" "GuardianStudent" "LivesWStudent" "=" "" "" "False" "" 4914 "" 1227 2
[END]
[MyQueryFields]
1043 1054 "Person" "FirstName" "" "x(15)" "First Name" no 2
1043 1055 "Person" "LastName" "" "x(15)" "Last Name" no 1
1043 1077 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 3
1043 1225 "bPerson" "FirstName" "" "x(15)" "Student First Name" no 4
1043 1226 "bPerson" "LastName" "" "x(15)" "Student Last Name" no 5
1043 4822 "GuardianStudent" "ReceivesMail" "" "yes/no" "Receive Mail" no 6
1043 4859 "Relationship" "RelationshipDescr" "" "X(25)" "Relationship " no 8
1043 4863 "LegalStatus" "LegalStatusDescr" "" "X(25)" "Legal Status" no 9
1043 4915 "GuardianStudent" "LivesWStudent" "" "yes/no" "Lives W/Student" no 7
[END]
[MyQuerySort]
1043 1060 "Person" "FirstName" no "" 3 "" "" no
1043 1061 "Person" "LastName" no "" 2 "" "" no
[END]
[MyQueryDocs]
1043 1063 2 "Portrait" 0 "" ""
1043 1064 6 "Portrait" 0 "" ""
1043 1065 1 "Portrait" 0 "" ""
1043 1066 4 "" 0 "" ""
[END]