What is absenteeism and accident data?
This section covers two related types of workplace health and safety data:- Absenteeisms: Periods when an employee is absent from work (e.g., sick leave, work-related injury leave)
- Accidents: Workplace incidents that may or may not result in an absence
Why is it needed?
Organizations must report on workplace health and safety to demonstrate:- Accident frequency: How often workplace incidents occur
- Accident severity: How much work time is lost due to accidents
- Sick leave: Overall absenteeism rates
- Safety trends: Whether conditions are improving or deteriorating
Types of records
Absenteeisms
An absenteeism records a period of absence from work. It captures:- Start date: When the absence began
- End date: When the absence ended (or empty if ongoing)
- Hours: Total hours of absence (optional — can be calculated from dates)
Accidents
An accident records a workplace incident. It captures:- Date: When the accident occurred
- Context: Where the accident happened
Combined records
Each uploaded record is either an absenteeism, an accident, or both (an accident that caused an absence). Thetype field determines which:
Data structure
Absenteeism and accident records are linked to employees via the External Employee ID.Employees must already exist in the system before you can upload their absenteeism and accident records. Upload contract data first.
CSV format
Required fields by type
Example CSV
How to upload
1
Go to Data > Workforce > Absenteeisms & Accidents
Navigate to the Workforce section and select the Absenteeisms & Accidents tab.
2
Click Upload
Click the Upload button to open the data import interface.
3
Import your data
Paste from a spreadsheet, upload a CSV/Excel file, or enter data manually.
4
Review and confirm
The importer validates that:
- Each
external_employee_idmatches an existing employee - The
typefield has a valid value - Required fields for the selected type are present
- Accident dates are not in the future
- End dates are on or after start dates
- Hours are a valid positive number (if provided)
Viewing absenteeism and accident data
List view
The list shows all uploaded records with:- Employee ID: Which employee the record belongs to
- Type: Absenteeism, Accident, or Accident with Absenteeism
- Dates: Absence period or accident date
- Hours: Duration of absence (if applicable)
- Context: In labore or In itinere (for accidents)
- Upload source: Which file the record came from
- Upload file
- Upload date range
Employee detail view
From the employee detail page, the Absenteeisms & Accidents section shows all records for that specific employee.How it appears in reports
Absenteeism and accident data feeds into these report metrics:Accident metrics
Absenteeism metrics
Absent days from accidents directly affect the FTE calculation. Days absent are subtracted from the working days when computing full-time equivalents, giving a more accurate picture of actual workforce capacity.
Understanding accident context
In labore
In labore accidents occur at the workplace during working hours. Examples:- Slips, trips, and falls in the office or factory
- Injuries from machinery or equipment
- Ergonomic injuries (e.g., repetitive strain)
- Chemical exposure incidents
In itinere
In itinere accidents occur during the employee’s commute between home and work. Examples:- Traffic accidents on the way to/from work
- Injuries on public transport
- Falls while walking to the workplace
The distinction between in labore and in itinere is legally significant in many jurisdictions and affects insurance coverage, liability, and reporting obligations.
Frequently asked questions
Do employees need to exist before I upload absenteeisms?
Do employees need to exist before I upload absenteeisms?
Yes. The
external_employee_id in each record must match an employee already uploaded through the contracts upload.How do I record an accident that resulted in sick leave?
How do I record an accident that resulted in sick leave?
Use type
accident_with_absenteeism and fill in both the accident fields (date, context) and the absence fields (start_date, end_date, hours).What if an absence is ongoing?
What if an absence is ongoing?
Leave the
end_date empty. You can update the record later when the absence ends.Can I have multiple absences and accidents for the same employee?
Can I have multiple absences and accidents for the same employee?
Yes. An employee can have any number of absenteeism and accident records.
What's the difference between hours and date range?
What's the difference between hours and date range?
The date range (
start_date to end_date) indicates when the absence occurred. The hours field specifies the actual hours missed, which may differ from the calendar duration (e.g., a 3-day absence for a part-time employee might be 12 hours, not 24).