About this Dataset

Managed Care Performance Monitoring Dashboard Report

This report contains data regarding enrollment demographics, utilization of services, grievances, state fair hearings, provider ratios, encounter completeness, Healthcare Effectiveness Data and Information Set (HEDIS) rates, and medical audit findings.
Organization: State of California
Last updated: 2024-05-14T20:50:56.506617
Tags: california-department-of-health-care-services, demographics, dhcs, encounter, enrollment, grievances, hedis, provider-ratio, state-fair-hearing, utilization

Tables

Encounter Completeness

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.encounter_completeness

9.47 kB
837 rows
5 columns

CREATE TABLE encounter_completeness (
  "cap_flag" VARCHAR,
  "all" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Ethnicity

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.ethnicity

8.44 kB
648 rows
5 columns

CREATE TABLE ethnicity (
  "month" BIGINT,
  "measure_category" VARCHAR,
  "measure_type" VARCHAR,
  "ethnicity_grouping" VARCHAR,
  "count" BIGINT
);

Grievance Demographics

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.grievance_demographics

4.73 kB
68 rows
4 columns

CREATE TABLE grievance_demographics (
  "quarter" VARCHAR,
  "measure_category" VARCHAR,
  "measure_type" VARCHAR,
  "grievances_per_1_000_member_months" DOUBLE
);

Grievance Type

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.grievance_type

5.87 kB
184 rows
4 columns

CREATE TABLE grievance_type (
  "quarter" VARCHAR,
  "grievance_type_roll_up" VARCHAR,
  "grievance_type" VARCHAR,
  "grievances_paces" BIGINT  -- Grievances (PACES)
);

HEDIS

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.hedis

5.78 kB
436 rows
3 columns

CREATE TABLE hedis (
  "hedis_reporting_year" BIGINT,
  "reporting_unit" VARCHAR,
  "aqfs" VARCHAR
);

Population

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.population

7.8 kB
648 rows
5 columns

CREATE TABLE population (
  "month" BIGINT,
  "measure_category" VARCHAR,
  "measure_type" VARCHAR,
  "population_type" VARCHAR,
  "count" BIGINT
);

Provider Ratios

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.provider_ratios

5.73 kB
372 rows
4 columns

CREATE TABLE provider_ratios (
  "plan_parent_reporting_name" VARCHAR,
  "month" BIGINT,
  "pcps_per_2_000_members" BIGINT,
  "physicians_per_1_200_members" BIGINT
);

Table 4

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.table_4

5.85 kB
216 rows
5 columns

CREATE TABLE table_4 (
  "month" BIGINT,
  "measure_category" VARCHAR,
  "measure_type" VARCHAR,
  "sex" VARCHAR,
  "count" BIGINT
);

Table 5

@usgov.ca_gov_managed_care_performance_monitoring_dashboard_r_dba075c0.table_5

7.11 kB
432 rows
5 columns

CREATE TABLE table_5 (
  "month" BIGINT,
  "measure_category" VARCHAR,
  "measure_type" VARCHAR,
  "age_group" VARCHAR,
  "count" BIGINT
);