Initial Student Load (ISL)

Introduction

This file is used to assign MSIS IDs. The process runs each year from June 1 to September 30. Use this file to assign MSIS numbers to new kindergarten and first grade students each year.

Selection Criteria

Selection criteria determine which database records 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 from the [Students] and [ReEnrollments] tables based on the following criteria:

The student must have a school enrollment at a school included in the report.
The student’s school entry date must occur on or before the report end date.
The student’s school exit date must occur on or after the report start date.

Report Input

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

Field	Description
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.
Reporting Segment or Begin and Ending Date	Do one of the following: Choose the reporting segment with the appropriate date range from the pop-up menu. Enter a begin and ending date for the report date range.
Report using	Choose one of the following from the pop-up menu: Current School – Include only the current school in the report. Alternate School Number – Include all schools with the alternate school number that may be entered below.
School Number to Use	Enter the school number for either the current school or for the alternate schools to be included in the report.
Version	Enter the version number.
Reporting Period	Choose the appropriate reporting period from the pop-up menu.
File ID (3 digit number)	Enter the three-digit File ID number.

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.

The records in this report are sorted by the student’s last name.

Item #	Data Element	Description	[Table]FieldName
1	Version	The value entered for Version at report runtime.	N/A
2	DTG	The date and time that the report completed, in the format MM-DD-YYYY and hh;mm;ss.	N/A
3	DISTRICT	The district number.	[Prefs]Value [Prefs]Name=districtnumber
4	SCHOOL	The school number, based on the selection at report runtime.	[Schools]School_Number
5	PERIOD	The reporting period selected at report runtime.	N/A
6	T_VERSION	The value entered for Version at report runtime.	N/A
7	TRACK_ID	This value is a combination of the district number, school number, current date, and the File ID entered at report runtime.	[Prefs]Value [Prefs]Name=districtnumber [Schools]School_Number
STUDENT
8	UID	The locally assigned student identifier.	[Students]Student_Number
9	FNAME	The student’s first name.	[Students]First_Name
10	MNAME	The student’s middle name. Note: If the Middle Name field is blank in PowerSchool, this data element is omitted from the report.	[Students]Middle_Name
11	LNAME	The student’s last name.	[Students]Last_Name
12	SSN	The student’s social security number, extracted without dashes. Note: If the SSN field is blank in PowerSchool, this data element is omitted from the report.	[Students]SSN
13	DOB	The student’s date of birth, reported in the format MM/DD/YYYY.	[Students]DOB

Back to Top