Starting the submission for January 2024, CDSS has issued a change where the column previously used to indicate if the child was receiving part time care will now be for “Service Type & Length.” The valid codes for this new column are as follows:

A - Direct Services Full-Day

B - Direct Services Part-Day

C - Subcontracted Services Full-Day

D - Subcontracted Services Part-Day

Steps to Manually Adjust 801A Files before January 2024

Please follow the instructions below if your agency needs to resubmit for a month before this change took effect:

1. Export your 801A as normal

2. Open Excel

3. Navigate to the File tab

4. Press Open

5. Press Browse

6. Select the option to display all files

7. Navigate to your 801A

8. Open file

9. It is recommended to open the file using the Excel application over the Excel web based version to select the delimited version and not to convert the file, so the leading zeros will remain for numeric values such as FIPS code.

10. Also, select the services date column and select text for the column data format

11. Then, select the Language Code column and select text for the column data format

12. Go to column AD and select the whole column, make sure only the values in this column are selected so you don’t replace anything in other parts of the spreadsheet

13. Column name is “Services Type & Length”

14. Do control + H or command + H to open the find and replace tool. The find and replace tool can also be found under Home → Editing → Find & Select → Replace

15. Find A and replace with N, click the replace all button

16. Find B and replace with Y, click the replace all button

17. Find C and replace with N, click the replace all button

18. Find D and replace with Y, click the replace all button

19. Save the document, it should be in the same format that it was in when you downloaded it

Note: Now that the document is repaired you should be able to use it as normal.