[MyQuery]
2008 "lpattonq" "Alerts" "Alerts"
[END]
[MyQueryTables]
2008 2009 1 "EACH" "Student" no
2008 2011 2 "FIRST" "Person" no
2008 2013 3 "FIRST" "EntryWithdrawl" no
2008 2017 4 "FIRST" "EntryWithdrawlCodes" no
2008 2019 5 "FIRST" "EnrollStatus" no
2008 2022 6 "FIRST" "RoomCatalog" no
2008 2043 7 "EACH" "Alert" no
2008 2045 8 "FIRST" "AlertType" no
[END]
[MyQueryWhere]
2008 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 2014 "" 2013 2
2008 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 2015 "" 2013 3
2008 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 2016 "" 2013 1
2008 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 2018 "" 2017 1
2008 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 2020 "" 2019 2
2008 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 2021 "" 2019 1
2008 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 2012 "" 2011 1
2008 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 2010 "" 2009 1
2008 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 2023 "" 2022 1
2008 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 2042 "" 2013 4
2008 "Where" "" "Alert" "StudentID" "=" "Student" "StudentID" "" "" 2044 "" 2043 1
2008 "Where" "" "AlertType" "AlertTypeSeq" "=" "Alert" "AlertTypeSeq" "" "" 2046 "" 2045 1
[END]
[MyQueryFields]
2008 2029 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
2008 2047 "Alert" "Active" "" "yes/no" "Active" no 10
2008 2048 "Alert" "Comment" "" "X(50)" "Student Comment" no 11
2008 2030 "Person" "LastName" "" "x(15)" "Last Name" no 2
2008 2031 "Person" "FirstName" "" "x(15)" "First Name" no 3
2008 2032 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
2008 2033 "Student" "GradeLevel" "" "X(2)" "GL" no 4
2008 2049 "Alert" "CreateDate" "" "99/99/9999" "Create Date" no 6
2008 2051 "Alert" "CreateUserId" "" "X(8)" "Create User" no 9
2008 2052 "Alert" "DeActiveDate" "" "99/99/9999" "Deactive Date" no 13
2008 2053 "Alert" "DeActiveUser" "" "X(8)" "Deactive User" no 14
2008 2054 "Alert" "ExpirationDate" "" "99/99/9999" "Expiration date" no 12
2008 2055 "AlertType" "AlertDescr" "" "X(20)" "Description" no 8
2008 2057 "AlertType" "AlertTitle" "" "X(8)" "Title" no 7
[END]
[MyQuerySort]
2008 2036 "Person" "FirstName" no "" 3 "" "" no
2008 2037 "Person" "LastName" no "" 2 "" "" no
[END]
[MyQueryDocs]
2008 2038 2 "Portrait" 0 "" ""
2008 2039 6 "Portrait" 0 "" ""
2008 2040 1 "Portrait" 0 "" ""
2008 2041 4 "" 0 "" ""
[END]