Spreadsheet: 05af2bb4-bc01-4f3e-8582-6cf361dcc7ad
Sheet: All Import fields

FileName | K-8 updates | Id | XSD/ [NAME] | FieldName | Description | Data Type | Length | Permitted Value | Required | XML Validation | Business Engine Validation
StudentCourse |  | 0 | 0 | Note: XML_Version | The current version of the Student XML format is Version 1.0 last updated on 03/07/2012 |  |  |  |  | None
StudentCourse |  | H1 | 1 | Schema Version | Identifies the version of the XML definition file used to create the XML file. | [NAME] | 1 | 0-9 | Y | • Min value = 2 • [NAME] value = 2
StudentCourse |  | B2 | 2 | Unit  Number | The district identifying number (MDE OrgUnit Number) | [NAME] | 4 | 0-9 | Y | • Must be an integer • Min value = 0001 [NAME] value = 9999 • Must be a 4 digit number | • File will be rejected if unit number is not valid and active in MDE OrgUnit for reporting year.   B2, B3, B1
StudentCourse |  | B3 | 3 | Unit Type | The district type identifying number (MDE OrgUnit district type number) | [NAME] | 2 | 0-9 | Y | • Must be an integer • Min value = 01 [NAME] value = 99 • Total digits = 2 | File will be rejected if the unit type is not valid for the unit number in MDE OrgUnit for reporting year.   B2, B3, B1
StudentCourse |  | B1 | 4 | Year | The reporting year. For the 2010-2011 school year, the value would be 2011. | Year | 4 | 0-9 | Y | • Min value = 2011 | File will be rejected if year is not an open collection year.
StudentCourse |  | H2 | 5 | District Wide | Used to indicate that this file applies to all sites in the district. | [NAME] | 3 | 0 | C | • Either DistrictWide field is used or Sites tag is used to list individual sites included in the XML file. • Must be 000
StudentCourse |  | H3 | 6 | Sites | TAG not a field - The list of sites to which the data in this file applies. | Tag not field | - | - | C | Either DistrictWide field is used or Sites tag is used to list individual sites included in the XML file.
StudentCourse |  | H4 | 7 | Site Number | Found only under the label Sites | [NAME] | 3 | 0-9 | C | • Must be an integer • Total digits = 3 • Max value=999 • Min value=001 • Only used if [NAME] is present | File will be rejected if site number is not valid and active in MDE OrgUnit for reporting year for the Unit Number and Unit Type.   Cannot equal 000.  B1, B2, B3, B4
StudentCourse |  | H5 | 8 | [NAME] | The name of the vendor or technical person who created the XML data file. | string | 60 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | N | [NAME] type field [NAME] length is 20
StudentCourse |  | 5 | 9 | Record Type | Indicates student coursework record type.  Element dependent on grade levels. | string | 22 | [NAME] | Y | •  Must be one of the valid [NAME]:     1. ScheduledStudentRecord     2. ProjectStudentRecord     3. IndStudyStudentRecord     4. DirectPayStudentRecord •  Must have one of the above types. •  Can have unlimited number of these types. | • DirectPayStudentRecord cannot be used for a local course with a K-8 MCCC  classification number.
StudentCourse |  | B4 | 10 | Site Number | The specific school number (MDE OrgUnit school number) | [NAME] | 3 | 0-9 | Y | • Must be an integer • Valid range 001-999 • Total digits allowed 3 | • File will be rejected if site number is not valid and active for the unit number and unit type in MDE OrgUnit for reporting year.   • File will be rejected if SiteNumber is not found in the SiteNumber List in the header. B1, B2, B3, B4
StudentCourse |  | 6 | 11 | State Course Code | • MCCC classification number, required only for ProjectStudentRecord (Project-Based Learning) Record Type.     • Must be a Seminar/Project MCCC classification. | [NAME] | 5 | 0-9 | C | • Required for Record Type:    -ProjectStudentRecord only • Must be an integer • Total digits = 5 | • File will be rejected if MCCC value is not valid. • For ProjectStudentRecords if the State Course Code does not have the ProjectBasedLearning set to true reject the file.
StudentCourse |  | B7 | 12 | Academic Year Number | MDE generated Academic Year ID number, found on  the MDE Calendar Export report. | [NAME] | 3 | 0-9 | C | • Required for RecordType:     -ScheduledStudentRecords only • Must be an integer • Min value allowed = 1 | File will be rejected if schedule number does not exist in Academic Year, [NAME], Term Type and Term Number sequence for the reporting year.  B1, B2, B3, B7
StudentCourse |  | B8 | 13 | Calendar Number | MDE generated Calendar ID number, found on the MDE Calendar Export report. | [NAME] | 3 | 0-9 | C | • Required for RecordType:     -ScheduledStudentRecords only • Must be an integer • Min value allowed = 1 | File will be rejected if schedule number does not exist in Academic Year, [NAME], Term Type and Term Number sequence for the reporting year.  B1, B2, B3, [NAME], B8
StudentCourse |  | B9 | 14 | Term Type | The type of term a district or site uses to schedule courses (year long, quarter, semester, trimester, hexmester, other).  Found on the MDE Calendar Export report. | string | 20 | "Y," "S," "T," "Q," "QM," "H," "OT," "SU"  See MCCC Field Definition Reference Document for valid term types and codes. | C | • Required for RecordType:     -ScheduledStudentRecords only • Min length = 1 • [NAME] length = 2 • Allowed characters A - Z | File will be rejected if schedule number does not exist in Academic Year, [NAME], Term Type and Term Number sequence for the reporting year.   B1, B2, B3, [NAME], B8, B9
StudentCourse |  | B10 | 15 | Term Number | Number identifying the term in which this course section occurs. Comes from the MDE Calendar Export. | [NAME] | 2 | 0-9 | C | • Required for Record Type:     -ScheduledStudentRecords only • Must be an integer • Min value = 1 | File will be rejected if schedule number does not exist in Academic Year, [NAME], Term Type and Term Number sequence for the reporting year.  B1, B2, B3, [NAME], B8, B9, B10
StudentCourse |  | B5 | 16 | Local Course Code | This is the alpha/numeric identifier used by the district or school to uniquely identify each course in the local curriculum. | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | C | • Required for Record Type:   -ScheduleStudentRecords   -IndStudyStudentRecords • Must be a string type • Min length = 1 • [NAME] length = 20 | • File will  reject if this code does not match the site and local course code in the Local Course Index for the reporting year.  • File will reject if  the local course code for an Ind.StudyStudentRecords is not indexed under a MCCC classification that has the IndStudy flag set to true. B1, B2, B3, B4 or 000,  B5  See MCCC Field Definition Reference Document for valid Independent Study MCCC classifications. • The file will be rejected if the LocalCourseCode has a space in the first or last positions in the field.
StudentCourse |  | B6 | 17 | Section Code | The local code (must use vendor code if available)  that identifies a particular section of a course that a teacher teaches and a student takes at a particular point in time. | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | C | • Required for Record Type:   -ScheduleStudentRecords • Must be a string type • Min length = 1 • [NAME] length = 20 | File will be rejected if this section code does not match a section code submitted in the StaffCourse records for the collection year. The file will be rejected if the SectionCode has a space in the first or last positions in the field. B1, B2, B3, B4, [NAME], B6, [NAME], B8, B9, B10
StudentCourse |  | B11 | 18 | State Student Id | MARSS number of the student. | [NAME] no dec | 13 | 0-9 | Y | • Must be an long integer • Must be 13 digits long | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student ID system is used to validate this number.
StudentCourse |  | 16 | 19 | Last Name | The student's surname. | string | 40 | a-z, A-Z, dash (-) and apostrophe (’).  See MCCC Field Definition Reference Document for valid formatting of special characters. | Y | • Must be a string • Min length = 1 • [NAME] length is 40. | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student ID system is used to validate this field.
StudentCourse |  | 14 | 20 | First Name | The student's given first name. | string | 40 | a-z, A-Z, dash (-) and apostrophe (’).  See MCCC Field Definition Reference Document for valid formatting of special characters. | Y | • Must be string • Min length = 1 • [NAME] length = 40 | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.   State Student ID system is used to validate this field.
StudentCourse |  | 15 | 21 | Middle Name | The student's given middle name. | string | 40 | a-z, A-Z, dash (-) and apostrophe (’).  See MCCC Field Definition Reference Document for valid formatting of special characters. | N | • Must be a string • Min length = 1 • [NAME] length is 40. • Min occurs = 0 (XML doesn't require) | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student ID system is used to validate this field.
StudentCourse |  | 17 | 22 | Suffix | Additional identifier following surname e.g.,  Junior, Senior. | string | 5 | a-z, A-Z, 0-9 | N | • Must be a string • Min length = 1 • [NAME] length = 5 • Min occurances = 0 (XML doesn't require) | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student Id system is used to validate this field.
StudentCourse |  | 19 | 23 | Gender | The gender of the student. | string | 1 | M, F | Y | • Must be a string [NAME] length is 1 • Must be M or F. | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student ID system is used to validate this field.
StudentCourse |  | 18 | 24 | DOB | Date of birth. | string | 10 | Date format: [NAME]. 0-9, hyphen (-) | Y | • Must be string • Length = 10 • Formatted yyyy-mm-dd | Row ID's B11 & 14-19 are considered one unit of data when confirming the student ID.  State Student Id system is used to validate this field.
StudentCourse | new rule | 20 | 20 | Subject Area | Identifies the MCCC Subject Area for the mark given. | string | 2 | 0-9  See MCCC Field Definition Reference Document for valid MCCC Subject Area codes. | C | • Must be an string • Total digits must = 2 • Min value = 01 [NAME] value = 99 | • Give an error if the value is not a permitted value. • Required for a MCCC classifications that are Multiple Subject Areas classification. -If only one mark is submitted then the subject area has to be empty. Rule suspended 6/2013. -If more than one mark is submitted for the same term data then Subject Area is required for these marks. • This field is only populated if the MCCC classifications is one that allows for multiple subjects. - Only 51 and 52 may be submitted for K-8 marks and/or credits if credits are awarded (K-8 only). • Reject file if StateCourseCode is 01055 or 01057 and Subject Area is not 01 or 04. See MCCC Field Definition Reference Document for valid Multiple Subject Area classifications.
StudentCourse |  | 24 | 21 | [NAME] Type | The term type in which the mark is given. | string | 2 | "Y," "S," "T," "Q," "QM," "H," "OT," "SU"  See MCCC Field Definition Reference Document for valid term types and codes. | C | • Used by StudentRecord Type:    - ScheduledStudentRecord • Must be a string type [NAME] digits = 2 • Min digits = 1 • Valid characters A - Z | • For scheduled courses only, if the marking indicator on the corresponding Staff file is true, give an error if [NAME] is not part of related Academic Year and [NAME]. • If marking indicator is true and more than one mark is submitted then Marking Terms are required. • If marking indicator is false, do not allow marks to be submitted.
StudentCourse |  | 25 | 22 | Marking Term Number | The term number in which the mark is given. | [NAME] | 2 | 0-9 | C | • Used by StudentRecord Type:    - ScheduledStudentRecord • Must be a integer type • Min value = 1 | • For scheduled courses only, if the marking indicator on the corresponding Staff file is true, give an error if [NAME] Number is not part of  related Academic Year and [NAME]. •  If marking indicator is true and more than one mark is submitted then marking terms are required. • If marking indicator is false, do not allow marks to be submitted.
StudentCourse |  | B12 | 23 | File Folder Number | The file folder number of the educator who gave the student this mark. | [NAME] no dec | 6 | 0-9 | C | • Required for StudentRecord Types    - ScheduledStudentRecord    - ProjectStudentRecord    - IndStudyStudentRecord • Must be an long integer • Total digits must = 6 | • File will be rejected if the value is not a valid File Folder Number. • For Scheduled Student Records student fields B1, B2, B3, B4, [NAME], B6, [NAME], B8, B9, [NAME] must match. • Staff Course Record fields B1 B2 B3 B4 [NAME] B10 B11 must match. • There must be a matching Staff Course record for this FFN.
StudentCourse |  | 22 | 24 | Local Mark Earned | The local mark awarded | string | 10 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | C | • Required for StudentRecord Types:    - ScheduledStudentRecord    - ProjectStudentRecord    - IndStudyStudentRecord • Must be a string [NAME] length = 10 • Min length = 01 | • File will be rejected If the marking indicator on the Staff Course Record is true and the XML section StudentMarks is not included. • File will be rejected if the marking indicator on the Staff Course Record is false and the XML section StudentMarks is included. • The two rules above are related to the XML section StudentMarks. The field LocalMarkEarned is in this section.
StudentCourse |  | 23 | 25 | Local Credits Earned | The number of credits earned.  0.000 is no credit, 9999.999 is the [NAME] credit. | decimal | 7,3 | 0-9 | C | • Required for StudentRecord Types:   - ScheduledStudentRecord   - ProjectStudentRecord   - IndStudyStudentRecord • Must be a decimal type • Total Digits = 7 • FractionDigits = 3  e.g. 1234.567
StudentCourse | Not used in K-8 | 30 | 26 | College [NAME] | The mark awarded to the student at the completion of the college course. | string | 10 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | C | • Required for StudentRecord Type:   -DirectPayStudentRecord  • Must be a string [NAME] length = 10 • Min length = 01
StudentCourse | Not used in K-8 | 28 | 27 | College Code | The unique federal identifier of the college , lookup same as MCCC Add a college on user interface. | string | 6 | a-z, A-Z, 0-9 | C | • Required for StudentRecord Type:    -DirectPayStudentRecord  • Must be a string type [NAME] length = 6 • valid characters a-z, A-Z, 0-9 | Reject file if the value is not a valid federal college code.  URL for federal college codes:  http://www.ifap.ed.gov/ifap/fedSchoolCodeList.jsp
StudentCourse | Only used in K-8 with a Course Level "X" | 27 | 28 | College Credits Earned | The college credits earned in the course. | integer,3 decimals | 7,3 | 0-9 | C | • Optional for StudentRecord Type:   - ScheduledStudentRecords • Required for StudentRecord Type:   -DirectPayStudentRecord • Must be a decimal type [NAME] digits = 7 • Fraction digits = 3  e.g. 1234.567 | Reject the file if a value is given and the associated Local Course Code does not have a level of D or X.
StudentCourse | Not used in K-8 | 29 | 29 | College Course Code | The college course number or code | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | O | • Optional field used ONLY with:    -DirectPayStudentRecord   • Must be a string type • Min length = 1 • [NAME] length = 20
StudentCourse | Not used in K-8 | 26 | 30 | College Course Title | The title of the college course | string | 255 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | O | • Optional field used ONLY with:    -DirectPayStudentRecord • Must be a string type [NAME] length = 255 • Min length = 1 • Not required in XML validation