Insight into ODJFS Child Welfare Dashboards

Overview of Public Facing ODJFS Child Welfare Dashboards February 25, 2019 Ohio SACWIS Project The webinar will begin at 1:00 pm 1

Agenda o Dashboard Background Information o Information on Data o Information on Specific Dashboards Population Periodicity Drilldowns o Questions 2

Background Since July 2016, ODJFS has fielded over 400 data requests The goal for the Public Facing Data Dashboards is to: Decrease the influx of data requests fielded by ODJFS Provide accurate child welfare information for the public Decrease the data requests fielded by each PCSA Transparency

Background Continued ODJFS partnered with Ohio Department of Administrative Services to create a visual dashboard experience. o Tableau was selected as the data visualization tool. Tableau provides an interactive design for users. Users will not be required to have Tableau to use the dashboards. The dashboards will be located on a dedicated URL. Users will be able to manipulate data using predetermined filters within the Tableau dashboard. Data will be refreshed on delay as opposed to real time. The refresh interval will be quarterly. Dashboards will allow users to view Statewide or County specific visualizations.

Data There is no direct transfer of confidential, detailed information from the Office of Families and Children (OFC) to the Department of Administrative Services. Data will be aggregated by OFC in the Oracle database and then extracted and uploaded into the Tableau application. Any ID associated with a Case, Person or Intake will be encrypted prior to the data extract. If the distinct count for a single county is less than 15, the drilldown options for the dashboard will not be available. Certain values have been mapped within the extract. Aggregate Data extracted from Tableau Application UPLOAD

Available Dashboards 1. Point in Time Count of Children in Care the base population for this dashboard is point in time data with a count of children in custody. 2. Point in Time Count of Participants on an Open Child Abuse and Neglect Case the base population for this dashboard is point in time data with a count of active case participants on open cases. 3. Child Abuse and Neglect Referrals and Outcomes the base population for this dashboard is CA/N and Stranger Danger intakes received during a period of time. 4. Children Removed from the Home due to Parental Substance Use/Abuse the base population for this dashboard looks at all removals and displays the percentage of those that have parental substance abuse/use prevalence as a removal reason during a period of time. 5. Adoption Related Summary the base population for this dashboard is children in permanent custody during the period. 6. Summary of Children Removed During the Period the base population for this dashboard is removals during the period. 7. Summary of Children Discharged from Care During the Period the base population for this dashboard is discharges from custody during the time period.

Drilldown Options For All Dashboards Date Period Month and Year This drilldown depends on the Date Period Selected Federal Fiscal Year October 1 September 30 (all dates begin October 1, YYYY) State Fiscal Year July 1 June 30 (all dates begin July 1, YYYY) Calendar Year January 1 December 31 (all dates begin January 1, YYYY) Month (all dates begin with the first day of the Month selected) Federal Fiscal Year State Fiscal Year Calendar Year Month Some dashboards are POINT IN TIME and some are PERIOD OF TIME

Drilldown Options For All Dashboards continued Agency Type Age Group Newborn 2-11 Months 1-3 Years 4-6 Years 7-9 Years 10-12 Years 13-15 Years 16-18 Years 19-21 Years Over 21 Years Unknown Juvenile Court Agencies Includes the 40 Ohio Juvenile Court Agencies Public Child Welfare Agencies Includes the 88 PCSAs Franklin County CSB NYAP Franklin County CSB PFSN (Franklin County Managed Care agencies will be mapped to Franklin County CSB) Ohio Department of Youth Services Dashboards will offer a Statewide count and the ability to view any combination of available agencies.

Dashboard #1 Point in Time Count of Children in Care [POINT IN TIME] Available Drilldown Filters Age Group Custody Type Placement Type Derived from Participant Legal Action Information Legal Action in SACWIS Derived from Case Workload Placements Service Information Placement Type in SACWIS Permanent Congregate Care Family Foster Care Independent Living Kinship Care Other Planned Permanent Living Situation Temporary ROM Report Foster Care Counts Placement Type

P_FOSTER_CARE.CUSTODY_TYPE Agency Authority Court Custody Emergency Custody to Agency Ex-parte Initial VAC Officer Acceptance Temporary Court Order Temporary Custody 1st Extension Temporary Custody 2nd Extension Temporary Custody/Placement and Care VAC 1st 30 day Extension VAC 2nd 30 day Extension PPLA Permanent Custody Permanent Surrender Bridges Care and Placement Court Ordered Prot Sup Court Ordered Prot Sup Ext Temp Court Order Protective Supv Final Tableau Temporary P_FOSTER_CARE.PLACEMENT_TYPE_CODE APPROVED ADOPTIVE HOME EMERGENCY FOSTER CARE FAMILY FOSTER HOME MEDICALLY FRAGILE FOSTER HOME PRE-ADOPTIVE INFANT HOME TREATMENT FOSTER HOME EXCEPTIO TREATMENT FOSTER HOME SPECIAL KINSHIP CARE - NON-RELATIVE HO KINSHIP CARE - PARENT (ICPC) KINSHIP CARE - RELATIVE HOME CHILDREN'S RESIDENTIAL CENTER DETENTION FACILITY EMERGENCY CARE EMERGENCY SHELTER CARE FACILIT GROUP HOME HOSPITAL HOSPITAL ADMISSION NURSING HOME RESIDENTIAL PARENTING HOME INDEPENDENT LIVING RUNAWAY/AWOL TRIAL HOME VISIT NON REIMBURSEABLE SERVICE ROM FINAL TABLEAU Family Foster Care Kinship Care Congregate Care Independent Living Other Adoptive Placement Approved Adoptive Home Emergency Foster Care Family Foster Home Medically Fragile Foster Home Treatment Foster Home Exceptional Needs Treatment Foster Home Special Needs Kimship Care - Non Relative Home Kinship Care - Parent (ICPC) Kinship Care - Relative Home Children's Residential Center Detention Facility Emergency Shelter Care Facility Group Home Hospital Admission Nursing Home Residential Parenting Home Independent Living Other Setting Emergency Care Trial Home Visit Non-Reimbursable Service Runaway/AWOL Unknown Planned Permanent Living Arrangement Permanent Will Not Display in Tableau

Dashboard #2 Point in Time Count of Participants on an Open Child Abuse and Neglect Case [POINT IN TIME] Available Drilldown Filters Age Group Case Category Derived from Case Workload Case Information Case Category in SACWIS Adoption Alternative Response Intake Ongoing Other Traditional Response Intake Young Adult Services

P_CASE_PARTICIPANT.CASE_CATEGORY_CODE Adoption Adoption Only Assess/Invest Alternative Response Ongoing Alternative Response Assessment Ongoing Emancipated Youth Young Adult Services Mapping Default N/A Bridges ICAMA ICPC Final Tableau Adoption Traditional Response Intake Alternative Response Intake Ongoing Young Adult Services Other WILL NOT DISPLAY IN TABLEAU

Dashboard #3 Child Abuse and Neglect Referrals and Outcomes [PERIOD OF TIME] Available Drilldown Filters Screening Decision with Screened Out Reason Screening Decision is derived from Intake Workspace Decision Details Screening Decision in SACWIS Screened Out Reason is Derived from Intake Workspace Decision Details Decision Reason for screening out in SACWIS Screened In Screened In AR Screened Out Currently Being Investigated Screened Out Does Not Meet Criteria for Investigation Screened Out Not Available Screened Out Referred to Another Public Children Services Agency SACWIS Report - Intake Details and Statistics 13

Dashboard #3 Child Abuse and Neglect Referrals and Outcomes [PERIOD OF TIME] Available Drilldown Filters continued Intake Type Disposition Derived from Intake Workspace Basic Intake Type Intake Category in SACWIS Derived from Case Workload Intake Intake Dispositions Disposition in SACWIS Baby Doe/Disabled Infant Emotional Maltreatment Multiple Neglect Physical Abuse Sexual Abuse Stranger Danger Alternative Response Indicated Other Substantiated Unsubstantiated

P_INTAKE_RECEIVED_TEST.SCREENING_DECISION Screened In Screened Out Screened In AR Not Available Information and/or Referral Source Value Missing In Dim Mapping Default Return to Screener P_INTAKE_RECEIVED.SCREENED_OUT_REASON_GRP Screened In Screened In AR Does not meet Criteria for Investigation Currently Being Investigated Referred to Another Public Children Services Agency Screen Out - Referred to Another Public Children Services Agency Not Available Will Not Display In Tableau Final Tableau Screened In Screened In AR Screen Out - Does not meet Criteria for Investigation Screen Out - Currently Being Investigated Screen Out - Not Available Will Not Display In Tableau P_INTAKE_RECEIVED.INTAKE_TYPE Physical Abuse Shaken Baby Physical Abuse Sexual Abuse Medical Neglect Neglect Stranger Danger Multiple Emotional Maltreatment Baby Doe/Disabled Infant Not Available Final Tableau Physical Abuse Sexual Abuse Neglect Stranger Danger Multiple Emotional Maltreatment Baby Doe/Disabled Infant WILL NOT DISPLAY IN TABLEAU

P_INTAKE_RECEIVED.DISPOSITION Substantiated Neglect Substantiated/No Other Indicated Neglect Indicated/No Other Unsubstantiated Alternative Response Family Moved - Unable to Complete A/I Waived: Previously Assessed/Investigated Unable to Locate Case Resolution Completed (Historical) Family Moved - Referred to Appropriate PCSA Not Available Final Tableau Substantiated Indicated Unsubstantiated Alternative Response Other

Dashboard #4 Children Removed from the Home due to Parental Substance Use/Abuse [PERIOD OF TIME] The only available drilldown filters for this dashboard are Date Period, Month/Year, Agency Type and Agency Name. Derived from Case Workload Initial Removal Child Removal from Home Information Selected Removal Reasons in SACWIS Removals With Parental Substance Abuse/Use Prevalence Total Removals Percentage ROM Report Removal Reasons for Children Entering Foster Care

Dashboard #5 Adoption Related Summary [PERIOD OF TIME] Available Drilldown Filters This dashboard utilizes Adoption Measures as Drilldown Filters Available for Adoption Derived from Participant Legal Action Information Legal Action in SACWIS Exit Custody, Not Finalized Derived from Legal Custody/Status Legal Custody Episode & Status Information Legal Status Termination Reason in SACWIS Adoption Finalized Derived from Adoption Finalization Checklist Information Finalization Information Checklist Details Ruling Adoption Finalization Date in SACWIS Distinct count of all children in Permanent Custody during the time period selected. Distinct count of all children who exited Permanent Custody without finalization during the time period selected. Exited Custody Legal Custody/Status Legal Custody Episode & Status Information Custody Episode End Date in SACWIS Distinct count of all children whose Adoption Finalized during the time period selected. Entered Custody Legal Custody/Status Legal Custody Episode & Status Information Custody Episode Start Date in SACWIS Distinct count of all children who exited Permanent Custody status during the time period selected. Distinct count of all children who entered Permanent Custody status during the time period selected.

ROM Report Countdown to Adoption/Other Permanency Number of children who were granted TPR Children adopted or achieved permanency Children who were discharged but did not achieve permanency Children remaining in care Adopted in less than 12 months of TPR 19

Dashboard #6 Summary of Children Removed During the Period [PERIOD OF TIME] Available Drilldown Filters Reason for Termination and Caretaker Structure are dependent on the Removal Reason measure selected Age Group Removal Reason Derived from Case Workload Initial Removal Removal Information Child Removal from Home Information Selected Removal Reasons in SACWIS Custody Type Derived from Participant Legal Action Information Legal Action in SACWIS Caretaker Structure Derived from Case Workload Initial Removal Removal Information Child Removal from Home Information Caretaker Structure in SACWIS Permanent Planned Permanent Living Situation Temporary Abandonment/Relinquishment Abuse Neglect Parental Problems with Child Parent/Family Issues One Parent Household Other Relative Two Parent Household ROM Report Removal Reasons for Children Entering Foster Care

REMOVAL_REASON.REMOVAL_REASON_CODE PHISICALABUSE DV EMOTIONALMALTREATMENTMENTALINJ SEXUALABUSE NEGLECT FAILURETOTHRIVE WITHHOLDINGTREATMENTDISABLEINF ALCOHOLABUSEOFPARENT CARTAKERSINABILITYTOCOPE CHILDDRUGAFFECTED DEATHOFPARENTS DEPENDENCY DRUBABUSEOFPARENT INADEQUATEHOUSING INCARCERATIONOFPARENTS PRENATALALCOHOL PRENATALDRUG SIBLINGREMOVAL CHILDBEHAVIORPROBLEM CHILDOFMINORPARENT CHILDSDISABILITY DELINQUENCY DRUBABUSEOFCHILD PREGNANCY TRUANCY UNRULYSTATUSOFFENDER DSRTCHLD RELINQUISHMENT ROM values Physical Abuse Sexual Abuse Neglect Parent Drug Abuse Parent Alcohol Abuse Inadequate Housing Inability to Cope Incarceration of Parent Death of Parent Child's Behavior Child's Disability Child Drug Abuse Child Alcohol Abuse Abandonment Relinquishment Final Tableau Abuse Neglect Parent/Family Issues Parental Problems with Child Abandonment/Relinquishment

PLACMENT_EPISODE.CARETAKER_STRUCTURE LEGALLYSEPARATED SINGLEFEMALE SINGLEMALE FATHER ONLY MOTHER ONLY STEP-PARENT MARRIEDCOUPLE UNMARRIEDCOUPLE BOTH PARENTS FATHER & STEP-PARENT MOTHER & STEP-PARENT RELATIVES NON-RELATIVE NOT AVAILABLE-HISTORY UNABLETODETERMINE UNKNOWN P_REMOVALS.CARETAKER_STRUCTURE Legally Seperated Single Female Single Male Married Couple Unmarried Couple Final Tableau One Parent Household Two Parent Household Relative Other

P_REMOVALS.CUSTODY_TYPE Agency Authority Court Custody Emergency Custody to Agency Ex-parte Initial VAC Officer Acceptance Temporary Court Order Temporary Custody 1st Extension Temporary Custody 2nd Extension Temporary Custody/Placement and Care VAC 1st 30 day Extension VAC 2nd 30 day Extension PPLA Permanent Custody Permanent Surrender Bridges Care and Placement Court Ordered Prot Sup Court Ordered Prot Sup Ext Temp Court Order Protective Supv Final Tableau Temporary Planned Permanent Living Arrangement Permanent Will Not Display in Tableau

Dashboard #7 Summary of Children Discharged from Care During the Period [PERIOD OF TIME] Available Drilldown Filters Age Group Custody Type Reason for Termination Derived from Case Workload Initial Removal Removal Information Child Removal from Home Information Custody Discharge Reason and Legal Custody/Status Legal Custody Episode & Status Information Termination Reason in SACWIS Derived from Participant Legal Action Information Legal Action in SACWIS Permanent Planned Permanent Living Situation Temporary Not Applicable Reunification with Parent(s) or Primary Caretaker Living with Other Relatives Adoption Emancipation Guardianship Transfer to Another Agency Runaway Death of a Child Missing or Unknown This dashboard will also display the average Days Spent In Custody! ROM Report Federal Discharge Reason

P_DISCHARGES.CUSTODY_TYPE Agency Authority Court Custody Emergency Custody to Agency Ex-parte Initial VAC Officer Acceptance Temporary Court Order Temporary Custody 1st Extension Temporary Custody 2nd Extension Temporary Custody/Placement and Care VAC 1st 30 day Extension VAC 2nd 30 day Extension PPLA Permanent Custody Permanent Surrender Bridges Care and Placement Court Ordered Prot Sup Court Ordered Prot Sup Ext Temp Court Order Protective Supv Final Tableau Temporary Planned Permanent Living Arrangement Permanent Will Not Display in Tableau

LEGAL_STATUS_INFO.REASON_FOR_TERMINATION_CODE CUSTODYTONONREMOVALPARENT CUSTTERMINATED REUNIFICATION VACEXPIRE VACTERMINATED CUSTTOREL ADOPTFINALIZED AGEOFMAJORITY CUSTTOGUARDIAN CUSTTONONREL CHILDINDYS CUSTODYTODYS CUSTTOANOTHERAGENCY AWOLTHRTYDAYS DECEASED INCR60DAYS NOCTWITHBRIDGES NOLNGRPRGELIG ODJFSDISACT RECH21AGEOLD VAPEXPIRED VWITHDRAW PLACEMENT_EPISODE.DISCHARGE_REASON_CODE AWOLABDUCTBYFAMMEM AWOLNONFAMABDUCT LIVNONRF LIVNONRM LIVNONRP LIVWREMF LIVWREMP LIVWREVM RETURNTOPARENT CUSTODYTOOTHERRELATIVE LCKINREL LCKINNR LIVWKINP LIVWKNR ADOPTIONFINALIZED KINNONCAF ADJUDDETERMINUNDERAGE AGE EMANCIPATION INDEPENDENTLIVING INDEPENDENTLIVING18YEARSOLD MARRIAGE MILITARY RETURNTOCUSTODIAN RETURNTOGUARDIAN DISCHARGEDTOANOTHERAGENCY RUNAWAYAWOL CHILDDIED AWOLRUNAWAYWHEREUNKNCONTCW P_DISCHARGES.REASON_FOR_TERMINATION_CODE CUSTODYTONONREMOVALPARENT REUNIFICATION VACTERMINATED CUSTTOREL ADOPTFINALIZED AGEOFMAJORITY CHANGEINCOURT CHNGINCUST CUSTTOGUARDIAN CUSTTONONREL CUSTODYTODYS AWOLTHRTYDAYS DECEASED VAPEXPIRED Final Tableau Reunification with Parent(s) or Primary Caretaker(s) Living with Other Relative(s) Adoption Emancipation Guardianship Transfer to Another Agency Runaway Death of Child Missing or Unknown BRIDGES WILL NOT DISPLAY IN TABLEAU

QUESTIONS?

Contacts: o Chris Beach christopher.beach@jfs.ohio.gov o Jennifer Watson jennifer.Watson@jfs.ohio.gov