V8 Employee Import to V9 User Import Field Mapping
Below is the list of fields that are required and recommended. Fields with no comment are optional.
| Field Name V9 | Field Name V8 | API Field Type | Description | |
| externalId | Int | External Payroll Identity Id | ||
| username | string | Username to allow the user to login | ||
| employeeCode | string | When empty it is set equal to username | ||
| name | string | Name of the user | ||
| surname | string | Surname of the user | ||
| emailAddress | string | Email for most notifications in the system e.g. Password reset | ||
| alternateEmailAddress | string | Email for reporting | ||
| idNumber | string | Id Number of the user | ||
| passportNumber | string | Passport number of the user | ||
| mobileNumber | string | Mobile number preferably with country code | ||
| workNumber | string | Work number preferably with country code | ||
| homeNumber | string | Home number preferably with country code | ||
| middleName | string | Middel name of user | ||
| initials | string | Initials of user | ||
| title | string | Title of user | ||
| knownAs | string | Name the user is known as | ||
| homeLanguage | string | |||
| gender | string | |||
| race | string | |||
| citizenship | string | |||
| maritalStatus | string | |||
| birthDay | string | Date of birth of the user | ||
| disability | string | A single disability for the user | ||
| residentialUnitNumber | string | |||
| residentialComplexName | string | |||
| residentialStreetNumber | string | |||
| residentialStreetName | string | |||
| residentialSuburbDistrict | string | |||
| residentialCityTown | string | |||
| residentialCountry | string | |||
| residentialProvince | string | |||
| residentialPostalCode | string | |||
| residentialAsPostal | string | |||
| postalUnitNumber | string | |||
| postalComplexName | string | |||
| postalStreetNumber | string | |||
| postalStreetName | string | |||
| postalSuburbDistrict | string | |||
| postalCityTown | string | |||
| postalCountry | string | |||
| postalProvince | string | |||
| postalCode | string | |||
| jobExternalId | int | The payroll job id | ||
| jobTitle | string | Name of the job | ||
| jobCode | string | Code of the job | ||
| occupationalCategory | string | Occupation Category of the job | ||
| occupationalLevel | string | Occupational Level of the job within the category | ||
| jobOfoCode | string | OFO code of the job | ||
| jobGrade | string | Grade of the job | ||
| gradingType | string | Grading used for the job | ||
| positionExternalId | int | The payroll position Id | ||
| positionTitle | string | Position Name | ||
| positionCode | string | Position Code | ||
| appointmentType | string | How the user is appointed in the position | ||
| startDate | string | Start date in the position | ||
| endDate | string | End date in the position, when empty the user is not terminated | ||
| reasonForTermination | string | The reason the users employment has been ended | ||
| startDateInGroup | string | The start date in the group | ||
| startDateInCompany | string | The start date in the company within the group | ||
| orgLevel1_externalId | Int | Org unit Id on payroll | ||
| orgLevel1_name | string | |||
| orgLevel1_code | string | Unique code per ruleset for org unit | ||
| orgLevel1_workLocationName | string | |||
| orgLevel2_externalId | Int | Org unit Id on payroll | ||
| orgLevel2_name | string | |||
| orgLevel2_code | string | Unique code per ruleset for org unit | ||
| orgLevel2_workLocationName | string | |||
| orgLevel3_externalId | Int | Org unit Id on payroll | ||
| orgLevel3_name | string | |||
| orgLevel3_code | string | Unique code per ruleset for org unit | ||
| orgLevel3_workLocationName | string | |||
| orgLevel4_externalId | Int | Org unit Id on payroll | ||
| orgLevel4_name | string | |||
| orgLevel4_code | string | Unique code per ruleset for org unit | ||
| orgLevel4_workLocationName | string | |||
| orgLevel5_externalId | Int | Org unit Id on payroll | ||
| orgLevel5_name | string | |||
| orgLevel5_code | string | Unique code per ruleset for org unit | ||
| orgLevel5_workLocationName | string | |||
| orgLevel6_externalId | Int | Org unit Id on payroll | ||
| orgLevel6_name | string | |||
| orgLevel6_code | string | Unique code per ruleset for org unit | ||
| orgLevel6_workLocationName | string | |||
| orgLevel7_externalId | Int | Org unit Id on payroll | ||
| orgLevel7_name | string | |||
| orgLevel7_code | string | Unique code per ruleset for org unit | ||
| orgLevel7_workLocationName | string | |||
| orgLevel8_externalId | Int | Org unit Id on payroll | ||
| orgLevel8_name | string | |||
| orgLevel8_code | string | Unique code per ruleset for org unit | ||
| orgLevel8_workLocationName | string | |||
| orgLevel9_externalId | Int | Org unit Id on payroll | ||
| orgLevel9_name | string | |||
| orgLevel9_code | string | Unique code per ruleset for org unit | ||
| orgLevel9_workLocationName | string | |||
| lineManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| performanceManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| departmentManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| trainingManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| pdpFirstApproverUsername | string | The username of the manager, existing in the system or part of the API body | ||
| pdpSecondApproverUsername | string | The username of the manager, existing in the system or part of the API body | ||
| leaveManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| salaryReviewManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| talentManagementManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| secondaryReportingManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| lineManagerOnceRemovedUsername | string | The username of the manager, existing in the system or part of the API body | ||
| workflowOriginatorUsername | string | The username of the manager, existing in the system or part of the API body | ||
| financeManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| financeOfficerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| hrOfficerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| hrRecruitmentOfficerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| businessUnitHrManagerUsername | string | The username of the manager, existing in the system or part of the API body | ||
| secondaryJobRequisitionApproverUsername | string | The username of the manager, existing in the system or part of the API body | ||
| leaveManagerAlternateApproverUsername | string | The username of the manager, existing in the system or part of the API body | ||
| customField001-customField020 | string | Any value that needs to be stored against the user for which an explicit field does not exist |