About this Dataset

Adult Population – Performance Dashboard

The Performance Dashboard (formerly Performance Outcomes System) datasets are developed to improve outcomes and inform beneficiaries who receive Medi-Cal Specialty Mental Health Services (SMHS). The intent of the dashboard is to gather information relevant to particular mental health outcomes, which will provide useful summary reports to help ensure 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-10-13T18:14:34.816476
Tags: adult, california-department-of-health-care-services, dhcs, pos, smhs

Tables

Adult SMHS Utilization

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.adult_smhs_utilization

54.8 kB
10,286 rows
6 columns

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

Adult Time To Step Down

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.adult_time_to_step_down

24.67 kB
426 rows
16 columns

CREATE TABLE adult_time_to_step_down (
  "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 Adult Snapshot Report

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.performance_dashboard_adult_snapshot_report

27.84 kB
448 rows
16 columns

CREATE TABLE performance_dashboard_adult_snapshot_report (
  "population_name" VARCHAR,
  "fiscal_year" BIGINT,
  "arrivals_ct" DOUBLE,
  "arrivals_ct_annot" DOUBLE,
  "svc_cont_2yr_ct" DOUBLE,
  "svc_cont_2yr_ct_annot" DOUBLE,
  "svc_cont_ct" DOUBLE,
  "svc_cont_ct_annot" DOUBLE,
  "exiting_ct" DOUBLE,
  "exiting_ct_annot" DOUBLE,
  "arriving_and_exit_ct" DOUBLE,
  "arriving_and_exit_ct_annot" DOUBLE,
  "svc_cont_and_exit_ct" DOUBLE,
  "svc_cont_and_exit_ct_annot" DOUBLE,
  "total_ct" DOUBLE,
  "total_ct_annot" DOUBLE
);