# 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	EmployeeNumber	string	Username to allow the user to login
employeeCode		string	When empty it is set equal to username
name	FullName	string	Name of the user
surname	Surname	string	Surname of the user
emailAddress	Email	string	Email for most notifications in the system e.g. Password reset
alternateEmailAddress		string	Email for reporting
idNumber	ID	string	Id Number of the user
passportNumber	PassportNumber	string	Passport number of the user
mobileNumber	CellNo	string	Mobile number preferably with country code
workNumber	TelNoW	string	Work number preferably with country code
homeNumber	TelNoH	string	Home number preferably with country code
middleName		string	Middle name of user
initials	Initials	string	Initials of user
title	EmpTitle	string	Title of user
knownAs	KnownAs	string	Name the user is known as
homeLanguage	HomeLanguage	string
gender	Gender	string
race	Race	string
citizenship	Nationality	string
maritalStatus		string
birthDay	Birthday	string	Date of birth of the user
disability		string	A single disability for the user
residentialUnitNumber	Home\_UnitNumber	string
residentialComplexName	Home\_Complex	string
residentialStreetNumber	Home\_StreetNo	string
residentialStreetName	Home\_Street	string
residentialSuburbDistrict		string
residentialCityTown	Home\_CityTownVillage	string
residentialCountry	Home\_Country	string
residentialProvince	Home\_Region	string
residentialPostalCode	Home\_PostalCode	string
residentialAsPostal		string
postalUnitNumber	Home\_UnitNumber	string
postalComplexName	Home\_Complex	string
postalStreetNumber	Home\_StreetNo	string
postalStreetName	Home\_Street	string
postalSuburbDistrict		string
postalCityTown	HomePostal\_CityTownVillage	string
postalCountry	HomePostal\_Country	string
postalProvince	HomePostal\_Region	string
postalCode	HomePostal\_PostalCode	string
jobExternalId		int	The payroll job id
jobTitle	JobTitle	string	Name of the job
jobCode	JobCode	string	Code of the job
occupationalCategory	OccupationalCategory\_Description	string	Occupation Category of the job
occupationalLevel	OccupationalLevel\_Description	string	Occupational Level of the job within the category
jobOfoCode	OFOCode	string	OFO code of the job
jobGrade	InternalGrading	string	Grade of the job
gradingType		string	Grading used for the job
positionExternalId		int	The payroll position Id
positionTitle	PositionTitle	string	Position Name
positionCode	PositionCode	string	Position Code
appointmentType	EmploymentType\_Description	string	How the user is appointed in the position
startDate	StartDateInPosition	string	Start date in the position
endDate	TerminationDate	string	End date in the position, when empty the user is not terminated
reasonForTermination	ReasonForTermination	string	The reason the users employment has been ended
startDateInGroup	StartDateInGroup	string	The start date in the group
startDateInCompany	StartDateInCompany	string	The start date in the company within the group
orgLevel1\_externalId		Int	Org unit Id on payroll
orgLevel1\_name	OrgLevel1\_Description	string
orgLevel1\_code	OrgLevel1	string	Unique code per ruleset for org unit
orgLevel1\_workLocationName		string
orgLevel2\_externalId		Int	Org unit Id on payroll
orgLevel2\_name	OrgLevel2\_Description	string
orgLevel2\_code	OrgLevel2	string	Unique code per ruleset for org unit
orgLevel2\_workLocationName		string
orgLevel3\_externalId		Int	Org unit Id on payroll
orgLevel3\_name	OrgLevel3\_Description	string
orgLevel3\_code	OrgLevel3	string	Unique code per ruleset for org unit
orgLevel3\_workLocationName		string
orgLevel4\_externalId		Int	Org unit Id on payroll
orgLevel4\_name	OrgLevel4\_Description	string
orgLevel4\_code	OrgLevel4	string	Unique code per ruleset for org unit
orgLevel4\_workLocationName		string
orgLevel5\_externalId		Int	Org unit Id on payroll
orgLevel5\_name	OrgLevel5\_Description	string
orgLevel5\_code	OrgLevel5	string	Unique code per ruleset for org unit
orgLevel5\_workLocationName		string
orgLevel6\_externalId		Int	Org unit Id on payroll
orgLevel6\_name	OrgLevel6\_Description	string
orgLevel6\_code	OrgLevel6	string	Unique code per ruleset for org unit
orgLevel6\_workLocationName		string
orgLevel7\_externalId		Int	Org unit Id on payroll
orgLevel7\_name	OrgLevel7\_Description	string
orgLevel7\_code	OrgLevel7	string	Unique code per ruleset for org unit
orgLevel7\_workLocationName		string
orgLevel8\_externalId		Int	Org unit Id on payroll
orgLevel8\_name	OrgLevel8\_Description	string
orgLevel8\_code	OrgLevel8	string	Unique code per ruleset for org unit
orgLevel8\_workLocationName		string
orgLevel9\_externalId		Int	Org unit Id on payroll
orgLevel9\_name	OrgLevel9\_Description	string
orgLevel9\_code	OrgLevel9	string	Unique code per ruleset for org unit
orgLevel9\_workLocationName		string
lineManagerUsername	LineManagerEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
performanceManagerUsername	PerformanceManagerEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
departmentManagerUsername	DepartmentManagerEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
trainingManagerUsername	TrainingManagerEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
pdpFirstApproverUsername	PDPFirstApproverEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
pdpSecondApproverUsername	PDPSecondApproverEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
leaveManagerUsername	LeaveManagerEmployeeNumber	string	The username of the manager, existing in the system or part of the API body
salaryReviewManagerUsername	SalaryReviewManagerEmployeeNumber	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	Customfield1	string	Any value that needs to be stored against the user for which an explicit field does not exist
customField002	Customfield2
customField003	Customfield3
customField004	Customfield4
customField005	Customfield5
customField006	Customfield6
customField007	Customfield7
customField008	Customfield8
customField009	Customfield9
customField010	Customfield10
customField011	Customfield11
customField012	Customfield12
customField013	Customfield13
customField014	Customfield14
customField015	Customfield15
customField016	Customfield16
customField017	Customfield17
customField018	Customfield18
customField019	Customfield19
customField020	Customfield20