Optima Data Management Toolkit

Optima Data Management Guide

The Optima Data Management Guide defines two types of Optima data, identifies common reports, lists basic data definitions, addresses Optima rules, describes recommended practices—all in an effort to create and ensure uniformity, consistency and accuracy in our data management practices across the state.

VIEW NOW

Texas CASA Network Data Definitions

The Texas CASA network has established Data Definitions, for use in key fields in local programs’ Optima systems. Included are Baseline Definitions (relating to statistics, counts and ODM reporting), Advocacy Definitions (relating to Optima Activity Types), and CFE Definitions.

View Now

Texas CASA Custom Reports

This series of reports has been developed for the CASA network. Below is a brief explanation of each of these reports, and in the subsequent pages, please find important detail about each report.

  1. Texas ODM Fiscal Start (BOY) Child-Case Submission – Count of children / cases and demographics at start of Fiscal Year, to be used for ODM BOY report.
  2. Texas ODM Fiscal Start (BOY) Volunteer Submission – Count of assigned volunteers and demographics (on active cases) at start of Fiscal Year, to be used for ODM BOY report.
  3. Texas ODM Quarterly Child-Case Submission – Count of new children / cases in a date range, with demographic and county breakdowns, to be used for ODM quarterly child submissions.
  4. Texas ODM Quarterly Volunteer Submission – Count of new children / cases in a date range, with demographic breakdowns, to be used for ODM quarterly child submissions.
  5. Texas PChV (Percent of Children Served with a Volunteer) – Lists all active children in a date range, and their supervisor and volunteer assignments. Totals all children with and without a volunteer.
  6. Texas VCR (Volunteer-Case Ratio) – Lists all active cases in a date range, and their supervisor and volunteer assignments. Totals all cases with and without a volunteer.
  7. 2-Year Volunteer Retention Rate – Based on the sworn date and discharge date of volunteers; for use in QA.
  8. No Petition/Case Start Date – Lists all active cases missing a Petition/Case Start Date.

Best Additional Helpful Custom Reports

  • COMING SOON – VOCA-CJD, OVAG, CFE: This page will be updated as those reports are published to the network.
  • Activity Types by Case: Lists all Activity Types for Contact Logs completed in a date range for one case. (Great tool for case supervisors!)
  • Document Types by Case: Lists all Document Types entered into a Case in a date range (use the Case Start Date to see all Documents for the case).
  • Document Types by Volunteer: Lists all Document Types entered into a Volunteer File. (Great for checking if a Volunteer has all required documents!)
  • Board Report: Lists children / cases by county, with opens and closes, for a month date range, and shows the previous month for comparison.
  • Case Contacts – by Supervisor – by Date (formerly titled Case Contacts – by Supervisor): Lists all persons contacted on a case, for a date range. Lists ALL occurrences of contact, and for anyone who entered a Contact Log in the case.
  • Texas VOCA Desk Audit Report (formerly titled Texas Tom’s Report): Developed as a one-stop report for all case-related information needed to send for the annual VOCA desk audit. Run for the date range and select all for the other options.
  • Texas Volunteer Contacts – Mileage by Date (formerly called Texas Voca Mileage): Lists all VOLUNTEER made contact logs approved in the date range, by supervisor and case. Suitable for use for totaling Volunteer Hours and Mileage for VOCA/CVC RFRs.
  • Texas Staff Contacts – Mileage by Date (formerly called Texas Voca Supervisor Mileage): Lists all STAFF made contact logs approved in the date range, by supervisor and case. Suitable for use for totaling Staff Mileage for VOCA/CVC RFRs, and for showing staff direct service hours.