[MyQuery]
8383 "BCarraherSIS" "Entry Withdrawal Report Selected Codes" "Entry Withdrawal Report Selected Codes"
[END]
[MyQueryTables]
8383 8384 1 "EACH" "Student" no 0
8383 8385 2 "FIRST" "Person" no 0
8383 8387 3 "FIRST" "EntryWithdrawl" no 0
8383 8389 4 "FIRST" "EntryWithdrawlCodes" no 0
8383 8391 5 "FIRST" "ReportingReason" no 0
8383 8393 6 "FIRST" "EnrollmentStatusCodes" no 0
8383 8395 7 "FIRST" "EnrollmentReason" no 0
8383 8397 8 "FIRST" "EnrollStatus" no 0
8383 8399 9 "FIRST" "SchoolProfile" no 0
8383 8401 10 "FIRST" "TownCodes" no 0
[END]
[MyQueryWhere]
8383 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 8386 "" 8385 1
8383 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 8388 "" 8387 1
8383 "WHERE" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 8390 "" 8389 1
8383 "Where" "" "ReportingReason" "ReportingReasonSeq" "=" "EntryWithdrawl" "ReportingReasonSeq" "" "" 8392 "" 8391 1
8383 "Where" "" "EnrollmentStatusCodes" "EnrollmentStatusCodesSeq" "=" "EntryWithdrawl" "EnrollmentStatusCodesSeq" "" "" 8394 "" 8393 1
8383 "Where" "" "EnrollmentReason" "EnrollmentReasonSeq" "=" "EntryWithdrawl" "EnrollmentReasonSeq" "" "" 8396 "" 8395 1
8383 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 8398 "" 8397 1
8383 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 8400 "" 8399 1
8383 "Where" "" "TownCodes" "TownCodesSeq" "=" "Student" "TownCodesSeq" "" "" 8402 "" 8401 1
8383 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "False" "" 8403 "" 8384 1
8383 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/28/2017" "" 8404 "" 8387 2
8383 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2018" "" 8405 "" 8387 3
8383 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 8406 "" 8387 4
8383 "AND" "" "EntryWithdrawlCodes" "EntryWithdrawlCode" "CAN-DO" "" "" "R1/01.R2/01,R3/01,R4/01" "" 8407 "" 8389 2
8383 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 8408 "" 8397 2
[END]
[MyQueryFields]
8383 8413 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
8383 8414 "Student" "SASID" "" "X(10)" "SASID" no 2 0
8383 8415 "Person" "LastName" "" "x(15)" "Last Name" no 3 0
8383 8416 "Person" "FirstName" "" "x(15)" "First Name" no 4 0
8383 8417 "Student" "GradeLevel" "" "X(2)" "GL" no 5 0
8383 8418 "Student" "YOG" "" "9999" "YOG" no 6 0
8383 8419 "Student" "Gender" "" "Male/Female" "Gender" no 7 0
8383 8420 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 8 0
8383 8421 "EntryWithdrawl" "EntryWithdrawlDate" "" "99/99/9999" "Entry Withdrawal Date" no 9 0
8383 8422 "EntryWithdrawlCodes" "EntryWithdrawlDescr" "" "X(30)" "Entry Withdrawal Desc" no 10 0
8383 8423 "ReportingReason" "StateCode" "" "X(3)" "DOE 11" no 11 0
8383 8424 "EnrollmentStatusCodes" "StateCode" "" "X(3)" "DOE 12" no 12 0
8383 8425 "EnrollmentReason" "StateCode" "" "X(3)" "DOE 13" no 13 0
8383 8426 "TownCodes" "TownCode" "" "X(6)" "Town Code" no 14 0
8383 8427 "TownCodes" "City" "" "X(25)" "City" no 15 0
8383 8428 "TownCodes" "State" "" "X(2)" "State" no 16 0
8383 8429 "TownCodes" "Zip" "" "99999" "Zip Code" no 17 0
[END]
[MyQuerySort]
8383 8431 "Person" "FirstName" no "" 2 "" "" no
8383 8430 "Person" "imageFile" no "" 1 "" "" no
[END]
[MyQueryDocs]
8383 8409 2 "Portrait" 0 "" ""
8383 8410 6 "Portrait" 0 "" ""
8383 8411 1 "Portrait" 0 "" ""
8383 8412 4 "" 0 "" ""
[END]