Facility record report · CMS certification number 035300

MIRABELLA AT ASU

TEMPE, Arizona · 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 October 2023 to 30 September 2024 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 16 April 2025.

Revenue and expenses, fiscal year 2024
Figure	As filed	Where it comes from
Total patient revenue	$6,325,364	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$1,230,122	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$5,095,242	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$40,624,799	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$35,529,557	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$21,578,775	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$13,950,782	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$13,950,782 (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	58	CMS-2540-10 worksheet S300001 line 800 column 100
Bed days available, all components	21,228	CMS-2540-10 worksheet S300001 line 800 column 200
Medicare (Title XVIII) patient days	2,672	CMS-2540-10 worksheet S300001 line 800 column 400
Other-payer patient days	2,189	CMS-2540-10 worksheet S300001 line 800 column 600
Total patient days, all components	4,861	CMS-2540-10 worksheet S300001 line 800 column 700
Medicare discharges	104	CMS-2540-10 worksheet S300001 line 800 column 900
Other-payer discharges	139	CMS-2540-10 worksheet S300001 line 800 column 1100
Total discharges, all components	243	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	25.69	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, all patients, in days	20	CMS-2540-10 worksheet S300001 line 800 column 1600

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

Cost report for 1 October 2022 to 30 September 2023 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 23 May 2024.

Revenue and expenses, fiscal year 2023
Figure	As filed	Where it comes from
Total patient revenue	$4,060,328	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$1,398,019	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,662,309	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$41,142,637	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$38,480,328	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$3,583,840	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$34,896,488	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$34,896,488 (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	58	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,409	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	186	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	19.93	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, all patients, in days	61.34	CMS-2540-10 worksheet S300001 line 800 column 1600

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

Cost report for 9 September 2021 to 30 September 2022 — a reporting period of 386 days, on form CMS-2540-10, settled, processed by CMS on 20 June 2023.

Revenue and expenses, fiscal year 2022
Figure	As filed	Where it comes from
Total patient revenue	$29,172,027	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$810,027	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$28,362,000	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$39,170,457	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$10,808,457	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$1,276,101	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$9,532,356	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$9,532,356 (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	58	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	4,109	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	73	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	23.18	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, all patients, in days	56.29	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1352757, read from the public cost report file SNF10FY2021.zip.

Five facilities of a similar size in Arizona, 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
GSS - PRESCOTT VILLAGE	58	10,095	$3,855,117	$4,752,120	−$897,003	18 November 2024
HAVEN HEALTH PRESCOTT	58	20,098	$9,626,459	$9,969,326	−$342,867	31 December 2024
HAVEN OF CAMP VERDE	58	17,026	$6,200,004	$6,440,610	−$240,606	31 December 2024
HAVEN OF SHOW LOW	60	21,575	$6,470,656	$6,303,956	$166,700	31 December 2024
MIRABELLA AT ASU	58	4,861	$5,095,242	$40,624,799	−$35,529,557	30 September 2024
THE REHAB CENTER AT THE PALAZZO	60	4,599	$1,360,264	$2,318,221	−$957,957	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
WASHINGTON FEDERAL	5% OR GREATER SECURITY INTEREST	Organization	NOT APPLICABLE	since 08/16/2016
DESANTO, VIRGINIA	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 07/21/2016
DILLON, DANIEL	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 01/29/2020
JOLLY, EDWARD	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 07/21/2016
MAYERS, ROBERT	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 10/28/2019
SHOLTY, ERIC	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 07/23/2020
WILSON, DOUG	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 07/21/2016
PACIFIC RETIREMENT SERVICES INC	OPERATIONAL/MANAGERIAL CONTROL	Organization	NOT APPLICABLE	since 04/01/2020
DOROUGH, THOMAS	W-2 MANAGING EMPLOYEE	Individual	NOT APPLICABLE	since 01/01/2020

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of MIRABELLA AT ASU, INC (enrollment ID O20210729001110).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
WASHINGTON FEDERAL	Organization	5% OR GREATER SECURITY INTEREST	100	8/16/2016	Private equity company: No Real estate investment trust: No Holding company: No
DANIEL DILLON	Individual	CORPORATE OFFICER	0	1/29/2020	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.
DOUG WILSON	Individual	CORPORATE OFFICER	0	7/21/2016	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.
EDWARD JOLLY	Individual	CORPORATE OFFICER	0	7/21/2016	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.
ERIC SHOLTY	Individual	CORPORATE OFFICER	0	7/23/2020	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 W MAYERS	Individual	CORPORATE OFFICER	0	10/28/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.
VIRGINIA DESANTO	Individual	CORPORATE OFFICER	0	7/21/2016	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.
PACIFIC RETIREMENT SERVICES INC	Organization	OPERATIONAL/MANAGERIAL CONTROL	100	4/1/2020	Private equity company: No Real estate investment trust: No Holding company: No
THOMAS DOROUGH	Individual	W-2 MANAGING EMPLOYEE	0	1/1/2020	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	8 August 2025	8 August 2025	7	2
2	29 November 2023	29 November 2023	1	0
3	13 October 2022	13 October 2022	3	1

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

Deficiencies cited

11 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
14 November 2025	Health	F 0689	Quality of Life and Care Deficiencies	Ensure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.	D	Yes	Deficient, Provider has date of correction	19 January 2026
8 August 2025	Health	F 0578	Resident Rights Deficiencies	Honor the resident's right to request, refuse, and/or discontinue treatment, to participate in or refuse to participate in experimental research, and to formulate an advance directive.	E	No	Deficient, Provider has date of correction	12 September 2025
8 August 2025	Health	F 0605	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Prevent the use of unnecessary psychotropic medications or use medications that may restrain a resident's ability to function.	D	No	Deficient, Provider has date of correction	12 September 2025
8 August 2025	Health	F 0756	Pharmacy Service Deficiencies	Ensure a licensed pharmacist perform a monthly drug regimen review, including the medical chart, following irregularity reporting guidelines in developed policies and procedures.	E	No	Deficient, Provider has date of correction	24 September 2025
8 August 2025	Health	F 0759	Pharmacy Service Deficiencies	Ensure medication error rates are not 5 percent or greater.	D	No	Deficient, Provider has date of correction	12 September 2025
8 August 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.	E	No	Deficient, Provider has date of correction	12 September 2025
8 August 2025	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	E	No	Deficient, Provider has date of correction	12 September 2025
29 November 2023	Health	F 0609	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Timely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.	E	Yes	Deficient, Provider has date of correction	5 January 2024
13 October 2022	Health	F 0578	Resident Rights Deficiencies	Honor the resident's right to request, refuse, and/or discontinue treatment, to participate in or refuse to participate in experimental research, and to formulate an advance directive.	D	No	Deficient, Provider has date of correction	21 November 2022
13 October 2022	Health	F 0622	Resident Rights Deficiencies	Not transfer or discharge a resident without an adequate reason; and must provide documentation and convey specific information when a resident is transferred or discharged.	D	No	Deficient, Provider has date of correction	21 November 2022
13 October 2022	Health	F 0677	Quality of Life and Care Deficiencies	Provide care and assistance to perform activities of daily living for any resident who is unable.	E	No	Deficient, Provider has date of correction	21 November 2022

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

Penalties

Not yet extracted for this facility.

Care Compare provider information

Field	As filed
Provider Type	Medicare and Medicaid
Ownership Type	Non profit - Corporation
Legal Business Name	MIRABELLA AT ASU, INC
Date First Approved to Provide Medicare and Medicaid Services	2021-09-09
Provider Resides in Hospital	N
Continuing Care Retirement Community	Y
Urban	Y
County/Parish	Maricopa
Telephone Number	6027777701
Chain Name	PACIFIC RETIREMENT SERVICES
Chain ID	391
Provider Changed Ownership in Last 12 Months	N
With a Resident and Family Council	None
Automatic Sprinkler Systems in All Required Areas	Yes
Number of Certified Beds	21
Average Number of Residents per Day	16.7
Overall Rating	3
Health Inspection Rating	3
QM Rating	4
Short-Stay QM Rating	4
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

16 April 2025: A cost report was filed for fiscal year 2024, on form CMS-2540-10. SNF10FY2024.zip
23 May 2024: A cost report was filed for fiscal year 2023, on form CMS-2540-10. SNF10FY2023.zip
20 June 2023: A cost report was filed for fiscal year 2022, on form CMS-2540-10. SNF10FY2021.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, MIRABELLA AT ASU — facility record report, CMS certification number 035300. https://velarionrecords.com/facility/035300/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 2023Q1 to 2026Q1.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 035300. 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
2023Q1	31 March 2023	90	1,227	2,756.93	1,052.52	5,204.19	9,013.64
2023Q2	30 June 2023	91	1,215	2,733.51	1,016.72	5,464.05	9,214.28
2023Q3	30 September 2023	92	1,090	2,377.97	1,087.84	5,251.63	8,717.44
2024Q2	30 June 2024	91	1,401	3,018.35	2,614.1	5,568.02	11,200.47
2024Q3	30 September 2024	92	1,174	3,416.95	1,444.67	4,593.45	9,455.07
2024Q4	31 December 2024	92	1,215	2,537.46	1,670.14	4,406.59	8,614.19
2025Q1	31 March 2025	90	1,220	3,049.7	1,607.02	5,420.13	10,076.85
2025Q2	30 June 2025	91	1,427	2,974.25	1,602.91	4,870.94	9,448.1
2025Q3	30 September 2025	92	1,643	2,302.82	1,630.63	5,780.74	9,714.19
2025Q4	31 December 2025	92	1,617	3,219.66	1,681.82	5,973.72	10,875.2
2026Q1	31 March 2026	90	1,506	3,115.03	1,674.16	5,785.37	10,574.56

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
2023Q1	2.246887	0.8578	4.241394	7.34608
2023Q2	2.249802	0.836807	4.49716	7.58377
2023Q3	2.181624	0.998018	4.818009	7.997651
2024Q2	2.154425	1.865882	3.974318	7.994625
2024Q3	2.91052	1.230554	3.912649	8.053722
2024Q4	2.088444	1.374601	3.626823	7.089868
2025Q1	2.499754	1.31723	4.44273	8.259713
2025Q2	2.084268	1.123273	3.413413	6.620953
2025Q3	1.401595	0.992471	3.518405	5.912471
2025Q4	1.991132	1.040087	3.694323	6.725541
2026Q1	2.068413	1.11166	3.841547	7.02162

How each quarter is derived, and its file

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
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