The Data Quality (DQ) Portal has been updated with new data cleansing processes that will cleanse, standardize, and enrich data providing timely, accurate, and consistent information to improve CWS/CMS services as well as contribute to a successful CARES migration. The summary of these processes is as follows:
- SCR 8844 Education Enrollment Closure – Around 1.4 million (66% of total) of open education current enrollments can be closed as the focus client is not on an open case and/or not on an active referral.
- Client Prefix / Suffix Cleanse and Standardization – Standardize around 330,000 clients with erroneous prefix/suffix values.
- SCR 8776 SSN Cleanse for CARES – Remove 162,000 SSNs for Client & SCP that do not meet rules as set by the social security administration (SSA).
- SCR 8935 Reporter Badge Number Cleanse for CARES – Move badge number from last name to the appropriate badge number field for around 70,000 reporters.
- SCR 8955 Other Adult Name Update – After R9.3, new explicit first/last name fields exist for other adults in home. This process will perform the data parse and population from the existing single name field for the existing 250,000 records.
- SCR 8840 Placement Home Name Standardization – Change county-created FFACRFH & FFACH home names to emulate LIS standards to assist in searches and reduce duplicates for 120,000 homes.
- Information documents & sign-up links for the above processes can be found on the ‘Data Cleansing Instructions’ page, see sections 3.1 Fully Automated & 3.2 County Validation.
- The ‘Auto-Clean Frequency’ page that summarizes all cleansing and their run frequency has also been updated.
- To see what your county has signed up for, the ‘Auto-Cleanup Counties’ page has been updated.
Visit the DQ Portal and review the above mentioned SCR’s.
