Q: Is the Organization (Org) Data Conversion Workgroup Subject Matter Expert (SME) more of a technical position, policy position, or can it be filled by a Children and Family Services Supervisor or Child Welfare Social Worker?
A: It is recommended the participating Organization’s Subject Matter Experts (SME’s):
- Understand data in the legacy system Child Welfare Services/Case Management System (CWS/CMS)
- Understand how the data is inter-related in CWS/CMS
- Understand data transformation rules.
- Understand data quality concepts.
- Are familiar with database and related concepts, i.e., entities, attributes, data types, relationships, mandatory fields, and list of values (LOVs)
- Are familiar with the current CWS/CMS business model (i.e., Referrals, Allegations, Delivered Services, Cases)
- Have knowledge of County policies and/or County desk procedures that direct specific data entry for a program or interim solution that may have used data fields for data other than their original intent. Sometimes counties have very specific data they want to capture.
- Have knowledge of County business practices (possibly by program) that will help identify the intentional or unintentional use of a field. For example:
- Storing the Corporate Identification Number (CIN) number in a different data field (before the CIN number was added to CWS/CMS)
- Storing a CalWORKs number in a data field intended for something else.
- Storing American Academy of Pediatrics (AAP) and/or Kinship Guardianship Assistance (Kin-GAP) program information in CWS/CMS data fields designated for other programs/placements
- Are familiar with any County unique dropdowns/screens/fields.
- Understand use or misuse of a field to record data that was not the original intent of the data element.