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 |