With the continued growth of the Coronavirus pandemic our leaders are going to be asking for regular updates on our employees health and our business’s productivity. This is not going to be a flash in the pan event either. The path back to normal will be long and gradual which means we need to approach data collection, reporting, and analysis with an emphasis on repeatability.
To that end there’s a number of questions that HR teams are going to need to answer in order to provide a status of and show the progression of the businesses adaptation to these challenges and how our workforce is coping.
So, what data do we need and how do we organize it to address the questions above?
This is where things get tricky and HR needs to be collecting additional data beyond what they have today. This is likely going to need to come from manager input with HR acting as the central collation point. Ideally this information can be captured and held within your HRIS, but most likely this is going to start out as a spreadsheet as your HRIS may not have the required fields for what we need to measure beyond traditional absence & availability information.
My view is that shortly we're going to be asking managers to provide information to HR when their employees move into quarantine, infection, and start/stop work (when remote) because of illness. This may or may not also be in association with an HRIS event recording absence or similar.
As this data is collated you'll want to make sure you can collect a few key data points as per the below
This data can then be merged with the following HRIS information
A combination of this event-related data alongside the HRIS data will create the ability to track over time the status of our workforce so we can report and analyze the trend and impact on the business.
It’s going to be a challenging job to collect and keep collated the above data so if you have already or can get data from some additional systems like facilities and IT access you can infer some of these data points. Below are some examples of business logic some of the organizations we have been talking to are using.
Note: the above is mock data
Overall metrics on the current workforce showing the total population, working status, remote working rates, and infection rates. We also want to show this trending over time so we have an idea of the growth and ultimately the recession of infection rates.
Key Metrics
Comparison against daily statistics by country/state/province produced by health organizations will enable you to compare your infection trend to the prevailing trend in the relevant geographical area. If the area is seeing an acceleration of cases, you should anticipate similar risks for your workforce. If the area has hit an inflection point and is leveling off, the risk to that part of your workforce should be on the wane as well.
Beyond geographic risk, age is the biggest factor on the impact to the employee and we're going to see longer infection periods and mortality rates for older employees than we will for other populations. Obviously any steps the organization can take to protect higher risk populations should be fought for.
Key Metrics
The absence of employees will reduce the productivity of your workforce, potentially impacting customers and creating financial risks such as over-ordering of supplies and raw materials, over-estimating orders and revenues, or committing to delivery dates that cannot be achieved because of workforce impacts beyond the view of the manufacturing location’s management. Questions we need to answer include how many of our employees are currently working, whether from home or their normal location? How many hours have we lost due to infection-related absences? While productivity isn't a major concern when lives are at stake, many of the actions we may take in protecting our employees will show up in either infection rates or in absences and we should be measuring to see what was effective and what wasn't.
Key Metrics
As we plan for how our employees are impacted we need to be analyzing how long our quarantined and infected employees are unable to work. Many employees may still be able to work from home while under quarantine and or infection but there will be periods when they are infected and unwell that they won’t be able to work while when their symptoms are significant or while they are recovering. Questions we need to answer include how long is the infection period for our workforce? What is our forecast for our currently infected employees being back to work?
Key Metrics
The above metrics and questions are a bare bones set of pertinent information that you could provide to leaders even if you don’t have fully integrated HR systems. Of course, there are many more attributes available that leaders may want to view. These will be specific to each business’ strategy so my advice is to include a number of common HRIS fields into the data collection process when you build your initial data set so you can segment later as needed.
Suggested other data elements to consider adding