[MyQuery]
2847 "jgriffin" "Guaradians Filter By Legal Status" "Guardians Filter By Legal Status"
[END]
[MyQueryTables]
2847 2874 1 "EACH" "GuardianStudent" no
2847 2875 2 "FIRST" "bPerson" yes
2847 2877 3 "FIRST" "LegalStatus" no
2847 2848 4 "FIRST" "Student" no
2847 2850 5 "FIRST" "Person" no
2847 2852 6 "FIRST" "EntryWithdrawl" no
2847 2856 7 "FIRST" "EntryWithdrawlCodes" no
2847 2858 8 "FIRST" "EnrollStatus" no
2847 2861 9 "FIRST" "RoomCatalog" no
[END]
[MyQueryWhere]
2847 "WHERE" "" "Student" "StudentID" "=" "GuardianStudent" "studentId" "" "" 2849 "" 2848 1
2847 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 2851 "" 2850 1
2847 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 2853 "" 2852 2
2847 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 2854 "" 2852 3
2847 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 2855 "" 2852 1
2847 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 2857 "" 2856 1
2847 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 2859 "" 2858 2
2847 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 2860 "" 2858 1
2847 "Where" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 2862 "" 2861 1
2847 "WHERE" "" "bPerson" "PersonSeq" "=" "GuardianStudent" "PersonSeq" "" "" 2876 "" 2875 1
2847 "WHERE" "" "LegalStatus" "LegalStatusSeq" "=" "GuardianStudent" "LegalStatusSeq" "" "" 2878 "" 2877 1
2847 "AND" "" "LegalStatus" "LegalStatusSeq" "CAN-DO" "" "" "1" "" 2881 "" 2877 2
[END]
[MyQueryFields]
2847 2863 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 4
2847 2864 "Person" "LastName" "" "x(15)" "Last Name" no 5
2847 2865 "Person" "FirstName" "" "x(15)" "First Name" no 6
2847 2866 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 8
2847 2867 "Student" "GradeLevel" "" "X(2)" "GL" no 7
2847 2885 "bPerson" "LastName" "" "x(15)" "Last Name" no 1
2847 2886 "bPerson" "FirstName" "" "x(15)" "First Name" no 2
2847 2887 "LegalStatus" "LegalStatusDescr" "" "X(25)" "Description" no 3
[END]
[MyQuerySort]
2847 2884 "bPerson" "FirstName" no "" 2 "" "" no
2847 2883 "bPerson" "LastName" no "" 1 "" "" no
2847 2868 "Person" "FirstName" no "" 4 "" "" no
2847 2869 "Person" "LastName" no "Count" 3 "Student" "StudentID" no
[END]
[MyQueryDocs]
2847 2870 2 "Portrait" 0 "" ""
2847 2871 6 "Portrait" 0 "" ""
2847 2872 1 "Portrait" 0 "" ""
2847 2873 4 "" 0 "" ""
[END]