MN MCCC Course Extract
Contents
MCCC Course Extract
To create the Course XML extract file, select System Reports/State and click on the MN MCCC Course Extract link. Be sure to have the proper current term set and select All Schools. Click Submit to start the process. The resulting file will be included in the Report Works report queue. Click the Completed link to download the XML file. Follow the Minnesota Department of Education instructions for MCCC data submission of the Course file.
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.
The report selects records based on the following criteria:
- The Course must not be indicated to be excluded from MCCC.
- The Course must students enrolled in at least one section in the selected reporting year.
- Early Education Courses must have the set-up completed from the Courses MN Common Course Catalog (MCCC) - Early Education page.
- Early Education Sections must have the set-up completed from the Sections MN Common Course Catalog (MCCC) - Early Education page.
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
This report uses the State reporting Platform to generate results. There may be some additional setup required to run this report. The additional setup required to will be to configure ReportWorks Preferences if you have not already done so.
- If you have already configured ReportWorks Preferences, no additional setup is required.
- If you have not configured ReportWorks Preferences, please refer to the "ReportWorks Preferences" section of the ReportWorks Setup Guide located on PowerSource. This section will provide steps for configuring the scheduler node for the report queue.
- There is no Report Output file included because the output file is in XML format.
Field | Description |
|---|---|
Report Parameters | Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file. |
Academic Year | Select the appropriate academic year for which you want to run the report. |
Select Schools | From the list of schools, select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. |
| Use Alternate School Number | If you require the use of the Alternate School number select Yes. |
| Tag to Report in Header | Select to run by Site or District Wide. |
Scheduling – Run Now | Leave Run Now selected to run the report now and click submit. |
Scheduling – Schedule (optional) | Click the Schedule button to schedule this report to run automatically at a scheduled time. |
Please Select Schedule Settings | Enter the Start Date and Start time. |
Select to Run Once or Repeat | If selecting Repeat, you will be given the option of Daily, Weekly, Monthly, Yearly |
Please select daily repeat cycle options | Click Weekdays only if you want this report to only run on weekdays |
Please select end date range option | Select No End Date or enter the End Date you want to use. |
Submit | Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
The MCCC Course Extract is an XML file.
Item | Data Element | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
1 | <SchemaVersion> | Schema Version of the file. This set to 4 by MCCC Course Extract. | Numeric | 1 | |
<OrganizationID> | |||||
1 | <UnitNumber> | The Org Unit ID number of a district. This will be District Number from PowerSchool. | [Prefs]DISTRICTNUMBER | Numeric | 4 |
2 | <UnitType> | District Type from MDE-Org | [Prefs]DISTRICTTYPE | Numeric | 2 |
| <Year> | |||||
1 | <Year> | This field contains the school year for the report | Report Parameter | Numeric | 4 |
| <DistrictWide> | |||||
| 1 | <DistrictWide> | Used to indicate that this file applies to all sites in the district. | 3 | ||
| <Sites> | |||||
1 | <SiteNumber> | School number from MDE-Org One line for each site. | [Schools]School_Number Or [Schools]Alternate_School_Number | Numeric | 3 |
<CourseRecord> | |||||
1 | <LocalCourseCode> | This field contains the local course code as specified by the District. This field value is extracted from the Courses table. | [Courses]Course_Number | Alpha | 11 |
2 | <LocalTitle> | This field contains the local course code as specified by the District. This field value is extracted from the Courses table. | [Courses]Course_Name | Alpha | 40 |
3 | <SiteNumber> | Identifies the course as district-wide (000) or associated with a specific school ( 3-digit MDE OrgUnit school code) | [S_MN_SEC_MCCC_EE_X]Site_Number OR [S_MN_CRS_MCCC_EE_X]Site_Number OR [Courses]Schoolid | Numeric | 3 |
4 | <StateCourseCode> | This field contains the Course Code as specified by MDE. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_CrsCd | Numeric | 5 |
5 | <CourseLevel> | This field contains the Course Level as specified by MDE. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_CrsLvl | Alpha | 1 |
6 | <SequenceNumber> | This field contains the Course Sequence. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_SeqNum | Numeric | 2 |
7 | <SequenceLimit> | This field contains the Course Sequence Limit. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_SeqLimit | Numeric | 2 |
8 | <StandardAddressed> | This field contains the Standard Addressed by the Course. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_StdAddr | Alpha | 1 |
9 | <GradRequirementIndicator> | This field contains the Grad Requirement Indicator for the Course. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_GrdReqInd | Alpha | 5 |
10 | <EndOfCourseIndicator> | This field contains the End Of CourseIndicator Indicator for the Course. This field value is extracted from the Courses table. | [S_MN_CRS_X]MCCC_EOCInd | Alpha | 5 |
| 11 | <LocalDescription> | Brief explanation of content of local course. Required when MCCC classification refers to classification for "Other" in any subject area. | [S_MN_CRS_X]Course_Description | Alpha | 1500 |
<Colleges> <College> | |||||
1 | <CollegeCourseLevel> | This field contains the College Course Level as specified by MDE. This field value is extracted from the S_MN_CRS_CollegeCourse_C table. | [S_MN_CRS_CollegeCourse_C] College_Course_Level | Alpha | 1 |
2 | <CollegeCode> | This field contains the Federal code representing post-secondary institution. This field value is extracted from the S_MN_CRS_CollegeCourse_C table. | [S_MN_CRS_CollegeCourse_C]College_Code | Alpha | 6 |
3 | <CollegeCourseCode> | This field contains the Course code assigned by the post-secondary institution. This field value is extracted from the S_MN_CRS_CollegeCourse_C table. | [S_MN_CRS_CollegeCourse_C] College_Course_Code | Alpha | 20 |
4 | <CollegeCourseCredits> | This field contains the Number of postsecondary credits assigned to the course. This field value is extracted from the S_MN_CRS_CollegeCourse_C table. | [S_MN_CRS_CollegeCourse_C] College_Course_Credits | Numeric | 8 |
| <Curriculums> | |||||
| 1 | <CurriculumCode> | The organized delivery of subject area content used in teaching and learning. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_C]Curriculum where [S_MN_CRS_MCCC_EE_C]Type = ‘C’ | ||
| 2 | <ImplementationCode> | The appropriate Implementation Code for the Curriculum From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_C]Implementation | Alpha | 4 |
| <AssessmentsTools> | |||||
| 1 | <AssessmentToolCode> | The tool used to assess early education student achievement. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_C]Curriculum where [S_MN_CRS_MCCC_EE_C]Type = ‘A’ | ||
| 2 | <ImplementationCode> | The appropriate Implementation Code for the Assessment From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_C]Implementation | Alpha | 4 |
| 1 | <EELocationCode> | The location in which the student instruction is delivered. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_X]Location | Alpha | 6 |
| 1 | <StateProgramIndicator> | Is this course a MN State Program. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_X]State_Program_TF | Numeric | 1 |
| 1 | <FederalProgramIndicator> | Is this course a Federal Program. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_X]Federal_Program_TF | Numeric | 1 |
| 1 | <ABEIndicator> | Is this course tied to an Adult Basic Education (ABE) Class. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_X]ABE_Indicator_TF | Numeric | 1 |
| <EEPrograms> | |||||
| 1 | <EEProgramCode> | The type of program under which this course is being reported. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_X]Program_Type | Alpha | 4 |
| <StandardPlacements> | |||||
| 1 | <StandardCode> | Unique code(s) to identify the specific state standard(s) placed in the Local Course as a focus for student learning. From the District Office > District Setup > Courses > MCCC Early Education. Or from a School > School Setup > Courses > MCCC Early Educations. | [S_MN_CRS_MCCC_EE_C]Curriculum where [S_MN_CRS_MCCC_EE_C]Type = ‘S’ | Alpha | 9 |