The CNA schedule template your units can use

A useful CNA schedule does more than put names beside shifts. It shows coverage by unit and keeps the call-out history beside the hours needed for PBJ and HPRD work.

The fields that make a CNA schedule usable

  • CMS PBJ job title code 10 is Certified Nurse Aide, while job title code 11 is Nurse Aide in Training.Source: CMS PBJ Policy Manual v2.7
  • CMS says a 12-hour shift paid to work 12 hours is reported as 11.5 hours after the required 30-minute meal-break deduction.Source: CMS PBJ Policy Manual v2.7
  • PBJ hours are recorded by calendar day, so a night shift that crosses midnight must be split between two reporting days.Source: CMS PBJ Policy Manual v2.7
  • CMS requires a staffing submission by the 45th calendar day after each federal fiscal quarter ends.Source: CMS staffing data submission guidance

Why the grid needs an audit trail

The grid is the visible part of a CNA schedule. The useful part is the record underneath it. A scheduler needs to see the assigned aide by unit and shift, then retain the change when that person calls out and someone else covers. If the same sheet also distinguishes scheduled hours from hours actually paid to work, it can support the PBJ file instead of forcing a second round of reconstruction.

Keep the staffing view and the reporting view connected, but do not treat them as the same number. A scheduled 12-hour shift is not automatically 12 PBJ hours. CMS deducts a 30-minute meal break from a full shift, whether the employee took the break or not.

Build rows around the decisions a scheduler makes

Start with one row for one person on one shift. A facility-wide list of names is quick to print and hard to operate. The unit column is what tells you whether a call-out leaves Cedar short while Maple still has spare coverage.

ColumnExampleWhy it belongs
Date and shiftTue, 7:00 AM to 3:00 PMShows the exact coverage window.
Unit or wingCedar, second floorExposes a local gap that a total census row can hide.
Role codeCNA, job code 10Keeps a certified aide separate from an aide in training.
Assigned staffJordan LeeNames the person expected to work.
Scheduled time7:00 AM to 3:00 PMSupports coverage planning before the shift.
Actual paid hours7.5Supports reporting after the shift is complete.
Pay typeEmployee or agency/contractPreserves the staffing source used for the shift.
Status and noteWorked or replacedKeeps the reason for a change with the assignment.

A weekly layout you can copy

Use the same columns for 8-hour shifts and 12-hour shifts. The schedule should describe the shift people planned to work, while the PBJ fields describe the hours they actually worked. That distinction matters most on nights and during backfill.

DateUnitShiftCNAScheduled timePBJ hoursStatus
MonCedarDayJordan Lee7:00 AM to 3:00 PM7.5Worked
MonCedarEveningSam Ortiz3:00 PM to 11:00 PM7.5Worked
Mon to TueCedarNightPriya Shah11:00 PM to 7:00 AMSplit at midnightWorked
TueMapleDayOpen row7:00 AM to 3:00 PMBlankNeeds coverage

The open row is intentional. A blank cell is easy to miss; a status that says 'Needs coverage' gives the scheduler something to resolve before publication.

Worked example: one 12-hour shift

Suppose four CNAs each work a full 12-hour shift on Cedar. The schedule view shows 48 scheduled hours. The PBJ view shows 11.5 hours per person after the meal-break deduction, for 46.0 reportable hours in total.

ViewCalculationTotal
Coverage plan4 shifts x 12 scheduled hours48 hours
PBJ work hours4 shifts x 11.5 reportable hours46.0 hours
Illustrative CNA HPRD46.0 hours / 40 residents1.15 HPRD

The 40-resident figure is an example for planning, not a federal minimum. Use the resident-day measure your facility has chosen for its internal HPRD report. Do not copy the schedule total into a PBJ file without applying the reporting rules.

For a 7:00 PM to 7:00 AM shift, keep the assignment in one staffing record but split the worked hours at midnight for the two calendar dates. Record actual paid-to-work time and apply the meal-break deduction before rounding the daily value as CMS requires. This is where a handwritten template tends to drift.

Make call-outs traceable instead of invisible

A replacement should not erase the original assignment. Keep both rows and link them with a change ID or note. That gives the scheduler a quick answer to two practical questions: who was scheduled, and who accepted the replacement?

EventOriginal rowReplacement rowWhat to retain
Call-outJordan Lee, Cedar dayOpenTime reported and reason category
Coverage searchOpenFloat pool contactedContact result and timestamp
Backfill acceptedCall-outCasey Brown, Cedar dayAccepted time and staff source
Shift closedCall-outWorked by Casey BrownActual paid hours and final status

Do not count the planned row and the replacement row as two completed shifts. The original row explains the schedule change. The person who worked supplies the actual hours.

Keep PBJ fields separate from coverage fields

These fields answer different questions. Combining them in one free-text note is how an overnight shift becomes eight hours on one date and disappears from the next.

FieldUse it forCommon mistake
Scheduled hoursPlanning unit coverage.Submitting the planned time when the employee worked less.
Actual paid-to-work hoursPBJ reporting.Including PTO or another paid absence.
Calendar dateSplitting a shift at midnight.Putting the whole overnight shift on its start date.
Job title codeSeparating CNA code 10 from Nurse Aide in Training code 11.Lumping every aide into a single role.
Pay typeDistinguishing employee or agency/contract staffing.Leaving the staffing source for month-end cleanup.
Decimal hoursReporting rounded fractions rather than minute strings.Entering 7 hours 33 minutes as 7.33.

CMS also has a daily cap of 22.5 hours per employee ID across job titles in the current PBJ data specification. That is another reason to reconcile duplicate rows before submission.

Treat state overtime checks as a separate layer

A CNA template can show that a shift is uncovered. It cannot decide whether your facility may require a person to stay late. Mandatory-overtime rules are state rules, and the facility coverage is not the same in every state.

For example, Pennsylvania Act 102 names long-term care nursing facilities among covered health care facilities and applies to certain hourly or nonsupervisory employees in direct patient care. Several provisions in the research are hospital-only. Check the statute's facility definition against your license. Record any applicable collective bargaining agreement before calling a last-minute gap an emergency. Keep the decision and the coverage search in the change record.

The practical template field is simple: add an 'overtime review' status beside the replacement row.

Where CNA templates break in practice

  • A facility-wide total can look full while one wing has an uncovered shift.
  • Replacing a call-out by overwriting the original name destroys the coverage history.
  • A 12-hour scheduled shift becomes 11.5 PBJ hours after CMS's meal-break deduction.
  • Putting an overnight shift on one date creates a second-day reporting error.
  • Mixing CNA code 10 with Nurse Aide in Training code 11 makes the role file harder to reconcile.
  • Using scheduled hours for PBJ ignores the hours actually paid to work.

From a blank grid to a checked schedule

Shiftd keeps CNA assignments tied to units and actual coverage changes. It carries HPRD calculations and PBJ job codes. It surfaces coverage gaps before publication and preserves an audit record when a call-out changes the plan.

See Shiftd in action →

Questions that come up at the scheduling desk

What columns should a CNA schedule template have?

Use date, unit, shift time, assigned staff, role code, scheduled hours, actual paid hours, pay type, and a status for call-outs or replacements. Keep a note or change ID for the coverage history.

How many PBJ hours does a 12-hour CNA shift count as?

CMS's example counts a full 12-hour shift paid to work as 11.5 hours after the required 30-minute meal-break deduction. A night shift still has to be split between its two calendar dates.

Should CNAs and nurse aides in training share a row?

No. CMS lists Certified Nurse Aide as job title code 10 and Nurse Aide in Training as job title code 11. Keep the roles separate in the schedule and the reporting export.

How should the template handle a CNA call-out?

Keep the original assignment marked as a call-out. Add the replacement as a new row and close it with actual paid hours after the shift ends.

Can a CNA schedule template calculate HPRD?

Yes, if it uses actual work hours and the resident-day value your facility selected. Treat the result as a planning measure and keep it separate from the PBJ hours file.

Does a CNA template tell me whether mandatory overtime is legal?

No. State rules differ by employee group and facility type. Use the template to preserve the coverage search and send the overtime review to your policy or legal workflow.