Daily Sped Student Data

This file should be submitted on a daily basis if a student’s status in Special Education changes. This file is used to transmit student level data to MSIS for informational use only.

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.

Log Entry Selection

The report selects records from the [Log] table based on the following criteria:

The log entry must be associated with a school included in the report, either the current school, or an alternate school, based on the criteria entered at report runtime.
The log entry date must match the Date to Scan entered at report runtime.
The log type must match the log type entered at report runtime.
The students included in the report must have a log entry that meets the criteria listed above.

Report Input

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

Field	Description
Date to Scan	Enter the date for which to report information.
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.
Reporting Period	Choose the reporting period from the pop-up menu.
Log Type name for Discipline	Enter the name assigned to the log type used for special education log entries. Log types are set up at the district level. See the District Setup for more information.
Increment by 1.0 for each modified Transaction	Enter 1, 2, or 3 to indicate by what value the transactions should be incremented.
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.

Item #	Data Element	Description	[Table]FieldName
1	Version	This value starts with 1.0 and increments by 1.0 for each modified daily discipline student data transaction set representing the same set of data.	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	This value starts with 1.0 and increments by 1.0 for each modified daily discipline student data transaction set representing the same set of data.	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
8	MSISID	The state assigned student identifier.	[Students]State_StudentNumber
9	FNAME	The student’s first name.	[Students]First_Name
10	MNAME	The student’s middle name. Optional: Data Element only pulls if middle_name is not blank	[Students]Middle_Name
11	LNAME	The student’s last name.	[Students]Last_Name
12	SSN	The student’s social security number, extracted without dashes. Optional: Data Element only pulls if SSN is not blank	[Students]SSN
13	DOB	The student’s date of birth, reported in the format MM/DD/YYYY.	[Students]DOB
14	SPECED	Indicates if the student is enrolled in a special education program.	[S_MS_STU_X]SpecialEdInd

Back to Top