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 or date range. The report is written to verify students transferred-in, transferred-out (exited), and no shows (Enrollment History Entry Date and Exit Date are the same date) on a monthly basis, but the report works for any date range entered within the Academic Year selected.
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) and the dates are within the Academic Year selected.
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]ExitDate<=End Date) and the dates are within the Academic Year selected.
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]ExitDate<=End Date) where the student’s Entry Date is the same date as their Exit Date and the dates are within the Academic Year selected.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Academic Year | Selected the school year of the Start Date and End Date. |
Start Date - Should be a date within the Academic Year selected. | Enter the start date for the date range. |
End Date - Should be a date within the Academic Year selected. | 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. This will be the the enrollment count on the ‘As Of: date’ on the report. |
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. | |