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 CWSDataQuality@osi.ca.gov

Update 7/20/2020 - Data Quality Summer workshop to be held August 12 / 13. See flyer for more info and signing up.

Update 6/10/2020 - January - May 2020 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. Report now contains an index and sheets sorted by newest first.

Update 5/13/2020 - Fuzzy Reports are available. To request reports for SCP, Placement Home and Client (Client available after 5/18/2020) go to the online form: https://cwscms.osi.ca.gov/Portal/CWS-Data-Quality-Portal/Data-Cleansing/Fuzzy-Reports

Update 1/15/2020 - Education Provider Missing School Number Report has been updated showing latest progress on education provider merging

Update 1/14/2020 - November & December 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 1/8/2020 - Updated Semi-Annual Merge Schedule for 2020. Go to Documents > Merges >  Merge Schedule.pdf

Update 11/12/2019 - Signups still available for 2 upcoming cleanup processes. Once the start date commences, County subscription will be via SCR. 1. Service Provider Address Merge 2. Education Provider Merge

Update 11/11/2019 - October 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 11/10/2019 - Two new pages added to the Links section (see right). Auto-cleanup Counties lists the Counties that have responded to the batch cleanup that requires subscription. Auto-cleanup Frequency lists all the recurring batch cleanup processes and the frequency they run.  

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


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
Links
Latest Tweets by Data Quality Team