Weekly Hospital Workforce Data: A Data Visualisation Exercise Yang - PDF document

Weekly Hospital Workforce Data: A Data Visualisation Exercise Yang XIE a , Sankalp KHANNA a , Norm GOOD a and Justin BOYLE a a The CSIRO Australian e-Health Research Centre, Brisbane, Australia Abstract. Quantifying the health workforce in terms of overall staff numbers and their ratio to patients under their care can strengthen analytical studies designed to inform policy regarding how hospital services are delivered. Information about staffing is traditionally obtained via location-specific audits or self-reported information gleaned from surveys which hold potential biases around time- dependence and recall. In contrast, work presented in this paper describes the derivation of useful workforce metrics from routine hospital financial and clinical information systems that overcome these biases. Staffing data is aggregated, visualised and linked to patient demand to gain insight into spatial and temporal variations in hospital staffing and workload. Overall, hospital staff resourcing varies noticeably across a week, with staff numbers and staff-to-patient ratios dropping to low levels at night and across a weekend. Exploration of staff-to-staff ratios allows further insight into staff dynamics across a week and the variation of supervision level. Keywords. Staff visualisation, patient ratios, health workforce, hospital performance Introduction Effective staffing of hospitals directly impacts their financial, safety and quality, and bed access performance. Fiscal impacts are obvious, as staffing costs are among the largest categories in hospitals’ budgets, where nursing staff alone have been estimated to account for 25% or more of annual operating expenses and as much as 40% of direct care costs [1]. Workforce issues have also been noted to be an issue with hospital crowding [2, 3]. Inadequate staffing has been described as one of the most obvious factors related to hospital overcrowding [4]; a major limiting factor for staffed bed availability [5]; and their being integral to a fully functioning hospital system. Shortage of staff has been stated as causing increased workloads, precipitating high turnover, and a resultant disproportionate level of inexperienced replacement personnel. Redeployed staff may fill the numbers but are working in unfamiliar terrain; with effects being manifested in productivity when overstretched clinicians attempt to make up the difference, with a threat to patient care [3]. Excessive or inappropriate workloads can also result in loss of hospital staff. An Australian study [6] calculated the average ED nurse to patient ratio of 1 to 15 on a morning shift, and found that staff modify practice in order to cope with such demand. While this adaptation ensures survival in the short term, the long-term implications are burnout, followed by leaving, with resultant fiscal and competency losses for the system.

There has been evidence reported of an association between lower staff workloads and better patient outcomes, including lower hospital mortality [7-11]. Research has shown that a higher number of registered nurses relative to the number of patients has a positive impact on patient outcomes including decreased lengths of stay in hospital. Evidence also indicates that appropriate staffing numbers benefits the workforce by reducing work-related injuries, absenteeism and turnover, and by increasing job satisfaction [12]. If hospital staff are to provide timely and high-quality care [13], then care and attention need to be paid to their numbers and ratios with respect to patient demand. Many analytical studies in the field of health informatics aiming to turn data and metrics into policy would benefit from inclusion of workforce data. For example, in a controversial study aimed at generating evidence around differential outcomes for patients admitted to hospital on weekends [14], a highly emotive debate has exploded in published responses to the article claiming that the underlying statistical models do not incorporate information related to how hospitals are staffed. To the best of our knowledge, studies that include workforce metrics have involved location-specific audits or relied on large mail surveys and self-reported workload assessment, rather than deriving this from hospital administration systems. For example, Aiken et al [1, 15-16] describe their calculation of workforce data from surveys of staff by dividing the average number of patients reported by staff in a particular hospital unit on their last shift by the average number of staff on the unit for that same shift. These methods are costly and can be biased based on the time they are carried out as well as by recall issues and motives held by survey participants. Our team have been working on generating evidence in relation to the delivery of acute health services and wish to include workforce data in the analyses to present policy makers with the best possible evidence. In most hospitals, information related to staffing is maintained within financial administration systems. However the form of workforce data is unwieldy, being mainly designed for payroll purposes. This paper describes the reshaping, aggregation and visualisation of workforce data and its linking with patient demand to create several useful metrics that have application to informing policy on the way healthcare should be delivered. 1. Methods This study used extracts of hospital admission data and payroll records covering the 28 largest public reporting hospitals in Queensland, Australia from April 2013-December 2015. The 28 facilities were categorised into 6 hospital peer groups in accordance with AIHW public hospital peer groupings. Admissions data covered approximately 3 million admission records from 1.1 million unique patients, and payroll data comprised approximately 34 million records capturing variables representing start and end time of shift, facility name, the role and hierarchical level of staff as well as worked hours and minutes. The raw workforce payroll records reflecting start and end times of individual staff were converted into counts of staff present at various hierarchical and operational areas at an hourly time resolution throughout the study period. The process used for calculating ratios was designed to be replicable and automated for generalising to a range of analytical studies. First, every payroll record was segmented into hourly slots. For example, a payroll record for a particular staff member spanning from 2011-03-17

8:15:00 to 2011-03-17 10:00:00 would be segmented into two hourly slots (2011-03-17 8:00:00 - 2011-03-17 9:00:00) and (2011-03-17 9:00:00 - 2011-03-17 10:00:00). In these two hourly slots, the individual staff member worked 0.75 hour and 1 hour respectively, thereby contributing to 0.75 staff and 1 staff in these two hourly slots. After segmenting all payroll records, aggregation by facility, position and hourly slot start timestamp and end timestamp was applied. A robust derivation of the numbers of every staff role in each hour in each facility across the study period was calculated in this way. Staffing data was categorised by the project ’s Advisory Group to focus on clinical staff in attendance during a shift i.e., the available care team, whose presence was deemed to make a difference in care and also seniority – i.e., nursing and doctor classifications were separated into junior/intermediate/senior, as per Table 1. Table 1. Role classification description. Classification Description A&O Clinical Administrative and Operational Staff with clinical responsibilities HP Clinical Heath Practitioners with clinical responsibilities Junior Nurses Trainee, Assistant, Student and Enrolled Nurses Intermediate Registered, Clinical & Consultant Nurses, Clinical Educators & Nurse Practitioners Nurses Senior Nurses Nurse Directors and Assistant, Nursing and Executive Directors of Nursing Junior Doctors Resident Medical Officers Intermediate Medical Registrars Doctors Senior Doctors Medical Senior Officers, Staff Specialists, Visiting Medical Offers and Specialists, and Superintendents Non-Clinical Senior Admin and Operational Staff and Health Practitioners, Professional and Technical Staff and Senior Health Executives Each row in the reshaped payroll data (i.e., hourly staff data) represented an hourly slot in a particular facility, and contained counts of staff of a particular role, working in that facility during that hourly slot. Hospital admission records were reshaped using a similar method as reshaping payroll data. Each row in the reshaped admission data (i.e., hourly patient data) represented an hourly slot in a particular facility and contained counts of inpatients staying in that facility during that hourly slot. After the reshaping, hourly admission data and hourly workforce data were then joined by facility name and hourly slot, thereby deriving an estimate of both the staffing levels (number of nurses, doctors, etc.) and number of patients at a particular facility in each hour. The resulting reshaped datasets reflected continuous counts of data in every hour across the study period, which were then aggregated to a weekly level by taking means. Therefore, estimates of average number of staff numbers working in every hour in a week in different hospital peer groups were derived.