200 likes | 543 Views
Team Decision Making (TDM) Database. Anne Abramson Bill Dawson Center for Social Services Research UC Berkeley http://cssr.berkeley.edu/tdm/. What this presentation contains:. An introduction to the data collection process: Paper data collection Child/Youth Form Meeting Form
E N D
Team Decision Making (TDM) Database Anne Abramson Bill Dawson Center for Social Services Research UC Berkeley http://cssr.berkeley.edu/tdm/
What this presentation contains: • An introduction to the data collection process: • Paper data collection • Child/Youth Form • Meeting Form • TDM CA database • A brief overview of the quarterly report process • References and contact information
Overview • TDM CA was developed to assist counties in collecting TDM meeting and child information. • TDM CA allows counties to create basic reports regarding attendance, meeting participants, children involved, etc. • TDM CA data combined with the California Children’s Services Archive (CCSA) will provide counties with outcome data and quarterly report information for self-evaluation.
TDM Data Collection • The TDM Meeting Form and Child/Youth Form capture basic information about the TDM • Forms designed to reduce redundancy with information are available in CWS/CMS • Counties can modify forms to suit their needs as long as basic information remains • Forms mirror TDM CA database
TDM Data Collection Details • Meeting Form captures information about: • Location • Primary reason for meeting • Process (people leaving meeting and why) • Attendance • Children involved
TDM Data Collection Details • Child/Youth Form captures information about: • Youth involvement reason • Decisions (i.e., Change placement, return home) • Recommendation for out of home placement type
Data Collection Detail Summary • VERY important to have Facilitator’s Data Entry Guide (previously called User’s Rules) in place • Keeping track of customization [if applicable] • Consistent use of forms and entry into database by people involved in TDM project
TDM CA Customization Options • Counties can easily customize locations, facilitators, decisions and recommendations during installation process. • Other customization options are possible, such as adding parent level data, but require advanced knowledge of MS Access.
Self-Evaluation and Reporting The quarterly report provides summary information on meeting frequencies, attendance, decisions and outcome information for each meeting type. Much of this information can be pulled from TDM CA. Remaining information will be derived from the California Children's Services Archive (CWS/CMS data).
Reporting Process • Quarterly Reports will be produced in county using TDM database reports and sent to AECF • Semi-Annually, counties will export data from database and send to UC Berkeley to link to CWS/CMS. UCB will then send linked data back to county for completion of report
Section I. Implementation Event A. Entered Placement B. Placement Move C. Exit from Placement 1) County Total (#)[i] 2) Child was focus of associated TDM meeting (#)[ii] (Imm. Risk. + Emerg. Plc.) (Imm. Risk. + Emerg. Plc.) 3) % events with associated TDM meeting (Calculation: I.A2 / I.A1) (Calculation: I.B2 / I.B1) (Calculation: I.C2 / I.C1) Quarterly Report- Sample [i] CWS/CMS Note: with assistance from UCB. [ii] TDM CA: Child Involvement Report Note: with assistance from UCB for Access 97 users.
County UCB Semi-Annual Reporting Process Zipped, password-protected email Enter data TDM CA (MS Access) California Children’s Service Archive (CWS/CMS data) Export file: CWS/CMS IDs, meeting dates (MS Excel) Create Report Export Link using CWS/CMS ID numbers (SAS) Report file: County data, placement data (MS Excel) Enter summary data Quarterly report (MS Word)
TDM CA to CCSA linkage CCSA contains data for all CA counties Linkage allows counties to keep TDM data collection to a minimum, only focusing on items unique to TDM process
Linkage Methods • Counties prepare a report using the export tool, providing UCB with meeting and child information to link • UCB matches children from TDM to CCSA on client numbers • UCB then retrieves child information (placements, moves, demographics) and summary county information
Linkage Methods, con’t UCB returns linked child information and summary county information to the county and they complete the report and send to AECF
Team Decision Making (TDM) Database Documentation and TDM CA available at the TDM CA Support Page: http://cssr.berkeley.edu/tdm/
For more information: Anne Abramson Bill Dawson TDMSupport@lists.berkeley.edu Child Welfare Services (CWS/CMS) Reports http://cssr.berkeley.edu/cwscmsreports/ TDM CA Support Page http://cssr.berkeley.edu/tdm/