Spreadsheet: 021e46ab-1433-4312-b0b6-2c552c8b8a6d
Sheet: XMLCourseRecord

MINNESOTA COMMON COURSE CATALOGUE (MCCC)
XML Course Record Element Definitions and Characteristics
NOTES: | • File submission validation will occur at time of file upload.  [NAME] may be rejected at this point in the load process.
 | • Database validations will occur after the file load is successful.  Errors will be sent to user via email.
 | • MinOccurs default is one (1).
 | • K-8 validations are in  dark red and will not be implemented until K-8 is released in March 2013.
Local Course Index Record
NAME | DEFINITION | TYPE | LENGTH | REQUIRED | PERMITTED VALUES | FILE SUBMISSION VALIDATION | SOFT ERROR VALIDATIONS
LocalCourseCode | This is the alpha/numeric identifier used by the district or school to uniquely identify each course in the local curriculum. | string | 20 | Y | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | • File will be rejected if this field is null, all spaces or if value is not permitted.  • File will be rejected if the LocalCourseCode has a space in the first or last positions in the field.
LocalTitle | The title of the course used by the district or school. | string | 255 | Y | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | File will be rejected if this field is null, all spaces, if value is not permitted or contains a leading space.
SiteNumber | Identifies the course as district-wide (000) or associated to a specific school (3-digit MDE-Org school code). | [NAME] | 3 | Y | 0-9 | • File will be rejected if site number is not valid in MDE-Org for submission year.    • File will be rejected if value is not permitted.
StateCourseCode | This is the number of the MCCC classification that most closely describes  the local course. | [NAME] | 5 | N | 0-9 | File will be rejected if value is not permitted.
CourseLevel | Describes the course level. | string | 1 | N | B – Basic or remedial  G – General or regular courses E – Enriched, honors or advanced D – Dual/concurrent enrollment A – Articulation agreement C – Industry/occupational certification courses    N – No credit X – Not applicable | An incorrect value whether submitted as a single value or as part of enumerated values causes the file to reject | • D, A, C valid only  for courses classified as 9-12.    •  K-8 course with D,A,C values will show a soft error and the value will not be saved.  •  An incorrect combination of valid values causes a soft error and no course level values will be saved.  See MCCC Field Definition Reference Document for allowable course level  combinations and grade level restrictions.
SequenceNumber | Identifies where a course occurs in a consecutive series of courses (e.g. 1st, 2nd or 3rd). | [NAME] | 2 | N | 0-9 | File will be rejected if value is not permitted | •  Record is rejected if Sequence Number is populated and Sequence Limit is omitted.  •  Record is rejected if Sequence Number is greater than Sequence Limit.  •  Creates soft error on record if both [NAME] and Sequence Limit are omitted.
SequenceLimit | Identifies the maximum number courses in a consecutive series. | [NAME] | 2 | N | 0-9 | File will be rejected if value is not permitted. | •  Record is rejected if Sequence Limit is populated and [NAME] is omitted.  •  Record is rejected if Sequence Limit is smaller then Sequence Number.  •  Creates soft error on record if both [NAME] and Sequence Limit are omitted.
StandardAddressed | Standards or benchmarks used to assess student learning in the course. | string | 1 | N | N – National S – State L – Local  C – Combination of national, state and/or local A – None addressed | File will be rejected if value is not permitted. | Creates soft error if omitted
GradRequirementIndicator | Defines the course as satisfying all or part of a graduation requirement for a content area. | string | 5 | N | true, false | File will be rejected if value is not permitted. | •  9-12 classifications -- soft error if omitted.  •  K-8 classifications -- A value of False is placed in the field no matter what value is submitted.
EndOfCourseIndicator | If set to true, then this course represents completion of state standards required for subject assessments. | string | 5 | N | true, false | File will be rejected if value is not permitted. | •  9-12 classifications -- soft error if omitted.   • K-8 classifications -- A value of False is placed in the field no matter what value is submitted.
Colleges | •  One or more colleges associated with A, D or X course levels grades 9-12.  •  One or more colleges associated only  with course level  X grades K-8. |  |  | C | At least one college and related data is required in this section when course level is A or D grades 9-12. |  | When the local course level is A or D then at least one set of college information (the four fields below) is required grades 9-12.
CollegeCourseLevel | •  Local course level that requires college documentation  •  K-8 Courses may only use X. | string | 1 | C | A, D, or X | •  File will be rejected if value is not permitted.   •  File will be rejected if this field is not provided and local course level is A or D. | If the level on the college course does not match  the level on the local course, the record will not save
CollegeCode | Federal code representing post-secondary institution. | string | 6 | C | 0-9, a-z, A-Z | •  File will be rejected if value is not permitted.   •  File will be rejected if this field is not provided and local course level is A or D. | Record will be rejected if college code is not a valid federal college code.  URL for federal college code information:  http://www.ifap.ed.gov/ifap/fedSchoolCodeList.jsp
CollegeCourseCode | Course code assigned by post secondary institution. | string | 20 | C | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | •  File will be rejected if value is not permitted.   •  File will be rejected if this field is not provided and local course level is A or D.
CollegeCourseCredits | Number of postsecondary credits assignd to the course (decimal should be displayed = 99.999) | number 3 dec | 8 | C | 0-9 | •  File will be rejected if value is not permitted.   •  File will be rejected if this field is not provided and local course level is A or D.
LocalDescription | Local course description | string | 1500 | C | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | •  Required when MCCC classification refers to classification for "Other" in any subject area.  •  File will be rejected if more than 1500 characters and spaces are submitted. | Record will be rejected if description is omitted and MCCC classification is "Other."