Spreadsheet: d4088125-d319-4877-b2b3-39f25654f48d
Sheet: All Fields

FileName | K-8 updates | Id | XSD/UI Order | FieldName | Desc | DataType | Length | PermittedValue | 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 | 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
StaffCourse |  | B2 | 2 | UnitNumber | 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 | UnitType | 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 the current 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 | 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
StaffCourse |  | 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
StaffCourse |  | B4 | 9 | SiteNumber | 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 found in the header.
StaffCourse |  | B7 | 10 | Academic Year Number | MDE generated academic year ID number, comes from the MDE Calendar Export. | [NAME] | N/A | 0-9 | Y | - Must be an integer - min value = 1 | File will be rejected if matching academic year, calendar, term type and term number sequence is not found in district calendar information entries. 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, comes from the MDE Calendar Export. | [NAME] | N/A | 0-9 | Y | - Must be an integer - min value = 1 | File will be rejected if matching academic year, calendar, term type and term number sequence is not found in district calendar information entries 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), Comes from the MDE Calendar Export. | string | 2 | "Y","S","T","Q","QM","H", "OT", "SU" | Y | - Must be string - Min length = 1 - Max length = 2 - Valid chars A-Z | File will be rejected if matching academic year, calendar, term type and term number sequence is not found in district calendar information entries File will be rejected if the term type is not a valid a term type in term type tab. B1, B2, B3, [NAME], B8, B9
StaffCourse |  | B10 | 13 | Term Number | Number identifying the term in which this course section occurs. Comes from the MDE Calendar Export. | [NAME] | N/A | 0-9 | Y | - Must be an integer - min value = 1 | File will be rejected if matching academic year, calendar, term type and term number sequence is not found in district calendar information entries 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 curriculum. | string | 20 | a-z, A-Z, 0-9, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | Y | - String type field - [NAME] length is 20 - Valid values in tab: XML valid characters | File will be rejected if this code and StaffCourse file site code do not match in the local course index for the district and reporting year.  B1, B2, B3, B4 or 000,  B5
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, ` ~ ! @ # $ % ^  * ( ) - _ = + [ { ] } \ | ; : ' " , . /  ? < > & | Y | - string type - maxlength=20 - minlength=1 - Valid values in tab: XML valid characters | 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
StaffCourse |  | 12 | 16 | Period Number | The period number defines period(s) during which the course is held, the code comes from the 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 • max occurance =  unbounded • Min value = 0  If periods are included then list must have 1 value | • File will be rejected if matching academic year, calendar, term type and term number sequence is not found in district calendar information entries • 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 | Grade level specific | 14 | 18 | Instruction Method Type | Identifies the different instruction delivery types. | string | 4 | Instructional Methods | Y | - String 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 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 being taught.  For courses indexed to MCCC bilingual classifications, this is the non-English language in which the course section is being taught. | [NAME] | 3 | 0-9 | C | - Integer type - min value = 001 - max 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 or   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 teaching the course section. | [NAME] | 6 | 0-9 | Y | -Must be an integer -Total digits = 6 | File will be rejected if the FFN 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 lease one Teacher of Record = true for the course section.  13, 19