Tool Search: MOSIS Extracts
The LEP/ELL Pre-code File reports a record for LEP ELL assessments for any student in grade levels K-12 with an LEP record of NRC (Student is LEP and is not receiving Title III services due to parent request) or RCV (Student is LEP and is receiving ELL services).
MOSIS Pre-Code File: LEP/ELL Assessment Type
Report Logic
When this assessment type is selected, LEPELL Test Method is hard-coded as PENPAP. The student's LEP Program Status must be NRC or RCV. Students who have a LEP Code = NLP, MY1 or MY2 are not included.
A Pre-Code record is reported for those students actively enrolled as of the September Count Date in the calendar selected.
Students in grades K-12 (PK, KA, KP, K, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12) who have an LEP/ELL Status of the following as of the end date of the entered date range report:
- LEP
- Pending
- Exited (LEP Exit Date is after the End date of the entered date range)
If the student is enrolled in more than one course where the Assessment Type is LEP/ELL, teacher information reports from the most current or most recent section of the date range entered on the report editor.
Report Editor
Field | Description |
|---|---|
Extract Type | Indicates the type of MOSIS Extract being generated. Choose Pre-code File. |
| Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
| Report State Excluded Student | When marked, students who meet the report population requirements but their enrollment record is marked as State Exclude report along with all other records. When not marked, students marked as State Exclude on their enrollment record are excluded from the report. |
| Effective Date | Entered date is used to return students actively enrolled as of that date. |
Ad hoc Filter | Selection of a filter limits the set of students to only those included in the filter. |
Assessment Type | Determines the pre-code file that generates. Choose LEPELL: LEP/ELL |
| Select Grades | Indicates which grade levels are included in the extract. All grade levels can be selected, but the EOC Fall extract only reports data for students in grades 9-12. |
Format | Determines the program used to display the report. State Format is in CSV - use this option when submitting data to the state. Use the other options or data review and testing - Tab Delimited, HTML, or XML. |
Calendar Selection | Indicates from which enrollments are included in the extract. At least one calendar must be selected to generate the report. Calendars can be selected by active year, school name or year. |
Report Generation | The report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information. |
Generate the LEPELL Pre-Code Extract
- Select the Pre-code File option from the Extract Type dropdown list.
- Mark the Report Protected Identities checkbox, if desired.
- Mark the Report State Excluded Students checkbox, if desired.
- Enter the Effective Date in mmddyy format or by clicking the calendar icon and selecting a date, if applicable.
- Select an Ad hoc Filter, if applicable.
- Select the Assessment Type as LEPELL: LEP/ELL from the dropdown list.
- Select which Grades to include in the report.
- Select the desired Format of the extract. For submission to MOSIS, select the State Format (CSV). Select any of the other formats for data review prior to submission.
- Select which Calendar(s) to include report within the extract. Selecting multiple calendars may impact extract generation times and overall Campus performance.
- Click the Generate Extract button or the Submit to Batch button. The extract will appear in a separate window in the designated format.
LEPELL State Format (CSV)
Report Layout
Element Name | Description | Location |
|---|---|---|
Collection Version | Indicates the assessment type selected on the extract editor. Collection version contains the value YYYYLEPELL1.0AsmPre where YYYY = the reporting school year (2010, 2011, etc.). Alphanumeric, 50 characters | MO State Reporting > MOSIS Extracts |
Current School Year | The ending year of the current school year. Date field, 4 characters (YYYY) | School Years > End Year Calendar.endYear |
Reporting District Code | DESE-assigned 6-digit county district code for the district reporting. Numeric, 6 digits | District Information > State District Name District.number |
Reporting School Code | DESE-assigned 6-digit school code for the reporting school. Reports the selected code entered on the State Reporting Fields Enrollment editor, if populated.
Numeric, 6 digits* *Note: while this report displays the full 6 digit school code, the state only accepts 4 and this value will need to be manually adjusted before submitting to the state. | Enrollments > State Reporting Fields > Reporting School; Residing School Enrollment.reportingSchool Enrollment.residingSchool Calendar > Calendar > Type Calendar.type School > School Org Type; State School Number School.type School.number |
State ID | State-assigned student identifier. Numeric, 10 digits | Demographics > Person Identifiers > State ID Person.stateID |
Local Student ID | School-assigned student identifier. Numeric 20 digits | Demographics > Person Identifiers > Student Number Person.studentNumber |
Last Name | Legal last name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated. Alphanumeric, 50 characters | Demographics > Person Information > Last Name Identity.lastName Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
First Name | Legal first name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated. Alphanumeric, 30 characters | Demographics > Person Information > First Name Identity.firstName Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
Middle Name | Legal middle Name as it appears on the birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Middle Name field if populated. Alphanumeric, 30 characters | Demographics > Person Information > Middle Name Identity.middleName Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
Suffix | Generational indication (Jr., III, etc.) part of the name, if any. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Suffix field if populated. Alphanumeric, 10 characters | Demographics > Person Information > Suffix Identity.suffix Identities > Protected Identity Information > Legal Suffix Identity.legalSuffix |
Date of Birth | Student's birth date as it appears on the birth certificate. Date field, 10 characters | Demographics > Person Information > Birth Date Identity.birthdate |
Student Grade Level | Grade level of enrollment at the time data is being submitted, unless otherwise specified. Alphanumeric, 2 characters | Enrollments > General Enrollment Information > Grade GradeLevel.stateGrade |
Gender | Student's gender. When the Report Protected Identities checkbox is marked on the report editor, the student's gender reports from the Legal First Name field if populated. Alphabetic, 1 character (M or F) | Demographics > Person Information > Gender Identity.gender Identities > Protected Identity Information > Legal Gender Identity.legalGender |
Race/Ethnicity | The student's defined race/ethnicity. Alphanumeric, 2 characters | Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Assessment | Reports the chosen assessment type from the extract editor. Alphanumeric, 6 characters | Not dynamically stored |
Test Method | Method used to administer the assessment. For the LEPELL Assessment Type, this field reports PENPAP. Alphanumeric, 6 characters | Course > Section > Section Editor > Test Method Section.testMethod |
ED First Name | First name of the educator who will be administering the assessment. If the student is not enrolled in a course where the subject area is ELA, this field reports blank. Alphanumeric, 60 characters | Course > Section > Staff History > Primary Teacher Section.teacher |
ED Last Name | Last name of the educator who will be administering the assessment. If the student is not enrolled in a course where the subject area is ELA, this field reports blank. Alphanumeric, 60 characters | Course > Section > Staff History > Primary Teacher Section.teacher |
Subject | Subject for which the student will be assessed. See the Reporting Logic for the Subject Field for setup options. Alphanumeric, 6 characters | Course > Section Courses.assessmentSubject |
Period | Period in which the instruction took place. This only reports for EOCFAL, EOCSUM EOCSPR, or any MAPSPR assessment types (MATH, ELA, SC). assessments. Alphanumeric, 10 characters | Course > Section > Section Editor > Schedule Placement Period.name |
Sort | This field reports blank. Alphanumeric, 40 characters | Assessment > Precode > MAP Sort Section.mapSort |
Examiner Email Required | Reports the active primary teacher's email address as of the report generate end date who will be administering the assessment. If the student is not enrolled in a course where the subject area is ELA, this field reports blank. Alphanumeric, 60 characters | Demographics > Personal Contact Information > Email Contact.email |
