A useful nurse schedule does more than put names beside shifts. It shows whether the right role is covered. It also shows how a pickup changes weekly hours and what will need to be explained later.
The template should let a scheduler answer one question before publishing: what changes if this person calls out? If the answer requires a separate calculator outside the grid, the template is not carrying enough information.
Keep the RN and LPN lines separate. Put day and night coverage on separate rows when the unit needs both. Add a running hours column beside each employee, then record the replacement decision instead of deleting the original assignment. That small amount of structure turns a weekly grid into a record someone else can follow.
Start with the coverage you need, then assign people. A blank nurse row is more useful than a full name list that hides the role being covered.
| Template field | What to record | Why it belongs on the grid |
|---|---|---|
| Unit and date | Wing, unit, calendar date | A facility-wide total can hide a thin assignment on one unit. |
| Shift window | Start time, end time, day or night | Overnight work crosses midnight and should not be treated as one calendar day for PBJ. |
| RN coverage | One row for each required RN assignment | RN work stays visible instead of being mixed with LPN hours. |
| LPN/LVN coverage | One row for each LPN/LVN assignment | The scheduler can see a licensed-nurse gap without counting it as an RN gap. |
| Float or backfill | Available person, source, or open slot | A call-out response is faster when the next option is already visible. |
| Hours and status | Scheduled hours, running weekly hours, confirmed or open | The same assignment can be a coverage win and an overtime problem. |
| Change note | Call-out, swap, pickup, or manager approval | It preserves the reason for a change instead of leaving a silent edit. |
If the unit also schedules aides, give them their own row. Do not make the RN line carry every licensed or direct-care role.
This compact layout is a practical starting point for a 12-hour unit. Copy the structure into a spreadsheet, then add rows for the actual coverage plan.
| Employee | Role | Week 1 shifts | Week 2 shifts | Week 1 hours | Week 2 hours | Change note |
|---|---|---|---|---|---|---|
| Assigned nurse A | RN | Mon, Wed, Sat | Tue, Thu, Sun | 36 | 36 | Base assignment |
| Assigned nurse B | RN | Tue, Thu, Sun | Mon, Wed, Sat | 36 | 36 | Weekend balance |
| Licensed nurse C | LPN/LVN | Mon, Fri | Tue, Sat | 24 | 24 | Open night row checked separately |
| Relief row | RN or LPN/LVN | Open | Open | 0 | 0 | Use only after confirming role and hours |
Now test a common change. Nurse A is asked to pick up a fourth shift in week 2. The week moves from 36 hours to 48. Under a 40-hour workweek, 8 hours become overtime. The schedule should show that before the pickup is confirmed, not after payroll closes.
Keep a separate PBJ-hours column if the same file feeds reporting work. Four full 12-hour shifts may be 46 PBJ hours because CMS deducts 30 minutes from each shift. PBJ hours are not a substitute for the wage-and-hour calculation. They answer a different question.
A template cannot repair a pattern that creates a predictable hole. Put the pattern beside the tradeoff so the scheduler knows what to watch.
| Pattern | Useful number | What the template must catch |
|---|---|---|
| Fixed 3x12 | 36 hours per week | A fourth shift creates a 48-hour week and 8 hours over a 40-hour threshold. |
| 2-2-3 rotation | 84 hours per 14 days, 42 hours per week on average | It needs four crews for 24/7 coverage and creates different overtime results depending on the workweek boundary. |
| 4-on/4-off | 48 hours every 8 days, 42 hours per week on average | Four consecutive 12-hour shifts and drifting weekends make fatigue and fair weekend assignment visible concerns. |
| DuPont | 168 hours per 28 days, 42 hours per week on average | The pattern includes four consecutive nights and a 72-hour week in one phase. |
These are not interchangeable templates. Fixed 3x12 is easier to audit for weekly hours. A rotating 2-2-3 gives predictable weekend rotation but needs careful day and night assignment. A longer rotation can create a useful block of days off while making one week much heavier than the next. The schedule should make that cost visible to the person approving it.
Do not treat 8/80 as a shortcut for 12-hour staffing. Under the federal 8/80 option, a hospital or residential-care facility needs a prior agreement or understanding, a fixed 14-day work period, and overtime for hours over 8 in a workday or over 80 in the period. A 2-2-3 nurse working seven 12-hour shifts would produce 28 daily overtime hours under that method. A 40-hour workweek aligned to three shifts in one week and four in the next produces 8 overtime hours. Read the statute and DOL guidance with counsel before changing the rule used for a facility.
There is no single nurse overtime setting that belongs in every template. The sourced state research distinguishes mandatory-overtime restrictions from overtime pay, staffing-plan requirements, and patient assignment rules.
For a facility template, add a jurisdiction field, the workweek start, and a way to mark whether extra coverage was voluntary or required. Keep a replacement log with the people contacted and the result. In several state laws, reasonable efforts to find coverage matter, and chronic short staffing is not treated as an emergency exception.
Coverage also varies by facility. The research identifies Pennsylvania, New Jersey, New York, and some Washington arrangements as reaching long-term-care settings, while the sourced table marks Connecticut, Illinois, Massachusetts, Oregon, Rhode Island, Texas, and West Virginia as hospital-only. Minnesota's sourced statute expressly excludes nursing facilities. Those examples are why a generic "nurse overtime law" checkbox is a poor substitute for a state-specific review.
Do not put a universal RN coverage threshold in the template unless your state rule, facility policy, or counsel has supplied it. The old version of this guide treated one federal RN-hours statement as a general floor. That was too broad for a page meant for different facility types.
PBJ needs worked and paid hours, not the clean-looking number printed at the top of a shift column. Build the reporting details into the workflow while the change is still fresh.
| Field | Template behavior | PBJ detail to protect |
|---|---|---|
| Job title code | Keep the code attached to the role row | CMS lists direct-care RN as code 7 and direct-care LPN/LVN as code 9. |
| Employee or contract status | Keep pay type beside the person | PBJ distinguishes employee, exempt, non-exempt, and contract categories in its data fields. Do not guess code values from a schedule. |
| Actual work date | Split overnight work at midnight | An 11:00 PM to 7:00 AM shift is recorded across two PBJ dates. |
| Worked hours | Record the paid-to-work result after the shift | For a full 12-hour shift paid to work 12 hours, CMS's example reports 11.5 hours after the meal-break deduction. |
| Leave or orientation | Mark non-work time instead of counting the scheduled block | PBJ excludes paid leave and other non-work absences from worked hours. |
The simplest spreadsheet safeguard is a second hours column labeled "PBJ hours" and a note that explains how it was calculated. Never silently replace a scheduled 12 with 11.5 without leaving the source shift visible.
Shiftd keeps RN and LPN/LVN assignments tied to the shifts they cover, then surfaces coverage conflicts and overtime before publication. It keeps a change history and can map shifts to PBJ job codes; it does not replace payroll or timekeeping.
See Shiftd in action →Yes. Separate rows let the scheduler see which licensed role is covered and stop an LPN/LVN assignment from being mistaken for RN coverage.
Usually not by the arithmetic in a 12-hour pattern. Under 8/80, each 12-hour shift creates 4 hours over the daily 8-hour point. A 2-2-3 nurse working seven shifts reaches 28 daily overtime hours before the over-80 credit. Confirm the facility's agreement and pay method with counsel.
Show the full shift on the schedule for staffing review, then split the worked hours at midnight in the PBJ-hours view. CMS gives an 11:00 PM to 7:00 AM shift as 1 hour on the first date and 7 hours on the next.
Keep the original assignment, mark it as open, record the replacement, and note whether the change was a swap, pickup, float assignment, or manager-approved exception. Recalculate the replacement nurse's running hours before confirming it.
No. State restrictions differ by facility type. Store the jurisdiction and workweek setup with the template, then have the applicable policy reviewed before relying on it.
