Feasibility of using payroll data to estimate hospital nurse staffing

Louise Winton Schreuders, Elizabeth Geelhoed, Alexandra Bremner, Judith Finn, Danielle Twigg

Research output: Contribution to journalArticleResearchpeer-review

2 Citations (Scopus)


Introduction The capacity for a hospital inpatient unit to provide high quality nursing care depends on a complex range of factors. Accurately identifying and measuring these factors is one of the challenges of nursing care quality research. Nursing hours per patient day and skill mix are two quantifiable indicators of capacity to provide nursing care. Aims The aims of the study are to measure fortnightly, unit-level nurse staffing and compare them to target nurse staffing levels. Method Nurse staffing and inpatient unit movement data were sourced for the administrative records of three Western Australian tertiary metropolitan hospitals (2004–2008). The impact of data source on nurse staffing estimates was tested with linear mixed models, adjusting for financial year. Counts, proportions, means, and standard deviations were used to describe nurse staffing data. Bar graphs depict proportion of nursing hours provided by nurses of different skill levels. Results Data source did not significantly affect estimate of nursing hours per patient day (p = 0.788). Fortnights during which nurse staffing targets were not reached were recorded for all units. Skill mix varied between units with different staffing targets. Conclusion It is feasible to calculate fortnightly nursing hours and skill mix per hospital unit from raw nursing payroll and inpatient unit movement records. Fortnightly, unit-level measurement highlights nurse staffing fluctuations that are masked by annually aggregated data and are relevant for studies which investigate the association between nurse staffing levels and inpatient complication rates. Staffing shortfalls may affect nurses’ experiences of working or patients’ care experiences.

Original languageEnglish
Pages (from-to)345-350
Number of pages6
Issue number4
Publication statusPublished - 1 Aug 2017
Externally publishedYes


  • Nurse staffing
  • Nursing hours per patient day
  • Skill mix

Cite this