{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["2122 HANDBOOK CHANGES"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":10,"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":"2122 HANDBOOK CHANGES","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SYSTEM","ITEM TYPE:\nEDIT, ELEMENT, FORMAT","CHANGE TYPE:\nNEW, DELETED, REVISED","FORMAT\nAFFECTED","EDIT TYPE:\nREJECT, VALIDATION, EXCEPTION","DATE\nCHANGED","ITEM","EDIT DESCRIPTION","REASON"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-06-22","Edit 18","18.    (REVISED 2122) If Survey = F then the Date of Entry, Program/Course/Section cannot be before April 01, 2021 and the Date of Exit, Program/Course/Section cannot be after September 02, 2021; and if Survey = W then the Date of Entry, Program/Course/Section cannot be before July 23, 2021 and the Date of Exit, Program/Course/Section cannot be after February 03, 2022; and if Survey = S, then the Date of Entry, Program/Course/Section cannot be before December 16, 2021 and the Date of Exit, Program/Course/Section cannot be after June 30, 2022. \n\nIf Survey is equal to G or X, then the Date of Entry, Program/Course/Section must be a valid MMDDYYYY date, and the Date of Exit, Program/Course/Section must be equal to zeroes.\n-record rejected-\n\n\n\n","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-06-22","Edit 31","31.    (REVISED 2122) Adult Test Name must be TAB, TBE, CAS, BSP, BSL or blank. – record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","DELETED","AGE SC","REJECT","2021-06-22","Edit 32","32.    Deleted 05/2021.","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-06-22","Edit 44","44.    (REVISED 2122) If Survey is not F, t The Adult Educational Functioning Level, Initial, Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must agree with the Career and Technical Education/Adult General Education Program Code and the Course Number in the following table; and, the Adult Educational Functioning Level, Initial, Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must not all contain the value Z with the exception of Career and Technical Education/Adult General Education Program Code 9900099 which allows all Zs; and if the Career and Technical Education/Adult General Education Program Code and the Course Number are both 9900040, then the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must not both contain the value 7:\n\n-record rejected-\n*Note- For more details please refer to the Adult General Education Edit document.","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-06-22","Edit 58","58.    (REVISED 2122) If Survey is not F = S, then If the Adult General Education Program Code is equal to 9900010, 9900040, 9900050, 9900099, or 9900000, then the Adult General Education Literacy Completion Point Code Date Earned must not be greater than 7 calendar days following the Date of Exit, Program/Course/Section. Not required for Survey G or X.* - record rejected –","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","DELETED","AGE SC","REJECT","2021-06-22","Edit 59","59.    Deleted 05/21.","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-06-22","Edit 60","60.    (REVISED 2122) If Survey is not F, then  i If Career and Technical Education/Adult General Education Program Code equals 9900040, 9900050 or 9900051, the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) and Adult General Education Literacy Completion Point (1-6) must conform to the below relationship in alignment with Appendix R. If Career and Technical Education/Adult General Education Program Code is 9900040, the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must not both contain the value 7. \n\n-record rejected-\n*Note- For more details please refer to the Adult General Education Edit document.","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-06-22","Edit 14","14.  (REVISED 2122) If Survey = F then the Date of Entry, Program/Course/Section cannot be before April 01, 2021 and the Date of Exit, Program/Course/Section cannot be after September 02, 2021; and if Survey = W then the Date of Entry, Program/Course/Section cannot be before July 23, 2021 and the Date of Exit, Program/Course/Section cannot be after February 03, 2022; and if Survey = S, then the Date of Entry, Program/Course/Section cannot be before December 16, 2021 and the Date of Exit, Program/Course/Section cannot be after June 30, 2022.  \n\nIf Survey is equal to G or X, then the Date of Entry, Program/Course/Section must be a valid MMDDYYYY date, and the Date of Exit, Program/Course/Section must be equal to zeroes.\n-record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","DELETED","CTE SC","REJECT","2021-06-22","Edit 49","49.  Deleted 05/2021 ","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","EOT","REJECT","2021-06-22","Edit 8","8.  (REVISED 2122) If Survey = F or S the Diploma Type must be W06, W07, W10, W27, WGA, WGD, W43, W45, W52, W54, W55, W58, W59, W60, W61, W62, W63, WCO, WD1, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, WXW or ZZZ. Else if Survey is W not F Diploma Type must be W06, W07, W10, W27, WGA, WGD, W43, W45, W52, W54, W55, W58, W59, W61, W62, W63, WD1, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, WXW or ZZZ. –record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","EOT","REJECT","2021-06-22","Edit 21","21.   (REVISED 2122) If Survey = F or S and Diploma Type is W06, W07, W10, W27, WCO, WD1, WGA, WGD, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, or WXW, Grade Level must be one of the grades 06-12. Else if Survey is W not F and Diploma Type is W06, W07, W10, W27, WD1, WGA, WGD, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, or WXW, Grade Level must be one of the grades 06-12. -record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","EOT","REJECT","2021-06-22","Edit 29","29.   (REVISED 2122) If Survey = F or S the and Diploma Type is W43, W45, W52, W54, W55, W58, W59, W60, W61, W62, or W63 then Grade Level must be one of the grades 30 or 31. Else if Survey is W not F and Diploma Type is W43, W45, W52, W54, W55, W58, W59, W61, W62, or W63 then Grade Level must be one of the grades 30 or 31. -record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","SUPPL","REJECT","2021-06-22","Edit 22","22.  (REVISED 2122) If Survey = F or S the Diploma Type must be W06, W07, W10, W27, WGA, WGD, W43, W45, W52, W54, W55, W58, W59, W60, W61, W62, W63, WD1, WFT, WFW, WRW, WXL, WXT, WXW, ZZZ or blank. Else if Survey is W not F Diploma Type must be W06, W07, W10, W27, WGA, WGD, W43, W45, W52, W54, W55, W58, W59, W61, W62, W63, WD1, WFT, WFW, WRW, WXL, WXT, WXW, ZZZ or blank.  -record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","SUPPL","REJECT","2021-06-22","Edit 23","23.  (REVISED 2122) If Diploma Type (for diplomas earned in the year after exit) is not ZZZ or blanks, then Adult General Education, Diploma Date must be a valid date in the format of MMDDYYYY that is between April 15, 2021 and June 30, 2022. If Diploma Type equals ZZZ or blanks, then Adult General Education, Diploma Date must be zeroes.\n-record rejected-","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-07-23","Edit 60","60.    (REVISED 2122) If Survey is not F, then  i If Career and Technical Education/Adult General Education Program Code equals 9900040, 9900050 or 9900051, the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) and Adult General Education Literacy Completion Point (1-6) must conform to the below relationship in alignment with Appendix R. If Career and Technical Education/Adult General Education Program Code is 9900040, the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must not both contain the value 7.  If Career and Technical Education/Adult General Education Program Code is 9900051, the Adult Educational Functioning Level, Initial (Listening ESOL/ELCATE) and Adult Educational Functioning Level, Initial (Reading ESOL/ELCATE) must not both contain the value Z.\n\n-record rejected-\n*Note- For more details please refer to the Adult General Education Edit document.","Change due to 2122 Handbook rollover"]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-09-05","Edit 14","14.  (REVISED 09/2122) If Survey = F then the Date of Entry, Program/Course/Section cannot be before April 01, 2021 and the Date of Exit, Program/Course/Section cannot be after September 02, 2021; and if Survey = W then the Date of Entry, Program/Course/Section cannot be before July 2312, 2021 and the Date of Exit, Program/Course/Section cannot be after February 03, 2022; and if Survey = S, then the Date of Entry, Program/Course/Section cannot be before December 16, 2021 and the Date of Exit, Program/Course/Section cannot be after June 30, 2022.  \n\nIf Survey is equal to G or X, then the Date of Entry, Program/Course/Section must be a valid MMDDYYYY date, and the Date of Exit, Program/Course/Section must be equal to zeroes.\n-record rejected-","Change Survey W Date of Entry from July 23, 2021 to July 12, 2021 to accommodate district needs."]
["WDIS","EDIT","REVISED","SUPPL","REJECT","2021-09-23","Edit 23","23.   (REVISED 09/2122) If Diploma Type (for diplomas earned in the year after exit) is not ZZZ or blanks, then Adult General Education, Diploma Date must be a valid date in the format of MMDDYYYY that is between April 015, 2021 and June 30, 2022. If Diploma Type equals ZZZ or blanks, then Adult General Education, Diploma Date must be zeroes. -record rejected-","Changed range or reporting Adult General Education, Diploma Type to start on April 01, 2021 instead of April 15, 2021 to accommodate district needs."]
["WDIS","ELEMENT","REVISED",null,null,"2021-10-13","Data Element Number: 184625 - Career and Technical Education Basic Skills Examination","(REVISED 10/2122)\n1. Code W note was added: (Note: Students entering programs after the Fall 2020 term or students who were not assessed as required may NOT be reported with the value of \"W.\")\n2. Code Y added additional information: utilizing the assessments listed in Rule 6A-10.040, F. A. C","1. Clarified when Code W should NOT be reported per DCAE.\n2. Added clarification per DCAE."]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-10-19","Edit 51","51. (REVISED 10/2122) Financial Assistance Received must be A-HJ, or Z, and must be left justified with trailing blanks. Not required for Survey G or X.* -record rejected-","Added Financial Assistance Received codes I (Open Door Grant State Grant, Student Investment )and J (Open Door Grant State Grant, Last Dollar )"]
["WDIS","EDIT","REVISED","AGE SC","REJECT","2021-10-19","Edit 53","53. (REVISED 10/2122) If Financial Assistance Received equals A- HJ, the value Z cannot be reported on the same record. Not required for Survey G or X.* -record rejected-","Added Financial Assistance Received codes I (Open Door Grant State Grant, Student Investment )and J (Open Door Grant State Grant, Last Dollar )"]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-10-19","Edit 57","57. (REVISED 10/2122) Financial Assistance Received must be A - HJ, or Z, and left justified with trailing blanks. \nNot required for Survey G or X.* -record rejected-\n","Added Financial Assistance Received codes I (Open Door Grant State Grant, Student Investment )and J (Open Door Grant State Grant, Last Dollar )"]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-10-19","Edit 59","59. (REVISED 10/2122) If Financial Assistance Received equals A - HJ, the value Z cannot be reported on the same record. Not required for Survey G or X.* -record rejected-","Added Financial Assistance Received codes I (Open Door Grant State Grant, Student Investment )and J (Open Door Grant State Grant, Last Dollar )"]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-11-22","Edit 36","36. (REVISED 11/2122) If Cost Reporting Code = 371 or 372, then the Career and Technical Education/Adult General Education Program Code must be a valid postsecondary program code listed in WDIS Appendix O where the seventh character ends in R; and the Career and Technical Education/Adult General Education Program Code must be the same as the Course Number.  -record rejected-","Program code must be a valid PostSecondary program code listed in Appendix O; and program code must be the same as the Course Number. "]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-11-22","Edit 54","54. (REVISED 11/2122) If the Cost Reporting Code is 371 or 372, then the Apprenticeship Sponsor Code must be a valid apprenticeship sponsor code listed in WDIS Appendix O.\n \nNote: For more information on Apprenticeship Sponsor Codes refer to WDIS Appendix O in the WDIS Database Handbook. -record rejected-","Appendix O Apprenticeship Sponsor Codes has been modified and for record matching purposes the reference to Appendix O and related data tables is noted."]
["WDIS","EDIT","REVISED","CTE SC","REJECT","2021-11-22","Edit 56","56. (REVISED 11/2122) If the Career and Technical Education/Adult General Education Program Code is E92010R, then Grade Level must be 10-12, 30, or 31,. else if the seventh byte of Career and Technical Education Program Code is an R, Grade Level must equal 30 or 31. Not required for Survey G or X.*  -record rejected-","The seventh byte of the Career and Technical Education Program Code E92010R no longer applies solely to grades 30 and 31. It applies to CTE/AGE grades 10-12,30-31."]
["WDIS","EDIT","NEW","CTE SC","REJECT","2021-11-22","Edit 60","60. (NEW 11/2122)  If the Apprenticeship Sponsor Code in WDIS Appendix O is “Cancelled” then the Date of Entry, Program/Course/Section must be before the Cancelled Date. -record rejected-","If the program status of \"CANCELLED\" exists on Appendix O, the CTESC date of entry, program/course/section must be edited against the CANCELLED date in WDIS Appendix O. Formerly \"Inactive Date\"."]
["WDIS","EDIT","DELETED","CTE SC","EXCEPTION","2021-11-22","Edit 89"," 89. (DELETED 11/2122) If the Apprenticeship Sponsor Code is “In-active” then the Date of Entry, Program/Course/Section must be before the Inactive Date in WDIS Appendix O. -exception report-","Logic replaced by new reject edit #60. "]
["WDIS","EDIT","NEW","CTE SC","EXCEPTION","2021-11-22","Edit 90","90. (NEW 11/2122)  If the Apprenticeship Sponsor Code is not blank, then the Career and \nTechnical Education/Adult General Education Program Code must have an ‘R’ in the seventh \ncharacter and be a valid postsecondary program code associated with the Sponsor Code listed in \nWDIS Appendix O, and the Cost Reporting Code must be 371 or 372.  –exception report-\n","Appendix O Apprenticeship Sponsor Codes has been modified and for record matching purposes the reference to Appendix O and related data tables is noted."]