{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["1718 Edit Changes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"1718 Edit Changes","index":0,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["WDIS Student Database Handbook changes made between the 1617 and 1718 WDIS reporting years."]
["Please see the 2017-18 Handbook formats, edits, and data element definitions for details."]
["Format","Edit #","Change Type","Description/Reason","Date"]
["AGE Adult Test Record",1,"Revised","Added the missing Adult Test Form part of the key.","2017-06-26"]
["AGE Adult Test Record",8,"Revised","Removed the Wonderlic Gain (WGN) Code.","2017-06-26"]
["AGE Adult Test Record",15,"New","Ensure TABE 11/12 is not reported prior to state board approval date of 02/20/2018","2018-03-09"]
["AGE Student Course ",16,"New","Ensure that Disability Student is Code Z for Adult High School Co-Enrolled students.","2017-06-26"]
["AGE Student Course ",27,"Revised","Removed the section of CTE Cost Reporting Code/Fee Status values. Deleted fee status V from AGE.","2017-06-26"]
["AGE Student Course ",29,"Revised","Added the missing Prior Year key.","2017-06-26"]
["AGE Student Course ",32,"Revised","Removed courses S990011, S990031, and S990021 in AAAE program S990001. \n7/20/17:  removed extraneous words that didn’t belong in the edit.","2017-07-20"]
["AGE Student Course ",33,"New","Added new reject for Svy W/S that fee status combo of W and Q cannot be allowed","2017-11-15"]
["AGE Student Course ",34,"Revised","Removed obsolete pre-AAAE program code S990000.","2017-06-26"]
["AGE Student Course ",40,"New","Ensure that CTE/AGE Completion Point Code does not contain all blanks.","2017-06-26"]
["AGE Student Course ",43,"Revised","Modified the language to be more clear on AGE Literacy Completion Date Earned.","2017-06-26"]
["AGE Student Course ",58,"New","Added new Svy S reject to inform you that LCP,Date Earned is greater than Date of Exit,PSC","2017-11-15"]
["AGE Student Course ",58,"Revised","Change the edit to give a 7 calendar day grace period to test the student after the Date of Exit, PSC","2018-05-03"]
["AGE Student Course ",73,"New","Validation to ensure valid AGE Withdrawal Reason reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",73,"Revised","Excluded surveys G and X","2017-09-21"]
["AGE Student Course ",74,"New","Validation to ensure Adult High School students and Adult High School Co-Enrolled students have a valid Adult High School Diploma Code.","2017-06-26"]
["AGE Student Course ",74,"Revised","Removed Adult High School Co-Enrolled students from the validation edit","2017-11-15"]
["AGE Student Course ",75,"New","Validation to ensure valid AGE Employment Barriers reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",76,"New","Validation to ensure valid AGE Ex-Offender reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",77,"New","Validation to ensure valid AGE Homeless Individuals or Runaway Youth reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",78,"New","Validation to ensure valid AGE Migrant and Seasonal Farmworker reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",79,"New","Validation to ensure valid Employment Status reported for WIOA Programs.","2017-06-26"]
["AGE Student Course ",82,"Revised","Added missing language to exclude G/X. Edit was already excluding these.","2017-12-22"]
["AGE Student Course ",84,"Deleted","Deleted old exception edit for Employment Status.","2017-06-26"]
["AGE Student Course ",85,"Revised","Added missing words that G/X are excluded.","2017-12-22"]
["AGE Student Course ",86,"Revised","Updated years in date ranges.","2017-06-26"]
["AGE Student Course ",87,"Revised","Updated years in date ranges.","2017-06-26"]
["AGE Student Course ",89,"New","Added new exception to let you know if the course grade level differs from demographic grade","2017-11-15"]
["AGE Student Course ",90,"New","Added new Svy W exception to inform you if LCP,Date Earned is greater than Date of Exit,PSC","2017-11-15"]
["CTE Student Course Schedule",2,"New","Ensure that CTE/AGE Completion Point Code does not contain all blanks.","2017-06-26"]
["CTE Student Course Schedule",11,"Revised","Added missing words that G/X are excluded.","2017-12-22"]
["CTE Student Course Schedule",17,"Revised","Modified so Postsecondary School of Enrollment must be a school in Appendix H.","2017-06-26"]
["CTE Student Course Schedule",21,"Revised","Added the missing Prior Year key.","2017-06-26"]
["CTE Student Course Schedule",29,"New","Ensures that Disability Student is Code Z for students marked with Code C in Dual Enrollment Indicator.","2017-06-26"]
["CTE Student Course Schedule",30,"New","Ensures valid values are reported in Dual Enrollment Course Location.","2017-06-26"]
["CTE Student Course Schedule",31,"New","Ensures that Dual Enrollment Course Location is not Z for students marked with Code C in Dual Enrollment Indicator.","2017-06-26"]
["CTE Student Course Schedule",33,"Revised","Removed the option of CTE/AGE Education Completion Point Code being only blanks.\n07/20/17: reworded the reason provided in this document","2017-07-20"]
["CTE Student Course Schedule",42,"Deleted","Removed edit that if Adult Fee Status (first) is Z, the Adult Fee Status (second) must be blank.","2017-06-26"]
["CTE Student Course Schedule",43,"Revised","Modified valid values allowed between Adult Fee Status (first) and Adult Fee Status (second). Removed the section of AGE Cost Reporting Code/Fee Status values.","2017-06-26"]
["CTE Student Course Schedule",45,"New","Added new reject for Svy W/S that fee status combo of W and Q cannot be allowed","2017-11-15"]
["CTE Student Course Schedule",46,"New","Added new Svy S reject edit to let you know if Full Program Completer does not match the type of program based on Cost Reporting Code.","2017-11-15"]
["CTE Student Course Schedule",48,"Revised","Added program code W170211 (paramedic program code) and district 08.","2018-01-22"]
["CTE Student Course Schedule",49,"Revised","Added program code W170213 (EMT program code).","2018-01-22"]
["CTE Student Course Schedule",50,"Revised","Removed program code W170209 and added W170210 (Radiology Tech program code).","2018-01-22"]
["CTE Student Course Schedule",80,"Deleted","Removed exception edit that if Adult Fee Status (first) is not Z, the Adult Fee Status (second) must be H, AA, BB, CC or blank.","2017-06-26"]
["CTE Student Course Schedule",84,"New","Added new exception to let you know if the course grade level differs from demographic grade","2017-11-15"]
["CTE Student Course Schedule",86,"Revised","Updated years in date ranges.","2017-06-26"]
["CTE Student Course Schedule",87,"Revised","Updated years in date ranges.","2017-06-26"]
["CTE Student Course Schedule",88,"New","Added new Svy W exception edit to let you know if Full Program Completer does not match the type of program based on Cost Reporting Code.","2017-11-15"]
["Student Demographic",24,"Revised","Modified to remove language specific to certain surveys for Displaced Homemaker.","2017-06-26"]
["Student Demographic",26,"Deleted","Removed edit specific to Adult Rural Resident.","2017-06-26"]
["Student Demographic",28,"Deleted","Removed edit specific to Veteran Student Indicator.","2017-06-26"]
["Student Demographic",29,"Deleted","Removed edit specific to Adult Rural Resident.","2017-06-26"]
["Student Demographic",32,"Deleted","Removed edit specific to Level of Schooling, Adult.","2017-06-26"]
["Student Demographic",34,"Revised","Modified to remove language specific to certain surveys for Ex-Offender.","2017-06-26"]
["Student Demographic",35,"Revised","Modified to remove language specific to certain surveys for Employment Barriers.","2017-06-26"]
["Student Demographic",36,"Revised","Modified to remove language specific to certain surveys for Highest Grade Completed.","2017-06-26"]
["Student Demographic",37,"Revised","Modified to remove language specific to certain surveys for Homeless Individuals or Runaway Youth.","2017-06-26"]
["Student Demographic",38,"Revised","Modified to remove language specific to certain surveys for Migrant and Seasonal Farmworker.","2017-06-26"]
["Student Demographic",39,"Deleted","Removed edit for combination of Level of Schooling, Adult and Highest School Grade Completed.","2017-06-26"]
["Student Demographic",41,"New","Ensures Adult High Schol Diploma Option is a valid value.","2017-06-26"]
["Student End of Term Status",8,"Revised","Added WD1.\n12/19/17: Added codes W57 and W58","2017-12-19"]
["Student End of Term Status",8,"Revised","Replaced code W57 with code W59 (W57 had been valid in 1415 with a different definition)","2018-01-16"]
["Student End of Term Status",9,"Revised","Removed obsolete cert codes W8C and W57.","2018-01-16"]
["Student End of Term Status",16,"Deleted","Removed edit specific to Career Pathways Participant.","2017-06-26"]
["Student End of Term Status",17,"Deleted","Removed edit specific to Career Pathways Participant.","2017-06-26"]
["Student End of Term Status",21,"Revised","Added WD1 for grades 09-12.","2017-06-26"]
["Student End of Term Status",27,"Revised","Removed blank as an option in reporting AGE, Withdrawal Reason.","2017-06-26"]
["Student End of Term Status",28,"Revised","Modified Diploma Data edit to ensure a valid Diploma Type and that the date is within the current reporting year.\n8/18/17: Added information about prior year into the edit.","2017-08-18"]
["Student End of Term Status",29,"Revised","Modified to include the new codes W57 and W58.","2017-12-19"]
["Student End of Term Status",29,"Revised","Replaced code W57 with code W59 (W57 had been valid in 1415 with a different definition)","2018-01-16"]
["Student End of Term Status",30,"Revised","Removed obsolete cert code W57.","2018-01-16"]
["Student End of Term Status",71,"Revised","Modified to remove Exceptionality, Primary codes A, B and N; and added codes C, G, H, J, K, S, V, W","2017-12-19"]
["Supplemental Information",10,"Revised","Modified so the Postsecondary School of Enrollment must come from Appendix H.","2017-06-26"]
["WDIS Teacher Course",9,"Revised","Modified the handbook to show that Facility Type allows for code 20 (typo).","2017-11-15"]