Spreadsheet: 20ad4b35-0e39-45c8-a18d-252afe785683
Sheet: All Import fields

FileName | K-8 updates | Id | XSD/UI Order | FieldName | Desc | DataType | Length | PermittedValue | 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 | none
StudentCourse |  | H1 | 1 | SchemaVersion | Identifies the version of the XML definition file used to create the XML file. | [NAME] | 1 | 0-9 | Y | -min value = 2 -max value = 2 | None
StudentCourse |  | B2 | 2 | Unit Number | The district identifying number (MDE OrgUnit Number) | [NAME] | 4 | 0-9 | Y | • must be an integer • min value = 0001 • max 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 • max 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 current collection year
StudentCourse |  | H2 | 5 | DistrictWide | 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 | SiteNumber | 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 | VendorName | The name of the vendor or technical person who created the XML data file. | string | 60 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | N | - String type field - [NAME] length is 20 - Valid values in tab: XML valid characters
StudentCourse | new rule | 5 | 9 | Record Type | Indicates the type of student coursework record type: | string | 22 | [NAME] | Y | • Section 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 # of these sections | •  DirectPayStudentRecord can't be a K-8 Classification
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 | StateCourseCode | MCCC number, required only for Project based learning. | [NAME] | 5 | 0-9 | C | • Required for ProjectStudentRecord • Must be an integer • Total digits = 5 | File will be rejected if MCCC value is not valid. For ProjectBasedStudentRecords if the StateCourseCode does not have the ProjectBasedLearning set to true reject the file.
StudentCourse |  | B7 | 12 | Academic Year Number | MDE generated academic year ID number, comes from the MDE Calendar Export. | [NAME] | 3 | 0-9 | C | • Required for RecordType: ScheduledStudentRecords only • Must be an integer • Min value allowed = 1 | File will be rejected if calendar number does not exist in academic year, calendar, term type and term number sequence   B1, B2, B3, B7
StudentCourse |  | B8 | 13 | CalendarNumber | MDE generated calendar ID number, comes from the MDE Calendar Export. | [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, calendar, term type and term number sequence for the reporting year.   B1, B2, B3, [NAME], B8
StudentCourse |  | B9 | 14 | TermType | The type of term a district or site uses to schedule courses. ( year long, quarter, semester, trimester, hexmester, other), Comes from the MDE Calendar Export. | string | 20 | "Y","S","T","Q","QM","H", "OT", "SU" | C | • Required for RecordType: ScheduledStudentRecords only • min length = 1 • [NAME] length = 2 • allowed characters A - Z | File will be rejected if the value does not exist in the academic year, calendar, term type and term number sequence for the reporting year.   B1, B2, B3, [NAME], B8, B9
StudentCourse |  | B10 | 15 | TermNumber | 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 the value does not exist in the academic year, calendar, 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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | C | • Required for: ScheduleStudentRecords, IndStudyStudentRecords • Must be a string type • min length = 1 • [NAME] length = 20 • valid characters  see XML valid characters tab. | File will be rejected if this code and StudentCourse file site code do not match in the local course index for the reporting year.  For Ind.StudyStudentRecords if the LocalCourseCode does not Associate with a MCCC# that has the Ind. Study flag set to true reject the file.  B1, B2, B3, B4 or 000,  B5
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 time. | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | C | • Required for: ScheduleStudentRecords • Must be a string type • min length = 1 • [NAME] length = 20 • valid characters  see XML valid characters tab. | File will be rejected if this section code does not match a section code submitted in the StaffCourse records for the collection year.  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 (’). | Y | • Must be a string • Min length = 1 • [NAME] length is 40. • see XML valid characters tab | 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 (’). | Y | • Must be string • Min length = 1 • [NAME] length = 40 • see XML valid characters tab | 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 (’). | N | • Must be a string • Min length = 1 • [NAME] length is 40. • Min occurs = 0 (XML doesn't require) • see XML valid characters tab | 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 [NAME] | 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 | SubjectArea | Identifies the subject area for the mark given. (View Subject Area tab for valid codes.) | string | 2 | 0-9 | 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# that is a Multiple Subjects classification. -If only one mark is submitted then the subject area has to be empty. -If multiple marks are submitted for the same term data then subjectarea 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
StudentCourse |  | 24 | 21 | [NAME] Type | The term type in which the mark is given. | string | 2 | "Y","S","T","Q","QM","H", "OT", "SU" | C | • Used by [NAME] - 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 CourseSectionInfo record is true, give an error if [NAME] is not part of  related Academic Year and [NAME]  If marking indicator is true and multiple marks are 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 [NAME] - ScheduledStudentRecord  • Must be a integer type • Min value = 1 | For scheduled courses only, if the marking indicator on the CourseSectionInfo record is true, give an error if [NAME] Number is not part of  related Academic Year and [NAME]  If marking indicator is true and multiple marks are 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 Field, B1, B2, B3, B4, [NAME], B6, [NAME], B8, B9, [NAME] need to match  StaffCourse record B1 B2 B3 B4 [NAME] B10 B11 must match  There must be a matching Course Section staff  record for this ffn.
StudentCourse |  | 22 | 24 | LocalMarkEarned | The local mark awarded | string | 10 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | C | • Required for StudentRecord Types - ScheduledStudentRecord - ProjectStudentRecord - IndStudyStudentRecord • Must be a string [NAME] length = 10 • Min length = 01 • Valid characters = permitted values match [NAME] allowed characters, but view XML valid characters tab for special rules. | 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 is false and the XML StudentMarks section 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 • TotalDigits = 7 • FractionDigits = 3  e.g. 1234.567
StudentCourse | Not used in K-8 | 30 | 26 | CollegeMarkEarned | The mark awarded to the student at the completion of the college course. | string | 10 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | C | • Required for StudentRecord Types - DirectPayStudentRecord • Must be a string [NAME] length = 10 • Min length = 01 • Valid characters = permitted values match [NAME] allowed characters, but view XML valid characters tab for special rules.
StudentCourse | Not used in K-8 | 28 | 27 | College code | The unique federal identifier of the college , lookup same as MCCC Add a college | string | 6 | a-z, A-Z, 0-9 | C | • Required for StudentRecord Types - 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 college code.
StudentCourse | Not used in K-8 | 27 | 28 | College credits earned | The college credits earned in the course. | integer,3 decimals | 7,3 | 0-9 | C | • Optional for StudentRecord Types - 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 localCourseCode 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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | O | • Optional field Only used with    [NAME] - DirectPayStudentRecord  • Must be a string type • Min length = 1 • [NAME] length = 20 • Valid characters in PermittedValue column, view XML valid characters tab for more rules.
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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | O | • Optional field Only used with - DirectPayStudentRecord  • Must be a string type [NAME] length = 255 • Min length = 1 • Not required in XML validation • Valid characters in PermittedValue column, view XML valid characters tab for more rules.