MOSIS Student Course Completion Extract (Missouri)

Tool Search: MOSIS Extracts

The MOSIS Course Completion Extract collects the final grade and credits earned for each student for each course taken. Students report when they have completed the course, which may take the form of a student who has a final grade or a student who ended early.

Screenshot of the MOSIS Student Course Completion extract editor.MOSIS Student Course Completion

Read - Generate MOSIS Student Course Completion Extract.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

Courses must have a Grading Task marked as State Reporting assigned to them in order to report. Grading Task credits are included in the report when they are marked as State Reported and have a Code of Final Course Grade (FCG) on the Grading Tasks tool.

  • Course are included in the report if the Credit Level is HS: High School or MS: Middle School on the Course tab.
  • Scores must be mapped to a State Score to appear in the report.
  • Students in grades 06-12 are included as long have been present in the course for at least one hour.
  • Students in grades K-05 are included when the course is marked Yes for Online Learning.

A record reports for the student/course/section when the student has a drop date before the course/section end date ONLY when the student is NOT marked absent all dates/all periods between the Course/Section Start Date and the student's drop date. 

One record per student is returned per enrollment. When a student has multiple enrollments in the same school year/calendar, only one record is returned.

Both Instructional and Non-instructional periods are returned.

For each student record returned that does NOT have a FCG entered:

  • If a student is scheduled in the course/section AND was present in the course/section for at least one period AND drops the course/section AND is still NOT scheduled at the end of that section AND date NOT have a FCG, a value of WD reports in the Grade Earned field. 
  • If a student is scheduled n the course/section AND was present in the course/section for at least one period AND is still scheduled at the end of the section AND does NOT have a FCG, a value of IC reports in the Grade Earned field. 

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.

The Course Completion extract collects the final grade and earned credit for each student for each class taken. 

  • Records are not returned when the Calendar is marked as State Exclude.
  • Records are not returned when the Grade Level is marked as State Exclude. 
  • Records are not returned when the Enrollment is marked as State Exclude or No Show.

Greater than or equal to one hour of attendance

A record is reported for the student/course/section when the student has a drop date before the Course/Section End Date ONLY when the student is NOT marked absent for all dates/all periods between Course/Section Start Date and the student's drop date.

If the student's enrollment, grade level or the course is not state exclude or if the student is not marked as No Show and a student drop date exits, the student's attendance from the section start date to the drop date is used. If the student was not absent the entire day for all day's scheduled, a record is returned for that student. If the student is absent the entire day in all days, a record is not returned.

For each student record returned that does not have a final course grade entered, the following values are returned in the Grade Earned field:

  • If a student is scheduled in the course section and was present in the course section for at least one period and drops the section and is still not scheduled at the end of that section and does not have a final course grade, a value of WD is returned.
  • If a student is scheduled in the course section and was present for at least one period and is still scheduled at the end of that section and does not have a final course grade, the value IC is returned.

Report Editor

Different options are available for entry on the Extract editor depending on the chosen Reporting Period. The following defines the available Extract Options, noting the different fields.

Extract Option

Description

Extract Type

Determines the extract that generates. Selection should be Student Course Completion.

Reporting Period

Indicates the section of the school year for which student data is being reported. The only Reporting Period available for this extract is February.

Report Protected IdentitiesWhen marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
Report State Excluded Course SectionsWhen 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.
Report State Excluded StudentsWhen 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.

Date Range

Entered date values return courses that are active on or between the entered dates. Default date settings are the beginning of the school year as the start date and the current date as the end date. Modify these dates by typing in mmddyy format or by using the calendar icon to choose a date.


When an end date is entered in the Date Range, the report only returns students whose enrollment records have an end date, regardless of their course setup. If an end date is not entered in the Date Range, the report returns

Ad hoc Filter

Selection includes only those students included in the filter.

Format

Determines how the extract generates. 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

Generates the selected calendar information and extract immediately for data review and printing purposes in one of the selected formats.

Submit to Batch

Delays the generation of the extract for data review and printing purposes for a designated time. See the Batch Queue documentation for more information.

Generate the Student Course Completion Extract

  1. Select Student Course Completion as the Extract Type.
  2. The Reporting Period is pre-selected as June.
  3. Mark the Report Protected Identities checkbox, if desired.
  4. Mark the Report State Excluded Course Sections, if desired.
  5. Mark the Report State Excluded Students checkbox, if desired.
  6. Enter a Date Range.
  7. If desired, select an Ad hoc Filter to control what students appear in the report.
  8. Indicate the Format in which the report should generate.
  9. Select the Calendar(s) that should be included on the report.
  10. Click Generate Extract to generate the report in the desired format.

Users have the option of submitting a Student Course Completion report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Screenshot of an example student course completion state CSV format.Student Course Completion - State Format (CSV)

Student Course Completion Extract Layout

Element Name

Description

Location

Collection Version

The collection version consisting of a hard-coded value and the calendar end year. For example, the 2011 June collection would report "2011Jun1.0StuCRSComp."


Alphanumeric, 50 characters

Data not stored

Current School Year

The ending year of the current school year. For example, for the 2010-2011 school year, reports as 2011.


Date field, 4 digits (YYYY)

School Year Setup > End Year


Calendar.endYear

Reporting District Code

The DESE-assigned count district code of the reporting district.


Numeric, 6 digits

System Administration > Resources > District Information > State District Number


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.

  • If not populated, the Reporting School Code on the Course reports.
  • If the Reporting School field on the Enrollment record is not populated and the Reporting School Code on the Course is not populated, the Calendar Type is used to determine the reported value. If the Calendar Type Code is AP: Alternative Program School, all students enrolled in that calendar report the value entered in the Residing School field on the State Reporting Enrollment editor.
  • If the Reporting School field is not populated and the Calendar Type is not AP, the School Organization Type is used. When the School Organization Type Code is AP: Alternative Program School, all students enrolled in that school report the value entered in the Residing School field on the State Reporting Enrollment editor. 
  • If the Reporting School field is not populated and the Calendar Type is not AP and the School Organization Type is not AP, the Reporting School reports from the State School Number.

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


Course Information > Reporting School Code


Course.reportingSchoolCode


Calendar Information > Type


Calendar.type


School Information > School Org Type; State School Number


School.type

School.number

Receiving Coll Dist Code

Six-digit number and name of the sending district.


When the Career Center checkbox is marked on the Calendar, the following logic is used for ALL students enrolled in courses in the calendar:

  • When the Dual Credit Site Code Override field is populated on the Roster Batch Edit, that code reports. When the value entered in the Section Dual Credit Site Code is null, the value entered into the Dual Credit Site Code field reports.
  • When the Dual Credit Site Code is null on the on the Roster Batch Edit, the State District Number reports.

When the Career Center checkbox is not marked on the calendar, this field only reports when the Dual Credit field on the Course is DIST, COLL, ACC, or ITV.

  • When the Dual Credit Site Code Override field is populated on the Roster Batch Edit, that code reports. 
  • When the Dual Credit Site Code Override field is null on the Roster Batch Edit, the Dual Credit Site Code on the Course Section reports. 
  • When the Dual Credit Site Code is null, the State District Number reports.

Numeric, 6 digits

Course Information > Dual Credit


Section Information > Dual Credit Site Code



Course.pseoType


Section Roster Batch Edit > Dual Site Credit Override


Enrollment. dualCreditSite

Send District Code

Resident district of the student.

When the Career Center checkbox is marked on the Calendar, the Sending District reports from the Course editor for ALL students. 


When the Sending District field is not populated on the Course Editor,  then it reports from the Resident District field on the student's Enrollment record.


When the Career Center checkbox is not marked, the Sending District reports when the Course Dual Credit is DIST, COLL, ACC, or ITV. When the Sending District field is not populated on the Course, Sending District reports from the student's Resident District field on the student's Enrollment record.


Numeric, 6 digits

Enrollments > State Reporting Fields > Residing District


EnrollmentMO.residingDistrict


Course Information > Custom Data Elements > Sending District

Sending School Code

Four digit number of the sending high school. This value reports only when the Sending District Code field is reported.


When the Career Center Center checkbox is marked, all students report the sending school from the Sending School field on the Course editor.


If the Sending School field is not populated on the Course editor, the value reports from the Residing School field on the Enrollment record.


When the Career Center checkbox is not marked on the Calendar editor, this field reports from the Sending School field on the Course tab when the Dual Credit field is DIST, COLL or ACC. 


If the Sending School field is not populated on the Course Editor, Sending School reports from Residing School field on the student's Enrollment record. n the Enrollments tab of Student Information.


Numeric, 4 digits

Course Information > Sending School Code


Enrollments > State Reporting Fields > Residing School


Enrollment.residentSchool


Course Information > Custom Data Elements > Sending District


Course.sendingSchoolCode

State ID

The state assigned student identifier.


Numeric, 10 digits

Demographics > State ID


Person.stateID

Local Student ID

The local student identification number maintained by the district.


Numeric, 20 digits

Demographics > Student Number


Person. studentNumber

Student 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

Student 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

Student 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

Student 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

Student Date of Birth

The date on which the student was born.


Date field, 10 characters (MM/DD/YYYY)

Demographics > Birthdate


Identity.birthDate

Student Grade Level

The grade level of the student's enrollment.


Alphanumeric, 2 characters

Enrollments > Grade


Enrollment.grade

ED SSN

The social security number of the primary teacher of the course section that is active as of the end date entered on the report editor.


If there is no primary teacher for the course section, the value tied to the teacher that was last active as of the end date on the extract editor reports.


Numeric, 9 digits

Demographics > Soc Sec Number


Identity.ssn

ED Last Name

The last name of the primary teacher of the course section that is active as of the end date entered on the report editor.


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.

If there is no primary teacher for the course section, the value tied to the teacher that was last active as of the end date on the extract editor reports.


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

Demographics > Last Name


Identity.lastName


Identities > Protected Identity Information > Legal First Name


Identity.legalLastName

ED First Name

The first name of the primary teacher of the course section that is active as of the end date entered on the report editor.


When the Report Protected Identities checkbox is marked on the report editor, the educator's first name reports from the Legal First Name field if populated.

If there is no primary teacher for the course section, the value tied to the teacher that was last active as of the end date on the extract editor reports.

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

Demographics > First Name



Identity.firstName


Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Pos Code

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 from the Employment Assignment. If both the Position Code field and the Assignment Code field are null, a value of 60 reports.


Alphanumeric, 2 characters

District Assignments > Employment Assignment Information > Assignment Code


Section Information > Section Editor > Position Code


Enrollment.positionCode

CTE Prog Type

The program type code of the CTE approved program.


Alphanumeric, 4 characters

Course Information > CTE Program Type


Course.programType

Assignment Number 

The number used to uniquely identify an instance of educator's course assignment also used to link that course to the records of the students within the course.

A record must exist in the Course Assignment Extract with the same Assignment Number, EDSSN, Current School Year, Reporting District Code, Reporting School Code, Pos Code and CTE Program Type in order to match.

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.


Alphanumeric, 20 characters

Section Information > Assignment Number


Section.assignment Number

Loc Sec Num

The section number.


Numeric, 6 digits

Section Information > Section Number


Section.number

Loc Course Num

The course number.


Alphanumeric, 12 characters

Course Information > Number


Course.number

Loc Course Name

The abbreviation of the course name.


Alphanumeric, 60 characters

Course Information > Name


Course.name

Course Num

The course's state code.


Alphanumeric, 6 characters


Course Information > State Code


Course.stateCode

Course Time Unit

The unit of time for which the grade and credit was earned.

  • The value entered in the Course Time Unit reports if that field is populated.
  • If the Course Time Unit field is null, the value reports from the Semester Code field:
    • When CourseSem is 0, reports as YL.
    • When CourseSem is 1, reports as S1.
    • When CourseSem is 2, reports as S2.

Alphanumeric, 2 characters

Section Information > Section Editor > Course Time Unit


CustomSection.value

Dual Credit Site

The site at which instruction of college credit (dual credit) course is given. Required when the  ReceivingColDistCode is not equal to ReportingDistrictCode and the ReceivingColDistCode is a college.


When the Career Center checkbox is marked on the calendar, Dual Credit reports from the Course for ALL students enrolled in courses for the selected calendar. When the Dual Credit field on the Course editor is not populated, a blank value reports.


When the Career Center checkbox is not marked, the selected code from Dual Credit dropdown reports when Dual Credit Site is DIST, ACC, COLL, or ITV.


When the Career Center checkbox is unmarked and the Dual Credit value is ITVN, this reports as blank.


When the Career Center Checkbox is unmarked and the Dual Credit value is DIST, COLL, ITV, or ACC, the code reports on the extract.


Alphanumeric, 4 characters

Course Information > Dual Credit


Section Information > Dual Credit


Course.pseoType

Course Sem

The length of the course.


Numeric, 1 digit

Section Information > Semester Code


Section.semCode

Credit Earned

The number of credits earned by the student for the course for a course that has a Credit Level of HS: High School or MS: Middle School.


Numeric, 4 digits (X.XX, XX.X, XXX)

Data not stored

Credit Scheduled

The number of credits the student was scheduled to earn for a course that has a Credit Level of HS: High School or MS: Middle School.


Numeric, 4 digits

Data not stored

Grade Earned

The grade the student earned for the course. Options include standard A+ through F grades, IC for incomplete and WD for students who withdrew. To report, the Grading Task must be flagged as State Reported and with a Code of FCG (Final Course Grade). The grade in the Score Group or Rubric must be mapped to a State Score value.


Alphanumeric, 2 characters

Data not stored

Adv Placement

Indicates if the course is designated as advanced placement (AP).


Alphanumeric, 1 character (Y or N)

Course Information > Type


Course.type

Honors

Indicates if the course is designated as an honors level course.


Alphanumeric, 1 character (Y or N)

Course Information > Type


Course.type

Crs Comp Comment

The comments attached to the course.

This field reports blank when the first three characters in the Course Comment field are DNR.


Alphanumeric, 70 characters

Course Information > Comments


Course.comments

Course Sequence
Number

Identifies the content of courses taught at more than one level. If only one level of course content is offered, this value is blank.


Numeric, 1 character

Course Information > Sequence


Course.sequence
Number

Credit TypeReports N/A for all records.

Alphanumeric, 2 characters
N/A
Virtual ProviderReports the code selection on the Course Section, indicating the organization that provided virtual learning.

Reports first from the Virtual Provider field on the Course Section. When that field is not populated, the value reports from the Virtual Provider field on the Course Information or Course Master Information editor. If that field is not populated, no value reports.

Numeric, 2 digits
Section Information > Virtual Provider

Section.provider
Course Information > Virtual Provider

Course.provider
Other Virtual ProviderReports the text entered on the Course Section indicating a second provider of virtual education.

Reports first from the Other Virtual Provider field on the Course Section. When that field is not populated, the value reports from the Other Virtual Provider field on the Course Information or Course Master Information editor. If that field is not populated, no value reports.

Alphanumeric, 60 characters
Section Information > Virtual Provider

Section.providerDisplayOverride
Course Information > Other Virtual Provider

Course.providerDisplay