FileSpec:201706JuneCycleStudentDisciplineIncident

Item	Item Name	Column Name	Required	Definition	Code Set	Data Type	Length	Precision
005	Collection Version	CollectionVersion	Required	Collection version should contain this value '2017Jun1.0StuDiscipline' for the 2017 Student Discipline June File Layout.		Text	50
010	Current School Year	CurrentSchoolYear	Required	The ending year of the current school year. For example, use '2007' for the 2006-2007 school year.		Integer	4
015	Attending District Code	AttendingDistrictCode	Required	DESE assigned 6 digit county district code for the district of attendance.	DESE_District_Codes	Text	6
020	Attending School Code	AttendingSchoolCode	Required	DESE assigned 4 digit school code for the school of attendance.	DESE_School_Codes	Text	4
025	Reporting District Code	ReportingDistrictCode	Required	DESE assigned 6 digit county district code for the district reporting.	DESE_District_Codes	Text	6
030	Reporting School Code	ReportingSchoolCode	Required	DESE assigned 4 digit school code where the student is being reported from.	DESE_School_Codes	Text	4
035	Resident District Code	ResidentDistrictCode	Required	DESE assigned 6 digit county district code for the district of residence. E.g. K-8 Resident II student attending high school in a different district would have Resident District Code populated with xxxxxx and the “Attending District Code” populated with yyyyyy representing the district of enrollment.	DESE_District_Codes	Text	6
040	Resident School Code	ResidentSchoolCode	Required	DESE assigned 4 digit school code for the school of residence.	DESE_School_Codes	Text	4
045	MOSIS Student ID	StateID	Required	State assigned student identifier. See http://dese.mo.gov/MOSIS for more information.		Text	10
050	Local Student ID	LocalStudentID	Optional	Local student id maintained by the district. Allows for data to be associated to local systems from DESE source systems.		Text	20
055	Legal Last Name	LastName	Optional	Legal last name.		Text	60
060	Legal First Name	FirstName	Optional	Legal first name.		Text	60
065	Legal Middle Name	MiddleName	Optional	Legal middle name.		Text	60
070	Legal Name Suffix	Suffix	Optional	Legal name suffix. E.g. Jr, Sr		Text	10
075	Date of Birth	DateOfBirth	Required	Date of birth.		Text	10
080	Student Grade Level	StudentGradeLevel	Required	Grade level as of the time data is being submitted unless otherwise specified.	Student_Grade_Level_Codes	Text	2
085	Gender	Gender	Required	Gender	Gender_Codes	Text	1
090	Race/Ethnicity	RaceEthnicity	Required	Pre-defined Race / Ethnic code.	Race_Ethnicity_Codes	Text	1
095	Offense Date	OffenseDate	Required	Date offense occurred.		Date	10
100	Offense Type	OffenseType	Required	Nature of offense resulting in removal of student from regular school setting.	Discipline_Offense_Type_Codes	Text	1
105	Weapon Type	WeaponType	Required	Type of weapon involved in the offense. For further clarification on weapons, see (18 U.S.C.§ 921).	Discipline_Weapon_Type_Codes	Text	1
110	Discipline Removal	DisciplineRemoval	Required	Type of disciplinary action used to remove student committing the offense from current educational setting.	Discipline_Removal_Codes	Text	3
115	Length Removed	LengthRemoved	Required	Length of time student committing offense is removed from current educational placement.	Discipline_Length_Removed_Codes	Text	3
120	Modified Length	ModifiedLength	Conditional	Value is required if student was expelled. Expelled student whose length of removal was modified (shortened) by chief administrative officer of the school district.	Yes_No	Boolean	1
125	Alternate Placement Indicator	API	Conditional	Value is required if student was expelled. Expelled student receiving educational services in an alternative educational setting.	Yes_No	Boolean	1
130	LEP / ELL	LEPELL	Required	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.	LEP_Codes	Text	3
135	IEP Disability	IEPDisability	Required	Report most dominant disability.	Disability_Codes	Text	2