Overview of Public Facing ODJFS Child Welfare Dashboards February 25,

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 Decrease the data requests fielded by each PCSA Provide accurate child welfare information for the public Transparen cy

Background Continued o ODJFS partnered with Ohio Department of Administrative Services to create a visual dashboard experience. 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

1. Available Dashboards 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 this dashboard is discharges from custody during the time period. – the base population for

Drilldown Options For All Dashboards Date Period Month and Year This drilldown depends on the Date Period Selected Federal Fiscal Year State Fiscal Year Calendar Year Month 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) Some dashboards are POINT IN TIME and some are PERIOD OF TIME

Drilldown Options For All Dashboards continued Agency Type 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) 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 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 Planned Permanent Living Situation Temporary Congregate Care Family Foster Care Independent Living Kinship Care Other 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 Planned Permanent Living Arrangement Permanent Will Not Display in Tableau P FOSTER CARE.PLACEMENT TYPE CODE ROM FINAL TABLEAU APPROVED ADOPTIVE HOME Adoptive Placement Family Foster Care EMERGENCY FOSTER CARE Approved Adoptive Home Kinship Care FAMILY FOSTER HOME Emergency Foster Care Congregate Care MEDICALLY FRAGILE FOSTER HOME Family Foster Home Independent Living PRE-ADOPTIVE INFANT HOME Medically Fragile Foster Home Other TREATMENT FOSTER HOME EXCEPTIO Treatment Foster Home Exceptional Needs TREATMENT FOSTER HOME SPECIAL Treatment Foster Home Special Needs KINSHIP CARE - NON-RELATIVE HO Kimship Care - Non Relative Home KINSHIP CARE - PARENT (ICPC) Kinship Care - Parent (ICPC) KINSHIP CARE - RELATIVE HOME Kinship Care - Relative Home CHILDREN'S RESIDENTIAL CENTER Children's Residential Center DETENTION FACILITY Detention Facility EMERGENCY CARE Emergency Shelter Care Facility EMERGENCY SHELTER CARE FACILIT Group Home GROUP HOME Hospital Admission HOSPITAL Nursing Home HOSPITAL ADMISSION Residential Parenting Home NURSING HOME Independent Living RESIDENTIAL PARENTING HOME Other Setting INDEPENDENT LIVING Emergency Care RUNAWAY/AWOL Trial Home Visit TRIAL HOME VISIT Non-Reimbursable Service NON REIMBURSEABLE SERVICE Runaway/AWOL Unknown

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 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 Screened In Screened In AR Screen Out - Does not meet Criteria for Investigation Screen Out - Currently Being Investigated Screen Out - Referred to Another Public Children Services Agency Screen Out - Not Available Will Not Display In Tableau 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 Distinct count of all children in Permanent Custody 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 entered Permanent Custody status during the time period selected. Adoption Finalized Derived from Adoption Finalization Checklist Information Finalization Information Checklist Details Ruling Adoption Finalization Date in SACWIS Distinct count of all children whose Adoption Finalized during the time period selected. Exit Custody, Not Finalized Derived from Legal Custody/Status Legal Custody Episode & Status Information Legal Status Termination Reason in SACWIS 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 who exited 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 Custody Type Caretaker Structure Derived from Case Workload Initial Removal Removal Information Child Removal from Home Information Selected Removal Reasons in SACWIS Derived from Participant Legal Action Information Legal Action in SACWIS Derived from Case Workload Initial Removal Removal Information Child Removal from Home Information Caretaker Structure in SACWIS Abandonment/Relinquishment Abuse Neglect Parental Problems with Child Parent/Family Issues Permanent Planned Permanent Living Situation Temporary 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 Offi cer 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 Participant Legal Action Information Legal Action in SACWIS 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 Permanent Planned Permanent Living Situation Temporary This dashboard will also display the average Days Spent In Custody! ROM Report – Federal Discharge Reason 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

P DISCHARGES.CUSTODY TYPE Agency Authority Court Custody Emergency Custody to Agency Ex-parte Initial VAC Offi cer 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 P DISCHARGES.REASON FOR TERMINATION CODE AWOLABDUCTBYFAMMEM CUSTODYTONONREMOVALPARENT AWOLNONFAMABDUCT REUNIFICATION LIVNONRF VACTERMINATED LIVNONRM CUSTTOREL LIVNONRP ADOPTFINALIZED LIVWREMF AGEOFMAJORITY LIVWREMP CHANGEINCOURT LIVWREVM CHNGINCUST RETURNTOPARENT CUSTTOGUARDIAN CUSTODYTOOTHERRELATIVE CUSTTONONREL LCKINREL CUSTODYTODYS LCKINNR AWOLTHRTYDAYS LIVWKINP DECEASED LIVWKNR VAPEXPIRED ADOPTIONFINALIZED KINNONCAF ADJUDDETERMINUNDERAGE AGE EMANCIPATION INDEPENDENTLIVING INDEPENDENTLIVING18YEARSOLD MARRIAGE MILITARY RETURNTOCUSTODIAN RETURNTOGUARDIAN DISCHARGEDTOANOTHERAGENCY RUNAWAYAWOL CHILDDIED AWOLRUNAWAYWHEREUNKNCONTCW 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 – [email protected] o Jennifer Watson – [email protected]