MN MCCC Student Extract

On this page:

MCCC Early Education Student and MCCC Student Extracts

To create the Student XML extract file, select System Reports/State and click on the MN MCCC Student 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. This file will need to be submitted to the Minnesota Department of Education in tandem with the Staff/Course file.

MCCC Overrides for students without Stored Grades

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

Historical Grades
- Grade
All Enrollments
- Grade Earned
Sections
- Grade Earned
- Term Type
- Term Number
Courses
- Grade Earned
- Term Type
- Term Number

Reporting Direct Pay Records

To report a Direct Pay record for a student you must input the course information by navigating to System Reports > State > Setup > MCCC – Minnesota Direct Pay Student Record Courses and you must associate a Direct Pay class to a Historical Grade, Section or Course.

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 Student must not be indicated to be excluded from the MARSS B Report.
The Student must be scheduled in a section in the selected reporting year that is not indicated to be excluded from MCCC and the course must not be indicated to be excluded from MCCC.
The Student must have a final grade that is associated with a store code in the MCCC Grade Mapping page from the start page > System Reports > State > Setup > MCCC Grade Mapping.

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 Student 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
ScheduledStudent Section Records The following 21 items are present in the ScheduledStudentRecord Section for each selected student.
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 student.
2	AcademicYearNumber	Number assigned by MDE for 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	This the MCCC Term Type associated with the Section based on its Scheduling Term. From a School > System Reports > State > Setup > MCCC Term Mapping.	[Gen]value where cat = mn_mccc_trm_map OR [S_MN_SEC_X]MCCC_Term_type OR [S_MN_CRS_X]MCCC_Term_type	Alpha	2
5	TermNumber	This the MCCC Term Number associated with the Section based on its Scheduling Term. From a School > System Reports > State > Setup > MCCC term Mapping.	[Gen]valueli3 where cat = mn_mccc_trm_map OR [S_MN_SEC_X]MCCC_Term_Number OR [S_MN_CRS_X]MCCC_Term_Number	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
Student: The following 7 items are present in the Student Section for each selected student.
8	StateStudentId	This field contains the Student's MARSS Number. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[Students]state_studentnumber	Numeric	13
9	LastName	This field contains the Student's Last Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Last_Name or [Students]Last_name	Alpha	40
10	FirstName	This field contains the Student's First Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_First_Name or [Students]First_Name	Alpha	40
11	MiddleName	This field contains the Student's Middle Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Middle_Name or [Students]Middle_name	Alpha	40
12	Suffix	This field contains the Student's Name Suffix. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[S_MN_STU_X]State_Suffix	Alpha	5
13	Gender	This field contains the Student's Gender. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics.	[StudentCoreFields]pscore_legal_gender or [Students]Gender	Alpha	1
14	BirthDate	This field contains the Student's Gender. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics.	[Students]DOB	Date Format YYYY-MM-DD	10
Student Marks: The following 7 items are present in the Student Marks Section for each selected student
15	SubjectArea	This field contains the Subject Area. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section.	[S_MN_SEC_X]MCCC_SUBJ_AREA	Numeric	2
16	TermType	This the MCCC Term Type associated with the Section based on its Scheduling Term and the Store Code for the grade that will be reported. From a School > System Reports > State > Setup > MCCC Grade Mapping.	[Gen]value where cat = mn_mccc_trm_map OR [S_MN_SEC_X]MCCC_Term_type OR [S_MN_CRS_X]MCCC_Term_type	Alpha	2
17	TermNumber	This the MCCC Term Number associated with the Section based on its Scheduling Term and the Store Code for the grade that will be reported. From a School > System Reports > State > Setup > MCCC Grade Mapping.	[Gen]valueli3 where cat = mn_mccc_trm_map OR [S_MN_SEC_X]MCCC_Term_Number OR [S_MN_CRS_X]MCCC_Term_Number	Numeric	2
18	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
19	LocalMarkEarned	This the Grade the student received from Historical Grades based on the MCCC Grade Mapping for the section. From the Start Page > Select a Student > Historical Grades.	[StoredGrades]Grade OR [S_MN_CC_X]MCCC_Grade_Reported OR [S_MN_SEC_X]MCCC_Grade_Reported OR [S_MN_CRS_X]MCCC_Grade_Reported	Alpha	10 4
20	LocalCreditsEarned	This the Earned Credit Hours the student received from Historical Grades based on the MCCC Grade Mapping for the section. From the Start Page > Select a Student > Historical Grades	[StoredGrades]EarnedCrHrs	Numeric	10
21	CollegeCreditsEarned	This field contains the College Course Credits if the course has a college course association. This field value is extracted from the Courses table. The student must have earned credit and the College Course level must be D – Dual/concurrent Enrollment or X – Not Applicable From the District Office > District Setup > Courses. Or from a School > School Setup > Courses.	[S_MN_CRS_CollegeCourse_C]College_Course_Credits OR [S_MN_SGR_X]MCCC_EarnedCrhrs	Numeric	10
DirectPayStudentRecord Section Records The following 16 items are present in the DirectPayStudentRecord Section for each selected student.
1	SiteNumber	School number from MDE-Org	[Courses]Schoolid	Numeric	3
2	StateStudentId	This field contains the Student's MARSS Number. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[Students]state_studentnumber	Numeric	13
3	StateCourseCode	This field contains the MCCC classification number. Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses	[S_MN_CRS_X]MCCC_CRSCD OR [S_MN_DirectPayCourses_S]State_Course_Code	Integer	10
4	CollegeCode	This field contains the Federal code representing the post-secondary institution. Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses	[S_MN_DirectPayCourses_S]College_Code	String	10
5	StateStudentId	This field contains the Student's MARSS Number. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[Students]state_studentnumber	Numeric	13
6	LastName	This field contains the Student's Last Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Last_Name or [Students]Last_name	Alpha	40
7	FirstName	This field contains the Student's First Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_First_Name or [Students]First_Name	Alpha	40
8	MiddleName	This field contains the Student's Middle Name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Middle_Name or [Students]Middle_name	Alpha	40
9	Suffix	This field contains the Student's Name Suffix. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[S_MN_STU_X]State_Suffix	Alpha	5
10	Gender	This field contains the Student's Gender. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics.	[StudentCoreFields]pscore_legal_gender or [Students]Gender	Alpha	1
11	BirthDate	This field contains the Student's Gender. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics.	[Students]DOB	Date YYYY-MM-DD	10
12	SubjectArea	This field contains the Subject Area. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section or Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses.	[Sections]MN_MCCC_SUBJ_AREA or [S_MN_DirectPayCourses_S]Subj_Area	Numeric	2
13	CollegeMarkEarned	This the Grade the student received from Historical Grades based on the MCCC Grade Scale Mapping for the section. Grade Scale Mapping is located: Start Page > District > Grade Scales > Edit Grade Scale > Grade Mapping for MCCC. See the Appendix for a list of valid codes. From the Start Page > Select a Student > Historical Grades or Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses.	[StoredGrades]Grade OR [S_MN_GSI_X]MCCC_Grade_Earned (if it exists) OR [S_MN_SGR_X]MCCC_Grade_Reported	Alpha	10
14	CollegeCreditsEarned	This the Earned Credit Hours the student received from Historical Grades based on the MCCC Grade Mapping for the section. From the Start Page > Select a Student > Historical Grades or Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses.	[StoredGrades]EarnedCrHrs OR [S_MN_CRS_CollegeCourse_C]College_Course_Credits OR [S_MN_SGR_X]MCCC_EarnedCrhrs	Numeric	10
15	CollegeCourseCode	This field contains the Course code for class assigned by post-secondary institution. Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses.	[S_MN_DirectPayCourses_S] College_Course_Code	String	50
16	CollegeCourseTitle	This field contains the Course title as assigned by a post-secondary institution. Start Page > System Reports > State Reports > State Reports Setup > MCCC - Minnesota Direct Pay Student Record Courses.	[S_MN_DirectPayCourses_S] College_Course_Title	Sting	500