Skip to main content
Skip table of contents

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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.