Adult Population – Performance Dashboard by US Government | Healthcare

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.816474
Tags: adult, california-department-of-health-care-services, dhcs, pos, smhs

Tables

Performance Dashboard Adult Demographics

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.performance_dashboard_adult_demographics

76.65 KB
5826 rows
9 columns


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

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.performance_dashboard_adult_snapshot_report

27.18 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
);

Adult Time To Step Down

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.adult_time_to_step_down

24.1 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
);

Adult SMHS Utilization

@usgov.ca_gov_adult_population_performance_dashboard_67dc9.adult_smhs_utilization

53.52 KB
10286 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
);