June Student Discipline Incident (Legacy)
School districts receiving funds under the No Child Left Behind Act (NCLB) and/or the Individuals with Disabilities Education Act (IDEA) are required to report all disciplinary incidents that result in in-school or out-of-school suspension (regardless of duration), expulsion, or unilateral removal to an interim educational setting. The data submitted in the June Cycle are used to satisfy the discipline-related reporting requirements for school districts under the federal Gun-Free School Act, NCLB, IDEA, and the state law (Section 160.522) concerning school district report cards. The report extracts one record per student even if there are multiple enrollment records
This report can be run at the District or School level. The report will only run for the district when in District Office.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
Record Selection
The report selects records from the [Students]and [Log]tables based on the following criteria:
The student must not be marked as "Exclude from State Reporting".
The school must not be marked as "Exclude from State Reporting".
The Log Entry is for Discipline.
The Offense Type is populated.
The incident record must be in the student's enrollment for the selected school.
The report end date is on or after the last in-session day and before the enrollment exit date.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Schools to Include* | Select Multiple Schools using Ctrl+click to select multiple schools or Shift+click to select a range. When running from a school, only the current school can be selected. |
Current Selection Students* | Select All Students or the current selection. |
Select Start Date | Select the Start Date for the range of dates to be reported. |
Select End Date | Select the End Date for the range of dates to be reported. |
Select Incident Type(s) | Select all or a selection of Incident Types |
Select Weapon Type(s) | Select all or a selection of Weapon Types |
Select Removal Type(s) | Select all or a selection of Removal Types |
Select Length Type(s) | Select all or a selection of Length Types |
Include Optional Information | If yes the report will include all information, if no, the report will exclude data that is not required by DESE. |
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.
Note: In the Required column, a value of "C" indicates that the element is conditional – if the element applies to the particular record, then it is required.
Item | Data Element | Description | [Table]FieldName | JUN |
|---|---|---|---|---|
005 | Collection Version | The ending year of the current school year concatenated with 'Feb1.0StuGradFllw', such as '2012 Jun1.0StuDiscipline' for the 2011-2012 school year. | Current Year selection | R |
010 | Current School Year | The ending year of the current school year, such as 2012 for the 2011-2012 school year. | Current Year selection | R |
015 | Attending District Code | The DESE-assigned 6digit county district code for the district where the student attends classes. | [S_MO_STU_X]AttendingDistrict [S_MO_REN_X]AttendingDistrict | R |
020 | Attending School Code | The DESE-assigned 4-digit code for the school where the student attends classes. | [S_MO_STU_X]AttendingSchool [S_MO_REN_X]AttendingSchool | R |
025 | Reporting District Code | The district responsible for reporting the student's data. | [Prefs]Value [Prefs]Name=districtnumber | R |
030 | Reporting School Code | The school responsible for reporting the student's data. The report extracts the alternate school number, if populated. Otherwise, the school number is reported. | [Schools]Alternate_School_Number [Schools]School_Number | R |
035 | Resident District Code | The 6-digit code for the district where the student resides. | [Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence | R |
040 | Resident School Code | The 4-digit code for the student's school of residence. | [S_MO_STU_X]SchoolofResidence [S_MO_REN_X]SchoolofResidence | R |
045 | MOSIS Student ID | The state-assigned student number. For more information, see MOSIS Reference Manual. All submitted students must have a unique state ID. | [Students]State_StudentNumber | R |
050 | Local Student ID | The locally assigned student identifier. | [Students]Student_Number | O |
055 | Legal Last Name | The student's last name. | [StudentCoreFields]PSCore_Legal_Last_Name Or, if NULL: [Students]Last_Name | O |
060 | Legal First Name | The student's first name. | [StudentCoreFields]PSCore_Legal_First_Name Or, if NULL: [Students]First_Name | O |
065 | Legal Middle Name | The student's middle name. | [StudentCoreFields]PSCore_Legal_Middle_Name Or, if NULL: [Students]Middle_Name | O |
070 | Legal Name Suffix | This element is not collected. | [StudentCoreFields]PSCore_Legal_Suffix | O |
075 | Date of Birth | The student's date of birth, reported in the format MM/DD/YYYY. | [Students]DOB | |
080 | Student Grade Level | Grade level as of the time data is being submitted unless otherwise specified. | [S_MO_STU_X]Kindergarten [S_MO_STU_X]Kindergarten [S_MO_REN_X]Kindergarten [Students]Grade_Level [ReEnrollments]Grade_Level | R |
085 | Gender | The student's gender. | [StudentCoreFields]PSCore_Legal_Gender Or, if NULL: [Students]Gender | R |
090 | Race/Ethnicity | The student's race/ethnicity. | [Students]FedEthnicity [StudentsRace]RaceCD | R |
095 | Offense Date | Date offense occurred. | [S_MO_LOG_X]OffenseDate | R |
100 | Offense Type | Nature of offense resulting in removal of student from regular school setting. | [S_MO_LOG_X]OffenseType | R |
105 | Weapon Type | Type of weapon involved in the offense. For further clarification on weapons, see (18 U.S.C.§ 921). | [S_MO_LOG_X]WeaponType | R |
110 | Discipline Removal | Type of disciplinary action used to remove student committing the offense from current educational setting. | [S_MO_LOG_X]ActionTaken | R |
115 | Length Removed | Length of time student committing offense is removed from current educational placement. | [S_MO_LOG_X]Duration | R |
120 | Modified Length | Value is required only if student was expelled. Expelled student whose length of removal was modified (shortened) by chief administrative officer of the school district. | [S_MO_LOG_X]DurationChangeSource | C |
125 | Alternate Placement Indicator | Value is required only if student was expelled. Expelled student receiving educational services in an alternative educational setting. | [S_MO_LOG_X]AlternatePlacement | C |
130 | LEP/ELL | DESE assigned LEP/ELL code set. This code set is used to declare if a student is LEP, ELL Receiving, first year monitoring, or second year monitoring. | [S_MO_STU_X]LEPELL | R |
135 | IEP Disability | Report most dominant disability. | [S_MO_STU_X]Handicapping_Conditions | R |