FileSpec:201706JuneCycleSummerStudentAssignment
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.0SumStuAssign' for the 2017 June Cycle Summer Student Assignment 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
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
045 MOSIS ID StateID Required State assigned student identifier. See http://dese.mo.gov/MOSIS for more information.
Text 10
055 Student 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
060 Student Legal Last Name StudentLastName Optional Legal last name as appears on certificate of birth.
Text 60
065 Student Legal First Name StudentFirstName Optional Legal first name as appears on certificate of birth.
Text 60
070 Student Legal Middle Name StudentMiddleName Optional Legal middle name as appears on certificate of birth.
Text 60
075 Student Legal Name Suffix StudentNameSuffix Optional Legal name suffix as appears on certificate of birth. E.g. Jr, Sr
Text 10
080 Student Date of Birth StudentDateofBirth Required Date of birth as appears on certificate of birth.
Text 10
095 Student Grade Level StudentGradeLevel Conditional Required for all students who are not adults taking special adult programs. Grade level as of the time data is being submitted unless otherwise specified. Student_Grade_Level_Codes Text 2
100 Student Gender StudentGender Optional Gender Gender_Codes Text 1
105 Race/Ethnicity StudentRaceEthn Optional Pre-defined Race / Ethnic code. Race_Ethnicity_Codes Text 1
110 Assignment Number AssignNum Required The number used to uniquely identify an instance of an educators course assignment also used to link that course to the records of students within the course.
Text 20
120 Dual Credit Site DualCreditSite Optional Site at which instruction of college credit (dual credit) course is given. Enter DIST if instruction is provided at district attendance center, COLL if instruction is provided on college campus, or ITV if instruction is provided by college through instructional television to students in district classroom else null. Dual_Credit_Site_Codes Text 4
126 Receiving Coll/Dist Code ReceivingCollDistCode Optional 6 digit code for site at which instruction of normal or college credit (dual credit) course is given. DESE_District_Codes Text 6
130 Sending District Code SendDistCode Optional 6-digit number and name of sending district else null. DESE_District_Codes Text 6
140 Sending School Code SendSchoolCode Optional 4-digit number and name of sending high school else null.
Text 4
150 ED SSN EDSSN Conditional Required if the Reporting and Receiving district are the same or if there is no Receiving district. Educator Social Security Number. Formats allowed '999999999'.
Text 9
160 Position Code PosCode Required Position code of educator’s assignment. Position_Codes Text 2
170 CTE Program Type CTEProgType Optional Program type code of CTE approved program. CTE_Program_Type_Codes Text 4
180 Disadvantaged Disadvantaged Optional Disadvantaged is defined as students who are eligible for free or reduced price lunch or Pell Grants. Yes_No Text 1
270 IEP Disability (Primary) IEPDisability Optional Report most dominant disability. Disability_Codes Text 2
280 Adult Adult Optional Required if CTEProgramType is reported. Indicate if student is considered an adult student taking a special adult program. Yes_No Boolean 1
282 Local Course Number LocCourseNum Optional Course code that identifies assignment. Every assignment must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. If a teacher has more than one grade in a self-contained elementary classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes, show as separate assignments.
Text 12
284 Local Course Name LocCourseName Optional Course name abbreviation.
Text 60
286 Local Section Number LocSecNum Optional Local Section Number
Text 6
288 State Course Number CourseNum Optional Course code that identifies assignment. Every assignment must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. If a teacher has more than one grade in a self-contained elementary classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes, show as separate assignments. State_Course_Codes Text 6