We compiled below a list of other event data worksheet validation messages and their description:
Validation message | Details |
'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 other leave entries exists in excel file | One or more other leave records for a certain employee overlap. |
Other Leave 'start date' must be after employee 'start date' | To review the employee's start date, check out their personal record. |
Other Leave 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 sickness, 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. |
Duration exceeds period | Review the employee's working pattern and adjust the other event duration. |
Make sure the start date is before the end date. | Review the start and end date of the record. |
"Column_Name" is Mandatory | Ensure you fill in the column highlighted. |
Data Exceeded permissible limit | The data exceeds the character limit of the fields in PeopleHR. |