Skip to main content
Skip table of contents

Student Assignment Report

Contents


Report Description

The Student Assignment File requires a record for each student enrolled in each educator's teaching assignment. An educator with a teaching assignment has a position code of 60. This file collects assignments for the entire regular school year.
This report can be run at the District or School level. The report can only be run for the entire district from the District Office.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student and Course Enrollment Selection

The report selects records from the [CC], [Courses], [Students], and [Sections]tables based on the following criteria:

  • The course and section must not be excluded from state reporting.
  • The Course or Co-Teaching Role must have a Position Code of 60 – Teachers.
  • Only the Lead Teacher will have student records.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

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.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: In the Required column, a value of "C" indicates that the element is conditional – if the element applies to the particular record, then it is required.

Item

Data Element

Description

[Table]FieldName

OCT

JUN

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.

Note: For code sets go to MO Code Set Document

[S_MO_CRS_X]PositionCode

[S_MO_CRS_X]PositionCode

Roles Administration > Co-Teaching > Reference Code

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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.