Velarion Records

The 340B register and hospital finances — joined, watched daily, delivered.

Facility record report · CMS certification number 035242

DR GUY GORMAN SR CARE HOME

CHINLE, 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 January 2023 to 31 December 2023 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 17 June 2024.

None of these figures is carried on this report.

CMS report record 1383930, 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 14 July 2023.

None of these figures is carried on this report.

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

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

None of these figures is carried on this report.

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

Cost report for 1 January 2020 to 31 December 2020 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 17 May 2021.

None of these figures is carried on this report.

CMS report record 1283974, read from the public cost report file SNF10FY2020.zip.

Cost report for 1 January 2019 to 31 December 2019 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 16 February 2021.

None of these figures is carried on this report.

CMS report record 1280178, read from the public cost report file SNF10FY2019.zip.

Cost report for 1 January 2018 to 31 December 2018 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 30 August 2019.

None of these figures is carried on this report.

CMS report record 1242915, read from the public cost report file SNF10FY2018.zip.

Cost report for 1 January 2017 to 31 December 2017 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 21 August 2018.

None of these figures is carried on this report.

CMS report record 1208974, read from the public cost report file SNF10FY2017.zip.

Cost report for 1 January 2016 to 31 December 2016 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 20 October 2017.

None of these figures is carried on this report.

CMS report record 1177396, read from the public cost report file SNF10FY2016.zip.

Cost report for 1 January 2014 to 31 December 2014 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 29 April 2015.

None of these figures is carried on this report.

CMS report record 1089352, read from the public cost report file SNF10FY2014.zip.

Cost report for 1 January 2011 to 31 December 2011 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 19 April 2013.

None of these figures is carried on this report.

CMS report record 1027436, read from the public cost report file SNF10FY2011.zip.

Cost report for 1 January 2010 to 31 December 2010 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 22 September 2011.

None of these figures is carried on this report.

CMS report record 418287, read from the public cost report file SNFFY2010.zip.

Cost report for 1 January 2009 to 31 December 2009 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 14 October 2010.

None of these figures is carried on this report.

CMS report record 388367, read from the public cost report file SNFFY2009.zip.

Cost report for 1 January 2008 to 31 December 2008 — a reporting period of 365 days, on form CMS-2540-96, settled, processed by CMS on 19 October 2009.

None of these figures is carried on this report.

CMS report record 357958, read from the public cost report file SNFFY2008.zip.

Cost report for 1 January 2007 to 31 December 2007 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 30 June 2008.

None of these figures is carried on this report.

CMS report record 318406, read from the public cost report file SNFFY2007.zip.

Cost report for 1 January 2006 to 31 December 2006 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 30 April 2008.

None of these figures is carried on this report.

CMS report record 307887, read from the public cost report file SNFFY2006.zip.

Cost report for 1 January 1999 to 31 December 1999 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 26 August 2003.

None of these figures is carried on this report.

CMS report record 157950, read from the public cost report file SNFFY1999.zip.

Cost report for 1 January 1998 to 31 December 1998 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 18 May 1999.

None of these figures is carried on this report.

CMS report record 3694, read from the public cost report file SNFFY1998.zip.

Cost report for 10 July 1997 to 31 December 1997 — a reporting period of 174 days, not a full year, on form CMS-2540-96, settled, processed by CMS on 18 May 1999.

None of these figures is carried on this report.

CMS report record 3692, read from the public cost report file SNFFY1997.zip.

Five facilities of a similar size in Arizona, fiscal year 2023

No other facility in Arizona has a cost report on file for fiscal year 2023 with a bed count to set beside this one.

Ownership, as filed with CMS

Care Compare

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

Owner or managerRoleTypeOwnership percentageAssociation
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.Ownership Data Not AvailableCMS 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.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.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.

Medicare enrollment

Not yet extracted for this facility.

Changes in ownership

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

Inspections

Inspection cycleHealth inspectionFire safety inspectionHealth deficienciesFire safety deficiencies
125 July 202525 July 2025170
227 September 202427 September 2024261
315 September 202315 September 2023213

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

Deficiencies cited

64 deficiencies on file, newest inspection first
Inspection dateInspection typeTagCategoryWhat was citedScope and severityComplaintCorrectedCorrection date
25 July 2025HealthF 0580Resident Rights DeficienciesImmediately tell the resident, the resident's doctor, and a family member of situations (injury/decline/room, etc.) that affect the resident.DYesDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0609Freedom from Abuse, Neglect, and Exploitation DeficienciesTimely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.DYesDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0610Freedom from Abuse, Neglect, and Exploitation DeficienciesRespond appropriately to all alleged violations.DYesDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0627Resident Rights DeficienciesEnsure the transfer/discharge meets the resident's needs/preferences and that the resident is prepared for a safe transfer/discharge.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0640Resident Assessment and Care Planning DeficienciesEncode each resident’s assessment data and transmit these data to the State within 7 days of assessment.DYesDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0641Resident Assessment and Care Planning DeficienciesEnsure each resident receives an accurate assessment.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0657Resident Assessment and Care Planning DeficienciesDevelop the complete care plan within 7 days of the comprehensive assessment; and prepared, reviewed, and revised by a team of health professionals.DYesDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0700Quality of Life and Care DeficienciesTry different approaches before using a bed rail. If a bed rail is needed, the facility must (1) assess a resident for safety risk; (2) review these risks and benefits with the resident/representative; (3) get informed consent; and (4) Correctly install and maintain the bed rail.FYesDeficient, Provider has date of correction22 January 2026
25 July 2025HealthF 0727Nursing and Physician Services DeficienciesHave a registered nurse on duty 8 hours a day; and select a registered nurse to be the director of nurses on a full time basis.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0757Pharmacy Service DeficienciesEnsure each resident’s drug regimen must be free from unnecessary drugs.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0842Resident Assessment and Care Planning DeficienciesSafeguard resident-identifiable information and/or maintain medical records on each resident that are in accordance with accepted professional standards.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0851Administration DeficienciesElectronically submit to CMS complete and accurate direct care staffing information, based on payroll and other verifiable and auditable data.FNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0868Administration DeficienciesHave the Quality Assessment and Assurance group have the required members and meet at least quarterlyDNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0883Infection Control DeficienciesDevelop and implement policies and procedures for flu and pneumonia vaccinations.DNoDeficient, Provider has date of correction22 January 2026
25 July 2025HealthF 0946Administration DeficienciesProvide training in compliance and ethics.DNoDeficient, Provider has date of correction20 November 2025
25 July 2025HealthF 0947Nursing and Physician Services DeficienciesEnsure nurse aides have the skills they need to care for residents, and give nurse aides education in dementia care and abuse prevention.ENoDeficient, Provider has date of correction22 January 2026
27 September 2024HealthF 0550Resident Rights DeficienciesHonor the resident's right to a dignified existence, self-determination, communication, and to exercise his or her rights.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0600Freedom from Abuse, Neglect, and Exploitation DeficienciesProtect each resident from all types of abuse such as physical, mental, sexual abuse, physical punishment, and neglect by anybody.GYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0606Freedom from Abuse, Neglect, and Exploitation DeficienciesNot hire anyone with a finding of abuse, neglect, exploitation, or theft.DYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0609Freedom from Abuse, Neglect, and Exploitation DeficienciesTimely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.DYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0623Resident Rights DeficienciesProvide timely notification to the resident, and if applicable to the resident representative and ombudsman, before transfer or discharge, including appeal rights.EYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0625Resident Rights DeficienciesNotify 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.ENoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0640Resident Assessment and Care Planning DeficienciesEncode each resident’s assessment data and transmit these data to the State within 7 days of assessment.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0641Resident Assessment and Care Planning DeficienciesEnsure each resident receives an accurate assessment.ENoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0644Resident Assessment and Care Planning DeficienciesCoordinate assessments with the pre-admission screening and resident review program; and referring for services as needed.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0656Resident Assessment and Care Planning DeficienciesDevelop and implement a complete care plan that meets all the resident's needs, with timetables and actions that can be measured.ENoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0657Resident Assessment and Care Planning DeficienciesDevelop the complete care plan within 7 days of the comprehensive assessment; and prepared, reviewed, and revised by a team of health professionals.DNoDeficient, Provider has date of correction10 October 2024
27 September 2024HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.EYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0686Quality of Life and Care DeficienciesProvide appropriate pressure ulcer care and prevent new ulcers from developing.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0689Quality of Life and Care DeficienciesEnsure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.HYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0690Quality of Life and Care DeficienciesProvide appropriate care for residents who are continent or incontinent of bowel/bladder, appropriate catheter care, and appropriate care to prevent urinary tract infections.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0712Nursing and Physician Services DeficienciesEnsure that the resident and his/her doctor meet face-to-face at all required visits.DYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0725Nursing and Physician Services DeficienciesProvide enough nursing staff every day to meet the needs of every resident; and have a licensed nurse in charge on each shift.EYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0726Nursing and Physician Services DeficienciesEnsure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.EYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0757Pharmacy Service DeficienciesEnsure each resident’s drug regimen must be free from unnecessary drugs.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0791Quality of Life and Care DeficienciesProvide or obtain dental services for each resident.ENoDeficient, Provider has date of correction28 February 2025
27 September 2024HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.ENoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0838Administration DeficienciesConduct and document a facility-wide assessment to determine what resources are necessary to care for residents competently during both day-to-day operations (including nights and weekends) and emergencies.DNoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0867Administration DeficienciesSet up an ongoing quality assessment and assurance group to review quality deficiencies and develop corrective plans of action.FYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.DYesDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0944Administration DeficienciesConduct mandatory training, for all staff, on the facility’s Quality Assurance and Performance Improvement Program.ENoDeficient, Provider has date of correction28 October 2024
27 September 2024HealthF 0947Nursing and Physician Services DeficienciesEnsure nurse aides have the skills they need to care for residents, and give nurse aides education in dementia care and abuse prevention.EYesDeficient, Provider has date of correction28 October 2024
11 January 2024HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FYesDeficient, Provider has date of correction1 February 2024
15 September 2023HealthF 0583Resident Rights DeficienciesKeep residents' personal and medical records private and confidential.DNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0602Freedom from Abuse, Neglect, and Exploitation DeficienciesProtect each resident from the wrongful use of the resident's belongings or money.DYesDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0609Freedom from Abuse, Neglect, and Exploitation DeficienciesTimely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.EYesDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0610Freedom from Abuse, Neglect, and Exploitation DeficienciesRespond appropriately to all alleged violations.EYesDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0623Resident Rights DeficienciesProvide timely notification to the resident, and if applicable to the resident representative and ombudsman, before transfer or discharge, including appeal rights.ENoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0625Resident Rights DeficienciesNotify 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.ENoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0637Resident Assessment and Care Planning DeficienciesAssess the resident when there is a significant change in conditionDNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0640Resident Assessment and Care Planning DeficienciesEncode each resident’s assessment data and transmit these data to the State within 7 days of assessment.DNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0641Resident Assessment and Care Planning DeficienciesEnsure each resident receives an accurate assessment.ENoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0655Resident Assessment and Care Planning DeficienciesCreate and put into place a plan for meeting the resident's most immediate needs within 48 hours of being admittedDNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0656Resident Assessment and Care Planning DeficienciesDevelop and implement a complete care plan that meets all the resident's needs, with timetables and actions that can be measured.DYesDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.KYesDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0692Quality of Life and Care DeficienciesProvide enough food/fluids to maintain a resident's health.DNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0727Nursing and Physician Services DeficienciesHave a registered nurse on duty 8 hours a day; and select a registered nurse to be the director of nurses on a full time basis.FNoDeficient, Provider has date of correction1 January 2024
15 September 2023HealthF 0758Pharmacy Service DeficienciesImplement gradual dose reductions(GDR) and non-pharmacological interventions, unless contraindicated, prior to initiating or instead of continuing psychotropic medication; and PRN orders for psychotropic medications are only used when the medication is necessary and PRN use is limited.DNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0812Nutrition and Dietary DeficienciesProcure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.FNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0881Infection Control DeficienciesImplement a program that monitors antibiotic use.FNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0895Administration DeficienciesHave a Compliance and Ethics Program.FNoDeficient, Provider has date of correction17 November 2023
15 September 2023HealthF 0947Nursing and Physician Services DeficienciesEnsure nurse aides have the skills they need to care for residents, and give nurse aides education in dementia care and abuse prevention.EYesDeficient, Provider has date of correction17 November 2023

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

Penalties

Penalty dateTypeFine amountPayment denial beganPayment denial, daysFine ID
25 July 2025Payment Denial25 October 202590
27 September 2024Fine$67,074133233
15 September 2023Fine$60,560133149
15 September 2023Payment Denial15 December 202317

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

Care Compare provider information

FieldAs filed
Provider TypeMedicare and Medicaid
Ownership TypeNon profit - Corporation
Legal Business NameLegal Business Name Not Available
Date First Approved to Provide Medicare and Medicaid Services1997-07-10
Provider Resides in HospitalN
Continuing Care Retirement CommunityN
UrbanN
County/ParishApache
Telephone Number9286745216
Special Focus StatusSFF Candidate
Provider Changed Ownership in Last 12 MonthsN
With a Resident and Family CouncilResident
Automatic Sprinkler Systems in All Required AreasYes
Number of Certified Beds80
Average Number of Residents per Day51.1
Overall Rating1
Health Inspection Rating1
QM Rating4
Long-Stay QM Rating4
Processing Date2026-08-01

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

Every change on this record

  • 17 June 2024: A cost report was filed for fiscal year 2023, on form CMS-2540-10. SNF10FY2023.zip
  • 14 July 2023: A cost report was filed for fiscal year 2022, on form CMS-2540-10. SNF10FY2022.zip
  • 20 December 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2021.zip
  • 17 May 2021: A cost report was filed for fiscal year 2020, on form CMS-2540-10. SNF10FY2020.zip
  • 16 February 2021: A cost report was filed for fiscal year 2019, on form CMS-2540-10. SNF10FY2019.zip
  • 30 August 2019: A cost report was filed for fiscal year 2018, on form CMS-2540-10. SNF10FY2018.zip
  • 21 August 2018: A cost report was filed for fiscal year 2017, on form CMS-2540-10. SNF10FY2017.zip
  • 20 October 2017: A cost report was filed for fiscal year 2016, on form CMS-2540-10. SNF10FY2016.zip
  • 29 April 2015: A cost report was filed for fiscal year 2014, on form CMS-2540-10. SNF10FY2014.zip
  • 19 April 2013: A cost report was filed for fiscal year 2011, on form CMS-2540-10. SNF10FY2011.zip
  • 22 September 2011: A cost report was filed for fiscal year 2010, on form CMS-2540-96. SNFFY2010.zip
  • 14 October 2010: A cost report was filed for fiscal year 2009, on form CMS-2540-96. SNFFY2009.zip
  • 19 October 2009: A cost report was filed for fiscal year 2008, on form CMS-2540-96. SNFFY2008.zip
  • 30 June 2008: A cost report was filed for fiscal year 2007, on form CMS-2540-96. SNFFY2007.zip
  • 30 April 2008: A cost report was filed for fiscal year 2006, on form CMS-2540-96. SNFFY2006.zip
  • 26 August 2003: A cost report was filed for fiscal year 1999, on form CMS-2540-96. SNFFY1999.zip
  • 18 May 1999: A cost report was filed for fiscal year 1998, on form CMS-2540-96. SNFFY1998.zip
  • 18 May 1999: A cost report was filed for fiscal year 1997, on form CMS-2540-96. SNFFY1997.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 at a stated confidence, saying what is left unaccounted for, where it does not. 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, DR GUY GORMAN SR CARE HOME — facility record report, CMS certification number 035242. https://velarionrecords.com/facility/035242/report.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 035242. 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
QuarterQuarter endedDays reportedResident daysRegistered nurse hoursLicensed practical nurse hoursNurse aide hoursTotal nurse hours
2017Q131 March 2017905,1222,494.752,52313,88418,901.75
2017Q330 September 2017925,7344,328.51,024.513,444.518,797.5
2018Q131 March 2018905,3893,852.5871.2512,56917,292.75
2018Q230 June 2018915,2863,242.51,352.2513,663.4518,258.2
2018Q431 December 2018925,4193,726.251,534.2513,477.7518,738.25
2019Q131 March 2019905,2414,366.751,49213,492.7519,351.5
2019Q230 June 2019915,2294,460.51,71613,378.519,555
2019Q330 September 2019925,2083,8442,12214,145.2520,111.25
2019Q431 December 2019925,8773,693.252,084.7515,227.2521,005.25
2020Q131 March 2020916,5263,420.252,063.7512,97218,456
2020Q230 June 2020916,2833,1412,525.513,495.2519,161.75
2020Q330 September 2020925,8883,506.52,90413,284.7519,695.25
2020Q431 December 2020925,4313,720.252,45611,117.7517,294
2021Q131 March 2021904,5113,386.252,585.510,087.516,059.25
2021Q330 September 2021925,1723,042.52,464.2511,092.516,599.25
2021Q431 December 2021925,2753,013.53,137.259,89816,048.75
2022Q230 June 2022914,9992,362.252,595.58,79513,752.75
2022Q330 September 2022924,7262,693.253,0048,551.7514,249
2023Q131 March 2023904,3772,596.53,234.758,317.2514,148.5
2023Q230 June 2023914,4412,781.753,403.259,253.515,438.5
2023Q330 September 2023924,4862,210.753,563.757,92813,702.5
2023Q431 December 2023924,9712,173.753,578.57,75813,510.25
2024Q131 March 2024915,2692,193.753,6827,697.513,573.25
2024Q230 June 2024915,1862,2473,149.58,956.2514,352.75
2024Q330 September 2024924,8592,409.752,833.759,540.7514,784.25
2024Q431 December 2024925,0132,684.752,8289,400.7514,913.5
2025Q230 June 2025914,4032,619.754,569.2513,359.2520,548.25
2025Q330 September 2025924,8022,590.52,449.1515,983.2521,022.9
2025Q431 December 2025924,9412,5793,909.7515,70222,190.75
2026Q131 March 2026904,5992,081.753,382.513,365.1518,829.4
Nurse staffing hours per resident day by quarter
QuarterRegistered nurse hours per resident dayLicensed practical nurse hours per resident dayNurse aide hours per resident dayTotal nurse hours per resident day
2017Q10.4870660.4925812.710663.690307
2017Q30.7548830.1786712.3446983.278253
2018Q10.7148820.1616722.3323443.208898
2018Q20.6134130.2558172.5848373.454067
2018Q40.6876270.2831242.4871293.45788
2019Q10.833190.2846782.5744613.69233
2019Q20.8530310.328172.558523.739721
2019Q30.7380950.407452.7160623.861607
2019Q40.6284240.354732.590993.574145
2020Q10.5240960.3162351.9877412.828072
2020Q20.499920.4019582.1478993.049777
2020Q30.5955330.4932072.2562423.344981
2020Q40.6850030.4522192.0470913.184312
2021Q10.7506650.5731552.23623.56002
2021Q30.5882640.476462.1447223.209445
2021Q40.571280.5947391.8763983.042417
2022Q20.4725450.5192041.7593522.7511
2022Q30.5698790.6356331.8095113.015023
2023Q10.5932150.7390341.9002173.232465
2023Q20.6263790.7663252.0836523.476357
2023Q30.4928110.7944161.7672763.054503
2023Q40.4372860.7198751.5606522.717813
2024Q10.416350.6988041.4609032.576058
2024Q20.4332820.6073081.7270052.767595
2024Q30.4959350.5831961.9635213.042653
2024Q40.5355580.5641331.8752742.974965
2025Q20.5949921.0377583.0341244.666875
2025Q30.5394630.5100273.3284574.377947
2025Q40.5219590.7912873.1778994.491146
2026Q10.4526530.7354862.9060994.094238

How each quarter is derived, and its file

  • 2017Q1: 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
  • 2017Q3: 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
  • 2018Q1: 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: 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
  • 2018Q4: 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: 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: 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: 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: 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
  • 2020Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-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_:_2020-03-31.csv
  • 2020Q2: 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: 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: 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: 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
  • 2021Q3: 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: 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
  • 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
  • 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
  • 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