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.

Note:

Some Asian languages use multibyte character sets. If the character limit for the fields in the target system is specified in bytes, then the number of Asian-language characters that you can enter in a particular field may be less than the number of English-language characters that you can enter in the same field. The following example illustrates this limitation:

Suppose you can enter 50 characters of English in the User Last Name field of the target system. If you have configured the target system for the Japanese language, then you would not be able to enter more than 25 characters in the same field.

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
Nationality	PER_ALL_PEOPLE_F.NATIONALITY	Nationality