[MyQuery]
1757 "MSweenySIS" "Homeless SIF Fields" "Homeless SIF Fields"
[END]
[MyQueryTables]
1757 1758 1 "EACH" "Student" no 0
1757 1760 2 "FIRST" "Person" no 0
1757 1762 3 "FIRST" "EntryWithdrawl" no 0
1757 1767 4 "FIRST" "EntryWithdrawlCodes" no 0
1757 1769 5 "FIRST" "EnrollStatus" no 0
1757 1772 6 "FIRST" "DOEField" no 0
1757 1774 7 "FIRST" "StuDOEField" no 0
1757 1777 8 "FIRST" "DOEFieldValue" no 0
1757 1779 9 "FIRST" "bDOEField" yes 0
1757 1781 10 "FIRST" "bStuDOEField" yes 0
1757 1784 11 "FIRST" "bDOEFieldValue" yes 0
1757 1786 12 "FIRST" "cDOEField" yes 0
1757 1788 13 "FIRST" "cStuDOEField" yes 0
1757 1791 14 "FIRST" "cDOEFieldValue" yes 0
1757 1793 15 "FIRST" "dDOEField" yes 0
1757 1795 16 "FIRST" "dStuDOEField" yes 0
1757 1798 17 "FIRST" "dDOEFieldValue" yes 0
[END]
[MyQueryWhere]
1757 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "False" "" 1759 "" 1758 1
1757 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 1761 "" 1760 1
1757 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 1763 "" 1762 4
1757 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/30/2017" "" 1764 "" 1762 2
1757 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/22/2018" "" 1765 "" 1762 3
1757 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 1766 "" 1762 1
1757 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 1768 "" 1767 1
1757 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 1770 "" 1769 2
1757 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 1771 "" 1769 1
1757 "WHERE" "" "DOEField" "DOEDescription" "=" "" "" "Homeless" "" 1773 "" 1772 1
1757 "OUTER-JOIN WHERE" "" "StuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 1775 "" 1774 1
1757 "AND" "" "StuDOEField" "DOEFieldSeq" "=" "DOEField" "DOEFieldSeq" "" "" 1776 "" 1774 2
1757 "OUTER-JOIN WHERE" "" "DOEFieldValue" "DOEFieldValueSeq" "=" "StuDOEField" "DOEFieldValueSeq" "" "" 1778 "" 1777 1
1757 "WHERE" "" "bDOEField" "DOEDescription" "=" "" "" "Foster Care" "" 1780 "" 1779 1
1757 "AND" "" "bStuDOEField" "DOEFieldSeq" "=" "bDOEField" "DOEFieldSeq" "" "" 1782 "" 1781 2
1757 "OUTER-JOIN WHERE" "" "bStuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 1783 "" 1781 1
1757 "OUTER-JOIN WHERE" "" "bDOEFieldValue" "DOEFieldValueSeq" "=" "bStuDOEField" "DOEFieldValueSeq" "" "" 1785 "" 1784 1
1757 "WHERE" "" "cDOEField" "DOEDescription" "=" "" "" "Dwelling Arrangement" "" 1787 "" 1786 1
1757 "OUTER-JOIN WHERE" "" "cStuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 1789 "" 1788 1
1757 "AND" "" "cStuDOEField" "DOEFieldSeq" "=" "cDOEField" "DOEFieldSeq" "" "" 1790 "" 1788 2
1757 "OUTER-JOIN WHERE" "" "cDOEFieldValue" "DOEFieldValueSeq" "=" "cStuDOEField" "DOEFieldValueSeq" "" "" 1792 "" 1791 1
1757 "WHERE" "" "dDOEField" "DOEName" "=" "" "" "MAHomelessUnaccompanied" "" 1794 "" 1793 1
1757 "OUTER-JOIN WHERE" "" "dStuDOEField" "StudentID" "=" "Student" "StudentID" "" "" 1796 "" 1795 1
1757 "AND" "" "dStuDOEField" "DOEFieldSeq" "=" "dDOEField" "DOEFieldSeq" "" "" 1797 "" 1795 2
1757 "OUTER-JOIN WHERE" "" "dDOEFieldValue" "DOEFieldValueSeq" "=" "dStuDOEField" "DOEFieldValueSeq" "" "" 1799 "" 1798 1
[END]
[MyQueryFields]
1757 1800 "bDOEField" "DOEDescription" "" "x(60)" "Description" no 9 0
1757 1801 "bDOEFieldValue" "DOEValueCode" "" "x(8)" "Code" no 10 0
1757 1802 "DOEField" "DOEDescription" "" "x(60)" "Description" no 7 0
1757 1803 "DOEFieldValue" "DOEValueCode" "" "x(8)" "Code" no 8 0
1757 1804 "Person" "LastName" "" "x(15)" "Last Name" no 2 0
1757 1805 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
1757 1806 "Person" "FirstName" "" "x(15)" "First Name" no 3 0
1757 1807 "Person" "MiddleInitial" "" "X(1)" "MI" no 4 0
1757 1808 "Student" "GradeLevel" "" "X(2)" "GL" no 5 0
1757 1809 "Student" "Gender" "" "Male/Female" "Gender" no 6 0
1757 1810 "cDOEField" "DOEDescription" "" "x(60)" "Description" no 11 0
1757 1811 "cDOEFieldValue" "DOEValueCode" "" "x(8)" "Code" no 12 0
1757 1812 "dDOEField" "DOEDescription" "" "x(60)" "Description" no 13 0
1757 1813 "dDOEFieldValue" "DOEValueCode" "" "x(8)" "Code" no 14 0
[END]
[MyQuerySort]
1757 1814 "Person" "FirstName" no "" 2 "" "" no
1757 1815 "Person" "LastName" no "" 1 "" "" no
[END]
[MyQueryDocs]
1757 1816 2 "Portrait" 0 "" ""
1757 1817 6 "Portrait" 0 "" ""
1757 1818 1 "Portrait" 0 "" ""
1757 1819 4 "" 0 "" ""
[END]