Spreadsheet: 05850fdc-d49e-45df-b5f3-cb0b5a839f57
Sheet: CHANGES

Date | [NAME] | Description of change | Reason for change | Change agent
2012-03-30 00:00:00 | All Import fields | SubjectArea changed from integer to a string to match the data model. |  | [NAME]
2012-04-30 00:00:00 | All Import fields | Row 44 & 45 Added validation for marking term types being required if the district wants to submit more than one mark.  Student file. | Clarification | [NAME]
2012-05-14 00:00:00 | Update TermType | Added summer to the list of valid choices. | Match production choices | [NAME]
2012-05-23 00:00:00 | General | The Marking Term Type and Number validation rules needed to be updated to indicate when they are required. | Some cases were not being caught. | [NAME]
2012-05-25 00:00:00 | All Import fields | Local Course Code definition needed updating in the Student File | The definition didn't match what was in the Staff file for the same field. | [NAME]
2012-05-31 00:00:00 | All Import fields | Changed wording in Marking Term Type and Number to say value must related to the correct Academic Year and [NAME] related to the submission. | previous version said [NAME]. | [NAME]
2012-06-04 00:00:00 | All Import fields | File Folder Number, Local Credits Earned, Local [NAME] - added a rule related to marking indicator = false | Missing rule implemented in release 4.1 | [NAME]
2012-06-08 00:00:00 | XML valid characters | Corrected the strings for special characters to add the ";" at the end of each string like & to make it &amp;. | Missing ; at end of special characters | [NAME]
2012-09-05 00:00:00 | All Import fields: L16 | Instruction Language field rule suspended until a future date.  RULE: " is classified as Bilingual and no language is provided" | Rule relaxed for first years. | [NAME]
2012-11-01 00:00:00 | All Import fields | Deleted all other data and left just the Staff data.  Add fields for Schema 2 version and added validation rule for k-8 on Instructional Method. | Easier for users to view. | [NAME]
2012-11-04 00:00:00 | Added tab for Sites processing | Added rules about Sites tag and DistrictWide tag. | Sites processing was complex and easier to read in it's own worksheet. | [NAME]
2012-11-19 00:00:00 | SitesProcessing | Clarified when Student data is removed that it will need to be reloaded.  Cells E6 and E8 | Clarification | [NAME]
2012-12-05 00:00:00 | [NAME] cell [NAME] | Fixed definition by deleting reference to submitting a Period Number 99 for FixedPeriodIndicator = false. | Correction | [NAME]
2013-01-04 00:00:00 | All Import fields | L11, SiteNumber, Site must be found in header of sites are specified and not DistrictWide type file. | Review of Programmed rules. | [NAME]
2013-01-04 00:00:00 | All Import fields | L12, AcademicYearNumber, field must be valid for district and year. | Review of Programmed rules. | [NAME]
2013-01-04 00:00:00 | All Import fields | [NAME], Term Type, must be a valid item in the term type list. | Review of Programmed rules. | [NAME]
2013-01-04 00:00:00 | All Import fields | L15, TermNumber, added it must be valid for district and reporting year to the list of dependence. | Review of Programmed rules. | [NAME]
2013-01-09 00:00:00 | All Import fields | Formatting changes to standardize colors. | Review of Programmed rules. | [NAME]
2013-04-30 00:00:00 | All Import fields | Added a rule to reject the file if the Local Course Code or Section Code have a trailing spaces. | To fix an issue with matching when spaces are present. | [NAME]