Velarion Records

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

Facility record report · CMS certification number 245263

GLENFIELDS LIVING WITH CARE

GLENCOE, Minnesota · Medicare and Medicaid

Finances, as filed

Not yet extracted for this facility.

Ownership, as filed with CMS

Care Compare

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

Owner or managerRoleTypeOwnership percentageAssociation
ERICKSON, ANGELAADP OF THE SNFIndividualNOT APPLICABLEsince 12/19/2024
PETERSEN, BRYANADP OF THE SNFIndividualNOT APPLICABLEsince 12/19/2024
SCHMIDT, JULIEADP OF THE SNFIndividualNOT APPLICABLEsince 12/19/2024
BUDAHN, KRISTENCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2024
FRITSCH, BRYANCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2016
KUEHN, SCOTTCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2017
PEIRCE, HEATHERCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2021
PETERSEN, BRYANCORPORATE DIRECTORIndividualNOT APPLICABLEsince 07/11/2011
STOLTENBURG, MARYCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2018
TRITABAUGH, SEANCORPORATE DIRECTORIndividualNOT APPLICABLEsince 01/01/2024
DAVIS, BENJAMINCORPORATE OFFICERIndividualNOT APPLICABLEsince 05/15/2023
ERICKSON, ANGELACORPORATE OFFICERIndividualNOT APPLICABLEsince 02/09/2019
KNUDTEN, KRISTINECORPORATE OFFICERIndividualNOT APPLICABLEsince 11/05/2018
ANDERSON, MELEAW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 03/01/2024
BERANEK, LYNNW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 09/04/2023
DAVIS, BENJAMINW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 05/15/2023
ERICKSON, ANGELAW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 02/19/2019
HATLESTAD, JILLW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 11/16/2007
KNUDTEN, KRISTINEW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 11/05/2018
PETERSEN, BRYANW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 07/11/2011
SCHMIDT, JULIEW-2 MANAGING EMPLOYEEIndividualNOT APPLICABLEsince 11/16/2007

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of GLENCOE REGIONAL HEALTH SERVICES (enrollment ID O20080505000752).

OwnerIndividual or organizationRoleOwnership percentageAssociation dateDescribed in the filing as
ANGELA ERICKSONIndividualADP OF THE SNFCMS 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.12/19/2024
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.
BRYAN T PETERSENIndividualADP OF THE SNFCMS 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.12/19/2024
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.
JULIE A SCHMIDTIndividualADP OF THE SNFCMS 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.12/19/2024
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.
BRYAN J FRITSCHIndividualCORPORATE DIRECTORCMS 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.1/1/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.
BRYAN T PETERSENIndividualCORPORATE DIRECTORCMS 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.7/11/2011
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.
HEATHER PEIRCEIndividualCORPORATE DIRECTOR01/1/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.
KRISTEN L BUDAHNIndividualCORPORATE DIRECTOR01/1/2024
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.
MARY K STOLTENBURGIndividualCORPORATE DIRECTOR01/1/2018
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.
SCOTT KUEHNIndividualCORPORATE DIRECTOR01/1/2017
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.
SEAN DAVID TRITABAUGHIndividualCORPORATE DIRECTOR01/1/2024
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.
ANGELA ERICKSONIndividualCORPORATE OFFICERCMS 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/9/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.
BENJAMIN DAVISIndividualCORPORATE OFFICER05/15/2023
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.
KRISTINE L KNUDTENIndividualCORPORATE OFFICER011/5/2018
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.
ANGELA ERICKSONIndividualW-2 MANAGING EMPLOYEECMS 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/19/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.
BENJAMIN DAVISIndividualW-2 MANAGING EMPLOYEE05/15/2023
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.
BRYAN T PETERSENIndividualW-2 MANAGING EMPLOYEE07/11/2011
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.
JILL M HATLESTADIndividualW-2 MANAGING EMPLOYEECMS 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/2007
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.
JULIE A SCHMIDTIndividualW-2 MANAGING EMPLOYEE011/16/2007
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.
KRISTINE L KNUDTENIndividualW-2 MANAGING EMPLOYEECMS 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/5/2018
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.
LYNN KATHRYN BERANEKIndividualW-2 MANAGING EMPLOYEE09/4/2023
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.
MELEA R ANDERSONIndividualW-2 MANAGING EMPLOYEE03/1/2024
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

Inspections

Inspection cycleHealth inspectionFire safety inspectionHealth deficienciesFire safety deficiencies
15 June 20255 June 202543
218 April 202418 April 2024010
330 August 202330 August 202342

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

Deficiencies cited

8 deficiencies on file, newest inspection first
Inspection dateInspection typeTagCategoryWhat was citedScope and severityComplaintCorrectedCorrection date
5 June 2025HealthF 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.DNoDeficient, Provider has date of correction26 July 2025
5 June 2025HealthF 0684Quality of Life and Care DeficienciesProvide appropriate treatment and care according to orders, resident’s preferences and goals.DNoDeficient, Provider has date of correction26 July 2025
5 June 2025HealthF 0688Quality of Life and Care DeficienciesProvide appropriate care for a resident to maintain and/or improve range of motion (ROM), limited ROM and/or mobility, unless a decline is for a medical reason.DNoDeficient, Provider has date of correction26 July 2025
5 June 2025HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.ENoDeficient, Provider has date of correction26 July 2025
2 July 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.DYesDeficient, Provider has date of correction8 August 2024
30 August 2023HealthF 0677Quality of Life and Care DeficienciesProvide care and assistance to perform activities of daily living for any resident who is unable.DNoDeficient, Provider has date of correction16 October 2023
30 August 2023HealthF 0686Quality of Life and Care DeficienciesProvide appropriate pressure ulcer care and prevent new ulcers from developing.DNoDeficient, Provider has date of correction16 October 2023
30 August 2023HealthF 0880Infection Control DeficienciesProvide and implement an infection prevention and control program.FNoDeficient, Provider has date of correction16 October 2023

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

FieldAs filed
Provider TypeMedicare and Medicaid
Ownership TypeNon profit - Corporation
Legal Business NameGLENCOE REGIONAL HEALTH SERVICES
Date First Approved to Provide Medicare and Medicaid Services1983-07-26
Provider Resides in HospitalY
Continuing Care Retirement CommunityN
UrbanN
County/ParishMc Leod
Telephone Number3208647790
Provider Changed Ownership in Last 12 MonthsN
With a Resident and Family CouncilResident
Automatic Sprinkler Systems in All Required AreasYes
Number of Certified Beds108
Average Number of Residents per Day95.4
Overall Rating4
Health Inspection Rating4
QM Rating2
Long-Stay QM Rating2
Short-Stay QM Rating1
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

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, GLENFIELDS LIVING WITH CARE — facility record report, CMS certification number 245263. https://velarionrecords.com/facility/245263/report.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 245263. 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 2017908,4596,150.054,097.7521,693.531,941.3
2017Q230 June 2017918,1666,245.354,430.522,299.7532,975.6
2017Q330 September 2017928,4266,117.64,40522,485.7533,008.35
2017Q431 December 2017928,5796,0064,841.521,60032,447.5
2018Q131 March 2018908,4086,1124,79121,594.7532,497.75
2018Q230 June 2018918,3296,275.254,541.7522,14732,964
2018Q330 September 2018928,1417,397.44,163.521,633.533,194.4
2018Q431 December 2018928,0747,653.754,019.7521,948.533,622
2019Q131 March 2019907,9077,893.73,88020,80732,580.7
2019Q230 June 2019917,9378,547.553,618.2521,189.7533,355.55
2019Q330 September 2019928,0128,506.13,80420,921.533,231.6
2019Q431 December 2019928,1549,662.13,789.7522,325.2535,777.1
2020Q131 March 2020918,74410,049.83,868.524,045.7537,964.05
2020Q230 June 2020918,1009,462.753,726.522,986.7536,176
2020Q330 September 2020927,9168,674.853,526.2520,618.2532,819.35
2020Q431 December 2020927,6128,543.453,709.7520,234.2532,487.45
2021Q131 March 2021907,9638,382.453,524.7521,370.2533,277.45
2021Q230 June 2021918,23310,155.33,349.521,451.2534,956.05
2021Q330 September 2021928,02110,1823,173.2519,97733,332.25
2021Q431 December 2021927,36710,5192,635.7517,634.530,789.25
2022Q131 March 2022906,90510,251.252,591.518,22031,062.75
2022Q230 June 2022917,5569,647.252,778.519,980.532,406.25
2022Q330 September 2022927,5099,098.752,849.520,35432,302.25
2022Q431 December 2022927,2429,366.253,079.519,097.7531,543.5
2023Q131 March 2023907,0339,534.53,615.518,785.531,935.5
2023Q230 June 2023917,66910,138.53,38620,013.533,538
2023Q330 September 2023927,2689,272.753,86120,707.7533,841.5
2023Q431 December 2023927,4059,649.753,738.7520,59133,979.5
2024Q131 March 2024917,5379,746.253,664.7520,88734,298
2024Q230 June 2024917,4959,580.53,808.7522,030.535,419.75
2024Q330 September 2024927,6289,930.53,618.921,481.535,030.9
2024Q431 December 2024927,89910,030.753,547.2521,79835,376
2025Q131 March 2025907,69910,4943,34522,04935,888
2025Q230 June 2025917,82510,341.753,71122,855.536,908.25
2025Q330 September 2025927,89612,628.53,659.7525,140.2541,428.5
2026Q131 March 2026908,58911,4694,09025,89441,453
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.7270420.4844252.5645473.776014
2017Q20.7647990.5425542.7308054.038158
2017Q30.7260380.5227872.6686153.91744
2017Q40.7000820.5643432.5177763.782201
2018Q10.7269270.5698142.5683583.865099
2018Q20.7534220.5452942.6590233.957738
2018Q30.908660.5114242.6573524.077435
2018Q40.947950.4978642.7184174.164231
2019Q10.9983180.4907042.6314664.120488
2019Q21.0769250.4558712.6697434.202539
2019Q31.061670.4747882.6112714.147728
2019Q41.1849520.4647722.7379514.387675
2020Q11.1493370.4424182.7499714.341726
2020Q21.1682410.4600622.837874.466173
2020Q31.0958630.4454592.604634.145951
2020Q41.1223660.4873552.6582044.267926
2021Q11.0526750.4426412.6836934.179009
2021Q21.2334870.4068382.605524.245846
2021Q31.2694180.3956182.4905874.155623
2021Q41.4278540.3577782.3937154.179347
2022Q11.4846130.3753082.6386684.498588
2022Q21.2767670.3677212.6443224.28881
2022Q31.2117130.3794782.7106144.301805
2022Q41.2933240.4252282.6370824.355634
2023Q11.355680.5140762.6710514.540808
2023Q21.3220110.4415182.6096624.373191
2023Q31.2758320.5312332.8491684.656233
2023Q41.303140.5048952.7806894.588724
2024Q11.2931210.4862352.7712624.550617
2024Q21.2782520.5081722.939364.725784
2024Q31.3018480.4744232.8161384.59241
2024Q41.2698760.4490762.759594.478542
2025Q11.3630340.4344722.8638784.661385
2025Q21.3216290.4742492.9208314.716709
2025Q31.5993540.4634943.1839225.246771
2026Q11.3353130.476193.0147864.826289

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
  • 2017Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin; they are read as hrs_lpnadmin. CMS's file labels its last six hours columns hrs_medaide, hrs_medaide_emp, hrs_rn_donadmin, hrs_na_trn, hrs_natrn_emp, hrs_natrn_ctr; they are read by position as Hrs_MedAide_emp, Hrs_MedAide_ctr, Hrs_NAtrn, Hrs_NAtrn_emp, Hrs_NAtrn_ctr, Hrs_MedAide, the order in which each total equals its employee and contract parts on every row. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv
  • 2017Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv
  • 2017Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv
  • 2018Q1: 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
  • 2018Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv
  • 2018Q4: 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
  • 2021Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv
  • 2021Q3: 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
  • 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
  • 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