A nursing home schedule template that holds up

• Long-term care facilities subject to 42 CFR Part 483 Subpart B must electronically submit direct-care staffing information through CMS's Payroll-Based Journal, including agency and contract staff.Source: CMS
• PBJ hours are reported as paid-to-work hours by calendar day, so a night shift is split at midnight rather than reported as one block on its start date.Source: CMS
• CMS requires a 30-minute meal-break deduction from each full shift paid to work, which makes a 12-hour shift 11.5 PBJ hours when the full shift is paid to work.Source: CMS
• PBJ separates nursing job categories such as RN, LPN/LVN, CNA, nurse aide in training, and medication aide or technician instead of treating all direct-care hours as one pool.Source: CMS

Use the template as a control sheet, not a substitute for judgment. One view checks role coverage by unit and shift. Another records changes after publication. A full-looking month can still hide a short night or a replacement that changes overtime exposure.

Label HPRD as an internal target unless counsel or your state agency says otherwise. Federal requirements and state rules are separate questions.

Make one row for each unit and shift, then attach employee assignments. A facility total is useful later, but it can hide an empty hall.

Most templates omit the change log. A replacement can change the unit, role mix, overtime exposure, and later reconciliation.

Here is an illustrative grid for a 60-bed facility with 54 residents on the day shown. The counts are a planning example, not a staffing requirement. Adjust them to your acuity model, state rules, resident needs, and facility policy.

Now test the grid instead of admiring it. If the South-unit night CNA calls out, change the row to CNA 1 and mark the missing slot before you start calling. If a float CNA takes the assignment, record the float source and the new unit. If nobody accepts, leave the open slot visible. Do not turn an unresolved gap into a green total because the facility still has enough aides somewhere else.

For employee rows, add the actual person, shift, unit, role, and planned paid hours below this summary. That gives the scheduler a fast coverage view while preserving the detail needed for an audit.

HPRD is reported hours divided by the resident count used for the calculation. Calculate it by role as well as in total. A single total can rise while RN hours fall.

Illustrative day: 54 residents, 4 RN shifts, 4 LPN/LVN shifts, and 10 CNA shifts. If each is a full 12-hour shift paid to work, CMS's rule makes each one 11.5 PBJ hours.

207 divided by 54 equals 3.83 total HPRD. This is not a legal threshold. It is a check before publication. An 11:00 p.m. to 7:00 a.m. shift also needs a split between two calendar dates. Scheduled hours and PBJ hours are not interchangeable.

A call-out row should force a decision. Use a small status field such as Open, Contacting, Covered, or Escalated, then record the time and person who changed it.

1. Mark the missing employee and the exact unit, role, and shift.
2. Check the float or relief list for someone qualified for that assignment.
3. Check the replacement's hours, rest period, approved availability, and facility overtime policy.
4. Record the contacts made and the outcome, including a refusal or an agency request.
5. Recalculate the affected unit, role totals, HPRD view, and employee hours before publishing the change.

Do not use a generic note such as "short staffed". Several state mandatory-overtime laws treat chronic short staffing differently from an unforeseeable emergency, and facility coverage is not uniform across states. Pennsylvania, New Jersey, and New York clearly reach long-term-care settings in the research reviewed here. Washington's coverage depends on the facility and licensing context. Put the state-policy check outside the formula, and have counsel confirm the rule that applies to your facility.

A spreadsheet works when one scheduler owns it and the final schedule is checked before release. It fails when copies multiply or the published grid no longer matches hours worked.

The missing feature is a shared record that recalculates conflicts and coverage when an assignment changes, then keeps the change history with the schedule.

• A facility-wide total can show full coverage while one unit has an empty night-shift slot.
• Copying 12 scheduled hours into PBJ fields misses CMS's 30-minute meal-break deduction.
• An overnight shift recorded only on its start date puts paid hours on the wrong PBJ day.
• A call-out without a timestamp or replacement record leaves the published schedule impossible to reconcile.
• A spreadsheet can show the planned role mix while hiding an employee overlap or an overtime-policy conflict.