Spreadsheet: 2987313a-baac-4340-8858-4ff06b080bca
Sheet: XMLCourseRecord

MINNESOTA COMMON COURSE CATALOGUE (MCCC)
XML Course Record Element Definitions and Characteristics
as of 10/23/2012
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 203.
COURSE RECORD
NAME | DEFINITION | TYPE | LEN | REQ | PERMITTED VALUES |  | FILE SUBMISSION VALIDATION | SOFT ERROR VALIDATIONS | PERMITTED VALUES |  | FILE SUBMISSION VALIDATION
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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & |  | File will be rejected if this field is null, all spaces, if value is not permitted or contins a leading space.
LocalTitle | The title of the course used by the district or school. | string | 255 | Y | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & |  | File will be rejected if this field is null, all spaces, if value is not permitted or contins 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 MCCC classification number that most closely represents the local course. | [NAME] | 5 | N | 0-9 |  | File will be rejected if value is not permitted.
CourseLevel | Description of 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 only valid for courses classified for 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 CrsLvlVal tab for valid combinations
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. | 0-9 |  | File will be rejected if value is not permitted. |  | K-8?
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. | 0-9 |  | File will be rejected if value is not permitted. |  | K-8?
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 meeting all or part of a graduation requirement for its subject. | 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 is 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 is value is submitted.
Colleges | One or more colleges associated with A, D or X course level K-8 Courses will only use Related College Courses for a Course Level of X. |  |  | C |  | At least one college and related data is required in this section when course level is A or D. |  | When the local course level is A or D then at least one set of college information (the four fields below) is required.
College
CollegeCourseLevel | Local course level that requires college documentation K-8 Courses will only have | 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.
CollegeCourseCode | Course code assigned by post secondary institution. | string | 20 | C |  | a-z, A-Z, 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. |  |  |  |  |  | Special instructions for certain characters at right
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 |  |  | Required when MCCC # 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 course classification is Other. |  |  |  |  | Special instructions for certain characters at right
characters in local description