Facility record report · CMS certification number 165793

The Summit of Bettendorf

Bettendorf, Iowa · Medicare and Medicaid

Finances, as filed

From this facility’s Medicare cost reports on form CMS-2540, each figure with the worksheet, line and column it was read from.

Cost report for 1 January 2024 to 31 December 2024 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 28 August 2025.

Revenue and expenses, fiscal year 2024
Figure	As filed	Where it comes from
Total patient revenue	$6,540,224	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$895,820	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$5,644,404	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$13,727,124	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$8,082,720	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$7,881,494	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$201,226	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$201,226 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2024
Figure	As filed	Where it comes from
Total facility beds, all components	40	CMS-2540-10 worksheet S300001 line 800 column 100
Bed days available, all components	14,640	CMS-2540-10 worksheet S300001 line 800 column 200
Medicare (Title XVIII) patient days	3,329	CMS-2540-10 worksheet S300001 line 800 column 400
Medicaid (Title XIX) patient days	443	CMS-2540-10 worksheet S300001 line 800 column 500
Other-payer patient days	9,481	CMS-2540-10 worksheet S300001 line 800 column 600
Total patient days, all components	13,253	CMS-2540-10 worksheet S300001 line 800 column 700
Medicare discharges	139	CMS-2540-10 worksheet S300001 line 800 column 900
Medicaid discharges	1	CMS-2540-10 worksheet S300001 line 800 column 1000
Other-payer discharges	133	CMS-2540-10 worksheet S300001 line 800 column 1100
Total discharges, all components	273	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	23.95	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	443	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	48.55	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1433879, read from the public cost report file SNF10FY2024.zip.

Cost report for 1 January 2023 to 31 December 2023 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 24 September 2024.

Revenue and expenses, fiscal year 2023
Figure	As filed	Where it comes from
Total patient revenue	$5,669,765	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$683,783	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$4,985,982	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$13,662,051	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$8,676,069	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$6,295,485	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$2,380,584	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$2,380,584 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2023
Figure	As filed	Where it comes from
Total facility beds, all components	40	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	12,110	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	252	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	24.72	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, all patients, in days	48.06	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1395643, read from the public cost report file SNF10FY2023.zip.

Cost report for 1 January 2022 to 31 December 2022 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 13 September 2023.

Revenue and expenses, fiscal year 2022
Figure	As filed	Where it comes from
Total patient revenue	$3,812,957	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$418,065	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$3,394,892	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$9,797,421	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$6,402,529	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$3,226,146	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$3,176,383	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$3,176,383 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2022
Figure	As filed	Where it comes from
Total facility beds, all components	40	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	6,742	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	214	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	18.26	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	41	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	31.5	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1364591, read from the public cost report file SNF10FY2022.zip.

Cost report for 10 November 2021 to 31 December 2021 — a reporting period of 51 days, not a full year, on form CMS-2540-10, settled, processed by CMS on 30 May 2022.

None of these figures is carried on this report.

CMS report record 1317456, read from the public cost report file SNF10FY2022.zip.

Five facilities of a similar size in Iowa, fiscal year 2024

Chosen for having certified bed counts closest to this facility’s, listed by name. Every one filed for the same fiscal year; the day each year ends differs and is shown. Each figure is that facility’s own filing.

Facility	Total facility beds	Total patient days	Net patient revenue	Total operating expenses	Net income from service to patients	Period ended
CARING ACRES NURSING AND REHABILITAT	41	9,975	$1,915,002	$2,235,268	−$320,266	31 December 2024
CORNING SPECIALTY CARE	40	9,618	$2,883,289	$2,721,835	$161,454	31 December 2024
CREST HAVEN CARE CENTER LLC	40	10,350	$2,864,837	$2,963,010	−$98,173	31 December 2024
MONTEZUMA SPECIALTY CARE	41	10,978	$3,315,544	$3,056,480	$259,064	31 December 2024
PREMIER ESTATES 504 LLC	40	10,417	$3,317,211	$3,357,371	−$40,160	31 December 2024
THE SUMMIT OF BETTENDORF	40	13,253	$5,644,404	$13,727,124	−$8,082,720	31 December 2024

Where each column comes from, on every filing in this table: Total facility beds: CMS-2540-10 worksheet S300001 line 800 column 100 · Total patient days: CMS-2540-10 worksheet S300001 line 800 column 700 · Net patient revenue: CMS-2540-10 worksheet G300000 line 300 column 100 · Total operating expenses: CMS-2540-10 worksheet G300000 line 400 column 100 · Net income from service to patients: CMS-2540-10 worksheet G300000 line 500 column 100.

Ownership, as filed with CMS

Care Compare

As filed in the CMS file dated 1 August 2026 (Care Compare ownership).

Owner or manager	Role	Type	Ownership percentage	Association
GENESIS HEALTH SYSTEM	5% OR GREATER DIRECT OWNERSHIP INTEREST	Organization	40%	since 02/21/2019
WESLEYLIFE	5% OR GREATER DIRECT OWNERSHIP INTEREST	Organization	60%	since 02/21/2019
CROPPER, DOUGLAS	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 02/21/2019
HOEKSEMA, NICOLE	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 03/02/2021
KRETZINGER, ROBERT	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 02/21/2019
MALAS, JOSEPH	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 11/16/2021
VANDERWIEL, KRISTY	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 02/21/2019
FLANAGAN, CRAIG	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 02/21/2019
SIMPSON, JANET	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 02/21/2019

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of WELLSPIRE-BETTENDORF LLC (enrollment ID O20210210001211).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
GENESIS HEALTH SYSTEM	Organization	5% OR GREATER DIRECT OWNERSHIP INTEREST	40	2/21/2019	Private equity company: No Real estate investment trust: No Holding company: No
WESLEYLIFE	Organization	5% OR GREATER DIRECT OWNERSHIP INTEREST	60	2/21/2019	Private equity company: No Real estate investment trust: No Holding company: No
DOUGLAS CROPPER	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	2/21/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
KRISTY VANDERWIEL	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	2/21/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
NICOLE LYNN HOEKSEMA	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	3/2/2021	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
ROBERT WILLIAM KRETZINGER	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	2/21/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
CRAIG FLANAGAN	Individual	CORPORATE OFFICER	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	2/21/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JOSEPH MALAS	Individual	DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	11/16/2021	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JANET A SIMPSON	Individual	OPERATIONAL/MANAGERIAL CONTROL	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	2/21/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.

Changes in ownership

No change in ownership appears in the CMS files on record since 20 September 2022.

Inspections

Inspection cycle	Health inspection	Fire safety inspection	Health deficiencies	Fire safety deficiencies
1	18 December 2025	18 December 2025	2	1
2	3 February 2025	3 February 2025	0	3
3	28 March 2024	28 March 2024	7	4

From the Care Compare inspection summary file NH_SurveySummary_Aug2026.csv, processed on 1 August 2026.

Deficiencies cited

9 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
18 December 2025	Health	F 0812	Nutrition and Dietary Deficiencies	Procure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.	D	No	Deficient, Provider has date of correction	2 January 2026
18 December 2025	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	D	No	Deficient, Provider has date of correction	2 January 2026
28 March 2024	Health	F 0623	Resident Rights Deficiencies	Provide timely notification to the resident, and if applicable to the resident representative and ombudsman, before transfer or discharge, including appeal rights.	B	No	Deficient, Provider has date of correction	25 April 2024
28 March 2024	Health	F 0625	Resident Rights Deficiencies	Notify the resident or the resident’s representative in writing how long the nursing home will hold the resident’s bed in cases of transfer to a hospital or therapeutic leave.	D	No	Deficient, Provider has date of correction	25 April 2024
28 March 2024	Health	F 0658	Resident Assessment and Care Planning Deficiencies	Ensure services provided by the nursing facility meet professional standards of quality.	D	Yes	Deficient, Provider has date of correction	25 April 2024
28 March 2024	Health	F 0686	Quality of Life and Care Deficiencies	Provide appropriate pressure ulcer care and prevent new ulcers from developing.	J	Yes	Deficient, Provider has date of correction	15 April 2024
18 September 2023	Health	F 0580	Resident Rights Deficiencies	Immediately tell the resident, the resident's doctor, and a family member of situations (injury/decline/room, etc.) that affect the resident.	D	Yes	Deficient, Provider has date of correction	8 October 2023
18 September 2023	Health	F 0602	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Protect each resident from the wrongful use of the resident's belongings or money.	D	Yes	Deficient, Provider has date of correction	8 October 2023
18 September 2023	Health	F 0658	Resident Assessment and Care Planning Deficiencies	Ensure services provided by the nursing facility meet professional standards of quality.	D	Yes	Deficient, Provider has date of correction	8 October 2023

From the Care Compare health citations file NH_HealthCitations_Aug2026.csv, processed on 1 August 2026.

Penalties

Penalty date	Type	Fine amount	Payment denial began	Payment denial, days	Fine ID
28 March 2024	Fine	$26,358			79427

From the Care Compare penalties file NH_Penalties_Aug2026.csv, processed on 1 August 2026.

Care Compare provider information

Field	As filed
Provider Type	Medicare and Medicaid
Ownership Type	For profit - Limited Liability company
Legal Business Name	WELLSPIRE-BETTENDORF LLC
Date First Approved to Provide Medicare and Medicaid Services	2021-11-10
Provider Resides in Hospital	N
Continuing Care Retirement Community	Y
Urban	Y
County/Parish	Scott
Telephone Number	5152716789
Chain Name	WESLEYLIFE
Chain ID	561
Provider Changed Ownership in Last 12 Months	N
With a Resident and Family Council	Resident
Automatic Sprinkler Systems in All Required Areas	Yes
Number of Certified Beds	39
Average Number of Residents per Day	37.9
Overall Rating	3
Health Inspection Rating	3
QM Rating	3
Long-Stay QM Rating	4
Short-Stay QM Rating	2
Processing Date	2026-08-01

From the Care Compare Provider Information file NH_ProviderInfo_Aug2026.csv, processed on 1 August 2026.

Every change on this record

28 August 2025: A cost report was filed for fiscal year 2024, on form CMS-2540-10. SNF10FY2024.zip
24 September 2024: A cost report was filed for fiscal year 2023, on form CMS-2540-10. SNF10FY2023.zip
13 September 2023: A cost report was filed for fiscal year 2022, on form CMS-2540-10. SNF10FY2022.zip
30 May 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2022.zip

How to read this report

Every figure is printed as the CMS file it came from printed it. Each cost-report figure carries the worksheet, line and column of form CMS-2540 it was read from, so a reader holding the same public file can go to that cell; each Care Compare and Medicare enrollment section names its file and the date CMS stamped on it.

A figure the filing does not carry is left out, and so is a figure whose value the filing’s own arithmetic contradicts. Net income is printed with what the form’s own arithmetic shows about it — plainly where it follows from the lines above it, and, where it does not, beside what the form’s own lines leave unaccounted for. An ownership field left empty carries the dated sentence on CMS’s pause of the expanded Form CMS-855A disclosure. A source that holds nothing for this facility says so in its section.

This report carries no percentile and no score, and it does not place this facility above or below another. The five facilities above are the one comparison it draws: the nearest certified bed counts in the same state at the same fiscal year, listed by name. Nurse staffing is printed in its own section, on its own page, apart from the cost-report figures.

How to cite this report

Velarion Records, The Summit of Bettendorf — facility record report, CMS certification number 165793. https://velarionrecords.com/facility/165793/report.

Cost report figures: CMS Healthcare Cost Report Information System, form CMS-2540-10, publication year 2024, file SNF10FY2024.zip.
Provider information, inspections, deficiencies and penalties: CMS Care Compare, file dated 1 August 2026.
Care Compare ownership: CMS file dated 1 August 2026.
Medicare enrollment ownership: CMS file dated 1 August 2026.
Nurse staffing: CMS Payroll-Based Journal, quarters 2022Q1 to 2026Q1.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 165793. Velarion Records publishes these records as filed.

Nurse staffing, quarter by quarter

Hours this facility reported to CMS’s Payroll-Based Journal, one row per quarter, oldest first, each with how its figures are derived and the file it came from.

Nurse staffing hours by quarter
Quarter	Quarter ended	Days reported	Resident days	Registered nurse hours	Licensed practical nurse hours	Nurse aide hours	Total nurse hours
2022Q1	31 March 2022	90	862	2,223.32	420.75	4,357.11	7,001.18
2022Q2	30 June 2022	91	1,502	1,493.42	711.84	6,048.32	8,253.58
2022Q3	30 September 2022	92	1,715	2,161.32	2,182.9	7,404.16	11,748.38
2022Q4	31 December 2022	92	2,783	4,194.47	2,500.13	8,867.64	15,562.24
2023Q1	31 March 2023	90	2,892	3,920.48	1,570.3	8,855.01	14,345.79
2023Q2	30 June 2023	91	2,564	4,530.65	1,435.52	7,403.05	13,369.22
2023Q3	30 September 2023	92	3,221	3,775.49	1,381.33	10,413.57	15,570.39
2023Q4	31 December 2023	92	3,376	4,270.8	1,778.5	11,367.71	17,417.01
2024Q1	31 March 2024	91	3,427	4,772.8	1,671.34	10,950.42	17,394.56
2024Q2	30 June 2024	91	3,257	4,501.92	1,782.98	10,113.13	16,398.03
2024Q3	30 September 2024	92	3,084	3,191.5	2,522	10,348.27	16,061.77
2024Q4	31 December 2024	92	3,349	3,193.79	2,884.75	11,287.86	17,366.4
2025Q1	31 March 2025	90	3,329	3,653.72	2,282	10,056.47	15,992.19
2025Q2	30 June 2025	91	3,301	3,352	2,478.75	10,056.94	15,887.69
2025Q3	30 September 2025	92	3,488	3,375.13	2,479.75	10,496.96	16,351.84
2025Q4	31 December 2025	92	3,423	3,084.67	2,728.58	10,209.01	16,022.26
2026Q1	31 March 2026	90	3,414	2,321.75	3,108.25	10,190.11	15,620.11

Nurse staffing hours per resident day by quarter
Quarter	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
2022Q1	2.579258	0.488109	5.054652	8.122019
2022Q2	0.994288	0.473928	4.026844	5.49506
2022Q3	1.260245	1.272828	4.317294	6.850367
2022Q4	1.507176	0.898358	3.18636	5.591894
2023Q1	1.355629	0.542981	3.061898	4.960508
2023Q2	1.767024	0.559875	2.887305	5.214204
2023Q3	1.172148	0.428851	3.233024	4.834024
2023Q4	1.265047	0.526807	3.367213	5.159067
2024Q1	1.392705	0.487698	3.195337	5.07574
2024Q2	1.382229	0.54743	3.105045	5.034704
2024Q3	1.034857	0.817769	3.35547	5.208097
2024Q4	0.953655	0.861377	3.370517	5.185548
2025Q1	1.097543	0.685491	3.020868	4.803902
2025Q2	1.01545	0.750909	3.046634	4.812993
2025Q3	0.96764	0.710938	3.00945	4.688028
2025Q4	0.90116	0.797131	2.982474	4.680765
2026Q1	0.680067	0.910442	2.984801	4.57531

How each quarter is derived, and its file

2022Q1: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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

← the facility’s full record