HCAI

Home

Dataset:

Name

workforce-quality-incentive-program-performance

Updated

2025-04-07

CA Dataset

link

Current

True

Tables

wqip_quarterly_performance_report_2023_1

facility_name - varchar(61)
facilityid - varchar(10)
ccn - varchar(6)
hcai_id - varchar(9)
npi - varchar(22)
cna_rate - varchar(8)
raw_score_cna - varchar(13)
cna_days_compliant - varchar(18)
score_cna - varchar(11)
lvn_rate - varchar(8)
raw_score_lvn - varchar(13)
lvn_days_compliant - varchar(18)
score_lvn - varchar(9)
rn_rate - varchar(7)
raw_score_rn - varchar(12)
rn_days_compliant - varchar(17)
score_rn - varchar(8)
total_nursing_rate - varchar(18)
raw_score_total_nursing - varchar(23)
total_nursing_days_compliant - varchar(28)
score_total_nursing - varchar(19)
total_weekend_nursing_rate - varchar(26)
raw_score_weekend - varchar(17)
total_weekend_days_compliant - varchar(28)
score_total_weekend_nursing - varchar(27)
acuity_points_earned - varchar(20)
acuity_possible_points - varchar(22)
acuity_area_score - varchar(17)
staffing_turnover_rate - varchar(22)
turnover_points_earned - varchar(22)
turnover_possible_points - varchar(24)
turnover_area_score - varchar(19)
antipsych_num_pyr - varchar(17)
antipsych_num_pyr_annotation - varchar(28)
antipsych_denom_pyr - varchar(19)
antipsych_denom_pyr_annotation - varchar(30)
antipsych_rate_pyr - varchar(18)
antipsych_rate_pyr_annotation - varchar(29)
antipsych_num - varchar(13)
antipsych_num_annotation - varchar(24)
antipsych_denom - varchar(15)
antipsych_denom_annotation - varchar(26)
antipsych_rate - varchar(14)
antipsych_rate_annotation - varchar(25)
gap_closure_antipsych - varchar(21)
gap_closure_antipsych_annotation - varchar(32)
achievement_points_antipsych - varchar(28)
improvement_points_antipsych - varchar(28)
antipsych_metric_score - varchar(22)
fall_num_pyr - varchar(12)
fall_num_pyr_annotation - varchar(23)
fall_denom_pyr - varchar(14)
fall_denom_pyr_annotation - varchar(25)
fall_rate_pyr - varchar(13)
fall_rate_pyr_annotation - varchar(24)
fall_num - varchar(8)
fall_num_annotation - varchar(19)
fall_denom - varchar(10)
fall_denom_annotation - varchar(21)
fall_rate - varchar(9)
fall_rate_annotation - varchar(20)
gap_closure_fall - varchar(16)
gap_closure_fall_annotation - varchar(27)
achievement_points_fall - varchar(23)
improvement_points_fall - varchar(23)
fall_metric_score - varchar(17)
pu_num_pyr - varchar(10)
pu_num_pyr_annotation - varchar(21)
pu_denom_pyr - varchar(12)
pu_denom_pyr_annotation - varchar(23)
pu_rate_pyr - varchar(11)
pu_rate_pyr_annotation - varchar(22)
pu_num - varchar(6)
pu_num_annotation - varchar(17)
pu_denom - varchar(8)
pu_denom_annotation - varchar(19)
pu_rate - varchar(7)
pu_rate_annotation - varchar(18)
gap_closure_pu - varchar(14)
gap_closure_pu_annotation - varchar(25)
achievement_points_pu - varchar(21)
improvement_points_pu - varchar(21)
pu_metric_score - varchar(15)
mds_points_earned - varchar(17)
mds_points_possible - varchar(19)
raw_mds_score - varchar(13)
mds_data_completeness - varchar(21)
mds_area_score - varchar(14)
medi_cal_share_rate - varchar(19)
medi_cal_share_points_earned - varchar(28)
medi_cal_share_possible_points - varchar(30)
medi_cal_share_area_score - varchar(25)
medi_cal_share_footnote - varchar(140)
re_completeness_rate - varchar(20)
re_completeness_points_earned - varchar(29)
re_completeness_points_possible - varchar(31)
re_completeness_area_score - varchar(26)

wqip_quarterly_performance_report_2023_2

facility_name - varchar(61)
facilityid - varchar(10)
ccn - varchar(6)
hcai_id - varchar(9)
npi - varchar(10)
cna_rate - varchar(8)
raw_score_cna - varchar(13)
cna_days_compliant - varchar(18)
score_cna - varchar(11)
lvn_rate - varchar(8)
raw_score_lvn - varchar(13)
lvn_days_compliant - varchar(18)
score_lvn - varchar(11)
rn_rate - varchar(7)
raw_score_rn - varchar(12)
rn_days_compliant - varchar(17)
score_rn - varchar(11)
total_nursing_rate - varchar(18)
raw_score_total_nursing - varchar(23)
total_nursing_days_compliant - varchar(28)
score_total_nursing - varchar(19)
total_weekend_nursing_rate - varchar(26)
raw_score_weekend - varchar(17)
total_weekend_days_compliant - varchar(28)
score_total_weekend_nursing - varchar(27)
acuity_points_earned - varchar(20)
acuity_possible_points - varchar(22)
acuity_area_score - varchar(17)
staffing_turnover_rate - varchar(22)
turnover_points_earned - varchar(22)
turnover_possible_points - varchar(24)
turnover_area_score - varchar(19)
antipsych_num_pyr - varchar(17)
antipsych_num_pyr_annotation - varchar(28)
antipsych_denom_pyr - varchar(19)
antipsych_denom_pyr_annotation - varchar(30)
antipsych_rate_pyr - varchar(18)
antipsych_rate_pyr_annotation - varchar(29)
antipsych_num - varchar(13)
antipsych_num_annotation - varchar(24)
antipsych_denom - varchar(15)
antipsych_denom_annotation - varchar(26)
antipsych_rate - varchar(14)
antipsych_rate_annotation - varchar(25)
gap_closure_antipsych - varchar(21)
gap_closure_antipsych_annotation - varchar(32)
achievement_points_antipsych - varchar(28)
improvement_points_antipsych - varchar(28)
antipsych_metric_score - varchar(22)
fall_num_pyr - varchar(12)
fall_num_pyr_annotation - varchar(23)
fall_denom_pyr - varchar(14)
fall_denom_pyr_annotation - varchar(25)
fall_rate_pyr - varchar(13)
fall_rate_pyr_annotation - varchar(24)
fall_num - varchar(8)
fall_num_annotation - varchar(19)
fall_denom - varchar(10)
fall_denom_annotation - varchar(21)
fall_rate - varchar(9)
fall_rate_annotation - varchar(20)
gap_closure_fall - varchar(16)
gap_closure_fall_annotation - varchar(27)
achievement_points_fall - varchar(23)
improvement_points_fall - varchar(23)
fall_metric_score - varchar(17)
pu_num_pyr - varchar(10)
pu_num_pyr_annotation - varchar(21)
pu_denom_pyr - varchar(12)
pu_denom_pyr_annotation - varchar(23)
pu_rate_pyr - varchar(11)
pu_rate_pyr_annotation - varchar(22)
pu_num - varchar(6)
pu_num_annotation - varchar(17)
pu_denom - varchar(8)
pu_denom_annotation - varchar(19)
pu_rate - varchar(7)
pu_rate_annotation - varchar(18)
gap_closure_pu - varchar(14)
gap_closure_pu_annotation - varchar(25)
achievement_points_pu - varchar(21)
improvement_points_pu - varchar(21)
pu_metric_score - varchar(15)
mds_points_earned - varchar(17)
mds_points_possible - varchar(19)
raw_mds_score - varchar(13)
mds_data_completeness - varchar(21)
mds_area_score - varchar(14)
medi_cal_share_rate - varchar(19)
medi_cal_share_points_earned - varchar(28)
medi_cal_share_possible_points - varchar(30)
medi_cal_share_area_score - varchar(25)
re_completeness_rate - varchar(20)
re_completeness_points_earned - varchar(29)
re_completeness_points_possible - varchar(31)
re_completeness_area_score - varchar(26)

wqip_quarterly_performance_report_2023_3

facility_name - varchar(61)
facilityid - varchar(10)
ccn - varchar(6)
hcai_id - varchar(9)
npi1 - varchar(10)
npi2 - varchar(10)
npi3 - varchar(10)
cna_rate - varchar(8)
raw_score_cna - varchar(13)
cna_days_compliant - varchar(18)
score_cna - varchar(11)
lvn_rate - varchar(8)
raw_score_lvn - varchar(13)
lvn_days_compliant - varchar(18)
score_lvn - varchar(11)
rn_rate - varchar(7)
raw_score_rn - varchar(12)
rn_days_compliant - varchar(17)
score_rn - varchar(11)
total_nursing_rate - varchar(18)
raw_score_total_nursing - varchar(23)
total_nursing_days_compliant - varchar(28)
score_total_nursing - varchar(19)
total_weekend_nursing_rate - varchar(26)
raw_score_weekend - varchar(17)
total_weekend_days_compliant - varchar(28)
score_total_weekend_nursing - varchar(27)
acuity_points_earned - varchar(20)
acuity_possible_points - varchar(22)
acuity_area_score - varchar(17)
staffing_turnover_rate - varchar(22)
turnover_points_earned - varchar(22)
turnover_possible_points - varchar(24)
turnover_area_score - varchar(19)
antipsych_num_pyr - varchar(17)
antipsych_num_pyr_annotation - varchar(28)
antipsych_denom_pyr - varchar(19)
antipsych_denom_pyr_annotation - varchar(30)
antipsych_rate_pyr - varchar(18)
antipsych_rate_pyr_annotation - varchar(29)
antipsych_num - varchar(13)
antipsych_num_annotation - varchar(24)
antipsych_denom - varchar(15)
antipsych_denom_annotation - varchar(26)
antipsych_rate - varchar(14)
antipsych_rate_annotation - varchar(25)
gap_closure_antipsych - varchar(21)
gap_closure_antipsych_annotation - varchar(32)
achievement_points_antipsych - varchar(28)
improvement_points_antipsych - varchar(28)
antipsych_metric_score - varchar(22)
fall_num_pyr - varchar(12)
fall_num_pyr_annotation - varchar(23)
fall_denom_pyr - varchar(14)
fall_denom_pyr_annotation - varchar(25)
fall_rate_pyr - varchar(13)
fall_rate_pyr_annotation - varchar(24)
fall_num - varchar(8)
fall_num_annotation - varchar(19)
fall_denom - varchar(10)
fall_denom_annotation - varchar(21)
fall_rate - varchar(9)
fall_rate_annotation - varchar(20)
gap_closure_fall - varchar(16)
gap_closure_fall_annotation - varchar(27)
achievement_points_fall - varchar(23)
improvement_points_fall - varchar(23)
fall_metric_score - varchar(17)
pu_num_pyr - varchar(10)
pu_num_pyr_annotation - varchar(21)
pu_denom_pyr - varchar(12)
pu_denom_pyr_annotation - varchar(23)
pu_rate_pyr - varchar(11)
pu_rate_pyr_annotation - varchar(22)
pu_num - varchar(6)
pu_num_annotation - varchar(17)
pu_denom - varchar(8)
pu_denom_annotation - varchar(19)
pu_rate - varchar(7)
pu_rate_annotation - varchar(18)
gap_closure_pu - varchar(14)
gap_closure_pu_annotation - varchar(25)
achievement_points_pu - varchar(21)
improvement_points_pu - varchar(21)
pu_metric_score - varchar(15)
mds_points_earned - varchar(17)
mds_points_possible - varchar(19)
raw_mds_score - varchar(13)
mds_data_completeness - varchar(21)
mds_area_score - varchar(14)
medi_cal_share_rate - varchar(19)
medi_cal_share_points_earned - varchar(28)
medi_cal_share_possible_points - varchar(30)
medi_cal_share_area_score - varchar(25)
re_completeness_rate - varchar(20)
re_completeness_points_earned - varchar(29)
re_completeness_points_possible - varchar(31)
re_completeness_area_score - varchar(26)

wqip_quarterly_performance_report_2024_1

facility_name - varchar(61)
facilityid - varchar(10)
ccn - varchar(6)
hcai_id - varchar(9)
npi1 - varchar(10)
npi2 - varchar(10)
npi3 - varchar(10)
cna_rate - varchar(8)
cna_days_compliant - varchar(18)
lvn_rate - varchar(8)
lvn_days_compliant - varchar(18)
rn_rate - varchar(7)
rn_days_compliant - varchar(17)
total_nursing_rate - varchar(18)
total_nursing_days_compliant - varchar(28)
total_weekend_nursing_rate - varchar(26)
total_weekend_days_compliant - varchar(28)
staffing_turnover_rate - varchar(22)
antipsych_num - varchar(13)
antipsych_num_annotation - varchar(24)
antipsych_denom - varchar(15)
antipsych_denom_annotation - varchar(26)
antipsych_rate - varchar(14)
antipsych_rate_annotation - varchar(25)
fall_num - varchar(8)
fall_num_annotation - varchar(19)
fall_denom - varchar(10)
fall_denom_annotation - varchar(21)
fall_rate - varchar(11)
fall_rate_annotation - varchar(20)
ltmw_num - varchar(8)
ltmw_num_annotation - varchar(19)
ltmw_denom - varchar(10)
ltmw_denom_annotation - varchar(21)
ltmw_rate - varchar(11)
ltmw_rate_annotation - varchar(20)
medi_cal_share_rate - varchar(19)
re_completeness_rate - varchar(20)

Sources

datapackage.json	-
py1-2023-wqip-quarterly-performance-report-1.csv	-	Table: wqip_quarterly_performance_report_2023_1	Updated: 2025-10-11
py1-2023-wqip-quarterly-performance-report-2.csv	-	Table: wqip_quarterly_performance_report_2023_2	Updated: 2025-10-11
py1-2023-wqip-quarterly-performance-report-3.csv	-	Table: wqip_quarterly_performance_report_2023_3	Updated: 2025-10-11
py2-2024-wqip-quarterly-performance-report-1.csv	-	Table: wqip_quarterly_performance_report_2024_1	Fails: 2

Updated