Student Assignment Report

Select Schools

School Selection is only available at District Office.

Current Selection Students*

Select All Students or the current selection.

Select Submission Cycle*

Select October or June

Term Abbreviation(s)

Choose the Term Abbreviation(s) to be reported.

005

Collection Version

The report concatenates the current year, such as 2012 for the 2011-2012 school year, the reporting cycle, followed by 1.0StuAssign or 1.0SumStuAssign.

For example: 2012Oct1.0StuAssign

[Terms]LastDay

R

R

010

Current School Year

The ending year of the current school year, such as 2012 for the 2011-2012 school year.

[Terms]LastDay

R

R

025

Reporting District Code

The district responsible for reporting the student's data.

[Prefs]Value

[Prefs]Name=districtnumber

R

R

030

Reporting School Code

The student's school number. If the alternate school number is less than 4 digits, then the alternate school number is reported. If the alternate school number is not populated for the school, then if the school number is less than 4 digits, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

R

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

R

055

Local Student ID

The locally assigned student number.

[Students]Student_Number

O

O

060

Student Legal Last Name

The student's legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name

Or, if NULL:

[Students]Last_Name

O

O

065

Student Legal First Name

The student's legal first name.

[StudentCoreFields]PSCore_Legal_First_Name

Or, if NULL:

[Students]First_Name

O

O

070

Student Legal Middle Name

The student's legal middle name.

[StudentCoreFields]PSCore_Legal_Middle_Name

Or, if NULL:

[Students]Middle_Name

O

O

075

Student Legal Name Suffix

This element is not collected.

[StudentCoreFields]PSCore_Legal_Suffix

O

O

080

Student Date of Birth

The student's date of birth.

[Students]DOB

R

R

095

Student Grade Level

The student's grade level. The report extracts the student's Missouri Kindergarten enrollment grade level, if populated on the Transfer Info > Edit Current/Previous Enrollment page. Otherwise, the report extracts the standard grade level.

[S_MO_STU_X]Kindergarten

[S_MO_REN_X]Kindergarten

[Students]Grade_Level

[ReEnrollments]Grade_Level

C

C

100

Student Gender

The student's gender.

[StudentCoreFields]PSCore_Legal_Gender

Or, if NULL:

[Students]Gender

R

O

105

Race/Ethnicity

The student's race/ethnicity.

Note: For code sets go to MO Code Set Document

[Students]FedEthnicity

[StudentsRace]RaceCD

R

O

110

Assignment Number

The internal ID of the section, as seen at the bottom of the Edit Section page.

[Sections]ID

R

R

120

Dual Credit Site

The site at which instruction of college credit (dual credit) courses is provided.

Note: For code sets go to MO Code Set Document

[S_MO_CRS_X]DualCreditSite

[S_MO_SEC_X]DualCreditSite

C

O

125

Receiving Coll/Dist Code

The 6-digit code for the site at which instruction of college credit (dual credit) courses is provided.

Note: For code sets go to MO Code Set Document

[S_MO_CRS_X]DualCreditCode

[S_MO_SEC_X]DualCreditCode

C

O

130

Sending District Code

The sending district number.

[Students]DistrictofResidence

C

O

140

Sending School Code

The sending school code.

[S_MO_STU_X]SchoolofResidence

[S_MO_STU_X]SchoolofResidence

C

O

150

ED SSN

The social security number of the lead educator assigned to the course.

[Teachers]SSN

C

C

160

Position Code

The educator's position code.

Notes:

• For code sets go to MO Code Set Document

• The Short Name for Reference Code should be defined as Code.

Navigation:

System Management > Security > User > User Roles > Co-Teaching > Configure Table > Reference Code=Code

[S_MO_CRS_X]PositionCode

[S_MO_CRS_X]PositionCode

R

R

170

CTE Program Type

The program type code for the educator's CTE-approved program.

[S_MO_CRS_X]ProgType

[S_MO_SEC_X]ProgType

C

O

180

Disadvantaged

Indicates if a disadvantaged student was served in the assignment, including adults.

[Students]Disadvantage

C

O

270

IEP Disability (Primary)

The student's disability code, if applicable. For code sets go to MO Code Set Document

Note: The following conditions apply to this element:

• The disability code cannot equal 00 if MAP Alternate equals Y.

• The disability code cannot equal 00 if Special Education Placement is not null.

• The disability code cannot equal 00 if Special Education Exit is not null.

[S_MO_STU_X]Handicapping_Conditions

[S_MO_STU_X]SPEDEXIT_Date

[S_MO_STU_X]SPEDEXIT_Code

R

O

280

Adult

Indicates if the student is an adult.

[S_MO_STU_X]Adult

C

O

282

Local Course Number

The course code that identifies assignment of the course.

[Courses]Course_Number

O

O

284

Local Course Name

The course name.

[Courses]Course_Name

O

O

286

Local Section Number

The local section number.

[Sections]Section_Number

O

O

288

State Course Number

The state course code that identifies assignment.

Note: Every assignment record must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. If a teacher teaches the course for more than one level (Language Arts 1, 2, 3) in a self-contained elementary classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes, the assignments must be reported separately.

[S_MO_CRS_X]StateCourseNumber

O

O