CWS Data Quality Portal

Data Quality Announcement Board

Welcome to the CWS Data Quality Portal. You can find all CWS data quality related information and documents here. Register and login to get access to the Issue Priority List.

You must register with your county work email or state work email domain. Public email domains are not allowed. If you have trouble with the registration, please email us at

Update 10/16/2019 - Expected numbers for the planned November 19, 2019 Quarterly processing for SCR8750 Closed Adoption Cases have been posted in Documents > Automated Data Correction > Closed Adoption Cases >  SCR8750_Expected_Numbers_for_2019-11.pdf

Update 10/14/2019 - July, August & September 2019 data added in Documents > Reporting > 'Monthly Manual Merges' - the report that tracks how many merges were performed manually in CWS/CMS by County per month

Update 10/10/2019 - Summary from the 2019 Autumn Data Quality workshop has been posted in Documents > Workshop > 2019-09 Autumn > Data Quality Workshop 2019 Autumn - Summary.pdf

Update 9/30/3029 - Address Standardization Analysis. Review of incorrectly entered "CITY NAME" values that have been corrected as part of the weekly address standardization process. List shows top 10 most popular incorrect values for each County. Data range is from Sep 1, 2018 to Sep 27, 2019.
Go to: Documents > Standardization > Address_Standardization > CITY_NAME_SEP2018-SEP2019.xlsx

Update 8/14/2019 - Data Quality Autumn Workshop dates have been finalized. Fresno=9/17, Orange=9/23, Sacramento=10/1. Information Flyer is here. Sign-up page is here

Update 8/6/2019 - Schedule for SCR8750 (Closed Adoption Case Assignments) Data Cleansing. Located in Documents / Automated Data Correction. Document shall be updated weekly.

Update 7/22/2019 - March, April, May & June 2019 data added in 'Monthly Manual Merges' - the report that tracks how many merges were performed manually in CWS/CMS by County per month

Update 6/24/2019 - Fuzzy Reports are available for Client, Placement Home & SCP to assist in data cleansing. Data as of 6/19/2019. Go here to request the reports

Update 6/3/2019 - New data quality report produced by Pandora for 'Case' information located on the Reporting page 


Latest CWS / CMS Videos

New Service: Get Instant Text Alerts on your phone
Data Quality Portal: How to Self-elect as a Data Quality Analyst
How to Register on the new CWS/CMS Website
Data Quality Portal: How to use the Dashboard / Reporting
Data Quality Portal: How to use the Data Quality Issues List
Latest Tweets by Data Quality Team