[MyQuery]
7922 "lpattonq" "Bus Routes" "Bus Routes"
[END]
[MyQueryTables]
7922 7923 1 "EACH" "Student" no
7922 7925 2 "FIRST" "Person" no
7922 7927 3 "FIRST" "EntryWithdrawl" no
7922 7931 4 "FIRST" "EntryWithdrawlCodes" no
7922 7933 5 "FIRST" "EnrollStatus" no
7922 7936 6 "FIRST" "RoomCatalog" no
7922 7958 7 "EACH" "StuBus" no
7922 7962 8 "EACH" "busRoute" no
7922 7964 9 "FIRST" "busRouteBusStopX" no
7922 7966 10 "FIRST" "busRouteBusX" no
7922 7968 11 "FIRST" "busStop" no
[END]
[MyQueryWhere]
7922 "AND" "" "StuBus" "SchoolHome" "=" "" "" "Yes" "" 7975 "" 7958 2
7922 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 7924 "" 7923 1
7922 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 7926 "" 7925 1
7922 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2001" "" 7928 "" 7927 2
7922 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2002" "" 7929 "" 7927 3
7922 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 7932 "" 7931 1
7922 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 7934 "" 7933 2
7922 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 7935 "" 7933 1
7922 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 7930 "" 7927 1
7922 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 7937 "" 7936 1
7922 "OUTER-JOIN WHERE" "" "StuBus" "StudentID" "=" "Student" "StudentID" "" "" 7959 "" 7958 1
7922 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 7960 "" 7927 4
7922 "OUTER-JOIN WHERE" "" "busStop" "busStopSeq" "=" "StuBus" "busStopSeq" "" "" 7969 "" 7968 1
7922 "OUTER-JOIN WHERE" "" "busRoute" "BusRouteSeq" "=" "StuBus" "BusRouteSeq" "" "" 7963 "" 7962 1
7922 "OUTER-JOIN WHERE" "" "busRouteBusStopX" "BusRouteSeq" "=" "StuBus" "BusRouteSeq" "" "" 7965 "" 7964 1
7922 "OUTER-JOIN WHERE" "" "busRouteBusX" "BusRouteSeq" "=" "StuBus" "BusRouteSeq" "" "" 7967 "" 7966 1
[END]
[MyQueryFields]
7922 7974 "StuBus" "SchoolHome" "" "School/Home" "Home" no 7
7922 7945 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1
7922 7946 "Person" "LastName" "" "x(15)" "Last Name" no 2
7922 7947 "Person" "FirstName" "" "x(15)" "First Name" no 3
7922 7948 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 5
7922 7949 "Student" "GradeLevel" "" "X(2)" "GL" no 4
7922 7970 "busRoute" "BusRouteId" "" "X(8)" "Bus Route ID" no 8
7922 7971 "busStop" "Intersection" "" "X(30)" "Intersection" no 9
7922 7973 "StuBus" "DayOfWeek" "" "9" "Day Of Week" no 6
[END]
[MyQuerySort]
7922 7976 "busRoute" "BusRouteId" no "" 3 "" "" no
7922 7977 "busRouteBusStopX" "StopNo" no "" 4 "" "" no
7922 7952 "Person" "FirstName" no "" 2 "" "" no
7922 7953 "Person" "LastName" no "Count" 1 "" "" no
[END]
[MyQueryDocs]
7922 7954 2 "Portrait" 0 "" ""
7922 7955 6 "Portrait" 0 "" ""
7922 7956 1 "Portrait" 0 "" ""
7922 7957 4 "" 0 "" ""
[END]