We compiled below a list of salary data worksheet validation messages and their description:
Validation message | Details |
Salary for effective date already exists. | Review the employee's salary details in their personal record. |
'First Name' & 'Last Name' are not correct for given EmployeeId | To review 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. |
Salary 'effective date' must be after employee 'start date' | To review the employee's salary details, check out their personal record. |
More than one salary record exists for effective date in excel file | Review the salary details in your worksheet and remove any duplicates. |
Column_Name" contains invalid data | Ensure the column highlighted contains data with the same format, order and name as the original worksheet template. |
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. |
Calculated Salary should be less than the "Total Annual Salary" | Review the salary details in your worksheet and adjust the data for both calculated and total annual salary. |