[MyQuery]
7194 "lpattonq" "All Phones by student" "All Phones by Student"
[END]
[MyQueryTables]
7194 7195 1 "EACH" "Student" no
7194 7197 2 "FIRST" "Person" no
7194 7199 3 "FIRST" "EntryWithdrawl" no
7194 7203 4 "FIRST" "SchoolProfile" no
7194 7205 5 "FIRST" "EntryWithdrawlCodes" no
7194 7207 6 "FIRST" "EnrollStatus" no
7194 7210 7 "EACH" "Phone" no
7194 7245 8 "FIRST" "PhoneType" no
[END]
[MyQueryWhere]
7194 "Where" "" "PhoneType" "PhoneTypeSeq" "=" "Phone" "PhoneTypeSeq" "" "" 7246 "" 7245 1
7194 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7196 "" 7195 1
7194 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7198 "" 7197 1
7194 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 7200 "" 7199 2
7194 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 7201 "" 7199 3
7194 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7202 "" 7199 1
7194 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 7204 "" 7203 1
7194 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7206 "" 7205 1
7194 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7208 "" 7207 2
7194 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7209 "" 7207 1
7194 "OUTER-JOIN WHERE" "" "Phone" "PersonSeq" "=" "Student" "personSeq" "" "" 7211 "" 7210 1
[END]
[MyQueryFields]
7194 7247 "PhoneType" "PhoneTypeDescr" "" "X(25)" "Description" no 7
7194 7228 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7194 7229 "Person" "LastName" "" "x(15)" "Last Name" no 2
7194 7230 "Person" "FirstName" "" "x(15)" "First Name" no 3
7194 7231 "Student" "GradeLevel" "" "X(2)" "GL" no 4
7194 7232 "Phone" "PhoneNo" "" "X(15)" "Phone No " no 6
7194 7238 "SchoolProfile" "SchoolCode" "" "X(3)" "School!Code" no 5
[END]
[MyQuerySort]
7194 7239 "Person" "FirstName" no "" 3 "" "" no
7194 7240 "Person" "LastName" no "Count" 2 "" "" no
[END]
[MyQueryDocs]
7194 7241 2 "Portrait" 0 "" ""
7194 7242 6 "Portrait" 0 "" ""
7194 7243 1 "Portrait" 0 "" ""
7194 7244 4 "" 0 "" ""
[END]