A Attribute Mappings Between Oracle Identity Manager and Oracle e-Business Employee Reconciliation

The following table discusses attribute mappings between Oracle Identity Manager and Oracle e-Business Employee Reconciliation.

Oracle Identity Manager Attribute	Oracle e-Business Employee Reconciliation Attribute	Description
First Name	PER_ALL_PEOPLE_F.FIRST_NAME	First name
Email	PER_ALL_PEOPLE_F.EMAIL_ADDRESS	E-mail address
Person ID	PER_ALL_PEOPLE_F.PERSON_ID	Identification ID
Middle Name	PER_ALL_PEOPLE_F.MIDDLE_NAMES	Middle name
Last Name	PER_ALL_PEOPLE_F.LAST_NAME	Last name
Department	HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID	Organization
SSN	PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER	Social security number
Title	PER_ALL_PEOPLE_F.TITLE	Title
Location	HR_LOCATIONS_ALL.LOCATION_CODE	Location
Manager	PER_ALL_PEOPLE_F.FULL_NAME	Supervisor's name
City	PER_ADDRESSES.TOWN_OR_CITY	City
Postal Code	PER_ADDRESSES.POSTAL_CODE	Postal code
Country	PER_ADDRESSES.COUNTRY	Country name
Telephone Number	PER_ADDRESSES.TELEPHONE_NUMBER_1	Telephone number
Employee number	PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER	Assignment number
Manager ID	PER_ALL_PEOPLE_F.PERSON_ID	Identification ID for supervisor