Assessment Pre-Code Extract
Contents
Report Description
The Assessment Pre-Code extracts student demographic and course enrollment data at multiple points throughout the school year. This enables districts to submit student information to the state, ensuring accurate pre-population of assessment testing labels.
This extract can only be run at the School level.
Pre-requisite Setup
Courses and/or Sections must be set up with:
Assessment Type
Subject (for ALL types of Assessments)
Sections can be excluded from the Assessment Pre-code and still be reported with all other state reports.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students]tables based on the following criteria:
A course cannot be excluded from State Reporting.
A section cannot be excluded from the Assessment Pre-Code.
The student is enrolled in a course/section that has the matching Assessment Type.
The student is active or pre-registered.
The student is NOT excluded from state reporting.
Assessment Selection
End of Course (EOC) – Fall, Spring, and Summer Submission
All courses that will be tested for EOC must have Missouri State Information completed at the course and/or section level.
Courses must have Assessment Type, Subject and Testing Method defined.
Sections may have Assessment and Testing Method selections that will override the Course settings.
Sections to be used for EOC
Fall - Sections in Semester 1 (S1), Quarter 1 (Q1), and Quarter 2 (Q2).
Spring - Sections in Semester 2 (S2), Quarter 3 (Q3), Quarter 4 (Q4), and Full Year (FY).
Summer - Sections designated as "Use for EOC Summer School".
The Examiner's Email Address extracts the email address of the teacher of record unless an email address is entered in the Course/Section.
MAP/MAP-Alternate – Spring Submission
MAP students: All students in grades 3 to 8 who are not designated as MAP-Alternate will be reported for Math and ELA. Students in grades 5 and 8 will also be reported for Science.
MAP Alternative students: All students in grades 3 to 12 who are designated as MAP-Alternate will be reported for Math and ELA. Students in grades 5, 8, and 11 will also be reported for Science.
Sort Selection (Required for MAP)
If the Sort selection is “Blank” then no data will be reported in the Sort field. Users must fill the column manually.
If the Sort selection is "Teacher Name" then the Sort field pulls the Teacher’s Last Name for the section assigned. Reports the most current Lead Teacher only.
If the Sort selection is “Homeroom” then the Sort field pulls the [Students]Home_room field.
If the Sort selection is “Period” then the Sort field pulls the period number for the section assigned.
LEP/ELL (WIDA) – Spring Submission
All students in grades K-12 coded as “Receiving Services (RCV)” for ELL Status are included.
Students must be enrolled in the appropriate course/section.
Classes included must meet in FY, S1, Q1, or Q2 terms.
ACT – Spring Submission
All students in grade 11 and are enrolled in a course/section designated as Assessment Type ACT will be included in the extract.
Classes included must meet in FY, S2, or Q3 terms.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Schools to Include | A school selection is available only at the District Office. |
Current Selection Students | Select students to run the report or select All Students. |
Assessment Type | Select the type of assessment:
|
Sort (Required for MAP) | For MAP assessments, select the information to be entered in the Sort column:
|
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.
Item | Data Element | Description | [Table]FieldName | REQ |
005 | Collection Version | The report concatenates the current year, such as 2025 for the 2024-2025 school year, the assessment chosen at runtime, followed by 1.0AsmPre. For example 2025EOCFAL1.0AsmPre | Derived | R |
010 | Current School Year | The ending year of the current school year, such as 2025 for the 2024-2025 school year. | [Terms]LastDay | R |
025 | Reporting District Code | The district number. | [Prefs]Value [Prefs]Name=districtnumber | R |
030 | Reporting School Code | The student’s school number. If the alternate school number is zero (0) then the school number will be reported. | [S_MO_CRS_X]ReportingSchool [S_MO_CRS_X]ReportingSchool [Schools]Alternate_School_Number [Schools]School_Number | R |
050 | MOSIS Student ID | The state-assigned student number. For more information, see the latest MOSIS Reference Manual. All submitted students must have a unique state ID. The state ID is verified against the ID system SIDMASTER (State_Student_ID). | [Students]State_StudentNumber | R |
055 | Local Student ID | The student’s locally assigned identifier. | [Students]Student_Number | O |
060 | Legal Last Name | The student’s legal last name. | [StudentCoreFields]PSCore_Legal_Last_Name Or, if NULL: [Students]Last_Name | R |
065 | Legal First Name | The student’s legal first name. | [StudentCoreFields]PSCore_Legal_First_Name Or, if NULL: [Students]First_Name | R |
070 | Legal Middle Name | The student’s legal middle name. | [StudentCoreFields]PSCore_Legal_Middle_Name Or, if NULL: [Students]Middle_Name | O |
075 | Suffix | The student's legal name suffix; for example, Jr, Sr, III, IV | [StudentCoreFields]PSCore_Legal_Suffix | O |
080 | Date Of Birth | The student’s date of birth. | [Students]DOB | R |
095 | Student Grade Level | The student’s grade level. | [Students]Grade_Level | R |
100 | Gender | The student’s gender. | [StudentCoreFields]PSCore_Legal_Gender Or, if NULL: [Students]Gender | R |
105 | Race/Ethnicity | The student’s ethnicity. For code sets go to the latest Core Data/MOSIS requirements. | [Students]FedEthnicity [StudentsRace] | R |
110 | Assessment | The name of the assessment included in this record. This value is determined by the assessment chosen at report runtime. For code sets go to the latest Core Data/MOSIS requirements. | [S_MO_SEC_X]AssessmentType [S_MO_CRS_X]AssessmentType | R |
115 | Testing Method | The method used to administer the assessment. Required for all students taking an EOC assessment. Valid values:
| [S_MO_CRS_X]TestMethod [S_MO_SEC_X]TestMethod | R |
130 | ED First Name | The first name of the educator administering the test. Required for all students taking an EOC assessment. Only the most current Lead Teacher will be reported. | [Users]First_Name | R |
135 | ED Last Name | The last name of the educator administering the test. Required for all students taking an EOC assessment. Only the most current Lead Teacher will be reported. | [Users]Last_Name | R |
140 | Subject | The subject matter of the test. Required for all students taking an EOC assessment. For code sets go to the latest Core Data/MOSIS requirements. | [S_MO_CRS_X]EOCSubject | R |
145 | Period | The period of the school day during which the instruction took place. Required for all students taking an EOC assessment. For sections that cross multiple periods, only the lowest period number will be reported. | [Sections_Meeting]Period | C |
150 | Sort | The final value in which the labels will be sorted. Required for all students taking a MAP assessment. Only the most current Lead Teacher will be reported. | [Users]Last_Name [Students]Home_Room [Students]Team [Sections_Meeting]Period | C |
155 | Examiner Email | This email address will receive a username and password for EOC assessment administration. | [Users]Email_Addr [S_MO_CRS_X]ExamEmailOverride [S_MO_SEC_X]ExamEmailOverride | R |