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_PERSON.EMPLID	Person ID associated with user
LastName	PS_NAMES.LAST_NAME	Last name
FirstName	PS_NAMES.FIRST_NAME	First Name
Sex	PS_PERS_DATA_EFFDT.SEX	Sex
Postal	PS_ADDRESSES.POSTAL	Postal address
City	PS_ADDRESSES.CITY	City name
SSN	PS_PERS_NID.NATIONAL_ID	National ID provided to user
Phone	PS_PERSONAL_PHONE.PHONE	Telephone number
BirthDate	PS_PERSONAL_DATA.BIRTHDATE	Date of birth
Country	PS_ADRESSES.COUNTRY	Country name
Address	PS_ADRESSES.ADDRESS1	Contact address
State	PS_ADRESSES.STATE	State
HireDate	PS_EMPLOYMENT.HIRE_DT	Date of hire
DepartmentID	PS_JOB.DEPTID	Department ID
JobCode	PS_JOB.JOBCODE	Job code