{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["2223 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":"2223 Handbook Changes","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"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","DESCRIPTION","REASON"]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2023-04-11","Edit 60","60. (REVISED 2223) If the Apprenticeship Sponsor Code and Career and Technical Education/ Adult General Education Program Code on WDIS Appendix O is “Cancelled” then the Date of Entry, Program/Course/Section must be before the Cancelled Date. – record rejected- ","Modified edit language to include Career and Technical Education/ Adult General Education Program Code. "]
["WDIS","EDIT","REVISED","AGE STUDENT","REJECT","2023-02-09","Edit 50","50.\t(Revised 2223) If the Career and Technical Education/Adult General Education Program Code equals 9900010 or 9900099, Course Number must be a valid number on the Course Code Directory file and in the range 0100300-2499990, 7910010-7980990, or 8002000-9701000. For Survey F, the course number will be validated against the current and prior year Course Code Directory. For Surveys G, W, X and S, the course number will be validated against the current year Course Code Directory. -record rejected-                  ","Verbiage added to help capture how the edit operates."]
["WDIS","EDIT","REVISED","TEACHER COURSE","REJECT","2023-02-09","Edit 5","5.\t(Revised 2223) Course Number must not contain blanks and must be a valid postsecondary course number on the Career and Technical Education/Adult General Education Program Edit file (F61730) or a valid number on the Course Code Directory file in the range 0100300-2499990, 7910010- 7980990, 8002000-9003490, and 9900010. For Survey F, the course number will be validated against the current and prior year Course Code Directory. For Surveys G, W, X and S, the course number will be validated against the current year Course Code Directory. -record rejected-  ","Verbiage added to help capture how the edit operates."]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2023-01-20","Edit 34","34. If the total program hours associated with the Career and Technical Education/Adult General Education Program Code are less than 450, then the Career and Technical Education Basic Skills Examination code must equal G. If the Cost Reporting Code is equal to 341 then the Career and Technical Education Basic Skills Examination code must be equal to Z. If the Cost Reporting Code is equal to 364 then the Career Technical education Basic Skills Education Basic Skills Examination codes must be A, B, C, D, F,G, H, N, P, Y or Z. Else the Career and Technical Education Basic Skills Examination code must equal A, B, C, D, F, H, N, P or Y. Not required for Survey G or X. Note1: See Appendix S in the WDIS Database Handbook to reference total program hours.","Modified edit language to include the following \"If the Cost Reporting Code is equal to 364 then the Career Technical education Basic Skills Education Basic Skills Examination codes must be A, B, C, D, F,G, H, N, P, Y or Z.\""]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2023-01-20","Edit 68","68. If Full Program Completer is V or A, then CTE Basic Skills Exam must not equal N or Z. Not required for Survey G or X.","Removed A"]
["WDIS","EDIT","REVISED","AGE STUDENT","REJECT","2023-01-05","Edit 27","27.The Adult Fee Status (First) code must be left justified and must be a valid code for the Cost Reporting Code area as indicated below. The Adult Fee Status (Second) code must be left justified and must be a valid code for the Cost Reporting Code area and must not equal Adult Fee Status (First), or it must be blank.\n\n\nAdult General Education\n(EXCLUDING Adult High School Co-Enrolled Program 9900099)\t\n401-405, 409\t\nD, I, J, M, N, O, P, Q, R, T, W, Z, 2, 3\nAdult General Education (Adult\nHigh School Co-Enrolled Program 9900099 ONLY)\n402\t\nC\n\n–record rejected-","New Adult Fee Status codes 2 and 3  has been added to the chart in edit 27. "]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2023-01-05","Edit 14","14. (REVISED 2223) If Survey = F then the Date of Entry, Program/Course/Section cannot be before April 01, 20221 and the Date of Exit, Program/Course/Section cannot be after September 02, 20221; and if Survey = W then the Date of Entry, Program/Course/Section cannot before July 012, 20221 and the Date of Exit, Program/Course/Section cannot be after February 03, 20232; and if Survey = S, then the Date of Entry, Program/Course/Section cannot be before December 16, 20221 and the Date of Exit, Program/Course/Section cannot be after June 30, 20232.\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-","Modified Date of Entry, Program/Course/Section date"]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2023-01-05","Edit 43","43.\tThe Adult Fee Status (First) code must be left justified and must be a valid code for the Cost Reporting Code area as indicated below. The Adult Fee Status (Second) code must be left justified and must be a valid code for the Cost Reporting Code area and must not equal Adult Fee Status (First), or it must be blank. If the Adult Fee Status (First) code is D, R or W, the Adult Fee Status (Second) must be H, AA, BB, CC or blank and must be left justified.\n\nContinuing Workforce Education\t341\tD, I, R, W\nApplied Technology Diploma\t364\tB, D, H, I, J, M, N, O, P, Q, R, T, W, AA, BB, CC, 2, 3 \n\nApprenticeship\t371, 372\t              K\n\n–record rejected-","New Adult Fee Status codes 2 and 3  has been added to the chart in edit 43."]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2022-11-21","Edit 41","41. (REVISED 2223) If Dual Enrollment Indicator equals C, the Career and Technical Education Basic Skills Exam must equal B, C, F, G, H, N, P, W or Y.\n\nNote: Students entering programs after the Fall 2020 term or students who were not assessed as required may NOT be reported with CTE Basic Skills Examination code “W”. CTE Basic Skills Examination code “W” may continue to be reported for students who were assessed and confirmed as meeting basic skills requirements using a local assessment.\n- record rejected -","New value 'H' added. Value 'W' has been removed along with accompanying note."]
["WDIS ","EDIT","REVISED","CTE STUDENT ","REJECT","2022-11-21","Edit 34","34. (REVISED 2223) If the total program hours associated with the Career and Technical Education/Adult General Education Program Code are less than 450, then the Career and Technical Education Basic Skills Examination code must equal G. If the Cost Reporting Code is equal to 341 then the Career and Technical Education Basic Skills Examination code must be equal to Z. Else the Career and Technical Education Basic Skills Examination code must equal A, B, C, D, F, H, N, P, W or Y. Not required for Survey G or X.\n\nNote1: See Appendix S in the WDIS Database Handbook to reference total program hours.\nNote2: Students entering programs after the Fall 2020 term or students who were not assessed as required may NOT be reported with CTE Basic Skills Examination code “W”. \nCTE  Basic Skills Examination code “W” may continue to be reported for students who were assessed and confirmed as meeting basic skills requirements using a local assessment.\n-record rejected-","New value 'H' added. Value 'W' has been removed along with accompanying note."]
["WDIS","ELEMENT ","REVISED","AGE STUDENT\nCTE STUDENT",null,"2022-10-01","Data element number: 101325 Adult Fee Status","Added new values '1', '2', and '3' to reflect legislative changes made during the 2022 Legislative Session. Value '1' waives fees for disabled verterans who do not qualify for the federal 100 percent eligibility tier. Value '2' exempts fees for students reunited with their parents who were the subject of dependency proceeding. Language from value '3' was previously included in value 'O', but was split to create a new value per DCF legislative changes. It also removed the requirement for a caregiver to participate or has participated in the Relative Caregiver Program. Additionally, value 'P' was revised to reflect the definition of \"homeless student\" per section 725 of the McKinney-Vento Homeless Assistance Act. A brief note referencing the DCF-related exemptions was also added.","New values added to better maintain data quality"]
["WDIS","ELEMENT ","REVISED","CTE STUDENT",null,"2022-10-01","Data element number:\n184625 Career and Technical Education Basic Skills Examination","Added a new value for an additional Basic Skills Examination exemption for students enrolling in a law enforcement officer basic training program if they are a veteran or possess an A.S. degree or higher from an accredited college or university per legislative updates made during the legislative session. Additionally, value 'W' was deleted. It allowed for flexible reporting related to a COVID-related EO that could no longer be reported as of 2019-20.","New values added to better maintain data quality"]
["WDIS","ELEMENT ","REVISED","AGE STUDENT\nCTE STUDENT",null,"2022-10-01","Data element number:\n187011 WDIS Student Instructional Hours","Added language to the data element description section that provides further guidance on how agencies are to report instructional hours for adult education IET programs that may teach CTE and AGE curriculum contextually.","New language has been added to clarify reporting practices"]
["WDIS","ELEMENT ","REVISED","AGE STUDENT\nCTE STUDENT",null,"2022-10-01","Data element number:\n197234 Education Services, State and Federal Inmates","Updated language to reflect recent legislative changes regarding the state fundable status of state inmates. Values 'S' and 'T' were updated to include statutory references and clarify the value language. Additionally, a brief summary outlining the data element values was added.","Updated language in light of recent policy changes"]
["WDIS","ELEMENT ","REVISED","CTE STUDENT\nSUPPLEMENTAL",null,"2022-10-01","Data element number:\n197260 Postsecondary School of Enrollment","Added a new value of 9999 to report non-accredited instructional sites that are different than the main school campus number reported for the postsecondary school of enrollment accredited by COE. This work aids HB 1507 requirement to establish an inventory of all workforce education programs down to the school level. ","New value added to capture non-accredited instructional sites"]
["WDIS","EDIT","REVISED","TEACHER COURSE","REJECT","2022-10-01","Edit 5 ","5. (Revised 2223) Course Number must not contain blanks and must be a valid postsecondary course\nnumber on the Career and Technical Education/Adult General Education Program Edit file (F61730) or \na valid number on the Course Code Directory file in the range 0100300-2499990, 7910010- 7980990, \n8002000-9003490, and 9900010. For Survey F, the course number will be validated against the prior year Course Code Directory. For Surveys G, W, X and S, the course number will be validated against the current year Course Code Directory. -record rejected\u0002","Verbiage added to help capture how the edit operates"]
["WDIS ","EDIT","REVISED","AGE STUDENT","REJECT","2022-10-01","Edit 50","50. (Revised 2223) If the Career and Technical Education/Adult General Education Program \nCode equals 9900010 or 9900099, Course Number must be a valid number on the Course Code\nDirectory fileand in the range 0100300-2499990, 7910010-7980990, or 8002000-9701000. For \nSurvey F, the course number will be validated against the prior year Course Code Directory. For \nSurveys G, W, X and S, the course number will be validated against the current year Course \nCode Directory. -record rejected\u0002","Verbiage added to help capture how the edit operates"]
["WDIS","EDIT","REVISED","AGE STUDENT","REJECT","2022-08-01","Edit 31","31. (REVISED 2223) Adult Test Name must be TAB, TBE, CLW, CAG, BSP, BSL or\nblank. – recordrejected-","CAS has been removed"]
["WDIS","EDIT","REVISED","AGE TEST","REJECT","2022-08-01","Edit 6","6. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS","EDIT","REVISED","AGE TEST","REJECT","2022-08-01","Edit 11","11. (REVISED 2223) Adult Test Level must be left justified with trailing blanks, and must be valid for the Adult Test Name and Adult Test Subject Area. -record rejected-","Adult Test Name and Adult Test Subject Area have been added"]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2022-08-01","Edit 17","17. (REVISED 2223) The Postsecondary School of Enrollment must be a Council on Occupational Education (COE) accredited school listed in Appendix H for the District Number, Current Instruction/Services. If the Postsecondary School of Enrollment is not a valid COE accredited school then submit 9999. –record rejected-","Revised for clarity"]
["WDIS","EDIT","REVISED","STUDENT DEMO","REJECT","2022-08-01","Edit 1","1. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS","EDIT","REVISED","EOT STATUS","REJECT","2022-08-01","Edit 1","1. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS","EDIT","REVISED","EOT STATUS","REJECT","2022-08-01","Edit 8","8. (REVISED 2223) The Diploma Type must be W06, W07, W10, W27, WGA, WGD, W43, W45, W52, W54, W55, W58, W59, W61, W62, W63, WD1, WEL, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, WXW or ZZZ. –record rejected-","Revised for clarity, new Diploma Type addition"]
["WDIS","EDIT","REVISED","EOT STATUS","REJECT","2022-08-01","Edit 21","21. (REVISED 2223) If Diploma Type is W06, W07, W10, W27, WD1, WEL, WGA, WGD, WFT, WFW, WRW, WWE, WWT, WWW, WXL, WXT, or WXW, Grade Level must be one of the grades 06-12. -record rejected-","Revised for clarity, new Diploma Type addition"]
["WDIS","EDIT","REVISED","SUPPLEMENTAL","REJECT","2022-08-01","Edit 6","6. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS","EDIT","REVISED","SUPPLEMENTAL","REJECT","2022-08-01","Edit 10","10. (REVISED 2223) If Diploma Type is ZZZ or blank, then Postsecondary School of Enrollment must be a valid Council on Occupational Education (COE) accredited school listed in Appendix H for the District Number, Current Instruction/Services. -record rejected","Revised for clarity"]
["WDIS","EDIT","NEW","SUPPLEMENTAL","REJECT","2022-08-01","Edit 82","82. (NEW 2223) If the Career and Technical Education/Adult General Education Program Code is a valid Adult General Education program number and the Industry Certification Identifier is not equal to blanks, then the Diploma Type must be ZZZ or blank. -record rejected","New edit for 2223"]
["WDIS","EDIT","REVISED","TEACHER COURSE","REJECT","2022-08-01","Edit 1","1. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS ","EDIT","REVISED","AGE STUDENT","REJECT","2022-08-01","Edit 8","8. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS ","EDIT","REVISED","AGE STUDENT","REJECT","2022-08-01","Edit 44","44.\n\nAdult\nCourse Number:\n9900001 – 9900003\n and 9900023","New Adult Course Number 9900023 has been added to the chart in edit 44"]
["WDIS ","EDIT","REVISED","CTE STUDENT","REJECT","2022-08-01","Edit 6","6. (REVISED 2223) District Number, Current Instruction/Services must be numeric in the range 01-68, 71-75 or 80 and must be correct for the district submitting the data. –record rejected-","New district addition"]
["WDIS ","EDIT","REVISED","EOT STATUS","REJECT","2022-08-01","Edit 29","29. (REVISED 2223) If 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-","Revised for clarity"]
["WDIS","ELEMENT ","REVISED","AGE TEST",null,"2022-07-01","Data element number:\n101742 Adult Test Form","Added “ESOL or ELCATE Only” to CASAS codes 185R-188R, 81R, 81RX, 82R, 83R, 84R, 85R, 86R and 981L- 9861L. Added “ESOL Only” to CASAS codes 27R, 28R, and added “ESOL or ELCATE” only to TABE Clas E codes A and B.","Modified definitions to differentiate between ESOL, ELCATE, and ESOL or ELCATE codes"]
["WDIS","ELEMENT ","REVISED","AGE TEST",null,"2022-07-01","Data element number:\n101759 Adult Test Level","Added Values for CASAS GOALS ONLY (Math), Values for CASAS Life and Work 80 ONLY (Reading for ESOL or ELCATE), Values for CASAS 900 GOALS ONLY (Reading for ABE) A-D, Values for CASAS Life and Work 980 ONLY (Listening for ESOL or ELCATE) A-C","New codes have been added for CASAS"]
["WDIS","ELEMENT ","REVISED","AGE TEST",null,"2022-07-01","Data element number:\n101776 Adult Test Name","Comprehensive Adult Student Assessment System (CASAS) has been split into two tests 1) CASAS Life and Work and 2) CASAS GOALS. CASAS code CAS deleted, two new codes added, CLW and CAG. Note and description of changes sections updated.  ","New codes have been added for CASAS"]
["WDIS","ELEMENT ","REVISED","AGE TEST",null,"2022-07-01","Data element number:\n101793 Adult Test Score","Code 0-249 has been modified to add ‘(Life and Work Skills for ESOL and ELCATE)’ to the Definition/Example section. Code 0-268 has been modified to add ‘(Goals for ABE Math Only)’ to the Definition/Example section. The Definition/Example for code 0-78 has been stricken. ‘BEST Literacy 2.0 Reading’ has been modified to add ‘2.0’ and ‘Writing’. The definition for code 088-999 has been changed to ‘BEST 2.0 Plus Listening and Speaking’. Code 165-262 has been modified to 0-265 and adds ‘(GOALS for ABE)’ to the Definition/Example section. ","Test score ranges revised"]
["WDIS","ELEMENT ","REVISED","AGE TEST",null,"2022-07-01","Data element number:\n101810 Adult Test Subject","Code M has been modified to remove ‘or Algebra’ from the Definition/Example section","Code M is no longer valid"]
["WDIS","EDIT","REVISED","AGE STUDENT","REJECT","2022-07-01","Edit 31","31. (REVISED 2223) Adult Test Name must be TAB, TBE, CAS, CLW, CAG, BSP, BSL or blank. \n-record rejected-","Removed CAS from the list of reportable codes fro Adult Test Name"]
["WDIS","EDIT","NEW","AGE STUDENT","REJECT","2022-07-01","Edit 93","93. (NEW 2223) If Adult General Education, Integrated Education and Training Program Number is not all zeroes, then the IET program number must be valid and listed in Appendix P for the District Number, Current Instruction/Service. \n-record rejected-","New edit for IET reporting"]
["WDIS","EDIT","REVISED","AGE TEST","REJECT","2022-07-01","Edit 12","12. (REVISED 2223) If Adult Test Score must be is within the allowable range for Adult Test Form and Adult Test Level, the score must be numeric, right justified with leading zeroes. If Adult Test Name is TAB and Adult Test Form is 11OL, 11PB, 12OL or 12PB and Adult Test Score is Out of Range - Low, the score must be numeric, right justified with a leading “1.” \n-record rejected-\nNote: Report scores that begin with a “+” or “-“. Only report the score, not the “+” or “-“","Updated for clarity"]
["WDIS","EDIT","REVISED","CTE STUDENT","REJECT","2022-07-01","Edit 90","90. (REVISED 2223) If the Apprenticeship Sponsor Code is not blank, then the Career and Technical Education/Adult General Education Program Code must have an “R”’ in the seventh character and be a valid postsecondary program code associated with the Sponsor Code listed in WDIS Appendix O, and the Cost Reporting Code must be 371 or 372. \n-record rejected-","Changed from exception/validation to reject edit"]
["WDIS","EDIT","REVISED","SUPPLEMENTAL","REJECT","2022-07-01","Edit 23","23. (REVISED 2223) 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 01, 20221, and June 30, 20232. If Diploma Type equals ZZZ or blanks, then Adult General Education, Diploma Date must be zeroes. \n-record rejected-","Modified to include dates for current reporting year"]
["WDIS ","ELEMENT ","NEW","AGE STUDENT",null,"2022-07-01","Data element number:\n197301 Adult General Education, Integrated Education and Training Program Number","Indicates the unique Integrated Education and Training (IET) program number assigned to each IET program offered by Adult Education programs.","New data element has been added to capture IET reporting"]
["WDIS ","EDIT","REVISED","AGE STUDENT","REJECT","2022-07-01","Edit 18","18.  (REVISED 2223) If Survey = F then the Date of Entry, Program/Course/Section cannot be before April 01, 20221, and the Date of Exit, Program/Course/Section cannot be after September 02, 20221; and if Survey = W then the Date of Entry, Program/Course/Section cannot be before July 1 23, 20221, and the Date of Exit, Program/Course/Section cannot be after February 03, 20232; and if Survey = S, then the Date of Entry, Program/Course/Section cannot be before December 16, 20221, and the Date of Exit, Program/Course/Section cannot be after June 30, 20232. \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 - ","Modified to include dates for current reporting year"]
["WDIS ","EDIT","REVISED","AGE TEST","REJECT","2022-07-01","Edit 8","8. (REVISED 2223) Adult Test Name must be TAB, TBE, CAS, CLW, CAG, BSP, BSL or blank. \n-record rejected-","Removed CAS from the list of reportable codes fro Adult Test Name"]