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