CWS/CMS

1. Child Welfare Services/Case Management System (CWS/CMS)
2. California Automated Response and Engagement System - Live (CARES-Live)
3. Child Welfare Services California Automated Response and Engagement System (CWS-CARES) – In Development

• SPOC, Customer Relations and Specific County Roles and Responsibilities
• Web Administration
• CWDS Meeting Information
• County Resources – including the following:
  • Portals Pages (https://cwds.ca.gov/Portals)
    • Training
    • Business Intelligence
    • Data Quality
    • CWS-CARES Implementation
• CWDS Website (https://cwds.ca.gov/) resources including:
  • CWS/CMS Release Information
  • Data Deletion Request (DDR)
  • System Change Request (SCR)
  • Server Based Computing (SBC)
• CWS-CARES User Resources, including:
  • CWS-CARES Users – Frequently Asked Questions (FAQ)
  • CWDS Glossary
  • CWS-CARES Newsletters
  • RFA Application Process Release Notes
• County Funding Process (Logon Required)
  • Advanced Planning Document
• County Contacts

•  \CODEDIST\Staging\R94

• SCR 8982 – Add Missing Name for Placement Homes (Data Quality) (Prioritized #1) - Application Support Contact: James Sidebotham
• SCR 8983 – Adding Missing Name for Non-Foster Case Facility (Data Quality) (Prioritized #2) - Application Support Contact: James Sidebotham
• SCR 8999 – Update Client Dates out-of-range for CARES (Data Quality) (Prioritized #3) - Application Support Contact: James Sidebotham
• SCR 8985 – Make Name Mandatory for Non-Foster Care Facility (Data Quality) (Prioritized #4) - Application Support Contact: Nora O’Hara
• SCR 8989 – Cleanup Outdated Home Studies (Data Quality) (Prioritized #5) – Application Support Contact: James Sidebotham

• SCR 8843 – Transfer Enrollment between DOE Schools (Data Quality) (Prioritized #6) – Application Support Contact: James Sidebotham
• SCR 8967 – Duplicate Hearing Notebook (Data Quality) (Prioritized #7): Application Support Contact: Nora O’Hara
• SCR 8972 – ACL 22-95 ICWA Mandatory Fields (Data Quality) (Prioritized #8): Application Support Contact: Kim Carpenter
• SCR 8973 – ACL 22-95 ICWA Reminder (Data Quality) (Prioritized #9): Application Support Contact: Gina Blakemore
• SCR 8943 – Expand Merge History Log (Data Quality) (Prioritized #10): Application Support Contact: Kim Carpenter
• SCR 8853 – Validate & Cleanse Collateral Demographic Data (Data Quality) (Prioritized #11) – Application Support Contact: James Sidebotham
• SCR 8852 – Validate & Cleanse Reporter Demographic Data (Data Quality (Prioritized #12) – Application Support Contact: James Sidebotham

•  \CODEDIST\Staging\R94

1. County signifies that they want to receive a copy of the unsupported/infected documents/files by sending an email to the CWDS Customer Relations mailbox (CWS_CustRel@otsi.ca.gov).
2. County provides the Point of Contact within the County to receive the media with the unsupported/infected documents/files, with the following contact information:
   1. Name
   2. Role
   3. Address
   4. Phone Number
   5. Email Address

3. County provides the signatory to be listed on the MOU, with the following information:
   1. Name
   2. Title
   3. Address
   4. Phone Number
   5. Email Address

4. CDSS will use the provided information to draft the MOU.
5. CDSS will send the MOU (signed by CDSS) to the County.
6. County signs the MOU and emails it to the CDSS Contracts and Procurement Services Branch.
7. CDSS or its designee(s) will contact the County to make arrangement for the transfer of the requested files.
8. CDSS or its designee(s) will copy the requested County files to an external storage medium mutually agreed upon by the Parties.
9. CDSS or its designee(s) shall send the external storage medium to County using a secured overnight courier that, at a minimum, requires signature receipt confirmation.
10. County will confirm receipt of the media and the files.
11. Upon county confirmation of files being received, the State may delete the original quarantined files from the CWDS quarantined area after 90 Days. After the original quarantined files have been deleted, the CDSS will terminate the MOU.

1. County submits the signed CDSS MOU requesting release of the files to the County. The MOU shall be signed by the County Director signature/approval. Please see the attached MOU.
2. CDSS or its designee(s) will copy the requested County files to an external storage medium mutually agreed upon by the Parties.
3. CDSS or its designee(s) shall send the external storage medium to County using a secured overnight courier that, at a minimum, requires signature receipt confirmation.
4. County will confirm receipt of the media and the files.
5. Upon county confirmation of files being received, the State may delete the original quarantined files from the CWDS quarantined area after 90 Days.

Please note, if additional infected/unsupported documents/files are identified in the future a County will need to submit -a new MOU to request transfer of those files.
If you are interested in requesting the transfer of files for your county, please send your signed MOU to CWS_CustRel@otsi.ca.gov . Once received CWDS or its designee(s) will contact you to make arrangement for the transfer of the files requested. 
____________________________________________________________________________
February 8, 2024 UPDATE:  The California Department of Social Services (CDSS), the CWDS Project and IBM are still working on determining an approach for sharing with counties the documents that have been quarantined. This decision will take a little longer to complete than originally thought. The updated ETA for the decision is now March 15, 2024. An update will be shared out to everybody once the decision has been made.
In the meantime, the CWDS Office is still awaiting notification from the CWS Directors from a majority of the impacted Counties on your preference to delete or to keep quarantined the affected files. If you have not yet shared your preference, please do so by the extended deadline of February 29, 2024.
____________________________________________________________________________
December 26, 2023 UPDATE:  The California Department of Social Services (CDSS), the CWDS Project and IBM have decided that the safest option is to quarantine the identified infected and unsupported files in CWS/CMS. The files will not be deleted from CWS/CMS, but users will be prevented from opening the affected documents. The affected documents will be saved to a quarantined area of CWS/CMS on Saturday, January 6, 2024. If a CWS/CMS user attempts to open one of the quarantined documents, they will receive the following error message:

Please note that this DRMS 00122 error message is informational only and that the user will be able to continue to work in the CWS/CMS application after receiving the error message.
The CWDS Project and IBM are still looking to receive responses from the CWS Directors indicating their permission to permanently delete these files. Please contact CWDS Customer Relations (CWS_CustRel@otsi.ca.gov) by January 31, 2024, with your decision whether to have IBM delete the files in a batch file deletion process.
__________________________________________________________________________________________
December 18, 2023 UPDATE:  In the attached letter the California Department of Social Services (CDSS) has provided updated guidance to Counties impacted by the CWS/CMS infected and unsupported file cleanup effort.
Please contact CWDS Customer Relations (CWS_CustRel@otsi.ca.gov) with any questions related to this guidance.
_________________________________________________________________________________________
As part of planning for CWS-CARES V1, the CARES Data Conversion team has been performing incremental conversion from CWS/CMS data and documents into CWS-CARES. After the documents are extracted from CWS/CMS, they are scanned to ensure that no viruses are introduced into the CARES environment. During this process, it was discovered that, out of 73 million documents that are stored in the CWS/CMS database, approximately 2,400 documents are infected with a virus or malware. Of these 2,400 documents, 95% were last updated in 2001 or before. 
Further, there are an additional 2,600 files that have an unsupported file extension. 
Due to security concerns, these documents and files cannot be moved into the CWS-CARES application. 
Please NOTE: These infected documents are stored in binary large object (BLOB) format on the mainframe in the Db2 database. As a result, these documents do not affect CWS/CMS data on the mainframe.  However, if the document is opened, the virus can infect the user’s personal computer.   Please ensure that you have a current antivirus operating on your workstation.
If you are receiving this communication, it means that your county is impacted by this issue.  
For each affected County, we will send a report listing the infected files and unsupported file extension files, with additional details pertaining to that County.   The reports will be sent to affected counties after the Kick-off meetings.
Please provide a point of contact including IT Support and Security Officer as appropriate and their information (Name, Email, Role, etc.) for the person that should receive your County’s report no later than 11/8/23. The report will be sent via encrypted email to that person.
Please use this form to provide the point(s) of contact: https://forms.gle/2tXrqpkevqUryxk39
Once Customer Relations receives the point of contact person’s information, they will be invited to the Kick-off meetings scheduled for 11/14/23 and 11/16/23. The intent of those meetings will be to review next steps.  
Action Required
Please provide a point of contact and their information (Name, Email, etc.), using the link above, for the person that should receive your County’s report no later than 11/8/23.

• Please contact one of your County CAD Contacts to request a CAD ID.
  • You can locate your County CAD list of contacts on the CWDS website.
    •  Location: Child Welfare Digital Services (ca.gov) >County Info (TAB)> County Contacts>(Select) your county>(Scroll down to find your) ‘CAD Contact’

• If your County CAD Contact is unavailable, contact IBM, Chris Lovejoy at Chris.Lovejoy@osi.ca.gov, or the CWS Operations Team at cwsoperationsteam@osi.ca.gov

• Accept the meeting invite from OSI-CWS-CAD@osi.ca.gov scheduled for Thursday, August 8, 2024 from 1:00 PM to 3:00 PM.
• Explore the new BI Interface from Friday, August 9, through Friday, September 13.
• If you have issues, contact Chris Lovejoy at Chris.Lovejoy@osi.ca.gov

What is Impacted: CWS/CMS Application

On Friday, June 21, 2024, from 6:00 PM - 7:00 PM the CDE Interface will run to update Education Provider information for public schools, private schools, and school districts in the CWS/CMS application. This update applies to CDE school information only. School information manually created by a CWS/CMS user will not be affected. During this time, users may be unable to perform Education Provider searches in the CWS/CMS application.

Due to differences in data and formatting between CDE and the CWS/CMS application, some otherwise valid Education Providers may be end-dated.  If this occurs, please refer to the Work Around section below. A list of all end-dated Education Providers will be sent to the SPOCs via email as soon as they become available.

Work Around
If an existing CDE Education Provider has been end-dated because of this process, users will need to conduct a search for the current Education Provider and create a new Education Notebook for the client.

Contact
CWDS Customer Relations