Exiting Students Validation

Contents

Introduction

Use this report option to validate the data entered on the Exiting page of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information.

This report populates the virtual table and creates a link to the Exiting.html report.

Selection Criteria

For the Exiting Students Page Validation report, student records are selected.

School Selection

The report selects which school records to use based on the following criteria:

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’s School ID is included in the school list for which the report is run.
The student’s has an exit date that falls between the start and end date.
The student’s exit date is greater than the student’s entry date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	Choose one of the following from the pop-up menu: Current School Only – Includes all student 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. District Wide (default) – Includes all student records on the PowerSchool server that meet the selection criteria.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2011 @ 10:05 AM.
Select District	(Optional) If this option appears, select the District for which to run the report.
Start Date	Enter the start date for the reporting period. Format: MM/DD/YYYY
End Date	Enter the end date for the reporting period. Format: MM/DD/YYYY

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	Field Type	Field Length
1	Student’s Name	This field contains the student’s full name. This field is calculated using the student’s Legal Last Name, Legal First Name, and Legal Middle Name entered on the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[S_IL_STU_Demographics_X]Legal_Last_Name [S_IL_STU_Demographics_X]Legal_First_Name [S_IL_STU_Demographics_X]Legal_Middle_Name	Alpha-numeric	N/A
2	State Student Identifier	This field contains the student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This field should be blank for all students upon first submission of the Student. This field is extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information.	[Students]State_StudentNumber	Numeric	9
3	Student Number	This field contains the PowerSchool student identification code. This field is extracted from the Demographics page of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If this field is blank, the PowerSchool Student Number entered on the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information, is extracted.	[Students]Student_Number	Alpha-numeric	50
4	Legal Last Name	This field contains the legal last name of the student. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If the Legal Last Name field is left blank, the student’s last name entered on the ISBE SIS Student Demographic/ Enrollment Information page is used in this field.	[S_IL_STU_Demographics_X]Legal_Last_Name	Alpha-numeric	30
5	Legal First Name	This field contains the legal first name of the student. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If the Legal First Name field is left blank, the student’s first name entered on the ISBE SIS Student Demographic/Enrollment Information page is used in this field.	[S_IL_STU_Demographics_X]Legal_First_Name	Alpha-numeric	30
6	DOB	This field contains the student’s date of birth. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If the Birth Date field is left blank, the student’s birth date entered on the Edit Student Demographics page is used in this field.	[Students]DOB	Numeric	10
7	RCDTS Home School	This field contains the Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s home school. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If left blank, the RCDTS Home School entered on the Edit School page is used in the report.	[S_IL_STU_X]RCDTS_Home_School	Alpha-numeric	6
8	RCDTS Serving School	This field contains the Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s serving school. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If left blank, the RCDTS Serving School entered on the Edit School page is used in the report.	[S_IL_STU_X]RCDTS_Serving_School	Alpha-numeric	6
9	Exit Date	This field contains the student’s current enrollment exit date. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information.	[Students]ExitDate	Numeric	10
10	Enrollment Exit Status	01 in this field indicates that the student’s enrollment exit status is permanent. The number 02 in this field indicates that the student’s enrollment exit status is temporary. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If the student’s enrollment exit status is blank on the ISBE SIS Exiting Students Information page, this field defaults to 01 (Permanent).	[S_IL_STU_X]Enrollment_Exit_Status	Numeric	2
11	Enrollment Type Code	This field contains the Enrollment Exit / Withdrawal Type Code that identifies the reason the student exited the school. This field is extracted from the Exiting tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Exiting Students Information. If this field is left blank on the ISBE SIS Exiting Students Information page, this field contains the Exit /Withdrawal Code entered on the Edit Current Enrollment page for this student.	[S_IL_STU_X]Enrollment_Exit_Type_Code	Numeric	2