DSP Cleaning Tool for NACCRRAWare Users

1
DSP Cleaning Tool for NACCRRAWare Users
2
Overview

• What is the DSP Cleaning Tool?
• Installing the DSP Cleaning Tool?
• How does the DSP Cleaning Tool work?
• Questions

3
DSP Cleaning Tool

• Checks for missing and miscoded DSP fields
• Client Reports
• Provider Reports
• ACCESS Database
• Links to excel tables exported from NW
• Contains queries to search exported tables.
• Provides Reports of client provider ids

4
Installing the DSP Cleaning Tool

• You will first need to install the DSP Cleaning
  tool folder onto your C Drive

5
Installing the DSP Cleaning Tool

• The folder contains
• Access database
• Excel files client provider information
• DSP Check Instructions

6

• Once the database is in place, log onto
  NACCRRAWare

7

• Follow Instructions for Custom Search Reports
• Create Save DSP Provider Custom Report
• Select provider fields needed for checks
• Create Save DSP Client Custom Report
• Select client fields needed for checks.

8
Provider Custom Search-Fields Selectdo not
select any fields
9

• Do not enter a query
• Run the custom report

10

• Select fields from the General Section
• Ex. First Name, Last Name, Business Name, Type of
  Care, Area Code, Phone, etc.

11

• Select fields from the Shifts Section
• Ex. Days of Care, Full/Part Time Care, Year
  Schedule

12

• Review all fields for export

13

• Save the report name
• Run the custom report

14

• Create multiple files

15
Right click on each file to save it to your
desktop
16

• Save files in the DSP Data Check folder
• Change files to Excel files (.xls)
• Tables are linked to the ACCESS database

17

• Change filename to existing excel file name
• Change file extension to excel (.xls)
• Change Save as type to All files

18
Running the DSP Checks

• Open the DSP_DataCheck database

19

• The Reports Screen will pop up
• Listed are each report available by Client or
  Provider

20
Examples of reports

• Client Reports
• Duplicate Client names
• Childs Age Care Needed has been left blank
• Evening Care entered Incorrectly
• Provider Reports
• Duplicate name or business name
• Duplicate phone number
• Total capacity was left blank

21
Report Results
22

• IDs can be checked on the NW database to make
  corrections.
• Enter IDs into the NW search page to check records

23
YOU ARE DONE!

• Repeat this process for each report
• Export files quarterly to clean data
• Contact the Network with questions!
• Carlise King at [phone] or
  carlise_at_rrnetwork.org

24
Questions?