MCCC – Staff/Course Audit Report

To validate the Staff/Course data, use the Staff/Course Audit Report. This listing will help find missing data and verify the information that will be extracted. To execute the on-screen report select System Reports/State and click on the MCCC – Staff/Course Audit Report link. This listing could take some time to process. Once the audit report is displayed, use the clickable column headers to sort the various columns to search for missing data. For example, click on the FileFldr column header to sort the listing by the teachers' file folder number to ensure that no blank entries exist. Excluded entries will still be listed in the report but will have a strike through them. Entries could be excluded at either the course or the section level.

This report displays the list of unique courses that are included in the current year's historical grades, or do not have a final grade depending on which Class Selection Option is selected.
Class Selection - Select the desired option and click Submit.

All Classes
Only Classes with a Final Grade
Only Classes without a Final Grade

Submit button is disabled until a Class Selection option is selected.
Once results are displayed, the Submit button is disabled until a new Class Selection option is selected.
If the Class Selection is set to Only Classes without a Final Grade then a course that does not have an associated historical grade will not display here but will be on the report if the Sections Marking Indicator is set to 'No' and the other MCCC reporting requirements are met.
Courses that should not be included in the MCCC export file are still listed but are identified by the strike-through font. For example: ~~ENG 100.~~

The columns displayed on the screen are as follows:

Item	Data Element	Description	[Table]FieldName
1	CrsNum	This field contains the course number 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
2	CrsName	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_Name
3	SectNum	This field contains the Section Number. This field value is extracted from the Sections table. From a School > School Setup > Sections > Edit Section.	[Sections]Section_Number
4	PdNum	This field contains the period number of the marked periods in the expression table of the section. From a School > School Setup > Sections > Edit Section.	[Section_Meeting]Period_Number
5	FinalGrade	This field indicates whether or not the class has a Historical Grade record.	[StoredGrades]Grade
6	MarkInd	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
7	InstMthd	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 If not specified reported as CR	[S_MN_SEC_X]MCCC_INST_MTHD
8	InstLang	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
9	InstMin	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: [S_MN_SEC_X]minutesPerTerm OR [S_MN_CRS_X]minutesPerTerm OR OR a sum of the [bell_schedule_items] Minutes_Attended
10	FxdPd	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
11	FileFldr	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
12	TchrOfRec	This field is set to true by the application.
13	MCCCCalYr	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
14	MCCCCalNum	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
15	MCCCTrmType	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
15	MCCCTrmNum	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