MN MCCC Staff Extract

On this page:

MCCC Early Education and MCCC Staff Extracts

To create the Course XML extract file, select System Reports/State and click on the MN MCCC Staff 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 Staff file.

MCCC Overrides for students without Stored Grades

If districts use the MCCC override options are selected in the following order:

Sections
- Grade Earned
- Term Type
- Term Number
Courses
- Grade Earned
- Term Type
- Term Number

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to 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 Section must not be indicated to be excluded from MCCC.
The Staff member must be the lead teacher of a section whose term is associated with an MCCC Local Term ID in the MCCC Term Mapping Setup page. From the start page > System Reports > State > Setup > MCCC Calendar Entry (Term Mapping).
The Students assigned to a specific section for which the teacher is a lead teacher must have a final grade in Historical Grades for the section to be reported. If this is an Early Education section a final grade is not required.

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	There are no runtime parameters assigned to this 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.
Scheduling – Run Now	Leave Run Now selected to run the report now and click Submit Button.
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 Staff 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 3 by the report application.		Numeric	1
Header The following 4 items are present in the Header Section.
1	UnitNumber	The Org Unit ID number of a district. This will be District Number from PowerSchool. From the District Office > District > District Info	[Prefs]DISTRICTNUMBER	Numeric	4
2	UnitType	District Type from MDE-Org From the District Office > District > District Info.	[Prefs]DISTRICTTYPE	Numeric	2
3	Year	This field contains the school year for the report 2016-2017 = 17	Report Parameter	Numeric	4
4	SiteNumber This item is repeated for each selected school	School number from MDE-Org	[Schools]School_Number Or [Schools]Alternate_School_Number	Numeric	3
Course Section Records The following 15 items are present for each selected section.
1	SiteNumber	School number from MDE-Org	[S_MN_SEC_MCCC_EE_X]Site_Number OR [S_MN_CRS_MCCC_EE_X]Site_Number OR [Courses]Schoolid	Numeric	3
	Term The following 4 items are present in the Term section for each selected section.
2	AcademicYearNumber	Number assigned by MDE to the Academic Year after Calendar Information was manually entered in MCCC. From a School > System Reports > State > Setup > MCCC term Mapping.	[Gen]valueli where cat = mn_mccc_trm_map	Numeric	10
3	CalendarNumber	Number assigned by MDE to Calendar after Calendar Information was manually entered in MCCC. From a School > System Reports > State > Setup > MCCC term Mapping.	[Gen]valueli2 where cat = mn_mccc_trm_map	Numeric	10
4	TermType	Code associated with the Term selected for a Calendar within an Academic Year when Calendar Information was manually entered in MCCC. From a School > System Reports > State > Setup > MCCC term Mapping.	[Gen]value where cat = mn_mccc_trm_map	Alpha	2
5	TermNumber	Number selected based on term type for a term in a Calendar for an Academic Year after Calendar Information was manually entered in MCCC. From a School > System Reports > State > Setup > MCCC term Mapping.	[Gen]valueli3 where cat = mn_mccc_trm_map	Numeric	2
6	LocalCourseCode	This field contains the local course code as specified by the District. This field value is extracted from the Courses table. From the District Office > District Setup > Courses. Or from a School > School Setup > Courses.	[Courses]Course_Number	Alpha	11
7	SectionCode	This field contains the SectionID. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section.	[Sections]ID	Numeric	20
8	PeriodNumber	This field contains the period number of the marked periods in the expression table of the section. All selected periods will be listed separately. From a School > School Setup > Sections > Edit Section.	[Section_Meeting]Period_Number	Numeric	2
9	MarkingIndicator	This field contains the Marking Indicator. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section. Reported Values: False if = 'N' else True if = 0 or null.	[S_MN_SEC_X]MCCC_MRK_IND	Alpha	5
10	InstructionMethodType	This field contains the Instruction Method Type. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section. Reported Values: CR - Classroom CS - Classroom - Self Contained CT - Classroom Team CC - Classroom Collaborative CL - Classroom Looped CP - Computer Program ITVS - Interactive Live Video - Sending ITVR - Interactive Live Video - Receiving BH - Blended/Hybrid G - Guided (Independent Study CO - Completely Online O - Other EE - Early Education SL - Supplemental *If not specified reported as CR\|[S_MN_SEC_X]MCCC_INST_MTHD\|Alpha\|4\|
11	InstructionLanguageType	This field contains the Instruction Language Type. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section. Reported Values: See Appendix A –MARSS B File Home Primary Language Codes in this document.	[S_MN_SEC_X]MCCC_INST_LNG	Numeric	3
12	InstructionMinutesPerTerm	This field contains the total number of minutes of instruction for this course section during the term it is scheduled to meet. This field value is extracted from: For schools that do not use a traditional Bell Schedule from the Sections or Courses table - Minutes Per Term. From a School > School Setup > Sections > Edit Section or Courses > Edit Course District Information. For schools that do use a traditional Bell Schedule from the Bell Schedule and a total of the minutes Attended field. From a School > School Setup > Bell Schedules.	If specified: [Sections]minutesPerTerm OR [Courses]minutesPerTerm OR OR a sum of the [bell_schedule_items] Minutes_Attended	Numeric	6
13	FixedPeriodIndicator	This field contains the Fixed Period Indicator. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section. Reported Values: false if = 'N' else true if = 0 or null.	[S_MN_SEC_X]MCCC_FXD_TM	Alpha	1
Staff Records: The following 2 items are present for each selected section
14	FileFolderNumber	This field contains the teachers' File Folder Number from MDE. This field value is extracted from the Teachers table. From the start page > Staff Search > Select a Staff Member > Information > STAR Information.	[S_MN_USR_X]FILE_FOLDER	Numeric	6
15	TeacherOfRecordIndicator	This field is set to true by the application.		Alpha	5