Tool Search: MOSIS Extract

The Student Discipline Incident Extract reports all discipline incidents that occur in-school or out-of-school suspension, expulsion or removal to an interim education setting. Only those behavior incidents within the entered date range are included.

Screenshot of the MOSIS Student Discipline Incident extract editor. MOSIS Student Discipline Incident

Read - Access and generate MOSIS Student Discipline Incident.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

One record per state event code (see the table below) associated with the resolution reports. When there are multiple resolutions associated to the state event, only the most serious state resolution reports. This is reported in the Discipline Removal column.

All enrollments for a student in the selected calendar are reviewed when reporting discipline incident data. If the qualifying discipline incident occurred within dates defined on the extract editor in the selected calendar, a record reports.

State Event Codes

Code	Description
A	Alcohol
D	Drugs
T	Tobacco
V	Violent Act with Injury
N	Violent Act without Injury
W	Weapon
O	Other

State Resolution Codes

Code	Description
EXP	Expulsion
OSS	Out of School Suspension
ISS	In School Suspension
UR	Unilateral Removal

NRC: Not Receiving Services

For EL/ELL reporting options, NRC reports only if the program status is EL and the Parent Declined checbox is marked.

Report Editor

The following fields are available for selection on the MOSIS Student Discipline Incident Report.

Field	Description
Extract Type	Selection indicates which extract generates. For this purpose, select Student Discipline Incident.
Reporting Period	When the Student Discipline Incident option is selected in the Extract Type field, the option to select the June Reporting Period is activated.
Report Protected Identities	When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
Report State Excluded Students	When marked, students who meet the report population requirements but their enrollment record is marked as State Exclude report along with all other records. When not marked, students marked as State Exclude on their enrollment record are excluded from the report.
Date Range	Enter a Date Range of the report. The entered start date in the first date field must be the same as the end date.
Ad hoc Filter	Select an ad hoc filter to use a pre-selected list of students in the report.
Format	Select the State Format (CSV), Tab Delimited, HTML or XML option. Use the Tab Delimited, HTML or XML formats to review student data prior to final submission to the state in CSV format.
Calendar Selection	Select at least one calendar from which to pull student enrollments and discipline information. Calendars can be selected by the active year, by school name or by all years.

Generate the MOSIS Student Discipline Incident Report

Select the Student Discipline Incident option from the Extract Type dropdown list.
Select the Reporting Period as June.
Mark the Report Protected Identities checkbox, if desired.
Mark the Report State Excluded Students checkbox, if desired.
Enter a Date Range of the Student Discipline Incident Report.
Select an Ad hoc Filter, if desired.
Select the desired Format of the report from the dropdown list.
Select a Calendar from which to pull discipline information.
Click the Generate Extract button. The extract displays in the selected format.

Screenshot of an example student discipline incident state CSV format. Student Discipline Incident - State Format (CSV)

Report Layout

Data Element	Description	Location
Collection Version	Collection version number based on the submission type in which the cycle occurs and the current school year. Reports a value of 20XXJun1.StuDiscipline. The June collection uses the start year of the summer school calendar, not the end year. Alphanumeric, 50 characters	Data not stored
Current School Year	The ending year of the current school year. Numeric, 4 digits	Calendar Information > School Year > End Year SchoolYear.endYear
Attending District Code	DESE-assigned 6-digit county district code for the district of attendance. Numeric, 6 digits	Enrollments > State Reporting Fields > Attendance District Enrollment.servingDistrict District.number
Attending School Code	DESE-assigned 4-digit school code for the school of attendance. Numeric, 4 digits	Enrollments > State Reporting Fields > Attending School Enrollment.servingSchool School.number
Reporting District Code	DESE-assigned 6-digit county district code. Numeric, 6 digits	District Information > State District Number District.number
Reporting School Code	DESE-assigned 6-digit school code for the reporting school. Reports the selected code entered on the State Reporting Fields Enrollment editor, if populated. If not populated, the Calendar Type is used to determine the reported value. If the Calendar Type Code is AP: Alternative Program School, all students enrolled in that calendar report the value entered in the Residing School field on the State Reporting Enrollment editor. If the Reporting School field is not populated and the Calendar Type is not AP, the School Organization Type is used. When the School Organization Type Code is AP: Alternative Program School, all students enrolled in that school report the value entered in the Residing School field on the State Reporting Enrollment editor. If the Reporting School field is not populated and the Calendar Type is not AP and the School Organization Type is not AP, the Reporting School reports from the State School Number . Numeric, 6 digits* *Note: while this report displays the full 6 digit school code, the state only accepts 4 and this value will need to be manually adjusted before submitting to the state.	Enrollments > State Reporting Fields > Reporting School; Residing School Enrollment.reportingSchool Enrollment.residingSchool Calendar Information > Type Calendar.type School Information > School Org Type; State School Number School.type School.number
Resident District Code	DESE-assigned 6-digit county district code. Numeric, 6 digits	Enrollments > State Reporting Fields > Residing District District.number Enrollment.residentDistrict
Resident School Code	DESE-assigned 4-digit school code. Numeric, 4 digits	Enrollments > State Reporting Fields > Residing School Enrollment.residentSchool School.number
State ID	State-assigned student identifier. Numeric, 10 digits	Demographics > Person Identifiers > State ID Person.stateID
Local Student ID	Local student ID maintained by the district. Allows for data to be associated to local systems from DESE source Systems. Alphanumeric, 20 characters	Demographics > Person Identifiers > Student Number Person.studentNumber
Legal Last Name	Legal last name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated. Alphanumeric, 60 characters	Demographics > Person Information > Last Name Identity.lastName Identities > Protected Identity Information > Legal Last Name Identity.legalLastName
Legal First Name	Legal first name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated. Alphanumeric, 60 characters	Demographics > Person Information > First Name Identity.firstName Identities > Protected Identity Information > Legal First Name Identity.legalFirstName
Legal Middle Name	Legal middle name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Middle Name field if populated. Alphanumeric, 60 characters	Demographics > Person Information > Middle Name Identity.middleName Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName
Legal Name Suffix	Legal suffix as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Suffix Name field if populated. Alphanumeric, 60 characters	Demographics > Person Information > Suffix Identity.suffix Identities > Protected Identity Information > Legal Suffix Identity.legalSuffix
Date of Birth	Student birth date. Date field, 10 characters (MM/DD/YYYY)	Demographics > Person Information > Birth Date Identity.birthDate
Student Grade Level	Grade level at the time data is being submitted. Alphanumeric, 2 characters	Enrollments > General Enrollment Fields > Grade Enrollment.grade
Gender	The student's gender. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Gender field if populated. Alphanumeric, 1 character (M or F)	Demographics > Person Information > Gender Identity.gender Identities > Protected Identity Information > Legal Gender Identity.legalGender
Race/Ethnicity	The Race/Ethnicity Code of the student. The following values are returned: If student is Hispanic, race/Ethnicity is H. If student is Asian, race/Ethnicity is A. If student is Native Hawaiian or Other Pacific Islander, race/Ethnicity is P. If student is American Indian or Alaskan Native, race/Ethnicity is I. If student is Black or African American, race/Ethnicity is B. If student is White, race/Ethnicity is W. If student is multiracial, race/Ethnicity is M. Alphanumeric, 1 character	Demographics > Person Information > Race Ethnicity Identity.raceEthnicity
Offense Date	Date the behavior incident occurred. Date field, 10 characters (MM/DD/YYYY)	Behavior Management > Incident Detail Information > Date of Incident BehaviorIndicdent.timestamp
Offense Type	Nature of the offense resulting in removal of the student from the regular school setting. Only those events that are mapped to a state event code are reported. See the State Event Codes list for options. When the State Code is N: Violent Act without Physical Injury and any participant has an injury value of 4: Serious Bodily Injury, a value of V reports. Alphabetic, 1 character	Behavior Management > Event Details > Event Type Behavior.stateEventCode
Weapon Type	Type of weapon involved in the offense. If the offense type is not W, the Weapon Type must equal N. Alphabetic, 1 character	Behavior Management > Event Details > Weapon BehaviorEvent.weaponCode
Discipline Removal	Type of disciplinary action used to remove the student committing the offense from the current educational setting. Only those resolutions listed in the State Resolution Codes are reported. For incidents with multiple resolutions, the most serious state resolution reports. Attributes with the lower value are considered the most serious (values of 1 are more serious than values of 4). Alphabetic, 3 characters	Behavior Management > Resolution Details Behavior.stateResCode
Length Removed	For one resolution and one event, reports the length of time the student committing the offense is removed from the current education placement. The value of this field is calculated using the Length Removed field, unless there is a value entered in the Duration in School Days field. If no value is entered there, the start and end dates entered in the Behavior Resolutions are used. If the student has the multiple reportable state resolutions with the same value, in one day on one event, only one record reports and the Duration in School Days from each matching resolution is summed. For example, 2 OSS resolutions are attached to one state event. One OSS has 0.5 in Duration in School Days and the other has 5 in Duration in School Days. In this instance, a value of 5.5 reports. If Duration in School Days is blank for one or both resolutions, the Duration in School Days reports from resolution where it is populated. If Duration in School Days is not populated, a blank value reports. Numeric, 3 digits	Behavior Management > Resolution Details> Duration in School Days Behavior > Resolution > Length Removed Behavior.lengthRemoved
Modified Length	Indicates the length of the student's removal from the educational setting was modified (shortened) by the chief administrative officer at the school district. The Discipline Removal code must be EXP for this value to report. Otherwise, a NULL value is reported. Numeric, 1 digit	Behavior Management > Resolution Details > Modified Length BehaviorResolution.modifiedLength
API	Indicates the expelled student was placed in an alternative educational setting. The Discipline Removal code must be EXP for this value to report. Otherwise, a NULL value is reported. Numeric, 1 digit	Behavior Management > Resolution Details > Alternative Placement BehaviorResolution.AlternativePlacement
LEP/ELL	DESE-assigned (LEP) EL/ELL code used to declare if a student is EL, ELL Receiving, first year monitoring or second year monitoring. If at least one EL record exists for a student, the EL record where the Second Year Monitoring Date is greater than or equal to the end of the reporting calendar is found. Or, if such a record does not exist, the EL record where the Second Year Monitoring Date is NULL is used. Then, the selected EL record is used to determine the value reported: When the Program Status = EL, reports RCV (parent decline marked and not marked). When the Exit date takes place after the First Year Monitoring date and up to or on the Second Year Monitoring date, reports MY2. When the Exit date takes place after the Second Year Monitoring date and up to or on the Third Year Monitoring date, reports AY3. When the Exit date takes place after the Third Year Monitoring date and up to or on the Fourth Year Monitoring date, reports AY4. Otherwise, reports NLP. Alphanumeric, 3 characters	English Learners (EL) > EL Enrollment.lep English Learners (EL) > EL Services
IEP Disability	Reports the student's most dominant disability. If a student has a Special Education Status equal to Y: Yes and a Primary Disability that is anything other than NULL, the Primary Disability is reported. If the student has a Special Education Exit Date before the date of the behavior event, no primary disability is reported even if the student has one assigned. Alphanumeric, 2 digits	Enrollments > Special Ed Fields > Primary Disability Enrollment.spedStatus

Data Element

Description

Location

Collection Version

Collection version number based on the submission type in which the cycle occurs and the current school year.

Reports a value of 20XXJun1.StuDiscipline.

The June collection uses the start year of the summer school calendar, not the end year.

Alphanumeric, 50 characters

Data not stored

Current School Year

The ending year of the current school year.

Numeric, 4 digits

Calendar Information > School Year > End Year

SchoolYear.endYear

Attending District Code

DESE-assigned 6-digit county district code for the district of attendance.

Numeric, 6 digits

Enrollments > State Reporting Fields > Attendance District

Enrollment.servingDistrict

District.number

Attending School Code

DESE-assigned 4-digit school code for the school of attendance.

Numeric, 4 digits

Enrollments > State Reporting Fields > Attending School

Enrollment.servingSchool

School.number

Reporting District Code

DESE-assigned 6-digit county district code.

Numeric, 6 digits

District Information > State District Number

District.number

Reporting School Code

DESE-assigned 6-digit school code for the reporting school.

Reports the selected code entered on the State Reporting Fields Enrollment editor, if populated.

If not populated, the Calendar Type is used to determine the reported value. If the Calendar Type Code is AP: Alternative Program School, all students enrolled in that calendar report the value entered in the Residing School field on the State Reporting Enrollment editor.
If the Reporting School field is not populated and the Calendar Type is not AP, the School Organization Type is used. When the School Organization Type Code is AP: Alternative Program School, all students enrolled in that school report the value entered in the Residing School field on the State Reporting Enrollment editor.
If the Reporting School field is not populated and the Calendar Type is not AP and the School Organization Type is not AP, the Reporting School reports from the State School Number .

Numeric, 6 digits*

*Note: while this report displays the full 6 digit school code, the state only accepts 4 and this value will need to be manually adjusted before submitting to the state.

Enrollments > State Reporting Fields > Reporting School; Residing School

Enrollment.reportingSchool

Enrollment.residingSchool

Calendar Information > Type

Calendar.type

School Information > School Org Type; State School Number

School.type

School.number

Resident District Code

DESE-assigned 6-digit county district code.

Numeric, 6 digits

Enrollments > State Reporting Fields > Residing District

District.number

Enrollment.residentDistrict

Resident School Code

DESE-assigned 4-digit school code.

Numeric, 4 digits

Enrollments > State Reporting Fields > Residing School

Enrollment.residentSchool

School.number

State ID

State-assigned student identifier.

Numeric, 10 digits

Demographics > Person Identifiers > State ID

Person.stateID

Local Student ID

Local student ID maintained by the district. Allows for data to be associated to local systems from DESE source Systems.

Alphanumeric, 20 characters

Demographics > Person Identifiers > Student Number

Person.studentNumber

Legal Last Name

Legal last name as it appears on the student's birth certificate.

When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated.

Alphanumeric, 60 characters

Demographics > Person Information > Last Name

Identity.lastName

Identities > Protected Identity Information > Legal Last Name

Identity.legalLastName

Legal First Name

Legal first name as it appears on the student's birth certificate.

When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated.

Alphanumeric, 60 characters

Demographics > Person Information > First Name

Identity.firstName

Identities > Protected Identity Information > Legal First Name

Identity.legalFirstName

Legal Middle Name

Legal middle name as it appears on the student's birth certificate.

When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Middle Name field if populated.

Alphanumeric, 60 characters

Demographics > Person Information > Middle Name

Identity.middleName

Identities > Protected Identity Information > Legal Middle Name

Identity.legalMiddleName

Legal Name Suffix

Legal suffix as it appears on the student's birth certificate.

When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Suffix Name field if populated.

Alphanumeric, 60 characters

Demographics > Person Information > Suffix

Identity.suffix

Identities > Protected Identity Information > Legal Suffix

Identity.legalSuffix

Date of Birth

Student birth date.

Date field, 10 characters (MM/DD/YYYY)

Demographics > Person Information > Birth Date

Identity.birthDate

Student Grade Level

Grade level at the time data is being submitted.

Alphanumeric, 2 characters

Enrollments > General Enrollment Fields > Grade

Enrollment.grade

Gender

The student's gender.

When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Gender field if populated.

Alphanumeric, 1 character (M or F)

Demographics > Person Information > Gender

Identity.gender

Identities > Protected Identity Information > Legal Gender

Identity.legalGender

Race/Ethnicity

The Race/Ethnicity Code of the student. The following values are returned:

If student is Hispanic, race/Ethnicity is H.
If student is Asian, race/Ethnicity is A.
If student is Native Hawaiian or Other Pacific Islander, race/Ethnicity is P.
If student is American Indian or Alaskan Native, race/Ethnicity is I.
If student is Black or African American, race/Ethnicity is B.
If student is White, race/Ethnicity is W.
If student is multiracial, race/Ethnicity is M.

Alphanumeric, 1 character

Demographics > Person Information > Race Ethnicity

Identity.raceEthnicity

Offense Date

Date the behavior incident occurred.

Date field, 10 characters (MM/DD/YYYY)

Behavior Management > Incident Detail Information > Date of Incident

BehaviorIndicdent.timestamp

Offense Type

Nature of the offense resulting in removal of the student from the regular school setting. Only those events that are mapped to a state event code are reported. See the State Event Codes list for options.

When the State Code is N: Violent Act without Physical Injury and any participant has an injury value of 4: Serious Bodily Injury, a value of V reports.

Alphabetic, 1 character

Behavior Management > Event Details > Event Type

Behavior.stateEventCode

Weapon Type

Type of weapon involved in the offense. If the offense type is not W, the Weapon Type must equal N.

Alphabetic, 1 character

Behavior Management > Event Details > Weapon

BehaviorEvent.weaponCode

Discipline Removal

Type of disciplinary action used to remove the student committing the offense from the current educational setting. Only those resolutions listed in the State Resolution Codes are reported.

For incidents with multiple resolutions, the most serious state resolution reports. Attributes with the lower value are considered the most serious (values of 1 are more serious than values of 4).

Alphabetic, 3 characters

Behavior Management > Resolution Details

Behavior.stateResCode

Length Removed

For one resolution and one event, reports the length of time the student committing the offense is removed from the current education placement. The value of this field is calculated using the Length Removed field, unless there is a value entered in the Duration in School Days field.

If no value is entered there, the start and end dates entered in the Behavior Resolutions are used.

If the student has the multiple reportable state resolutions with the same value, in one day on one event, only one record reports and the Duration in School Days from each matching resolution is summed.

For example, 2 OSS resolutions are attached to one state event. One OSS has 0.5 in Duration in School Days and the other has 5 in Duration in School Days. In this instance, a value of 5.5 reports.

If Duration in School Days is blank for one or both resolutions, the Duration in School Days reports from resolution where it is populated. If Duration in School Days is not populated, a blank value reports.

Numeric, 3 digits

Behavior Management > Resolution Details> Duration in School Days

Behavior > Resolution > Length Removed

Behavior.lengthRemoved

Modified Length

Indicates the length of the student's removal from the educational setting was modified (shortened) by the chief administrative officer at the school district. The Discipline Removal code must be EXP for this value to report. Otherwise, a NULL value is reported.

Numeric, 1 digit

Behavior Management > Resolution Details > Modified Length

BehaviorResolution.modifiedLength

API

Indicates the expelled student was placed in an alternative educational setting. The Discipline Removal code must be EXP for this value to report. Otherwise, a NULL value is reported.

Numeric, 1 digit

Behavior Management > Resolution Details > Alternative Placement

BehaviorResolution.AlternativePlacement

LEP/ELL

DESE-assigned (LEP) EL/ELL code used to declare if a student is EL, ELL Receiving, first year monitoring or second year monitoring.

If at least one EL record exists for a student, the EL record where the Second Year Monitoring Date is greater than or equal to the end of the reporting calendar is found. Or, if such a record does not exist, the EL record where the Second Year Monitoring Date is NULL is used. Then, the selected EL record is used to determine the value reported:

When the Program Status = EL, reports RCV (parent decline marked and not marked).
When the Exit date takes place after the First Year Monitoring date and up to or on the Second Year Monitoring date, reports MY2.
When the Exit date takes place after the Second Year Monitoring date and up to or on the Third Year Monitoring date, reports AY3.
When the Exit date takes place after the Third Year Monitoring date and up to or on the Fourth Year Monitoring date, reports AY4.
Otherwise, reports NLP.

Alphanumeric, 3 characters

English Learners (EL) > EL

Enrollment.lep

English Learners (EL) > EL Services

IEP Disability

Reports the student's most dominant disability. If a student has a Special Education Status equal to Y: Yes and a Primary Disability that is anything other than NULL, the Primary Disability is reported.

If the student has a Special Education Exit Date before the date of the behavior event, no primary disability is reported even if the student has one assigned.

Alphanumeric, 2 digits

Enrollments > Special Ed Fields > Primary Disability

Enrollment.spedStatus

MOSIS Student Discipline Incident (Missouri)

Report Logic

State Event Codes

State Resolution Codes

NRC: Not Receiving Services

Report Editor

Generate the MOSIS Student Discipline Incident Report

Report Layout

Related Articles