We compiled below a list of sickness data worksheet validation messages and their description:
Validation message | Details |
Please check your dates include working days | To ensure all holidays land on a working day for your employees, review their working pattern. |
'First Name' & 'Last Name' are not correct for given EmployeeId | To check the employee ID of your employees, check out their personal record. |
Employee(s) with 'Employee Id' does not exist in system | In your worksheet, you have employee IDs that don't match those you store in PeopleHR. |
Overlapped absence entries exists in excel file | One or more holiday records for a certain employee overlap. |
Absence 'start date' must be after employee 'start date' | To review the employee's start date, check out their personal record. |
Absence too far into future | You can only load holiday records in the past and up to one holiday year in future. |
There is already has an existing absence entry during the period requested. Please edit or split the entry so the dates do not coincide | To check the overlapping holiday or other events, check out the employee's planner. |
Invalid duration | Ensure the holiday duration format is as follows: 0.25, 0.5, 0.75, 1 and so on. |
"Column_Name" contains invalid data | Ensure the column highlighted contains data with the same format, order and name as the original worksheet template. |
Make sure the start date is before the end date | Ensure the sickness rows have the start date before the end date. |
Data Exceeded permissible limit | The data exceeds the character limit of the fields in PeopleHR. |
"Column_Name" is Mandatory | Ensure you fill in the column highlighted. |