Nurse staffing · CMS certification number 415084

Elmhurst Rehabilitation and Healthcare Center

Name: Nurse staffing by quarter — Elmhurst Rehabilitation and Healthcare Center (CCN 415084)
Creator: Velarion Records
License: https://www.cms.gov/about-cms/information-systems/privacy/privacy-policy

Providence, Rhode Island

Hours reported to CMS’s Payroll-Based Journal, one row per quarter, oldest first. The facility’s full record →

Quarter by quarter

Quarter	Quarter ended	Days reported	Resident days	Registered nurse hours	Licensed practical nurse hours	Nurse aide hours	Total nurse hours	Registered nurse hours per resident day	Licensed practical nurse hours per resident day	Nurse aide hours per resident day	Total nurse hours per resident day	How it is derived, and the file
2017Q1	March 31, 2017	90	17,687	15,191.85	4,146.45	40,786.41	60,124.71	0.858927	0.234435	2.306011	3.399373	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_rn_donadmin, hrs_lpn_admin, hrs_na_trn; they are read as hrs_rndon, hrs_lpnadmin, hrs_natrn. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-03-31.csv`
2017Q2	June 30, 2017	91	17,607	16,809.47	4,759.2	38,390.71	59,959.38	0.954704	0.270302	2.180423	3.405429	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin; they are read as hrs_lpnadmin. CMS's file labels its last six hours columns hrs_medaide, hrs_medaide_emp, hrs_rn_donadmin, hrs_na_trn, hrs_natrn_emp, hrs_natrn_ctr; they are read by position as Hrs_MedAide_emp, Hrs_MedAide_ctr, Hrs_NAtrn, Hrs_NAtrn_emp, Hrs_NAtrn_ctr, Hrs_MedAide, the order in which each total equals its employee and contract parts on every row. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv`
2017Q3	September 30, 2017	92	17,302	15,710.32	5,942.25	39,569.01	61,221.58	0.908006	0.343443	2.286962	3.538411	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv`
2017Q4	December 31, 2017	92	17,333	14,336.75	6,854.75	40,485.62	61,677.12	0.827136	0.395474	2.335754	3.558364	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv`
2018Q1	March 31, 2018	90	16,318	14,060	7,673.2	40,065.68	61,798.88	0.861625	0.470229	2.455306	3.78716	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv`
2018Q2	June 30, 2018	91	16,881	13,689.25	7,902.76	40,952.19	62,544.2	0.810926	0.468145	2.425934	3.705006	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv`
2018Q3	September 30, 2018	92	16,888	11,759.9	9,280.7	39,879.55	60,920.15	0.696347	0.549544	2.361413	3.607304	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv`
2018Q4	December 31, 2018	92	17,526	11,380.25	9,947.65	41,236.6	62,564.5	0.649335	0.567594	2.352881	3.569811	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv`
2019Q1	March 31, 2019	90	17,240	9,870.5	11,908.25	41,021.96	62,800.71	0.572535	0.690734	2.379464	3.642733	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv`
2019Q2	June 30, 2019	91	16,350	9,342.2	14,215	41,851.4	65,408.6	0.571388	0.869419	2.559719	4.000526	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv`
2019Q3	September 30, 2019	92	16,703	9,628.5	13,000.18	40,795	63,423.68	0.576453	0.778314	2.442376	3.797143	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv`
2019Q4	December 31, 2019	92	16,908	9,592	13,510.25	40,231.03	63,333.28	0.567305	0.799045	2.379408	3.745758	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv`
2020Q2	June 30, 2020	91	16,528	9,064	13,157.25	32,732.42	54,953.67	0.548403	0.796058	1.980422	3.324883	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv`
2020Q3	September 30, 2020	92	16,571	8,619.63	14,569.75	38,652.7	61,842.08	0.520164	0.879232	2.332551	3.731946	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv`
2020Q4	December 31, 2020	92	14,989	8,786.12	14,100.41	36,868.42	59,754.95	0.586171	0.940717	2.459698	3.986587	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv`
2021Q1	March 31, 2021	90	15,628	8,905.99	14,970.8	37,204.6	61,081.39	0.569874	0.957947	2.380637	3.908459	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv`
2021Q2	June 30, 2021	91	16,345	7,768.7	13,683.64	37,246.93	58,699.27	0.475295	0.837176	2.278797	3.591268	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv`
2021Q3	September 30, 2021	92	16,959	7,057.25	13,178.75	35,690.9	55,926.9	0.416136	0.777095	2.10454	3.297771	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv`
2021Q4	December 31, 2021	92	16,418	7,056	12,448.5	35,701.14	55,205.64	0.429772	0.758223	2.174512	3.362507	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. The file's `incomplete` column flags 0 of this facility's days as 1; those days are included as filed. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv`
2022Q1	March 31, 2022	90	15,497	7,977	10,993.75	35,170	54,140.75	0.514745	0.709411	2.269472	3.493628	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv`
2022Q2	June 30, 2022	91	16,472	11,648.75	9,848	40,407.22	61,903.97	0.707185	0.597863	2.453085	3.758133	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv`
2022Q3	September 30, 2022	92	16,993	10,719.95	13,326.64	41,691.84	65,738.43	0.630845	0.784243	2.453471	3.868559	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv`
2022Q4	December 31, 2022	92	17,083	8,787.5	12,949.5	41,939.52	63,676.52	0.5144	0.758034	2.455044	3.727479	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv`
2023Q1	March 31, 2023	90	16,398	9,545.5	13,678.09	36,468.34	59,691.93	0.582114	0.834132	2.22395	3.640196	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv`
2023Q2	June 30, 2023	91	16,418	9,451.5	13,067	37,776.8	60,295.3	0.575679	0.795895	2.300938	3.672512	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv`
2023Q3	September 30, 2023	92	13,769	9,185.25	10,917.25	33,404.15	53,506.65	0.667096	0.792886	2.42604	3.886023	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv`
2023Q4	December 31, 2023	92	14,564	8,884.61	11,409.72	36,041.6	56,335.93	0.610039	0.783419	2.474705	3.868163	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv`
2024Q1	March 31, 2024	91	14,370	10,039.75	11,340.3	34,938.5	56,318.55	0.69866	0.789165	2.43135	3.919175	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv`
2024Q2	June 30, 2024	91	15,537	10,156	11,685.5	35,942.5	57,784	0.653665	0.752108	2.313349	3.719122	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv`
2024Q3	September 30, 2024	92	16,599	10,571	13,534	37,904.5	62,009.5	0.636846	0.81535	2.283541	3.735737	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv`
2024Q4	December 31, 2024	92	16,481	8,191.7	13,610.75	39,903.03	61,705.48	0.497039	0.825845	2.421153	3.744037	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv`
2025Q1	March 31, 2025	90	15,989	9,292.25	13,830.54	39,905.07	63,027.86	0.581165	0.865003	2.495783	3.941951	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv`
2025Q2	June 30, 2025	91	16,452	8,749.7	13,543.5	41,423.18	63,716.38	0.531832	0.823213	2.51782	3.872865	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv`
2025Q3	September 30, 2025	92	16,223	7,542.15	14,829.75	39,591.25	61,963.15	0.464905	0.914119	2.440439	3.819463	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv`
2025Q4	December 31, 2025	92	16,614	6,926.7	15,576.45	39,004.35	61,507.5	0.416919	0.93755	2.34768	3.702149	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv`
2026Q1	March 31, 2026	90	17,307	7,652.5	14,949.25	39,501.78	62,103.53	0.442162	0.863769	2.282416	3.588347	From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. `Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv`

Every figure on this page is printed as it was banked from the Payroll-Based Journal file named on its row. A figure that does not match its file? Tell us on the corrections page, quoting certification number 415084 and the quarter.