[MyQuery]
8432 "BCarraherSIS" "Entry Withdrawal Report" "Entry Withdrawal Report"
[END]
[MyQueryTables]
8432 8433 1 "EACH" "Student" no 0
8432 8435 2 "FIRST" "Person" no 0
8432 8437 3 "FIRST" "EntryWithdrawl" no 0
8432 8442 4 "FIRST" "EntryWithdrawlCodes" no 0
8432 8445 5 "FIRST" "ReportingReason" no 0
8432 8447 6 "FIRST" "EnrollmentStatusCodes" no 0
8432 8449 7 "FIRST" "EnrollmentReason" no 0
8432 8451 8 "FIRST" "EnrollStatus" no 0
8432 8454 9 "FIRST" "SchoolProfile" no 0
8432 8456 10 "FIRST" "TownCodes" no 0
[END]
[MyQueryWhere]
8432 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "False" "" 8434 "" 8433 1
8432 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 8436 "" 8435 1
8432 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 8438 "" 8437 1
8432 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "08/28/2017" "" 8439 "" 8437 2
8432 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2018" "" 8440 "" 8437 3
8432 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "1" "" 8441 "" 8437 4
8432 "WHERE" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 8443 "" 8442 1
8432 "Where" "" "ReportingReason" "ReportingReasonSeq" "=" "EntryWithdrawl" "ReportingReasonSeq" "" "" 8446 "" 8445 1
8432 "Where" "" "EnrollmentStatusCodes" "EnrollmentStatusCodesSeq" "=" "EntryWithdrawl" "EnrollmentStatusCodesSeq" "" "" 8448 "" 8447 1
8432 "Where" "" "EnrollmentReason" "EnrollmentReasonSeq" "=" "EntryWithdrawl" "EnrollmentReasonSeq" "" "" 8450 "" 8449 1
8432 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 8452 "" 8451 1
8432 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 8453 "" 8451 2
8432 "Where" "" "SchoolProfile" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 8455 "" 8454 1
8432 "Where" "" "TownCodes" "TownCodesSeq" "=" "Student" "TownCodesSeq" "" "" 8457 "" 8456 1
[END]
[MyQueryFields]
8432 8458 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 1 0
8432 8459 "Student" "SASID" "" "X(10)" "SASID" no 2 0
8432 8460 "Person" "LastName" "" "x(15)" "Last Name" no 3 0
8432 8461 "Person" "FirstName" "" "x(15)" "First Name" no 4 0
8432 8462 "Student" "GradeLevel" "" "X(2)" "GL" no 5 0
8432 8463 "Student" "YOG" "" "9999" "YOG" no 6 0
8432 8464 "Student" "Gender" "" "Male/Female" "Gender" no 7 0
8432 8465 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 8 0
8432 8466 "EntryWithdrawl" "EntryWithdrawlDate" "" "99/99/9999" "Entry Withdrawal Date" no 9 0
8432 8467 "EntryWithdrawlCodes" "EntryWithdrawlDescr" "" "X(30)" "Entry Withdrawal Desc" no 10 0
8432 8468 "ReportingReason" "StateCode" "" "X(3)" "DOE 11" no 11 0
8432 8469 "EnrollmentStatusCodes" "StateCode" "" "X(3)" "DOE 12" no 12 0
8432 8470 "EnrollmentReason" "StateCode" "" "X(3)" "DOE 13" no 13 0
8432 8471 "TownCodes" "TownCode" "" "X(6)" "Town Code" no 14 0
8432 8472 "TownCodes" "City" "" "X(25)" "City" no 15 0
8432 8473 "TownCodes" "State" "" "X(2)" "State" no 16 0
8432 8474 "TownCodes" "Zip" "" "99999" "Zip Code" no 17 0
[END]
[MyQuerySort]
8432 8475 "Person" "FirstName" no "" 2 "" "" no
8432 8476 "Person" "imageFile" no "" 1 "" "" no
[END]
[MyQueryDocs]
8432 8477 2 "Portrait" 0 "" ""
8432 8478 6 "Portrait" 0 "" ""
8432 8479 1 "Portrait" 0 "" ""
8432 8480 4 "" 0 "" ""
[END]