Baselight
Sign In

Workforce & Quality Incentive Program Performance

State of California

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb

Loading...
Loading...

About this Dataset

Workforce & Quality Incentive Program Performance

The Workforce & Quality Incentive Program Quarterly Performance Reports (WQIP) contain the following WQIP metrics: acuity-adjusted staffing, staffing completeness, staffing turnover, MDS clinical metrics, MDS data completeness, claims-based clinical metrics, Medi-Cal disproportionate share metric, and MDS racial and ethnic data completeness. The data set will include the distribution of facility-level scores for the currently available performance period data, as well as a comparison to the benchmark values for the MDS clinical and acuity-adjusted staffing hour metrics. If you need to reference the source for the HCAI IDs used in the Quarterly Performance Report, you can find it at ELMS-OSHPD - Licensed and Certified Healthcare.
Organization: State of California
Last updated: 2025-07-23T15:50:28.372228
Tags: california-department-of-health-care-services, dhcs, healthcare-value, medi-cal, quality-health-care, quality-improvement, snf, workforce, wqip

Tables

Data Dictionary - PY1–2023 WQIP Quarterly Performance Report #1

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.data_dictionary_py1_2023_wqip_quarterly_performance_report_1
  • 5.22 KB
  • 97 rows
  • 4 columns
Loading... 

CREATE TABLE data_dictionary_py1_2023_wqip_quarterly_performance_report_1 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - PY1–2023 WQIP Quarterly Performance Report #2

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.data_dictionary_py1_2023_wqip_quarterly_performance_report_2
  • 6.46 KB
  • 96 rows
  • 4 columns
Loading... 

CREATE TABLE data_dictionary_py1_2023_wqip_quarterly_performance_report_2 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - PY1–2023 WQIP Quarterly Performance Report #3

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.data_dictionary_py1_2023_wqip_quarterly_performance_report_3
  • 6.5 KB
  • 98 rows
  • 4 columns
Loading... 

CREATE TABLE data_dictionary_py1_2023_wqip_quarterly_performance_report_3 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - PY2–2024 WQIP Quarterly Performance Report #1

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.data_dictionary_py2_2024_wqip_quarterly_performance_report_1
  • 4.74 KB
  • 38 rows
  • 4 columns
Loading... 

CREATE TABLE data_dictionary_py2_2024_wqip_quarterly_performance_report_1 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

PY1–2023 WQIP Quarterly Performance Report #2

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.py1_2023_wqip_quarterly_performance_report_2
  • 264.8 KB
  • 1064 rows
  • 96 columns
Loading... 

CREATE TABLE py1_2023_wqip_quarterly_performance_report_2 (
  "facility_name" VARCHAR,
  "facilityid" BIGINT,
  "ccn" VARCHAR,
  "hcai_id" DOUBLE,
  "npi" DOUBLE,
  "cna_rate" DOUBLE,
  "raw_score_cna" BIGINT,
  "cna_days_compliant" DOUBLE,
  "score_cna" DOUBLE,
  "lvn_rate" DOUBLE,
  "raw_score_lvn" BIGINT,
  "lvn_days_compliant" DOUBLE,
  "score_lvn" DOUBLE,
  "rn_rate" DOUBLE,
  "raw_score_rn" BIGINT,
  "rn_days_compliant" DOUBLE,
  "score_rn" DOUBLE,
  "total_nursing_rate" DOUBLE,
  "raw_score_total_nursing" BIGINT,
  "total_nursing_days_compliant" DOUBLE,
  "score_total_nursing" DOUBLE,
  "total_weekend_nursing_rate" DOUBLE,
  "raw_score_weekend" BIGINT,
  "total_weekend_days_compliant" DOUBLE,
  "score_total_weekend_nursing" DOUBLE,
  "acuity_points_earned" DOUBLE,
  "acuity_possible_points" BIGINT,
  "acuity_area_score" DOUBLE,
  "staffing_turnover_rate" DOUBLE,
  "turnover_points_earned" DOUBLE,
  "turnover_possible_points" BIGINT,
  "turnover_area_score" DOUBLE,
  "antipsych_num_pyr" DOUBLE,
  "antipsych_num_pyr_annotation" DOUBLE,
  "antipsych_denom_pyr" DOUBLE,
  "antipsych_denom_pyr_annotation" DOUBLE,
  "antipsych_rate_pyr" DOUBLE,
  "antipsych_rate_pyr_annotation" DOUBLE,
  "antipsych_num" DOUBLE,
  "antipsych_num_annotation" DOUBLE,
  "antipsych_denom" DOUBLE,
  "antipsych_denom_annotation" DOUBLE,
  "antipsych_rate" DOUBLE,
  "antipsych_rate_annotation" DOUBLE,
  "gap_closure_antipsych" DOUBLE,
  "gap_closure_antipsych_annotation" DOUBLE,
  "achievement_points_antipsych" DOUBLE,
  "improvement_points_antipsych" DOUBLE,
  "antipsych_metric_score" DOUBLE,
  "fall_num_pyr" DOUBLE,
  "fall_num_pyr_annotation" DOUBLE,
  "fall_denom_pyr" DOUBLE,
  "fall_denom_pyr_annotation" DOUBLE,
  "fall_rate_pyr" DOUBLE,
  "fall_rate_pyr_annotation" DOUBLE,
  "fall_num" DOUBLE,
  "fall_num_annotation" DOUBLE,
  "fall_denom" DOUBLE,
  "fall_denom_annotation" DOUBLE,
  "fall_rate" DOUBLE,
  "fall_rate_annotation" DOUBLE,
  "gap_closure_fall" DOUBLE,
  "gap_closure_fall_annotation" DOUBLE,
  "achievement_points_fall" DOUBLE,
  "improvement_points_fall" DOUBLE,
  "fall_metric_score" DOUBLE,
  "pu_num_pyr" DOUBLE,
  "pu_num_pyr_annotation" DOUBLE,
  "pu_denom_pyr" DOUBLE,
  "pu_denom_pyr_annotation" DOUBLE,
  "pu_rate_pyr" DOUBLE,
  "pu_rate_pyr_annotation" DOUBLE,
  "pu_num" DOUBLE,
  "pu_num_annotation" DOUBLE,
  "pu_denom" DOUBLE,
  "pu_denom_annotation" DOUBLE,
  "pu_rate" DOUBLE,
  "pu_rate_annotation" DOUBLE,
  "gap_closure_pu" DOUBLE,
  "gap_closure_pu_annotation" DOUBLE,
  "achievement_points_pu" DOUBLE,
  "improvement_points_pu" DOUBLE,
  "pu_metric_score" DOUBLE,
  "mds_points_earned" DOUBLE,
  "mds_points_possible" BIGINT,
  "raw_mds_score" DOUBLE,
  "mds_data_completeness" DOUBLE,
  "mds_area_score" DOUBLE,
  "medi_cal_share_rate" DOUBLE,
  "medi_cal_share_points_earned" BIGINT,
  "medi_cal_share_possible_points" BIGINT,
  "medi_cal_share_area_score" DOUBLE,
  "re_completeness_rate" DOUBLE,
  "re_completeness_points_earned" BIGINT,
  "re_completeness_points_possible" BIGINT,
  "re_completeness_area_score" DOUBLE
);

PY1–2023 WQIP Quarterly Performance Report #3

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.py1_2023_wqip_quarterly_performance_report_3
  • 267.54 KB
  • 1062 rows
  • 98 columns
Loading... 

CREATE TABLE py1_2023_wqip_quarterly_performance_report_3 (
  "facility_name" VARCHAR,
  "facilityid" BIGINT,
  "ccn" VARCHAR,
  "hcai_id" BIGINT,
  "npi1" BIGINT,
  "npi2" DOUBLE,
  "npi3" DOUBLE,
  "cna_rate" DOUBLE,
  "raw_score_cna" BIGINT,
  "cna_days_compliant" DOUBLE,
  "score_cna" DOUBLE,
  "lvn_rate" DOUBLE,
  "raw_score_lvn" BIGINT,
  "lvn_days_compliant" DOUBLE,
  "score_lvn" DOUBLE,
  "rn_rate" DOUBLE,
  "raw_score_rn" BIGINT,
  "rn_days_compliant" DOUBLE,
  "score_rn" DOUBLE,
  "total_nursing_rate" DOUBLE,
  "raw_score_total_nursing" BIGINT,
  "total_nursing_days_compliant" DOUBLE,
  "score_total_nursing" DOUBLE,
  "total_weekend_nursing_rate" DOUBLE,
  "raw_score_weekend" BIGINT,
  "total_weekend_days_compliant" DOUBLE,
  "score_total_weekend_nursing" DOUBLE,
  "acuity_points_earned" DOUBLE,
  "acuity_possible_points" BIGINT,
  "acuity_area_score" DOUBLE,
  "staffing_turnover_rate" DOUBLE,
  "turnover_points_earned" DOUBLE,
  "turnover_possible_points" BIGINT,
  "turnover_area_score" DOUBLE,
  "antipsych_num_pyr" DOUBLE,
  "antipsych_num_pyr_annotation" DOUBLE,
  "antipsych_denom_pyr" DOUBLE,
  "antipsych_denom_pyr_annotation" DOUBLE,
  "antipsych_rate_pyr" DOUBLE,
  "antipsych_rate_pyr_annotation" DOUBLE,
  "antipsych_num" DOUBLE,
  "antipsych_num_annotation" DOUBLE,
  "antipsych_denom" DOUBLE,
  "antipsych_denom_annotation" DOUBLE,
  "antipsych_rate" DOUBLE,
  "antipsych_rate_annotation" DOUBLE,
  "gap_closure_antipsych" DOUBLE,
  "gap_closure_antipsych_annotation" DOUBLE,
  "achievement_points_antipsych" DOUBLE,
  "improvement_points_antipsych" DOUBLE,
  "antipsych_metric_score" DOUBLE,
  "fall_num_pyr" DOUBLE,
  "fall_num_pyr_annotation" DOUBLE,
  "fall_denom_pyr" DOUBLE,
  "fall_denom_pyr_annotation" DOUBLE,
  "fall_rate_pyr" DOUBLE,
  "fall_rate_pyr_annotation" DOUBLE,
  "fall_num" DOUBLE,
  "fall_num_annotation" DOUBLE,
  "fall_denom" DOUBLE,
  "fall_denom_annotation" DOUBLE,
  "fall_rate" DOUBLE,
  "fall_rate_annotation" DOUBLE,
  "gap_closure_fall" DOUBLE,
  "gap_closure_fall_annotation" DOUBLE,
  "achievement_points_fall" DOUBLE,
  "improvement_points_fall" DOUBLE,
  "fall_metric_score" DOUBLE,
  "pu_num_pyr" DOUBLE,
  "pu_num_pyr_annotation" DOUBLE,
  "pu_denom_pyr" DOUBLE,
  "pu_denom_pyr_annotation" DOUBLE,
  "pu_rate_pyr" DOUBLE,
  "pu_rate_pyr_annotation" DOUBLE,
  "pu_num" DOUBLE,
  "pu_num_annotation" DOUBLE,
  "pu_denom" DOUBLE,
  "pu_denom_annotation" DOUBLE,
  "pu_rate" DOUBLE,
  "pu_rate_annotation" DOUBLE,
  "gap_closure_pu" DOUBLE,
  "gap_closure_pu_annotation" DOUBLE,
  "achievement_points_pu" DOUBLE,
  "improvement_points_pu" DOUBLE,
  "pu_metric_score" DOUBLE,
  "mds_points_earned" DOUBLE,
  "mds_points_possible" BIGINT,
  "raw_mds_score" DOUBLE,
  "mds_data_completeness" DOUBLE,
  "mds_area_score" DOUBLE,
  "medi_cal_share_rate" DOUBLE,
  "medi_cal_share_points_earned" BIGINT,
  "medi_cal_share_possible_points" BIGINT,
  "medi_cal_share_area_score" DOUBLE,
  "re_completeness_rate" DOUBLE,
  "re_completeness_points_earned" BIGINT,
  "re_completeness_points_possible" BIGINT,
  "re_completeness_area_score" DOUBLE
);

PY2–2024 WQIP Quarterly Performance Report #1

@usgov.ca_gov_workforce_quality_incentive_program_performance_ee4bb.py2_2024_wqip_quarterly_performance_report_1
  • 124.55 KB
  • 1055 rows
  • 38 columns
Loading... 

CREATE TABLE py2_2024_wqip_quarterly_performance_report_1 (
  "facility_name" VARCHAR,
  "facilityid" BIGINT,
  "ccn" VARCHAR,
  "hcai_id" BIGINT,
  "npi1" BIGINT,
  "npi2" DOUBLE,
  "npi3" DOUBLE,
  "cna_rate" DOUBLE,
  "cna_days_compliant" DOUBLE,
  "lvn_rate" DOUBLE,
  "lvn_days_compliant" DOUBLE,
  "rn_rate" DOUBLE,
  "rn_days_compliant" DOUBLE,
  "total_nursing_rate" DOUBLE,
  "total_nursing_days_compliant" DOUBLE,
  "total_weekend_nursing_rate" DOUBLE,
  "total_weekend_days_compliant" DOUBLE,
  "staffing_turnover_rate" DOUBLE,
  "antipsych_num" DOUBLE,
  "antipsych_num_annotation" DOUBLE,
  "antipsych_denom" DOUBLE,
  "antipsych_denom_annotation" DOUBLE,
  "antipsych_rate" DOUBLE,
  "antipsych_rate_annotation" DOUBLE,
  "fall_num" DOUBLE,
  "fall_num_annotation" DOUBLE,
  "fall_denom" DOUBLE,
  "fall_denom_annotation" DOUBLE,
  "fall_rate" DOUBLE,
  "fall_rate_annotation" DOUBLE,
  "ltmw_num" DOUBLE,
  "ltmw_num_annotation" DOUBLE,
  "ltmw_denom" DOUBLE,
  "ltmw_denom_annotation" DOUBLE,
  "ltmw_rate" DOUBLE,
  "ltmw_rate_annotation" DOUBLE,
  "medi_cal_share_rate" DOUBLE,
  "re_completeness_rate" VARCHAR
);

Share link

Anyone who has the link will be able to view this.