A Attribute Mappings Between Oracle Identity Manager and PeopleSoft Employee Reconciliation

The following table discusses attribute mappings between Oracle Identity Manager and PeopleSoft Employee Reconciliation.

Oracle Identity Manager Attribute	PeopleSoft Employee Reconciliation Attribute	Description
EmployeeID	PS_NAMES.EMPLID	Person ID associated with user
LastName	PS_NAMES.LAST_NAME	Last name
FirstName	PS_NAMES.FIRST_NAME	First Name
Sex	PS_PERSONAL_DATA.SEX	Sex
Postal	PS_PERSONAL_DATA.POSTAL	Postal address
City	PS_PERSONAL_DATA.CITY	City name
SSN	PS_PERS_NID.NATIONAL_ID	National ID provided to user
Phone	PS_PERSONAL_DATA.PHONE	Telephone number
BirthDate	PS_PERSONAL_DATA.BIRTHDATE	Date of birth
Country	PS_PERSONAL_DATA.COUNTRY	Country name
Address	PS_PERSONAL_DATA.ADDRESS1	Contact address
State	PS_PERSONAL_DATA.STATE	State
HireDate	PS_EMPLOYMENT.HIRE_DT	Date of hire
DepartmentID	PSJOB.DEPTID	Department ID
JobCode	PSJOB.JOBCODE	Job code