Portal CWS Data Quality Portal Data Quality Rules

Data Quality Rules

Data Quality Rules (DQR) are a set of requirements that are used to measure the quality of data within CWS / CMS. Detailed information on DQRs can be found in the 'Data Quality Strategy' document. The following DQRs are being measured by the Data Quality Team.

Rule Description Origin Priority Detailed Report Progress Reference Plan
DQR1001 Attorney records should be unique and not duplicated DQ Issue #61 MED BO DQ1001 Data Quality Portal > Reporting > Duplicate Attorney History Data Quality Portal > Documents > Merges > ‘Manual Merge Attorney Duplicates’ Manual correction of records by County, on an-going basis
DQR1002 Substitute Care Provider (SCP) records should be unique and not duplicated DQ Issue #62 MED Semi-Annual Reports Data Quality Portal > Reporting > Duplicate Substitute Care provider (SCP) History Data Quality Portal > Documents > Merges > ‘Guide to Substitute care Provider Merge Process’ Semi-annual batch merge process
DQR1003 Client records should be unique and not duplicated DQ Issue #4 HIGH Semi-Annual Reports Data Quality Portal > Reporting > Duplicate Client History Data Quality Portal > Documents > Merges > ‘ Guide To Automated Client Batch Merge Process’ Semi-annual batch merge process
DQR1004 Placement Home records should be unique and not duplicated DQ Issue #45 HIGH Semi-Annual Reports Data Quality Portal > Reporting > Duplicate Placement Home History Data Quality Portal > Documents > Merges > ‘Placement Home Semi Annual Batch Merge’ Semi-annual batch merge process
DQR1005 Service Provider records should be unique and not duplicated DQ Issue #21 HIGH Semi-Annual Reports Data Quality Portal > Reporting > Duplicate Service Provider History Data Quality Portal > Documents > Merges > ‘Service Provider Semi Annual Batch Merge’ Semi-annual batch merge process
DQR2001 Addresses stored in the database should comply with USPS standardization DQ Issue #1 HIGH DQT Data Quality Portal > Reporting > Release 7.4 Data Quality Portal > Documents > Address_Standardization > ‘CWSCMS Address Standardization Facts’ Addresses shall be standardized directly in the database through a 3rd party tool initially at 7.4 and then periodically
DQR3001 CA Schools (excluding home schools) should have a CDE Issued school # DQ Issue #381 MED DQT Data Quality Portal > Reporting > Missing School Numbers Data Quality Portal > Documents > Automated Data Correction > ‘Education Providers Missing School Number’ Missing school numbers for applicable education providers shall be updated through an automated process
DQR3002 Placement Homes should have a Licence Number. DQ Issue #372 MED Data Quality Portal > Documents > Placement Home Cleanup - Results Data Quality Portal > Documents > Automated Data Correction > WA1601 Placement Home Cleansing - Statewide - 2017-02-04 Data Quality Portal > Documents > Automated Data Correction > ‘About Placement Home Cleanup’ Homes shall be deleted if there are no historical placements attached - through an automated process