| Name |
workforce-quality-incentive-program-performance |
|---|
| Updated |
2025-04-07 |
|---|
| 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 |
py1-2023-wqip-quarterly-performance-report-1.csv --> wqip_quarterly_performance_report_2023_1
py1-2023-wqip-quarterly-performance-report-2.csv --> wqip_quarterly_performance_report_2023_2
py1-2023-wqip-quarterly-performance-report-3.csv --> wqip_quarterly_performance_report_2023_3
py2-2024-wqip-quarterly-performance-report-1.csv --> wqip_quarterly_performance_report_2024_1
|
|---|
| Updates |
| 2025-04-11 11:47:40 |
|
0 |
| 2025-03-12 19:06:45 |
|
0 |
| 2025-02-02 19:22:01 |
|
0 |
| 2024-12-24 15:38:55 |
|
0 |
| 2024-12-03 14:50:08 |
|
None |
| 2024-12-02 16:32:38 |
|
None |
| 2024-12-02 13:57:17 |
|
None |
| 2024-09-18 13:25:55 |
|
None |
|
|---|