DATA MODELS

A number of CPYP counties and their partners have developed or found tools to assist them in their work of data collection, data analysis, and outcome measurement. These resources include paper forms as well as electronic databases.

Data Collection Forms

CPYP Counties

This form, developed by CPYP counties, is designed to provide a comprehensive list of all known current and past maternal relatives, paternal relatives, caregivers and other non-relatives such as godparent, friend, teacher, neighbor, etc.
Current Relationships/Past Connections of Affection (MS WORD)

This form, developed by CPYP counties, is a worksheet to be used while searching for potential connections. Information captured includes dates the potential connection appeared in the file, contact information, and follow up ideas.
Intensive Relative Search Contact Information (MS WORD)

 

Dumisha Project

Family Builders by Adoption is working on the Dumisha Project, a five-year federal research project. The agency is tracking demographic data on the youth, as well as service data.

Dumisha Youth and Siblings Referral Form (MS WORD)

Dumisha Monthly Services Form (MS WORD)

 

Orange County

The Brief Impairment Scale (BIS) is a 23-item public domain instrument that evaluates three domains of functioning: interpersonal relations, school/work functioning, and self-care/self-fulfillment instrument. It is structured to be administered by the care provider. It can be done multiple times; retesting not an issue. The county uses the scale as an ancillary instrument to assist with demonstrating cost savings; it is done primarily with contracted workers but also with other cohorts.
Brief Impairment Scale (BIS) (MS WORD)

 

San Mateo County

As part of their work to capture permanency data, San Mateo County uses a Permanency Program Referral Form to start the tracking process.
San Mateo Permanency Program Referral Form (MS WORD)

 

Electronic Tracking/Databases

Dumisha Project

Family Builders by Adoption is working on the Dumisha Project, a five-year federal research project. The agency is tracking demographic data on the youth, as well as service data. For more information on the database or the Dumisha Project, please contact Barbara Turan.
Dumisha Database (Access 2003 required)

 

Los Angeles County

Los Angeles County primarily uses CWS/CMS (Child Welfare Services/Case Management System). However, to obtain more flexibility with CWS/CMS data, the county uses Cognos, which is a web-based system which allows users to extract data from CWS/CMS, analyze it and create reports on the fly. Unfortunately, there is no way to track connection data with CWS/CMS. To address this problem, the county is also using another web-based application, HTML DB, which allows additional fields and information to be added to CWS/CMS people.

 

San Luis Obispo County

The county is using special projects codes in CWS/CMS to track connection status of their youth.
San Luis Obispo Special Project Codes (MS WORD)

 

San Mateo County

San Mateo County uses a fairly simple Excel spreadsheet to track permanency information. The county tracks basic information on the youth (name and birth date), who the youth wants to find, known support people, and persons that have been located and the results of contacts.
San Mateo County Permanency Database (MS EXCEL)

 

Stanislaus County

In order to track data on youth connections, Stanislaus County developed an Access database to capture this information. Where known, the database tracks all family members and other connections by name, birth date, social security number, address, phone number, and relationship to youth. Recently, a screen was added to capture due diligence work for absent parents. Each social worker has an icon for the database on her/his computer desktop. For more information on the database, please contact Karla Self.
Search process documentation (MS WORD)
Stanislaus Youth Connections database (Access 2003 required)