Skip to main content
Skip table of contents

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.

Back to Top

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.

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.