Spreadsheet: 05ca505c-c129-4c4f-b2a8-9530452858cd
Sheet: Sheet1

Date | Version | By | Change | Reason | Notes
2011-03-02 00:00:00 | v 1.01 | [NAME] | Document created as spreadsheet from [NAME] document. | Provide for easier update/review and for use in profile database
2011-03-07 00:00:00 | v 1.01 | [NAME] | Modified names on valid values lookup table | Change to generic names | From discussion with Mike & Alex
2011-03-08 00:00:00 | v 1.01 | [NAME] | Modified Overview, completed data transfer from Word docs, completed REF table definitions. | Completion of initial task | Revision needed for spec changes from version 1.01 to 1.1. Error messages and desciptions are done through School Membership in S1 record. USOE needs to review and complete error messages and descriptions.
2011-03-09 00:00:00 | v 1.01 | [NAME] | Updated references to CACTUS and SSID databased with info for using REF tables. | Not previously included | Requested by [NAME].
2011-03-18 00:00:00 | v 1.01 | [NAME] | Updated generic rule 012 with [ComparisonOp] and [ComparisonOpFailure] tokens. | Defined in String Substitution Design Spec | Replaced six 012 rows with one, making it fully generic.
2011-03-23 00:00:00 | v 1.01 | [NAME] | Added messages/descriptions for SchoolMembershipCode | Provided additional example for unusual multi-field case. | Value in SchoolMembershipCode column is called 'SchoolMembership' in description.
2011-03-24 00:00:00 | v 1.01 | [NAME] | Added REF_MASTER_CATALOG and REF_Level1_Vld_Msgs tables and table creation scripts to Ref Tables tab | Not previously included | Table scripts provided by [NAME]
2011-03-24 00:00:00 | v 1.01 | [NAME] | Added proposed change on S1.302 & 303.  Added explanation of color highlighting in pre-release version. | Check S1.303 redundant as originally written. | Colors already in use but not previously explained.
2011-03-29 00:00:00 | v 1.01 | [NAME] | Changed Ref Table UPDATE_VER_NUMBER data type to rowversion. | Was timestamp, deprecated alias for rowversion in SQL Server. | Old version OK for now, changed to rowversion for future implementations.
2011-03-29 00:00:00 | v 1.01 | [NAME] | Added hand SQL insert statement in row 4 of Validation Rules (VRF insert in row 3) | VRF insert uses 'default' for VRF defaults, but hand SQL needs to specify values. | Delete unwanted version and copy desired one when using, without saving spreadsheet.
2011-04-08 00:00:00 | v 1.01 | [NAME] | Replaced unsupported characters in Error Messages and Definitions on Validation Rules, removed suffix of 1 from column data, added Special Characters section to Overview. | Character limitations on single-quote, m-dash, n-dash not previously known.  Single-quotes are removed, others replaced with question mark. | [NAME] would like VRF to support single quotes, but is complex issue and not high priority.
2011-04-12 00:00:00 | v 1.01 | [NAME] | Corrected syntax for Vrf poperty reference in SC.204; added message/description for S1.362 & S1.365. | Syntax was incorrect on SC.204.  Added messages on S1.362 & 365 for testing multiple fields. | Vrf property displays correctly, column data after first column does not.
2011-04-13 00:00:00 | v 1.01 | [NAME] | Added 'P' to SCRAM Environment options, and note about validation method. | P' option ('Parent') not previously included. | Lookup table is used in custom validation.
2011-04-14 00:00:00 | v 1.01 | [NAME] | Add DESCRIPTION column to REF_COURSE_CODE. | Inadvertantly left out. | Updated table script.
2011-04-14 00:00:00 | v 1.01 | [NAME] | Corrected syntax for Description on Error Code 004. | Replaced [ColumnData], [ColumnData2]… with [UniqueFieldsData]. | [UniqueFieldsData] not currently working, but is in spec.
2011-04-19 00:00:00 | v 1.01 | [NAME] | Corrected error id numbers for I2 secondary fields. | Copy-paste error.
2011-04-27 00:00:00 | v 2.0 | [NAME] | Changed version to 2.0, removed validations for fields deleted in Data Spec 2.0. | Next release version to accompany other 2.0 docs. | Rule deletions affect only the four Transcript tables.
2011-04-28 00:00:00 | v 2.0 | [NAME] | Deleted [NAME] and S1.305i, removed School_Type_Code and Max_Enrollment fields from REF_SCHOOL_LEA. | Discussed in meeting with USOE. | Also added answers to S2 questions on S1.378 and [NAME], modified rules accordingly.
2011-05-04 00:00:00 | v 2.0 | [NAME] | Completed messages, added new generic codes 033, 051, 052, modified RefTables. | REF table mods reflect changes made during initial import process. | Still need to remove colors
2011-05-05 00:00:00 | v 2.0 | [NAME] | Corrected wording on SC.203, updated [NAME] footer date. | Message was incorrect, had forgotten to update date.
2011-05-09 00:00:00 | v 2.0 | [NAME] | Corrected VRF properties references in error descriptions for generic errors. | Overlooked updating when other property references corrected. | Will remove colors when USOE approves changes (manifest reflects changes).
2011-05-09 00:00:00 | v 2.0 | [NAME] | Changed I1 Incident Id unique rule from School to LEA, changed I2 dependency rules. | Changed in USOE Clearinghouse doc, May 4, 2011.
2011-07-11 00:00:00 | v 2.1 | [NAME] | Changed generic Required rule on Student.Accompanied to conditional S1.374. | Accompanied requied only if Home Status = 0. | Also removed 'not null' from Accompanied field in staging table script.
2011-07-13 00:00:00 | v 2.1 | [NAME] | Corrections to S1.356, S1.361, S1.377. | S1.356 shouldn't include GE code, S1.361 should include T1 and T2 codes, S1.377 shouldn't require Course Membership > 0. | Corrected rule description, message, and code.
2011-07-15 00:00:00 | v 2.2 | [NAME] | Corrections to S1.342, S1.360, S1.374, S2.618, S3.713, [NAME], removed S1.302, S1.303, [NAME], added S1.305, AC.820. | Errors identified by [NAME] and [NAME] districts. | Corrected rule description, message, and code.
2011-07-18 00:00:00 | v 2.2 | [NAME] | Corrections to S1.370, SL.505, [NAME], S2.617, S3.712. | Errors identified by [NAME] and [NAME], discrepancies from Clearinghouse doc. | Corrected rule description, message, and code.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Removed '6' as valid value for [NAME] | USOE request after reviewing element. | Had added on July 15 at USOE request.
2011-07-27 00:00:00 | v 2.2 | [NAME] | [NAME] validations to multiple S1 paradigm.  Reinstated S1.302, S1.303, [NAME], old version of S1.342.  Commented S1.305. | USOE request after reviewing multiple S1 issue. | Had changed to single S1 paradigm on July 15.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Added S1.375, ensures correct School Membership for School Number 990/995. | USOE request after reviewing 990/995 issue. | SC record for 990/995 should pass regular SC validations.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Added [NAME] length checks on I1 Incident Id and Incident Description. | [NAME] [NAME] length. | I2 check implicit - must match I1.
2011-07-27 00:00:00 | v 2.2 | [NAME] | Added 012 check on S1  Statewide Student Id, ensure > 1,000,000. | [NAME] | Excluded from Ref lookup in Student List.
2011-08-03 00:00:00 | v 2.2 | [NAME] | Added temporary versions of S1.342 while traditional combined S1 records still in use: S1.342w (warning-only) and S1.342t (traditional S1).  Currently used in place of S1.342. | Traditional combined S1 records will fail S1.342 as written for multiple [NAME]'s. | Need to comment S1.342t and S1.342w, un-comment S1.342 when move to multiple S1 paradigm completed (Dec 2011).
2011-09-15 00:00:00 | v 2.2 | [NAME] | Added alternative elementary course check to AC.819: core code begins with '22'. | Alternative check is the one used in the validation code. | With alternative, grade_low & grade_high not needed in REF_COURSE_CODE.
2011-09-20 00:00:00 | v2.3 | Quint | Added District_ID, School_ID, and Institution_Name columns to REF_SCHOOL_LEA ref table | Requested by Choice to facilitate writing into the RDW. | District and School_Id are unique numbers generated in the RDW
2011-09-20 00:00:00 | v2.3 | [NAME] | Added S1.382, S2.623, [NAME], modified S1.012 on Statewide Student ID. | USOE change requests. | Need to add messages to REF_Lvl1_Vld_Msgs for S1.382, S2.623, [NAME].
2011-09-20 00:00:00 | v2.3 | [NAME] | Added 002 Must be Numeric on AC.Period and AM.Period. | Receiving some non-numeric values ('PM').
2011-09-27 00:00:00 | v2.3 | [NAME] | Corrected rule on S1.317 to error if Exit Date after Sept.1. | Rule previously had error if Exit Date on or before Sept 1. | Error message/description OK.
2011-09-27 00:00:00 | v2.3 | [NAME] | Added S2.626 and [NAME]. | Entry dates on or after earliest S1 entry date. | Rquested by USOE.
2011-09-28 00:00:00 | v2.3 | [NAME] | Added S2.627, S3.715, and [NAME]. | Exit dates on or before latest [NAME] exit date. | Rquested by USOE.
2011-09-28 00:00:00 | v2.3 | [NAME] | Marked as deleted: 002 Numeric check on Period in AM and AC | Allow for Kindergarten AM and PM periods. | Consistent with data.
2011-10-04 00:00:00 | v2.3 | [NAME] | Changed S2.603 to warning, [NAME]. | Requested by USOE.
2011-10-04 00:00:00 | v2.3 | [NAME] | Changed S1.382 ExitDate not more than 10 days future, to 032 Must be in current school year. | Requested by USOE.
2011-10-04 00:00:00 | v2.3 | [NAME] | Change S2.623 and SC.207 to warnings, S2.623w and SC.207w. | Requested by USOE.
2011-10-05 00:00:00 | v2.3 | [NAME] | Removed S1.357. | Requested by USOE.
2011-10-05 00:00:00 | v2.3 | [NAME] | Changed '170' in SL.505 to '190' | Requested by USOE.
2011-10-05 00:00:00 | v2.3 | [NAME] | Deleted rows: SC.201 (old), [NAME], S2.625, AM dependency on DI & SC, other redundant/replaced checks. | Redundant, marked for deletion since start of QA in May.
2011-11-02 00:00:00 | v2.3 | [NAME] | Changed SL.505 from 190 to 360. | Requested by USOE. | Message modified Jan 31, 2012.
2011-11-16 00:00:00 | v2.3 | [NAME] | Added I1.1001 | Requested by USOE. | New message
2011-11-16 00:00:00 | v2.3 | [NAME] | Marked S2.603w for deletion, added new [NAME]. | Requested by USOE. | New message
2011-11-18 00:00:00 | v2.3 | [NAME] | Deleted S2.603w (original S2.603 logic). | USOE confirmed [NAME] logic obsolete.
2011-11-18 00:00:00 | v2.3 | [NAME] | Deleted unused length check on CourseRecordId in TC and TG records. | Avoid confusion. | Also greyed out all remaining unused validations (highlighted in rose).
2011-11-28 00:00:00 | v2.3 | [NAME] | Removed 001 Must be Present validation from SchoolAccreditation in Student Transcript. | Field will be left blank if data not found in CACTUS. | Data not reported by districts, pulled from CACTUS ref table.
2011-12-05 00:00:00 | v2.3 | [NAME] | Added S1.319w and S1.329w; updated extended description on S1.319 and [NAME]. | USOE requested warning-only versions for December collection.  [NAME] not used. | Regular version of S1.329 will likely be reinstated after issues resolved.
2011-12-13 00:00:00 | v 2.3 | [NAME] | Added note on S1.365 to include all PK S2 membership days (treat as self-contained). | USOE clarification. | Updated code.
2011-12-14 00:00:00 | v 2.3 | [NAME] | Changed S1.362 description and message. | USOE clarification. | Using relaxed version, strict version available.
2011-12-20 00:00:00 | v 2.3 | [NAME] | Change level on TC.1308w from Error to Warn | Oversight | Might want to change message also.
2011-12-23 00:00:00 | v 2.3 | [NAME] | Added TC.1308 message, modified message in TC.1308w to match. | Manifold tool currently doesn't recognize 'w' suffix on longer error codes. | Temporary correction, so manifest can use either 1308 or 1308w.
2012-01-05 00:00:00 | v 2.3 | [NAME] | Moved TS.1610-1612 down one grade level, added TS.1613. | Update to relflect prior change to handle SIS2000 grade publishing system. | Larger problem of no data for prior year(s) remains.
2012-01-09 00:00:00 | v 2.4 | [NAME] | Changed S1.350 and S1.352 to year-end checks, added S1.350w and S1.352w prior to year end. | Reading status not determined/updated until mid-year. | New messages
2012-01-10 00:00:00 | v 2.4 | [NAME] | Moved TS.1610-1612 back to original locations as warnings, removed TS.1613. | Provide warning but allow publication of transcript. | Updated messages
2012-01-10 00:00:00 | v 2.4 | [NAME] | Added generic 001w, Should be present. | Provide warning version of Must be present. | New message
2012-01-19 00:00:00 | v 2.4 | [NAME] | Corrected 'High School Exit Status' to 'High School Completion Status' on ST.1601 and ST.1602. | Inadvertent error. | Updated messages
2012-01-20 00:00:00 | v 2.4 | [NAME] | Added REF_ASSESS_NAMES to Ref Tables | New ref table.
2012-01-25 00:00:00 | v 2.4 | [NAME] | Added note on [NAME] to allow 3-day overlap between Course Exit Date and S1 Exit Date. | USOE request - handle date issue in SIS2000. | May remove/reduce overlap allowance in future
2012-01-27 00:00:00 | v 2.4 | [NAME] | Added note on S2.627, S3.715 to allow 3-day overlap between Exit Date and S1 Exit Date. | USOE request - handle date issue in SIS2000. | May remove/reduce overlap allowance in future
2012-02-23 00:00:00 | v 2.4 | [NAME] | Changed 001w on TC Cumulative Credits, Cumulative GPA Credits, and Total Credits Attempted from warning to error (001). | Previously changed to warning in validation spec (required in code and tables).
2012-02-23 00:00:00 | v 2.4 | [NAME] | Removed School Fax from TC. | Previously removed from Data Spec and tables.