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

<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
 | <xs:element name="SERVSCourseSubmission" type="SERVSCourseSubmissionType">
 |  | <xs:annotation>
 |  |  | <xs:documentation>This Common Course Catalog Schema v02 07/25/2012, represents the schema design for the Common Course Catalog Course Section Staff submission format. Address all commments to [EMAIL] or [PHONE]. Thank you.</xs:documentation>
 |  | </xs:annotation>
 | </xs:element>
 | <xs:complexType name="HeaderType2">
 |  | <xs:sequence>
 |  |  | <xs:element name="OrganizationID" type="OrganizationIDType">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>There must be an org number.  This will be checked against the submission login ID. </xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  | </xs:element>
 |  |  | <xs:element name="Year">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>This field is the year number representing this school year. For the 10-11 school year, this value should be 2011.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:gYear">
 |  |  |  |  |  | <xs:minInclusive value="2011"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="OrganizationIDType">
 |  | <xs:sequence>
 |  |  | <xs:element name="UnitNumber">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The Org Unit ID number of a district.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="0001"/>
 |  |  |  |  |  | <xs:maxInclusive value="9999"/>
 |  |  |  |  |  | <xs:totalDigits value="4"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="UnitType">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The district type.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="01"/>
 |  |  |  |  |  | <xs:maxInclusive value="99"/>
 |  |  |  |  |  | <xs:totalDigits value="2"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="CourseRecordType">
 |  | <xs:sequence minOccurs="0">
 |  |  | <xs:element name="LocalCourseCode">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The alpha/numeric identifier used by the district or school to uniquely identify each course in the local curriculum.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:maxLength value="20"/>
 |  |  |  |  |  | <xs:pattern value="[\w_!~`|^=@#$%*&quot;&amp;&lt;&gt;&apos;,:;(\[\)\]\{\}\\\.\s\-/\?\+]+"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="LocalTitle">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The alpha/numeric title of the course used by the district or school</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:[NAME] value="255"/>
 |  |  |  |  |  | <xs:pattern value="[\w_!~`|^=@#$%*&quot;&amp;&lt;&gt;&apos;,:;(\[\)\]\{\}\\\.\s\-/\?\+]+"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element [NAME]">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Identifies the course as district-wide (000) or associated to a specific school ( 3-digit MDE OrgUnit school code)</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="000"/>
 |  |  |  |  |  | <xs:maxInclusive value="999"/>
 |  |  |  |  |  | <xs:totalDigits value="3"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="StateCourseCode" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The MCCC index number that most closely represents the local course.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:totalDigits value="5" fixed="false"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="CourseLevels" type="CourseLevelType" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Description of the course level e.g. basic or enriched. See list of permitted values</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  | </xs:element>
 |  |  | <xs:element name="SequenceNumber" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Identifies where a course falls in a sequence of courses, e.g. 1st, 2nd or 3rd.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="1"/>
 |  |  |  |  |  | <xs:maxInclusive value="99"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="SequenceLimit" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Identified the maximum number courses in a sequence.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="1"/>
 |  |  |  |  |  | <xs:maxInclusive value="99"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="StandardAddressed" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Standards or benchmarks used to assess student learning in the course.  See list of permitted values.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:length value="1"/>
 |  |  |  |  |  | <xs:enumeration value="N"/>
 |  |  |  |  |  | <xs:enumeration value="S"/>
 |  |  |  |  |  | <xs:enumeration value="L"/>
 |  |  |  |  |  | <xs:enumeration value="C"/>
 |  |  |  |  |  | <xs:enumeration value="A"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="GradRequirementIndicator" type="xs:boolean" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Defines the course as meeting all or part of a graduation requirement for its subject.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  | </xs:element>
 |  |  | <xs:element name="EndOfCourseIndicator" type="xs:boolean" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>If set to true, then this course represents completion of state standards required for subject assessments.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  | </xs:element>
 |  |  | <xs:element name="Colleges" type="CollegesType" minOccurs="0"/>
 |  |  | <xs:element name="LocalDescription" minOccurs="0">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>The local description of the course used by the district or school. Value needs to be submitted if the MCCC course classification is Other for any subject area.</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:maxLength value="8000"/>
 |  |  |  |  |  | <xs:pattern value="[\w_!~`|^=@#$%*&quot;&amp;&lt;&gt;&apos;,:;(\[\)\]\{\}\\\.\s\-/\?\+]+"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="CourseRecordsType">
 |  | <xs:sequence minOccurs="0" maxOccurs="unbounded">
 |  |  | <xs:element name="CourseRecord" type="CourseRecordType"/>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="SERVSCourseSubmissionType">
 |  | <xs:sequence>
 |  |  | <xs:element name="SchemaVersion">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>There must be one and only one schema version.  This is restricted to the list of possible versions.   </xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:integer">
 |  |  |  |  |  | <xs:minInclusive value="2"/>
 |  |  |  |  |  | <xs:maxInclusive value="2" fixed="false"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="Header" type="HeaderType2">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>There must be one and only one header</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  | </xs:element>
 |  |  | <xs:element name="CourseRecords" type="CourseRecordsType"/>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="CourseLevelType">
 |  | <xs:sequence minOccurs="0" maxOccurs="8">
 |  |  | <xs:element name="CourseLevel">
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:length value="1"/>
 |  |  |  |  |  | <xs:enumeration value="B"/>
 |  |  |  |  |  | <xs:enumeration value="G"/>
 |  |  |  |  |  | <xs:enumeration value="E"/>
 |  |  |  |  |  | <xs:enumeration value="D"/>
 |  |  |  |  |  | <xs:enumeration value="A"/>
 |  |  |  |  |  | <xs:enumeration value="C"/>
 |  |  |  |  |  | <xs:enumeration value="X"/>
 |  |  |  |  |  | <xs:enumeration value="N"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="CollegesType">
 |  | <xs:sequence maxOccurs="unbounded">
 |  |  | <xs:element name="College" type="CollegeType"/>
 |  | </xs:sequence>
 | </xs:complexType>
 | <xs:complexType name="CollegeType">
 |  | <xs:sequence>
 |  |  | <xs:element name="CollegeCourseLevel">
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:length value="1"/>
 |  |  |  |  |  | <xs:enumeration value="D"/>
 |  |  |  |  |  | <xs:enumeration value="A"/>
 |  |  |  |  |  | <xs:enumeration value="X"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="CollegeCode">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Federal code representing post-secondary institution</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:length value="6"/>
 |  |  |  |  |  | <xs:pattern value="([0-9a-zA-Z])*"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="CollegeCourseCode">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Course code assigned by Post-secondary institution</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:string">
 |  |  |  |  |  | <xs:maxLength value="20"/>
 |  |  |  |  |  | <xs:[NAME] value="1"/>
 |  |  |  |  |  | <xs:pattern value="(\s*[\w_!~`|^=@#$%*&quot;&amp;&lt;&gt;&apos;,:;(\[\)\]\{\}\\\.\-/\?\+]\s*)+"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  |  | <xs:element name="CollegeCourseCredits">
 |  |  |  | <xs:annotation>
 |  |  |  |  | <xs:documentation>Number of post-secondary credits earned by this student for this course section.  Submission format:  9999.999</xs:documentation>
 |  |  |  | </xs:annotation>
 |  |  |  | <xs:simpleType>
 |  |  |  |  | <xs:restriction base="xs:decimal">
 |  |  |  |  |  | <xs:fractionDigits value="3"/>
 |  |  |  |  |  | <xs:minInclusive value="0"/>
 |  |  |  |  |  | <xs:maxInclusive value="9999.999"/>
 |  |  |  |  | </xs:restriction>
 |  |  |  | </xs:simpleType>
 |  |  | </xs:element>
 |  | </xs:sequence>
 | </xs:complexType>
</xs:schema>