Summer Withdrawal Report
Contents
Introduction
Use the Summer Withdrawal report to collect the information required to report students that withdrew from the district over the summer and can also be used to report students who had Exit Type updates.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Summer Withdrawal Report, student enrollment records are used.
School Selection
The report selects which school records to use based on the following criteria:
- The school is not excluded from state reporting.
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- The student is not excluded from state reporting.
- For a summer withdrawal
- The student was actively enrolled at the end of the prior school year
- The student has an Exit Code other than 00, 14, 30-31, & 33
- The student's enrollment began prior to the report start date, and they exited on or before the report end date.
- For prior year exit code updates:
- The student should be pre-selected.
- Prior Year Exit Code Update parameter set to 'Yes'
- Report Start Date and Report End Date (use exit date for end of year withdrawals) should be for the prior year.
Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.
Required Data Setup
You must define the following information before generating this extract.
- Exclude students from this report, General tab of the state/province-RI page.
For Summer Withdrawals:
- Students withdrawing during the summer must be withdrawn.
- Report Start Date should be at least 2 days after the prior year's last day of school.
- Report End Date should be the day prior to the first day of school.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Select Students | The default option is All students. |
Report Start Date | Enter the beginning date in the range of dates you want to use to determine the student records to include on the report. |
Report End Date | Enter the last date in the range of dates you want to use to determine the student records to include on the report. |
| Scheduling Options | |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run. |
Please Select Schedule Settings | Enter the Start Date and Start time. Click the Repeat button. |
Please select repeat cycle options. | Choose the applicable option. |
Please select end date range option | Enter the appropriate information. |
Submit | Click Submit to schedule the report |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Column | Data Element | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
A | SASID | The student's state identification code as noted on Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information. | [Students]State_StudentNumber | Number | 10 |
B | LASID | The student's local school identification code as noted on Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information. | [Students]Student_Number | Text | 16 |
C | DISTCODE | The district code assigned to the school district reporting the student information as noted on District Setup page, Start Page > District Setup > District Information. | [Prefs]Name=districtnumber OR [Prefs]Value | Text | 2 |
D | LASTNAME | The last name of the student as noted on the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal last name is populated on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information. | [Students]Last_Name OR | Text | 50 |
E | EXIT_TYPE | The circumstances under which a student exited school as noted on the Edit Enrollment page, Start Page > Student Selection > Transfer Info > Edit [Current] Enrollment. This field contains a W, indicating the student was a summer withdrawal during the reporting period. | [S_RI_STU_X]Exit_Type OR [S_RI_REN_X]Exit_Type | Text | 2 |