Classic View: MO State Reporting > MOSIS Extracts > Course Assignment
Search Terms: MOSIS Extracts
The Course Assignment extract contains educator identifiers and assignment data including regular instructional or administrative assignments, planning time and travel time between buildings, course number, sequence, grade, semester, program code, delivery system, minutes per week and units of credit. The Course Assignment extract requires a record for every educator assignment (all positions). The Course Assignment and the Student Assignment extracts are collected together as the Assignment Collection.
If a course section has multiple primary teachers associated with it, a record for each teacher who taught that section during the date range entered on the report editor will report.
The Course Assignment Extract is collected during October and June. The October extract defines educator instruction and services information and the June extract defines certified staff and student information for state-approved and state-funded summer school programs. All active courses within the calendar(s) selected on the extract editor report.
Report Logic
Records are reported from the selected calendar(s) on the extract editor, regardless of those calendars being the active school year.
The following business rules exist for the Course Assignment Extract:
- Items reported:
- Course Number
- Sequence
- Grade
- Semester
- Program Code
- Delivery System
- Minutes per week
- Units of Credit
The following determines when an educator will be reported:
- The educator MUST be assigned as the Primary Teacher in order to report.
- If the educator's District Assignment or Personnel Record Start Date is on or before the State Date in the date range in the extract editor, the record is reported.
- If the Start and End Date of the educator's District Assignment or Personnel Record is within the date range of the extract editor, the record is reported.
- If the Start Date of the educator's District Assignment or Personnel Record is on or before the Start Date in the extract editor and the district assignment End Date is after the End Date in the Extract Editor, the record is reported.
- If the educator's District Assignment Start and End Dates are after the dates entered in the extract editor, the record is not reported.
- If the Start and End Dates of the educator's district assignment are before the Start Date in the date range of the extract editor, the record is not reported.
Course Assignment data is used to populate the following MOSIS Core Data Screens:
- 18 – Educator
- 20 – Course and Assignment Data
- 22 – Sending School Courses and Enrollment
- 24 – Summer School Courses and Enrollment
Any course marked as Exclude from State Reporting is not included. Any Course Section that has an Assignment Number value of 0 is not included.
Course Minutes Calculation
This value is reported for the October Reporting Period only.
If the Override field on the Section editor has a value, that value is used as an override of the calculation.
The average weekly course minutes are calculated for the course/section separately for each term in which it is scheduled as follows:
- For each period schedule in which the course/section is assigned in that term:
- Total instructional minutes are calculated by the number of instructional minutes per day for the course/section times the number of instructional days to which the period schedule is assigned in the term.
- Total instructional minutes divided by the number of weeks in the term = the average weekly course minutes for that period schedule in that term.
- If the term is less than one week, instructional minutes are divided by 1.
- This calculation is repeated for each period schedule to which the course/section is assigned in that term.
- The weekly course minutes are then summed for each period schedule in the term to which the course/section is assigned, equaling the average weekly course minutes for that term.
- This is repeated for each term in which the course/section is scheduled.
- The average weekly course minutes are summed for each term, divided by the number of terms in which the course/section is scheduled.
- This result is reported, rounded to the nearest whole number.
Report Editor
The following fields are available for selection on the MOSIS Course Assignment Extract.
Extract Option | Description |
---|---|
Extract Type | Determines the extract that will generate. Selection should be Course Assignment. |
Reporting Period | Indicates the section of the school year for which student data is being reported. Each selection contains the same layout, but certain fields may be required in certain extracts, and optional in others. |
Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
Report State Excluded Course Sections | When marked, course sections where the Assignment Number field on the Course Section editor has a value zero (0), those sections are included in the report, as long as the sections meet all other reporting population logic. Marking this checkbox will also includes courses where the Exclude from State Reporting checkbox are marked on the Course editor. |
Date Range | Entered dates are used to return students enrolled during that time frame. Enter dates in mmddyy format or use the calendar icon to choose a date. |
Ad hoc Filter | Selection includes only those students included in the filter. |
Format | Determines how the extract will generate. Use the State Format (CSV) when submitting the final data to MOSIS. Use the other available formats (HTML, Tab Delimited, XML) for data review and testing. |
Calendar | Selected calendar indicates which students will be included in the report. Multiple calendars can be selected at one time; it is recommended that all calendars in a district not be selected as this will increase the amount of time it takes to generate the extract. The calendar chosen in the Campus toolbar is already selected. |
Generate Extract | Displays the selected calendar information and extract immediately for data review and printing purposes in one of the selected formats. |
Generate the Report
- Select the Course Assignment Extract Type.
- Select the Reporting Period.
- Mark the Report Protected Identities checkbox, if desired.
- Mark the Report State Excluded Course Sections, if desired.
- Enter the Date Range.
- Select the Format.
- Select which Calendar(s) to include within the extract. Selecting multiple calendars may impact generation times and overall Campus performance.
- Select the Generate Extract button. The extract will appear in a separate window in the designated format.
MOSIS Course Assignment Layout
Element | Description | Location |
---|---|---|
CollectionVersion | Reports a value of 20XXOct1.0CrsAssign or 20XXJun1.0SumCrsAssign, depending on the reporting period selected. Alphanumeric, 50 characters | Data not stored |
CurrentSchoolYear | The ending year of the current school year (i.e., 2013 reports for the 2012-2013 school year).
Numeric, 4 digits (YYYY) | System Administration > Calendar > School Years > School Year Editor > School Year Detail > End Year Calendar.endYear |
ReportingDistrictCode | DESE-assigned 6-digit county district code for the district reporting. Alphanumeric, 6 characters | System Administration > Resources > District Info > State District Number District.number |
ReportingSchoolCode | DESE-assigned 4 digit school code where the student is being reported from. Reports first from the Reporting School Code field on the Course. If that field is not populated, reports from the State School Number field on the School Resources editors. Alphanumeric, 4 characters | Scheduling > Courses > Course > Reporting School Code Course.reporting SchoolCode System Administration > Resources > School > State School Number School.number |
EDSSN | The Social Security Number of the teacher teaching the section of the course. Numeric, 9 digits | Census > Person > Demographics > Person Information > Social Security Number Identity.ssn |
LastName | The legal last name of the educator teaching the section of the course. When the Report Protected Identities checkbox is marked on the report editor, the educator's last name reports from the Legal Last Name field if populated. This field reports a blank value when the educator's last name's first three characters is DNR. When Report Protected Identities is marked, the last name reports blank. Alphanumeric, 60 characters | Census > Person > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
FirstName | The legal first name of the educator teaching the section of the course. 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. This field reports a blank value when the educator's last name's first three characters is DNR. When Report Protected Identities is marked, the first name reports blank. Alphanumeric, 60 characters | Census > Person > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
PosCode | Position code of educator's assignment. See the Position Codes table for a list of options. If this field is null, the Assignment Code for the Primary Teacher reports. If both the Position Code field and the Assignment Code field are null, a value of 60 reports. Alphanumeric, 2 characters | Census > People > District Assignments > Employment Assignment Information > Assignment Code Enrollment.position Code Scheduling > Courses > Course/Section > Section Editor > Position Code |
CTEProgType | Program type code of CTE approved program. Alphanumeric, 4 characters | Scheduling > Courses > Course > CTE Program Type Course.programType |
AssignNum | The number used to uniquely identify an instance of an educator's course assignment also used to link that course to the records of students within the course. The value reports from the Section Assignment Number field. If that field is not populated, a concatenated value of the course ID plus the section ID reports. Integer, 20 characters | Scheduling > Courses > Course > Section > Assignment Number Section.assignment Number |
LocCourseNum | Course code that identifies assignment Alphanumeric, 12 characters | Scheduling > Courses > Course > Number Course.number |
LocCourseName | The course name. Alphanumeric, 60 characters | Scheduling > Courses > Course > Name Course.name |
LocSecNum | The section number. Alphanumeric, 6 characters | Scheduling > Courses > Section > Section Number Section.number |
CourseNum | The state course code. Alphanumeric, 6 characters | Scheduling > Courses > Course > State Code Course.stateCode |
AssignStartDate | The date the course is added after beginning of school year or filled for first time after beginning of school year, or the date an individual replaces the original course educator after beginning of school year; otherwise, reports as NULL. The Late Start Date field is compared to the Staff History Start Date. The latest start date reports. If only one field is populated, that populated date reports. If both fields are blank, a null value reports. Date field, 10 characters (MM/DD/YYYY) | Scheduling > Courses > Sections > Late Start CustomSection.assignStartDate Scheduling > Courses > Sections > Staff History > Start Date SectionStaffHistory. startDate |
AssignEndDate | The date the course is eliminated prior to the end of school year or the individual is transferred out of position prior to end of school year (leaving position vacant), or the individual is replaced in position with another individual prior to the end of school year; otherwise, reports as NULL. The Early End Date field is compared to the Staff History End Date. The earliest end date reports. If only one field is populated, that populated date reports. If both fields are blank, a null value reports. Date field, 10 characters (MM/DD/YYYY) | Scheduling > Courses > Sections > Early End CustomSection. assignEndDate Scheduling > Courses > Sections > Staff History > End Date SectionStaffHistory. endDate |
CourseSeqNum | Sequence number that identifies the content of courses taught at more than one level. Alphanumeric, 1 character | Scheduling > Courses > Course > Sequence Course.coursePart |
CourseGradeLevel | Grade level at which curriculum for the specific course is designed to be taught. Alphanumeric, 2 characters | Scheduling > Courses > Course > Grade Course.grade |
CourseSem | The course length. Valid options include:
Alphanumeric, 1 character | Scheduling > Courses > Section > Semester Code CustomSection.semCode |
CourseDeliverySys | The delivery system of the course. Alphanumeric, 2 characters | Scheduling > Courses > Section > Delivery Method Section.teachingMethod |
CourseProgCode | Program code that identifies special funding or approval. A Program must be assigned to the course.
Alphanumeric, 2 characters | Scheduling > Courses > Course > Program Course.program Scheduling > Courses > Sections > Program |
CourseMins | Minutes per week for class/assignment. Calculated based on the student's period schedule. See the Report Logic section for details on the calculation. Numeric, 4 digits | System Administration > Calendar > Calendar > Periods CustomSection.minutesPerWeek |
CourseCredit | Units of high school credit granted for the assignment.
Alphanumeric, 4 characters | Scheduling > Courses > Grading Tasks > Credit GradingTaskCredit.credit |
Caseload | The number of students served in an education setting other than a regularly scheduled class.
Alphanumeric, 4 characters | Scheduling > Courses > Sections > Caseload; Census > People > District Assignments > Assignment Code, Resource Teacher CustomSection.caseLoad |
CourseHours | Total hours the class meets during the full duration of the summer school program (normally 60 to 120 hours).
Numeric, 6 digits | Data not stored |
AssignComment | Reports any value entered in the Sections Assignment Comment field. Alphanumeric, 70 characters | Scheduling > Courses > Sections > Assignment Comment EmploymentAssignment.title |
CombinedCourse | Indicates the course being reported contains curriculum for multiple subjects, or grade levels for self-contained elementary courses are taught during the same period by the same teacher. Numeric, 2 digits | Scheduling > Courses > Sections > Combined Course Section.combined Course |
Position Codes
Code | Name | Description |
---|---|---|
10 | ADMIN | Central Office Administration |
20 | PRIN | Building Principals |
30 | SUPER | Supervisors |
40 | MEDIA | Media Personnel |
50 | GUID | Guidance Personnel/Placement Specialists |
60 | TEACH | Teachers |
70 | PUPIL SERV | Other Pupil Services Personnel |
80 | AIDE | Aides |
90 | ANCIL | Ancillary Personnel |