Skip to main content

Bulk employee data upload validation messages

Unable to complete employee data import due to data loader validation messages.

J
Written by Joshua Shooter
Updated over 3 months ago

We compiled below a list of bulk employee data worksheet validation messages and their description:

Validation message

Details

Employee(s) with 'Employee Id' does not exist in system

There is no employee in your People system with the specified
employee ID.

‘ContinuousServiceDate’ should be less than or equal to ‘Start date’

You can check/edit the employee Start date in their Personal tab.
If employee has been TUPE’d over, the continuous service date
would be the original start date.

"Column_Name" contains invalid data

This error message will specify the actual column. Make sure the
column is displayed the same as the original template, and has
not been moved or renamed. Also double check the help
instructions, there may be a specific format for this bit of data.

'DateOfBirth' should be less than Today’s date

You can check employee’s Date of Birth in employee’s Personal
tab.

'DateOfBirth' should be less than or equal to 'Start Date'

You can check employee’s Date of Birth and Start Date in
employee’s Personal tab.

'JobRoleEffectiveDate' should be greater than or equal to 'Start Date'

You can check employee’s Start Date in employee’s Personal tab.

'Email' & 'Reports To' are same.

The ‘Reports to’ field should be the email of the employee’s
manager. Employee’s cannot report to themselves.

"Column_Name" is Mandatory

This error message will specify the actual column. This will show
if a mandatory column (red) is blank.

Data Exceeded permissible limit

The data in this box will exceed the character limit of the field
within PeopleHR.

Total Employees(Existing Employees + Number of Employees in Uploaded file) should not exceed Total Licensed Employees

If this alert flags up, you are about to exceed your Total No.
Licensed Employees. You may wish to discuss this further with
the account management team through the Contact Us form.
This value not count leaver records.
You can check value this in your Settings > Licenses.

Did this answer your question?