Spreadsheet: 0c1ddd73-5372-432f-807e-407c0fdc8cc6
Sheet: Sheet1

Date | Version | By | Change | Reason | Notes
2010-12-21 00:00:00 | v 0 | USOE | Initial approved version in USOE meeting on December 21, 2010 |  | Discussed that 'Null' should be changed to 'blank' and that 'blank' should be removed from lists of valid values ('Optional' implies blank).
2011-01-06 00:00:00 | v 0 | [NAME] | Added Course Record Id to both AC and AM records - internally generated link | Course-Section-Period not adequate for linking AM to AC records when AC records require Where Taught fields | Discussed with [NAME]; no additional data supplied by districts
2011-01-06 00:00:00 | v 0 | [NAME] | Reinstated Expected Graduation Date in ST record, to be populated from SIS where available | Better to use SIS value than to calculate | Recommendation from Quint; ODS or Manifest could calculate if not available in SIS.  Additional data requested by SIF, should normally be available.
2011-01-12 00:00:00 | v 0 | [NAME] | Added School Membership Code to S1 record, used for cases where School Membership is initially non-numeric and is reset to 0 ('PVT' or 'HSC') | Once School Membership is set to 0, need original char value for validations. | Not needed in ODS; no additional data supplied by districts
2011-01-12 00:00:00 | v 0 | [NAME] | Added several fields to ST record: [NAME], School Name, School Address, School City, School State, School ZIP, School Phone, School Fax, Accredited By | USOE decided not to pull School data from CACTUS, info is available in SIF data (except Accredited By).  [NAME] sent by [NAME]. | How to populate Accredited By under discussion
2011-01-14 00:00:00 | v 0 | [NAME] | Removed CIP Code from TC record | Not required in Attachment G, no field in SIF Student Academic Record, not clear how SIS would provide data for historic courses. | Discussed with Quint, notified [NAME], who agreed on 1/18/2011.
2011-01-14 00:00:00 | v 0 | [NAME] | Reinstated Grade Level in TC record | Needed for validations, generally available from SIS | Discussed with Quint, notified [NAME], who agreed on 1/18/2011.
2011-01-14 00:00:00 | v 0 | [NAME] | Changed TC 'School' field names that relate to course taken to 'Course School…' | Clear up confusion between submitting school and school at which course was taken. | Discussed with Quint
2011-01-18 00:00:00 | v 0 | [NAME] | Added Change Log tab | Maintain list of changes since approval with related reasons. | Requested by Shadd
2011-01-21 00:00:00 | v 1.0 | [NAME] | Removed 'Blank' from lists of valid options Changed version to 1.0 | Blank' indicates no entry, not an actual option.  'Blank' is implied by 'Optional'. | Removing 'Blank' requested by USOE.
2011-01-22 00:00:00 | v 1.0 | [NAME] | Changed 'Null' to 'Blank' | Flat-file doesn't supply Null, only Blank | Requested by USOE.
2011-01-24 00:00:00 | v 1.0 | [NAME] | Deleted unused columns (all tabs), changed formatting for release & printing (Change Log through Student tabs) | Prepare for release to USOE, SIS vendors | Questions and Discussion columns on record tabs hidden for printing.
2011-01-25 00:00:00 | v 1.0 | [NAME] | Removed Test Type from TA record | Not in SIF spec | Test Name adequate for transcript display
2011-01-25 00:00:00 | v 1.0 | [NAME] | Reinstated High School Exit Date as optional element in ST record | Not clear how to calculate but want to accept if available from SIS | No ODS-calculated elements remain
2011-01-25 00:00:00 | v 1.0 | [NAME] | Added Element ID column, completed formatting for release | Link Data Spec to SIF Mapping doc | Relevant content from Questions and Discussion columns moved to Notes
2011-01-26 00:00:00 | v 1.0 | [NAME] | Changed TS 'High School Entry Date' & 'High School Exit Date' fields to 'Student Entry Date' and 'Student Exit Date' | Match field name definitions in attachment G | Suggested by Quint
2011-01-28 00:00:00 | v 1.01 | [NAME] | Added tab for internally-generated Student List ('[NAME]') record extracted from 'S1' records.  [NAME] version number to 1.01. | Internal record not submitted by LEAs & not used by ODS, but documented for reference by development | Record previously defined, [NAME] requested documentation in data spec
2011-01-31 00:00:00 | v 1.01 | [NAME] | Added 'Test' prefix to TA field names: Test Date, Test Form, Test Level, Test Score | Disambiguate/clarify field names | Requested by [NAME]
2011-02-01 00:00:00 | v 1.01 | [NAME] | Added new fields to Lookup Values, added note to [NAME]. | Document REF Options table population | Requested by [NAME]
2011-02-17 00:00:00 | v 1.01 | [NAME] | Changed ID on Counselor Phone in Student Transcript from 192 (redundant) to 201. | UT.192 already in use as School of Record | Noted by [NAME], ID modified by Quint.
2011-02-21 00:00:00 | v 1.01 | [NAME] | Added note 'Output as string' to fields that should are listed as numeric but serve as identifiers with possible leading zero. | Need to indicate which numeric data requires string column type to preserve leading zero. | Requested by [NAME]
2011-02-21 00:00:00 | v 1.01 | [NAME] | Added 'Blank OK' to CourseRecordId on Course Master (AC) and Course Membership (AM) records. | CourseRecordId is generated for SIF only.  Not available for flat-file. | Requested by [NAME]
2011-02-25 00:00:00 | v 1.01 | [NAME] | Added remaining value sets needed for validations to 'Lookup Values' tab. | Several value sets had not been included in the list. | Noted and updated by [NAME]
2011-02-28 00:00:00 | v 1.01 | [NAME] | Corrected print header on School record from 'District' to 'School'. | Header was incorrect. | Noted by Quint
2011-03-07 00:00:00 | v 1.01 | [NAME] | Changed line 739 in Lookup Values from 'AmerIndianAlaskan' to 'HawaiianPacificIsl' | Correcting copy-paste error | Noted by [NAME]
2011-03-23 00:00:00 | v 1.01 | [NAME] | [NAME] in later Lookup Values records, added Descriptions, marked some for deletion | Oversight at time of data entered | Noted while checking insert statements
2011-03-28 00:00:00 | v 1.01 | [NAME] | Added Migrant LEAs, changed [NAME] column to use REF_VALID_VALUES. | Table name was changed from REF_UTREX_VALID_OPTIONS to REF_VALID_VALUES. | Also changed Update_Ver_Number value from 1 to default
2011-03-31 00:00:00 | v 1.01 | [NAME] | Added proposed changes for eTrans since January, with highlights for deletions (rose), questions (yellow), and changes (lt blue). | For review prior to implementing changes and issuing as v 2.0 | Changes from eTrans spreadsheets supplied by Quint
2011-04-01 00:00:00 | v 1.01 | [NAME] | Added ReqELLNativeLanguage and ReqELLParentLanguage values to Lookup Values, added ENG to ELLParentLanguage codes. | Additons & correction for validating ELLNativeLanguage and ELLParentLanguage. | ENG is invalid for ELLNativeLanguage, but is OK for ELLParentLanguage
2011-04-04 00:00:00 | v 1.01 | [NAME] | Added ReqELLInstructionType and SuppServ_LEA to Lookup Values. | Additions for validating ELLInstructionType and NCLBSuppServ Math & Language. | Using custom query with REF table
2011-04-08 00:00:00 | v 1.01 | [NAME] | Removed leading space from four Exit Status codes on Valid Values tab. | Leading space inadvertantly included. | [NAME] sent out update script for REF_VALID_VALUES.
2011-04-13 00:00:00 | v 1.01 | [NAME] | [NAME] tab: Removed unused S2 Environment values, added option 'P' and values for PK use. | Table used old value set. | Sent update script to [NAME].
2011-04-18 00:00:00 | v 1.01 | [NAME] | Updated modify/delete indications on Transcript elements. | Discussion with Bart & Turab.
2011-04-26 00:00:00 | v 2.0 | [NAME] | Update version to 2.0.  Deleted rows marked for deletion, removed most shading (kept yellow for questions). | Next release version to accompany [NAME] 2.0. | Footer date on each tab indicates date of most recent change.
2011-05-09 00:00:00 | v 2.0 | [NAME] | Changed Course Record Id on AC and AM records from numeric(12.0) to alpha(30). | Changed from internal unique id to combined string of identifying fields. | Where Taught School & District not included because not part of AM record.
2011-05-17 00:00:00 | v 2.1 | Quint | Added PESC Mapping worksheet to document | Introduce the PESC mapping for eTranscript into this single source of ODS related data.
2011-07-13 00:00:00 | v 2.1 | [NAME] | Changed IncidentID on Incident tables from 5 chars to 10. | USOE request. | Modified manifest files and staging script.  No change in validations.
2011-07-14 00:00:00 | v 2.1 | [NAME] | Added 'Output as string' to Student Phone Number spec. | Synchronize with staging table column, which is varchar(10).
2011-07-18 00:00:00 | v 2.2 | [NAME] | Changed Student Record 'Home Status' element display name back to '[NAME]', added option value of '6' | Specified in Clearinghouse doc, confirmed by USOE. | Normally Accompanied Student = 'Y' should be used with other Homeless code rather than '6'.
2011-07-18 00:00:00 | v 2.2 | [NAME] | Modified description of S1 record to indicate only one S1 allowed per student per school, rather than one for each enrollment period. | Specified in Clearinghouse doc, confirmed by USOE. | Also modified validations accordingly.
2011-07-18 00:00:00 | v 2.2 | [NAME] | Modified AC.Teacher1 ID, indicated LEA Number removal from Exit Status. | Specified in Clearinghouse doc, confirmed by USOE. | Left LEA Number in database schema in case reinstated.
2011-07-20 00:00:00 | v 2.2 | [NAME] | Added LEA Number back to Exit Status. | [NAME] reinstated after USOE review. | Had removed July 18 at USOE request.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Removed Option '6' from [NAME] values. | Requested by USOE after reviewing element. | Had added element July 18 at USOE request.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Added comment on S1 record reinstating multiple S1 records per school for a student. | Requested by USOE after reviewing S1 issue. | Had changed to single [NAME] at USOE request.
2011-08-03 00:00:00 | v 2.2 | [NAME] | Added comment on S1 record that USOE will not require multiple S1 records until Dec 2011. | Allow districts & vendors time to change extraction routines.
2011-09-20 00:00:00 | v 2.3 | [NAME] | Moved element numbers UT.188, UT.189 on S1, UT.190 on S2, and UT.191 on S3 from Actual day elements to Equivalent day elements.  Marked Actual day elements 'no longer used'. | SIF agent publishes equivalent FTE-prorated days, no 'Actual day' version of the data to preview. | SIF spec updated accordingly.  In cases where membership calculated from entry/exit dates, value should be converted to equivalent prorated days before writing to field.
2011-09-22 00:00:00 | v 2.3 | [NAME] | Changed 'Where Taught District' on AC from numeric to alpha. | Forgot to change when [NAME] was changed from numeric to alpha. | First version of spec had both [NAME] and Were Taught District as numeric.
2011-09-22 00:00:00 | v 2.3 | [NAME] | Changed [NAME] Record type from 'ST' to 'S1' for UT.027 Completion Status, UT.036 Student Phone, and UT.044 Student Zip. | Inadvertantly recorded as 'ST'
2011-09-23 00:00:00 | v 2.3 | [NAME] | Changed Student Phone and Completion Status from 'R' to 'O' in PESC mapping. | Phone not required in Clearinghouse, HS Completion Status not always present. | Changed to allow processing.  USOE needs to review.
2011-10-03 00:00:00 | v 2.3 | [NAME] | Added 'OP' to AC Instruct Setting options. | Requested by USOE.
2011-10-07 00:00:00 | v 2.3 | [NAME] | Added '65' Dixie ATC to AC CollegeGrantingCr options. | Requested by USOE.
2011-10-07 00:00:00 | v 2.3 | [NAME] | Added note on Scram Exit Date & [NAME] Date: if blank and Exit Date on latest [NAME] not blank, manifest will insert S1 Exit Date and set [NAME] = 'X'. | Requested by USOE.
2011-10-07 00:00:00 | v 2.3 | [NAME] | Added note on AM Course Exit Date: if blank and Exit Date on latest [NAME] not blank, manifest will insert S1 Exit Date. | Requested by USOE.
2011-11-28 00:00:00 | v 2.3 | [NAME] | Added "Blank OK" to SchoolAccreditation on Student Transcript ('ST') record. | Oversight.
2011-12-12 00:00:00 | v 2.3 | [NAME] | Updated S1 ELL Parent Language description to include 'ENG' (previously added to options). | Oversight.
2011-12-12 00:00:00 | v 2.3 | [NAME] | Added GAR to Options for both ELL Native Language and ELL Parent Language. | Requested by USOE. | Created option update script.
2012-01-05 00:00:00 | v 2.3 | [NAME] | Changed ST Parent/Guardian question to comment: Use first listed. | Oversight: question had been resolved previously.
2012-01-05 00:00:00 | v 2.3 | [NAME] | Changed ST yearly GPA question to comment: Yearly GPA is across all schools. | Oversight: question had been resolved previously.
2012-01-05 00:00:00 | v 2.3 | [NAME] | Modified ST Grade9GreditsEarned, Grade10CreditsEarned, Grade11CreditEarned, Grade12CreditsEarned to reflect existing validations. | Oversight: validations had been changed previously.
2012-01-20 00:00:00 | v 2.4 | [NAME] | Modified ST Grade9GreditsEarned, Grade10CreditsEarned, Grade11CreditEarned, Grade12CreditsEarned to reflect validation changes. | Validations changed after reviewing data from districts: prior school years not always available (transfers, home school etc).
2012-02-22 00:00:00 | v 2.4 | [NAME] | Added 'output as string' to StudentTranscript Graduation Date and Expected Graduation Date spec. | Oversight - staging table changed previously.
2012-02-28 00:00:00 | v 2.4 | [NAME] | Added 'Blank exit reason' to Scram and YIC lookup values. | Blank exit reason new in YIC, previously included in Ref table for Scram.