Spreadsheet: 20ad4b35-0e39-45c8-a18d-252afe785683
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-12-03 00:00:00 | All Import fields: | Reviewed College fields and updated the ones that changed due to PSEO changes. | Some fields were changed to optional | [NAME]
2013-01-03 00:00:00 | All Import fields: | L27, SubjectArea, business rule change to clarify the use of subject area to match the programatic rules. | Satchits email of the rules implemented were not described as clear as needed. | [NAME]
2013-01-03 00:00:00 | All Import fields: | [NAME], StateCourseCode, business rule was modified on 11/01 to only check that the state classification is valid.  Removed statement about Project Based record requiring the field.  XSD requires it so it is not a business rule. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | L30, FileFolderNumber, required field business rules is an XML validation so not needed as a business rule. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | L34, CollegeCode, the required field business rule is an XML validation so it is not needed in the business rule. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | K35, CollegeCreditsEarned, reversed optional and required words in lines 1 & 3.  They were reversed. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | L35, CollegeCreditsEarned, removed redundant statements with XML rules and made the business rule match the programatic rules. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | L12, SiteNumber, added a rule to check the if the site number is found in the SiteNumber List in the header for schema 2. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | [NAME], StateCourseCode, rule added for MCCC-530 to validate that a PBL studentrecord has the flag set for ProjectBasedLearning. | Review of programmed rules. | [NAME]
2013-01-03 00:00:00 | All Import fields: | L18, LocalCourseCode, Ind Study type records must tie back to a State Classifications that has the Ind Study flag set to true. | Review of programmed rules. | [NAME]
2013-01-09 00:00:00 | All Import fields: | [NAME], LocalMarkEarned, a statement was added to explain the two rules are related to the XM section the rules apply. | Review of programmed rules. | [NAME]
2013-01-09 00:00:00 | All Import fields: | Cleaned up the K-8 field data. | Cleanup of spreadsheet for release. | [NAME]