Spreadsheet: a5123540-0f84-4667-a31c-836977bc89b3
Sheet: Change Log

Date | Version | By | ID Num. | Change | Reason | Notes
2011-04-08 00:00:00 | v2.0 | Quint | All Extended Elements | Changed the format of the extended elements to a single extend edelement for each object with a complex structure below that element. See document "Utah SIF ExtendedElements" for a complete explanation | Improve the manner in which extendedelements are defined within an object
2011-04-08 00:00:00 | v2.0 | Quint | UT.034 | Added Note and References | Clarify the useage of Yes/No
2011-04-08 00:00:00 | v2.0 | Quint | UT.053 | Changed mapping from StudentParticipation/ProgramExitDate to StudentPersonal/SpecialEdExitDate | This is a single date related to the student and not a specific program
2011-04-08 00:00:00 | v2.0 | Quint | UT.061 | Changed description | Normalize description with the Clearinghouse Spec.
2011-04-08 00:00:00 | v2.0 | Quint | UT.069 | Changed mapping from an ExtendedElement to StudentParticipation/LeastRestrictiveEnvironment/OtherCodeList[@CodeSet='StateProvince'] | Improved mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.072 | Changed mapping from an ExtendedElement to StudentParticipation/LeastRestrictiveEnvironment/OtherCodeList[@CodeSet='StateProvince'] | Improved mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.077 | Fixed mapping for SchoolCourseInfo/Coursecode | Fixed error in mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.083 | Changed mapping from using TermInfo/EndDate and TermInfo/TermSpan to using TermInfoStartDay and TermInfo/RelativeDuration | Improved mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.089 | Added Note and References | Added translation information
2011-04-08 00:00:00 | v2.0 | Quint | UT.090 | Change mapping from SectionInfo/ExtendedElements/ExtendedElement[@Name='InstructSetting'] to SectionInfo/MediumOfInstruction/OtherCodeList[@CodeSet='StateProvince'] | Improved mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.091 | Change mapping from SectionInfo/ExtendedElements/ExtendedElement[@Name='StateTermCode'] to TermInfo/TermCode | Improved mapping. Use translations  to normalize LEA termcodes to state termcodes
2011-04-08 00:00:00 | v2.0 | Quint | UT.096 | Changed mapping from using StudentSectionMarks to StudentGrades/Letter/Grade | Improved mapping. StudentGrade is cleaner and requires less overhead
2011-04-08 00:00:00 | v2.0 | Quint | UT.099 | Changed mapping from using StudentSectionMarks to StudentGrade/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ ut:StudentGradeExtensions/ut:CreditsEarned | Improved mapping. StudentGrade is cleaner and requires less overhead
2011-04-08 00:00:00 | v2.0 | Quint | UT.101 | Changed mapping from an extended element to DisciplineIncident/RelatedToList/RelatedTo and added a Note: 3068=GangRelated | Improved mapping and added note
2011-04-08 00:00:00 | v2.0 | Quint | UT.105 | Changed mapping to include DisciplineIncident/VictimList/Victim/Injury | Improved mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.111 | Changed mapping from DisciplineIncident/IncidentActionList/IncidentAction/PoliceNotification to DisciplineIncident/OffenderList/Offender/ActionList/Action/PoliceNotification | Corrected mapping.
2011-04-08 00:00:00 | v2.0 | Quint | UT.112 | Changed mapping from DisciplineIncident/IncidentActionList/IncidentAction/CourtReferral to DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | Corrected mapping and added note
2011-04-08 00:00:00 | v2.0 | Quint | UT.114 | Changed mapping to include DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | Improved mapping and added note
2011-04-08 00:00:00 | v2.0 | Quint | UT.115 | Changed mapping from DisciplineIncident/IncidentActionList/IncidentAction/HearingOfficerRemoval to DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | Corrected mapping and added note
2011-04-08 00:00:00 | v2.0 | Quint | UT.135 | Added Note and References | This value is calculated in the manifest by totaling credits received from all marking periods for a specific course
2011-04-08 00:00:00 | v2.0 | Quint | UT.139 | Removed the word "Summary" from SchoolAttendanceHistory | Corrected mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.140 | Removed the word "Summary" from SchoolAttendanceHistory | Corrected mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.141 | Changed mapping from an extendedelement to SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/AddressList/Address/City | Corrected mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.142 | Changed mapping from an extendedelement to SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/AddressList/Address/State | Corrected mapping
2011-04-08 00:00:00 | v2.0 | Quint | UT.144 | Fixed mapping for StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/CourseCreditsEarned | Corrected mapping and added Note
2011-04-08 00:00:00 | v2.0 | Quint | UT.148 | Added Note and References | Specified which assessments are reported
2011-04-08 00:00:00 | v2.0 | Quint | UT.153 | Added Note and References | Specified which subtests are reported
2011-04-08 00:00:00 | v2.0 | Quint | UT.157 | Changed mapping from StudentPersonal/GraduationDate to StudentAcademicRecord/AcademicPerformanceSummary/GraduationDate | More flexibility in mapping this in StudentPersonal AND StudentAcademicRecord.
2011-04-08 00:00:00 | v2.0 | Quint | UT.158 | Changed element name from STUDENT START DATE TO STUDENT ENTRY DATE | Consistency
2011-04-08 00:00:00 | v2.0 | Quint | UT.162 | Removed element  "CREDITS REQUIRED" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.163 | Removed element "CREDIT BALANCE NEEDED" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.164 | Removed element "TOTAL GPA POINTS" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.167 | Added Note and References | Optional element. Manifest will calculate if not provided by SIS SIF Agent
2011-04-08 00:00:00 | v2.0 | Quint | UT.170 | Remove element "GRADE 9 CUMULATIVE CREDITS" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.173 | Remove element "GRADE 10 CUMULATIVE CREDITS" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.176 | Remove element "GRADE 11 CUMULATIVE CREDITS" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.179 | Remove element "GRADE 12 CUMULATIVE CREDITS" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.181 | Added element STUDENT ADDRESS LINE 2 | Optional element.
2011-04-08 00:00:00 | v2.0 | Quint | UT.192 | Changed UT.192, School of Record, to UT.201, School of Record | This ID Num was a duplicate of [NAME] on the  S1 record.
2011-04-08 00:00:00 | v2.0 | Quint | UT.200 | Removed element "SCHOOL FAX" | Not required or needed per meeting on 3/2/2011
2011-04-08 00:00:00 | v2.0 | Quint | UT.201 | Changed UT.192, School of Record, to UT.201, School of Record | This ID Num was a duplicate of [NAME] on the  S1 record.
2011-04-08 00:00:00 | v2.0 | Quint | UT.202 | Added element "STUDENT UN-WEIGHTED GPA" | Specify an un-weighted GPA for transcripts
2011-04-08 00:00:00 | v2.0 | Quint | UT.203 | Added element "STUDENT WEIGHTED GPA" | Specify an optional, weighted GPA for transcripts
2011-04-08 00:00:00 | v2.0 | Quint | UT.204 | Added element "STUDENT PARENT/GUARDIAN FIRST NAME" | No mapping existed. Optional element
2011-04-08 00:00:00 | v2.0 | Quint | UT.205 | Added element "STUDENT PARENT/GUARDIAN LAST NAME" | No mapping existed. Optional element
2011-04-08 00:00:00 | v2.0 | Quint | UT.206 | Added element "DIPLOMA TYPE" | No mapping existed. Optional element
2011-04-27 00:00:00 | v2.1 | Quint | UT.064 | Changed mapping from StudentParticipation/StudentParticipantionAsOfDate to StudentParticipation/ProgramPlacementDate | Improved mapping
2011-04-27 00:00:00 | v2.1 | Quint | UT.073 | Changed mapping from StudentParticipation/StudentParticipantionAsOfDate to StudentParticipation/ProgramPlacementDate | Improved mapping
2011-04-27 00:00:00 | v2.1 | Quint | UT.079 | Changed mapping from LEAInfo/StateProvinceId to SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='WhereTaughtDist'] | Corrected mapping. Added note
2011-04-27 00:00:00 | v2.1 | Quint | [NAME] | Changed mapping from SchoolInfo/StateProvinceId to SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='WhereTaughtSchll'] | Corrected mapping. Added note
2011-05-17 00:00:00 | V2.1 | Quint | UT.207 | Added SchoolInfo ExtendedElement for School Code (CEEB) | Differentiated between StateProvinceId and the CEEBACT code. Optional Element
2011-05-18 00:00:00 | V2.1 | Quint | n/a | Added Worksheet for SIF Objects List | Provide a summary of which SIF Objects are required for the collection, eTrans and SLF. Also contains required provisioning
2011-05-20 00:00:00 | V2.1 | Quint | UT.081 | Added Alternative Mapping SectionInfo/SIF_ExtendedElements/SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ ut:SectionInfoExtensions/ut:Teacher1ID | Provide an alternative mapping that does not require StaffPersonal Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.083 | Added Alternative Mapping SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ut:SchoolCourseInfoExtensions/ut:SemesterLength | Provide an alternative mapping that does not require TermInfo Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.086 | Added Alternative Mapping SectionInfo/SIF_ExtendedElements/SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ ut:SectionInfoExtensions/ut:Teacher2ID | Provide an alternative mapping that does not require StaffPersonal Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.087 | Added Alternative Mapping SectionInfo/SIF_ExtendedElements/SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ ut:SectionInfoExtensions/ut:Teacher3ID | Provide an alternative mapping that does not require StaffPersonal Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.091 | Added Alternative Mapping SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ut:SchoolCourseInfoExtensions/ut:TermCode | Provide an alternative mapping that does not require TermInfo Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.096 | Added Alternative Mapping StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ut:StudentSectionEnrollmentExtensions/ut:GradeEarned | Provide an alternative mapping that does not require StudentGrade Object
2011-05-20 00:00:00 | V2.1 | Quint | UT.099 | Added Alternative Mapping StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ut:StudentSectionEnrollmentExtensions/ut:CreditsEarned | Provide an alternative mapping that does not require StudentGrade Object
2011-07-06 00:00:00 | V2.2 | [NAME] | All Extended Elements | Removed namespace reference 'ut:' from extended element xpaths. | [NAME] not supported yet, format incorrect for when it becomes so.
2011-08-05 00:00:00 | V2.2 | [NAME] | UT.112,  UT.115 | Changed OtherCodeList/OtherCode  to Code.  Also added NCES code identifiers to [NAME] mappings. | Copy-paste error.  Element mapping uses standard NCES codes.
2011-09-14 00:00:00 | v2.3 | [NAME] | UT.079, [NAME] | Changed CourseMembership ('AM') WhereTaughtDist and WhereTaughtSchl mapping from SchoolCourseInfo to SectionInfo extended elements. | SectionInfo had been intended (see 4/27/2011 entries), SchoolCourseInfo entered inadvertantly. | Left SchoolCourseInfo as alternative mapping.  Manifest modifed to use either, SectionInfo has priority.
2011-09-14 00:00:00 | v2.3 | [NAME] | UT.119 - UT.130 | Changed DisciplineIncident secondary InvolvementType extended elements from all 'Secondary' to 'Secondary1', 'Secondary2', 'Secondary3', 'Secondary4'. | Facilate populating Incident Association ('I2') table in Manifest.
2011-09-14 00:00:00 | v2.3 | [NAME] | UT.097, UT.190, UT.191 | Made alternative mapping (using SIF_ExtendedElements) the primary one. | Former alternative mapping was preferred method. | Alternative mapping uses CalendarDate, also BellSchedule for UT.097.
2011-09-20 00:00:00 | v2.3 | [NAME] | Extended Elements | Corrected typo: changed 'Extenstions' to 'Extensions'. | Typo had been copied to several extended elements.
2011-09-20 00:00:00 | v2.3 | [NAME] | UT.188, UT.189 | Removed 'Actual' suffix from element names, added note that SIF value should be Equivalent Days, prorated for FTE. | SIS2000 and PowerSchool both return Equivalent Day value through agent.  'Actual' suffix misleading. | Data spec modified accordingly.
2011-09-20 00:00:00 | v2.3 | [NAME] | UT.190, UT.191 | Removed 'Actual' suffix from element names, added note that extended element value should be Equivalent Days, prorated for FTE. | SIS2000 and PowerSchool both return Equivalent Day value through agent.  'Actual' suffix misleading. | Data spec modified accordingly. Also added note about FTE prorating and equivalent day conversion if value is calculated from entry/exit dates.
2011-10-05 00:00:00 | v2.3 | [NAME] | UT.110 | Changed mapping to: If value is 3086 or 3101 then 'Y' otherwise 'N' (NECS 1054). Was: If value is 3087 or 3102 then 'N' otherwise 'Y'. | Prior mapping not consistent with SIS2000 flat-file output. | Previous mapping had 'Y' unless services explicitly excluded.  New mapping has 'N' unless services explicitly included.
2012-01-18 00:00:00 | v2.4 | [NAME] | UT.097, UT.190, UT.191 | Removed alternate mapping.  Agent must provide value in extended element (primary mapping). | Existing agents use extended element, any future agent should use existing flat-file algorithm. | Also removed CalendarDate and BellSchedule from SIF Objects List
2012-01-18 00:00:00 | v2.4 | [NAME] | UT.077 | Added alternative mappings where agent provides combined unique Id. | Alternative mappings already in use by SIS2000 and PowerSchool.
2012-01-20 00:00:00 | v2.4 | [NAME] | All | Sorted alphabetically by record type and record name. | Had become disorganized.
2012-01-20 00:00:00 | v2.4 | [NAME] | AC records | Added ExcludeFromStateReporting extended element on SchoolCourseInfo and SectionInfo. | [NAME] to determine excluded records, not a reported element. | Manifest also excludes associated AM records.
2012-02-15 00:00:00 | v2.4 | [NAME] | SC & S1 records | Added ExcludeFromStateReporting extended element on SchoolInfo, StudentPersonal, and StudentSchoolEnrollment. | [NAME] to determine excluded records, not a reported element. | Manifest also excludes associated records. SchoolInfo: SC, S1, AC, AM StudentPersonal: S1, S2, S3, AM StudentSchoolEnrollment:  AM
2012-02-17 00:00:00 | v2.4 | [NAME] | UT.146 | Removed element ([NAME]). | Update to match data spec and code, inadvertantly left in SIF profile. | Had been proposed but removed during USOE Trascript discussions Jan 2011.
2012-02-21 00:00:00 | v2.4 | [NAME] | SIF Objects List | Added section on VRF Environment Variable usage to SIF Objects tab and corresponding notes in Profile. | Previously not in document. | Added three new environment variables in manifest.
2012-02-28 00:00:00 | v2.4 | [NAME] | SIF Objects List | Added Vrf.Property.ProrateMembershipDays to VRF Environment Variable Notes and corresponding elements in Profile. | New environment variable, required for SIS2000. | Changed page orientation to landscape.