MI Monthly Exit/Transfer-In
Introduction
This will create the MI Monthly Exit/Transfer-In report. Use this to generate a listing of students who have transferred in or exited the school during the month. The report should be run using start and end dates within the same month.
Selection Criteria
Selection criteria determine the database records that are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records for the Students Who Transferred In section of the report based on the following criteria:
The student has an enrollment entry date that is between the Start Date and End Date entered in the report parameters. ([Students]EntryDate>=Start Date) and ([Students]EntryDate<=End Date) or ([ReEnrollments]EntryDate>=Start Date) and ([ReEnrollments]EntryDate<=End Date)
The report selects records for the Students Who Exited section of the report based on the following criteria:
The student has an enrollment exit date that is between the Start Date and End Date entered in the report parameters.([Students]ExitDate>=Start Date) and ([Students]ExitDate<=End Date) or ([ReEnrollments]ExitDate>=Start Date) and ([ReEnrollments]<=End Date). The first day of the school calendar must be on or after the report start date for transferred out students in that school to be included.
The report selects records for the Students Who Did not Show section of the report based on the following criteria:
The student has an enrollment exit date that is between the Start Date and End Date entered in the report parameters.([Students]ExitDate>=Start Date) and ([Students]ExitDate<=End Date) or ([ReEnrollments]ExitDate>=Start Date) and ([ReEnrollments]<=End Date) and the Start Date equals the Exit Date
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
---|---|
Start Date - Should be in the same month as the End Date | Enter the start date for the date range. |
End Date - Should be in the same month as the Start Date | Enter the end date for the date range. |
Report Date (The Report date is used to determine the total student count. Any student where the report date is between their enrollment start and end date is included in the total student count.) | Enter the report date |
Select schools to export. | Select which schools to export if applicable. |
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.
Item # | Data Element | Description | [Table]FieldName |
---|---|---|---|
1 | District Name | This contains the name of the school district. | [Prefs]Value [Prefs]Name=districtname |
2 | District Number | This contains the district number. | [Prefs]Value [Prefs]Name=districtnumber |
3 | Date Prepared | This contains the date prepared. | N/A |
4 | Start Date | This contains the Start Date of the reporting period. | N/A |
5 | End Date | This contains the End Date of the reporting period. | N/A |
Students Who Transferred In | |||
6 | School Name | This contains the name of the school for the student's enrollment record. | [Schools]Name |
7 | School ID | This contains the school number for the student's enrollment record. | [Students]SchoolID [ReEnrollments]SchoolID |
8 | Student Name | This contains the name of the student. | [Students]LastFirst |
9 | Student ID | This contains the student's ID number. | [Students]Student_Number |
10 | Grade Level | This contains the student's grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
11 | Entry Date | This contains the entry date for the student's enrollment record. | [Students]EntryDate [ReEnrollments]EntryDate |
12 | Entry Code | This contains the entry code for the student's enrollment record. | [Students]EntryCode [ReEnrollments]EntryCode |
Students Who Exited | |||
13 | School Name | This contains the name of the school for the student's enrollment record. | [Schools]Name |
14 | School ID | This contains the school number for the student's enrollment record. | [Students]SchoolID [ReEnrollments]SchoolID |
15 | Student Name | This contains the name of the student. | [Students]LastFirst |
16 | Student ID | This contains the student's ID number. | [Students]Student_Number |
17 | Grade Level | This contains the student's grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
18 | Exit Date | This contains the exit date for the student's enrollment record. | [Students]ExitDate [ReEnrollments]ExitDate |
19 | Exit Code | This contains the exit code for the student's enrollment record. | [Students]ExitCode [ReEnrollments]ExitCode |
Students Who Did not Show | |||
20 | School Name | This contains the name of the school for the student's enrollment record. | [Schools]Name |
21 | School ID | This contains the school number for the student's enrollment record. | [Students]SchoolID [ReEnrollments]SchoolID |
22 | Student Name | This contains the name of the student. | [Students]LastFirst |
23 | Student ID | This contains the student's ID number. | [Students]Student_Number |
24 | Grade Level | This contains the student's grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
25 | Exit Date | This contains the exit date for the student's enrollment record. | [Students]ExitDate [ReEnrollments]ExitDate |
26 | Exit Code | This contains the exit code for the student's enrollment record. | [Students]ExitCode [ReEnrollments]ExitCode |
Totals | |||
27 | School Name | This contains the name of the school for the student's enrollment record. | [Schools]Name |
28 | Total Added | Total Students Added for the school. | |
29 | Total Dropped | Total Students Dropped for the school. | |
30 | Total No Show | Total No Show Students for the school. | |
31 | As of: <date> | Total Students enrolled as the date entered in the Report Date field for the school. | |
32 | Grand Total | Grand Total of each section for all schools on the report. |