Spreadsheet: 23dce0d7-7820-4aae-8818-8ee00ea09b7f
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.
2012-05-15 00:00:00 | v2.4 | [NAME] | UT.022 | Added new mapping for S1 Grade Level. | Multiple enrollments at same school may have different grade levels. | Manifest uses old mapping where new one not implemented.
2012-05-31 00:00:00 | v2.4 | [NAME] | UT.024, UT.094 | Added new extended element mapping for ExitDate and CourseExitDate. | Extended element ReportedExitDate is day after final day. | Manifest uses old mapping where new one not implemented.  Some agents may publish day after final day as ExitDate, though not  SIF spec.
2012-05-31 00:00:00 | v2.4 | [NAME] | UT.041, UT.042 | Added new other code mapping for ELL Parent and Native Language. | Other code should always match UT codes. | Manifest uses old mapping where new one not implemented.
2012-07-13 00:00:00 | v2.4 | [NAME] | UT.003 on S2 & S2 | Added preferred SchoolNumber link, StudentParticipation / ManagingSchool. | Provides positive link where student had enrollments at multiple schools. | Not available in VRF versions prior to July 2012.
2012-07-13 00:00:00 | v2.4 | [NAME] | UT.096 | Added required Grade fields (Letter, Percentage, Numeric) and note on StudentGrade/Grade | All three fields required for calculating reported value. | No change for alternative extended element.
2012-07-13 00:00:00 | v2.4 | [NAME] | UT.034 | Added new preferred extended element mapping. | Old mapping provides only 'Y' or blank - no provision for 'F' or 'R'. | Old mapping still supported.
2012-09-06 00:00:00 | v2.5 | Clint | UT.208 | Added Read Grade Level Fall extended element | New column required for DIBELS
2012-09-06 00:00:00 | v2.5 | Clint | UT.209 | Added Read Grade Level Spring extended element | New column required for DIBELS
2012-09-17 00:00:00 | v2.5 | Clint | UT.211 | Added Early Graduate extended element | New flag required for SEOP
2012-09-20 00:00:00 | v2.5 | Clint | UT.131 | Removed UptdatedStatus extended element | Abandoned due to new S1 method of status updates
2012-09-20 00:00:00 | v2.5 | Clint | UT.211 | Added CausedSeriousBodilyInjury extended element | New flag required for IDEA
2012-11-11 00:00:00 | V2.6 | Quint | UT.188 | Added Alternative Mapping StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions]/StudentSchoolEnrollmentExtensions/DaysAttended | Gives an alternative to publishing the StudentAttendanceSummary object for the SIS Agents. | Requires the Property Vrf.Target.usesStudentAttendanceSummary.  Default will be 'true'. [NAME] will be 'false'
2012-11-11 00:00:00 | V2.6 | Quint | UT.189 | Added Alternative Mapping StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions]/StudentSchoolEnrollmentExtensions/DaysInMembership | Gives an alternative to publishing the StudentAttendanceSummary object for the SIS Agents. | Requires the Property Vrf.Target.usesStudentAttendanceSummary.  Default will be 'true'. [NAME] will be 'false'
2012-11-11 00:00:00 | V2.6 | Quint | SIF Objects List | Added Vrf.Target.usesStudentAttendanceSummary to VRF Environment Variables | To allow SIS agents to either publish StudentAttendanceSummary or ExtendedElements on StudentSchoolEnrollment for DaysAttended and DaysInMembership | Default='true'  - Skyward will use 'false'