Daily Discipline Student Data

Introduction

This file should be submitted on a daily basis if students are suspended or expelled for a violent incident. This file is used to transmit student level data to MSIS for informational use only.

Incidents are grouped into the following types:

Alternative Education codes are used to track reasons for remanding students to Alternative School and do not count in aggregate numbers of incidents for the school/district. This data may be used to determine funding for alternative programs.
Persistently Dangerous School codes must be reported within 72 hours of occurrence.

State Law codes are incident codes reported to track dispositions and may be reported in the monthly submission.

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.

Back to Top

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 discipline log entries. Log types are set up at the district level. See the District Setup for more information.
Version	Enter 1, 2, or 3 to indicate by what value the transactions must be incremented. The default value is 1.
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
STUDENT
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
15	DATE	The date the incident occurred.	[Log]Discipline_IncidentDate
INCIDENT
16	LOC	The location where the incident occurred. Valid values: S B O	[Log]Discipline_IncidentLocation
17	BYFNAME	The first name of the individual who reported the incident.	[S_MS_LOG_X]IncidentRepByFName
18	BYLNAME	The last name of the individual who reported the incident.	[S_MS_LOG_X]IncidentRepByLName
19	BYTYPE	The role of the individual who reported the incident (staff, student, etc.). Valid values: S M T P	[S_MS_LOG_X]Discipline_Reporter
20	TYPE	This field is reported if the weapon type is reported.	[Log]Discipline_IncidentTypeCategory
21	WEAPON	The type of weapon involved in the incident.	[S_MS_LOG_X]WeaponType
22	DESC	The type of incident that occurred.	[S_MS_LOG_X]Description
23	DISPTYPE	The type of disposition (disciplinary action taken) assigned to the offender. This field is reported if the description is reported. Valid values: SUS – Suspended EXP – Expelled	[Log]Consequence
24	DISPDESC	Details regarding the disposition (disciplinary action).	[Log]Discipline_ActionTakenDetail
25	DISPSTART	Not required.	Not reported.
26	DISPEND	Not required.	Not reported.
27	DISPDURATION	Not required.	Not reported.

Back to Top