About this Dataset

Performance Dashboard Children And Youth With An Open Child Welfare Case

The Performance Dashboard (formerly Performance Outcomes System) datasets are developed in line with legislative mandates to improve outcomes and inform decision making regarding individuals receiving Medi-Cal Specialty Mental Health Services (SMHS). The Dashboard gathers information relevant to specific mental health outcomes and provides useful summary reports for ongoing quality improvement and to support decision making. Please note: the Excel file Performance Dashboard has been discontinued and replaced with the SMHS Performance Dashboards found on Behavioral Health Reporting (ca.gov).
Organization: State of California
Last updated: 2023-08-12T11:53:25.430890
Tags: california-department-of-health-care-services, dhcs, ocwc, pos, smhs

Tables

Performance Dashboard Demographics Report: Children And Youth With An Open Child Welfare Case

@usgov.ca_gov_performance_dashboard_children_and_youth_with_a_d65773b2.performance_dashboard_demographics_report_children_and_f8c7a297

44.44 KB
5276 rows
9 columns


CREATE TABLE performance_dashboard_demographics_report_children_and_f8c7a297 (
  "population_name" VARCHAR,
  "fiscal_year" BIGINT,
  "demo_grp" VARCHAR,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE,
  "smhs1_ct" DOUBLE,
  "smhs1_ct_annot" DOUBLE,
  "smhs5_ct" DOUBLE,
  "smhs5_ct_annot" DOUBLE
);

Performance Dashboard Time To Step Down Report: Children And Youth With An Open Child Welfare Case

@usgov.ca_gov_performance_dashboard_children_and_youth_with_a_d65773b2.performance_dashboard_time_to_step_down_report_childre_006290f4

19.67 KB
393 rows
16 columns


CREATE TABLE performance_dashboard_time_to_step_down_report_childre_006290f4 (
  "population_name" VARCHAR,
  "fiscal_year" BIGINT,
  "less7_ct" DOUBLE,
  "less7_ct_annot" DOUBLE,
  "between_8and30_ct" DOUBLE,
  "between_8and30_ct_annot" DOUBLE,
  "more30_ct" DOUBLE,
  "more30_ct_annot" DOUBLE,
  "no_step_ct" DOUBLE,
  "no_step_ct_annot" DOUBLE,
  "min_days" DOUBLE,
  "max_days" DOUBLE,
  "mean_days" DOUBLE,
  "median_days" DOUBLE,
  "bene_count" DOUBLE,
  "bene_count_annot" DOUBLE
);

Performance Dashboard Utilization Of SMHS Report: Children And Youth With An Open Child Welfare Case

@usgov.ca_gov_performance_dashboard_children_and_youth_with_a_d65773b2.performance_dashboard_utilization_of_smhs_report_child_3d39ff97

45.02 KB
10121 rows
6 columns


CREATE TABLE performance_dashboard_utilization_of_smhs_report_child_3d39ff97 (
  "population_name" VARCHAR,
  "fiscal_year" BIGINT,
  "svc_desc" VARCHAR,
  "unit_type" VARCHAR,
  "amount" DOUBLE,
  "amount_annot" DOUBLE
);