| 005 |
Collection Version |
CollectionVersion |
Required |
Collection version should contain this value '2023Jun1.0SumStuAssign' for the 2023 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 '2023' for the 2022-2023 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 https://dese.mo.gov/data-system-management/core-datamosis 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 |
3 |
|
| 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. |
|
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 |
|