Spreadsheet: 05850fdc-d49e-45df-b5f3-cb0b5a839f57
Sheet: All Import fields

FileName | Id | XSD/ [NAME] | FieldName | Description | DataType | Length | Permitted Value | Required | XML Validation | Business Engine Validation
StaffCourse | 0 | 0 | Note: XML_Version | The current version of the Staff XML format is Version 2.0 last updated on 10/23/2012. |  |  |  |  | none
StaffCourse | 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 | None
StaffCourse | B2 | 2 | Unit Number | MDE 4-digit district number | [NAME] | 4 | 0-9 | Y | • Must be an integer • Valid range is 0001-9999 • Total digits = 4 | File will be rejected if unit number is not valid and active in MDE OrgUnit for reporting year. B2, B1
StaffCourse | B3 | 3 | Unit Type | MDE 2-digit district type. | [NAME] | 2 | 0-9 | Y | • Must be an integer • Valid range is 01-99 • Total digits = 2 | File will be rejected if the Unit Type is not valid in MDE OrgUnit for reporting year for the Unit Number.  B1, B2, B3
StaffCourse | B1 | 4 | Year | The reporting year. For the 2010-2011 reporting year, the value would be 2011. | [NAME] | 4 | 0-9 | Y | • Min value 2011 | File will be rejected if the year isn't an open reporting year. B1
StaffCourse | 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
StaffCourse | 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.
StaffCourse | 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
StaffCourse | 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
StaffCourse | B4 | 9 | Site Number | Identifies where the course is being taught; a specific 3-digit MDE OrgUnit school code. | [NAME] | 3 | 0-9 | Y | • Must be an integer • Total digits = 3 • Max value=999 • Min value=001 | • 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 •  File will be rejected if Site is not found in the Sites List in the header.
StaffCourse | B7 | 10 | Academic Year Number | MDE generated academic year ID number.  Found  on the MDE Calendar Export report. | [NAME] | N/A | 0-9 | Y | • Must be an integer • Min value = 1 | •  File will be rejected if matching Academic Year, [NAME], Term Type and Term Number sequence is not found in  Calendar Information  for district and reporting year. •  File will be rejected if the Academic Year Number is not valid for the district and in the Reporting Year. B1, B2, B3, B7
StaffCourse | B8 | 11 | Calendar Number | MDE generated calendar ID number.  Found on the MDE Calendar Export report. | [NAME] | N/A | 0-9 | Y | • Must be an integer • Min value = 1 | File will be rejected if matching Academic Year, [NAME], Term Type and Term Number sequence is not found in  Calendar Information  for district and reporting year. B1, B2, B3, [NAME], B8
StaffCourse | B9 | 12 | 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 | 2 | "Y," "S," "T," "Q," "QM," "H,"  "OT," "SU"  See MCCC Field Definition Reference Document for valid Term Type and term codes. | Y | • Must be string • Min length = 1 • [NAME] length = 2 • Valid chars A-Z | • File will be rejected if matching Academic Year, [NAME], Term Type and Term Number sequence is not found in  Calendar Information  for district and reporting year. • File will be rejected if the Term Type is not a valid a Term Type. B1, B2, B3, [NAME], B8, B9
StaffCourse | B10 | 13 | Term Number | Number identifying the term in which this course section occurs. Found on  the MDE Calendar Export report. | [NAME] | N/A | 0-9 | Y | • Must be an integer • Min value = 1 | File will be rejected if matching Academic Year, [NAME], Term Type and Term Number sequence is not found in Calendar Information  for district and reporting year. B1, B2, B3, [NAME], B8, B9, B10
StaffCourse | B5 | 14 | Local Course Code | This is the alpha/numeric identifier used by the district or school to uniquely identify each course in the Local Course Index. | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | Y | [NAME] type field [NAME] length is 20 | • File will be rejected if this code and Staff Course file site code do not match in the Local Course Index for the district and reporting year. B1, B2, B3, B4 or 000,  B5 • File will be rejected if a space is used in the first or last positions in the LocalCourseCode (causes matching errors).
StaffCourse | B6 | 15 | 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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > &  See MCCC Field Definition Reference Document for valid formatting of special characters. | Y | [NAME] type [NAME] length=20 • Min length=1 | • File will be rejected if this field is null, all spaces, or if the value is not permitted or contains a leading space.  Uniqueness check for section code. B1, B2, B3, B4, [NAME], B7, B8, B9, B10, B6 • File will be rejected if a space is used in the first or last positions in the SectionCode (causes matching errors).
StaffCourse | 12 | 16 | Period Number | The period number defines period(s) during which the course is held. The number is found in district's  Calendar Information.  If a course is held for more than one period, then submit more than one XML value for that Course, else submit just one. | [NAME] | N/A | 0-9 | Y | • Min occurance = 1 • Must be an integer [NAME] occurance =  unbounded • Min value = 0  If periods are included then list must have 1 value. | • File will be rejected if matching Academic Year, [NAME], Term Type and Term Number sequence is not found in Calendar Information  for district and reporting year. • File will be rejected If  value is not in the range of valid periods for the related term/term type. • File will be rejected If FixedPeriodIndicator = False and any Period Numbers are submitted. • File will be rejected If FixedPeriodIndicator = True and no Period Numbers are submitted. B1, B2, B3, [NAME], B8, B9, B10, 12 -- matching check B1, B2, B3, B4, [NAME], B7, B8, B9, B10, [NAME], 12 -- uniqueness check 17 = False, 12 = empty list 17=true, 12 must have one valid period
StaffCourse | 13 | 17 | Marking Indicator | Does the student receive a mark for this course section record. | boolean | N/A | true, false | Y | true, false
StaffCourse | 14 | 18 | Instruction Method Type | • Identifies the different instruction delivery types.  • This element is grade level specific. | string | 4 | Instructional Methods  See MCCC Field Definition Reference Document for valid Instruction [NAME] and codes by grade levels. | Y | [NAME] type • Min length = 1 • Valid characters = 0-9 a-z A-Z | File will be rejected if value is not a valid choice for the grade levels K-8 and 9-12 as determined by the MCCC classification.
StaffCourse | 15 | 19 | Instruction Language Type | • For language immersion courses, this is the non-English language in which the course section is taught. • For courses indexed to MCCC bilingual classifications, this is the non-English language in which the course section is  taught. | [NAME] | 3 | 0-9 | C | • Integer type • Min value = 001 • [NAME] value = 999 • Total digits= 3 • Min occurs = 0 (XML doesn't require) | • File will be rejected if the course:     - Is classified as Bilingual and no language is provided or ([NAME])     - Is not a valid MARSS language code       - Is English
StaffCourse | 16 | 20 | Instruction Minutes per Term | The number of minutes of scheduled student instruction provided in this course section. | [NAME] | N/A | 0-9 | Y | • Must be an integer  • Min value 1
StaffCourse | 17 | 21 | Fixed Period indicator | Does this course section meet in a fixed time slot? | boolean | 5 | true, false | Y | true, false
StaffCourse | B11 | 22 | File Folder Number | The folder number of the educator(s) teaching the course section. | [NAME] | 6 | 0-9 | Y | • Must be an integer • Total digits = 6 | File will be rejected if the FFN(s) is not a valid MDE file folder number. B1 B2 B3 B4 [NAME] B10 B11 uniqueness check
StaffCourse | 19 | 23 | Teacher of Record Indicator | Indicates whether the educator listed in this record is responsible for awarding a mark and credit for the section. | boolean | 5 | true, false | Y | true, false | If Marking Indicator is true, then there must be at least one Teacher of Record = true for the course section. 13, 19