2025 - Annual Batch Merge Data Cleanse Reminder

Batch Merge and Data Cleanses are scheduled on a Weekly, Bi-Monthly, Semi-Annual, and Manually Directed basis.

For information regarding the Batch Merge & Data Cleanse Schedule, Cleansing Instructions, Issues List, FAQs, and other information, please visit the https://cwds.ca.gov/DQP

For additional information regarding the Batch Merge process and reports, please refer to the Automated Client Merge Training Guides located on the Training Portal | Child Welfare Digital Services
 You must have Training Portal access to view the documents. If you do not have access, contact your County's Single Point of Contact (SPOC).

Data Cleanses
  • Update Education Provider School Number
  • Standardize Addresses
  • Education Enrollment Cleanup (SCR8844)
  • End Assignments for Closed Finalized Adoption Cases (SCR 8750)
  • Run Unknown Client Name Standardization (SCR 8842)
  • Validate & Cleanse Client Demographic Data (SCR 8850)
  • SSN Cleansing (SCR 8776)
  • Reporter Badge Number Cleansing (SCR 8935) 
  • Other Adults Cleansing (SCR 8955)
  • Multi Notebook Email Cleansing (SCR 8936)
  • Service Provider NPI data Cleansing (SCR 8954)
  • Staff Person Email Cleansing (SCR 8964)
  • Other Child Data Cleansing (SCR 8961)
  • Illogical Client Relationship Cleansing (SCR 8971)
  • Validate & Cleanse SCP Demographic Data (SCR 8846)
  • Staff Person Email Cleansing (SCR 8964)
  • Deduplication Cleansing of Hearing (SCR 8970)

Batch Merges
  • Bi-monthly Client
  • Semi Annual SCP/Attorney
  • Semi Annual Placement Home/Service Provider
  • Distribute Quarterly SCP/Attorney/Service Provider/Placement Home Reports
  • SCP Deduplication (SCR8912)
  • Run Service Provider Merge (SCR 8794)
  • Run Education Provider De-Duplication - Batch Merge (SCR 8653)
  • Run Service Provider Address Merge


Manually Directed Merges
  • FFACRFH and FFACH Homes (SCR 8856)

Contact the CWS_CustRel@osi.ca.gov if you have any questions.