10.2 Data that You Can Import from Oracle Human Resources

Table 10-1 lists the tables in the Oracle Human Resources schema. If you choose, you can import most of these attributes into Oracle Internet Directory.

Table 10-1 Tables in Oracle Human Resources Schema

Table Name	Alias Used in the Connector Config Info Field
PER_PEOPLE_F	PER
PER_ADDRESSES	PA
PER_PERIODS_OF_ SERVICE	PPS
PER_PERSON_TYPES	PPT

All of these tables are visible if the login to the Oracle Human Resources database is done with the apps account.

Because attributes can be added or deleted at runtime from the configuration file, the Oracle Human Resources connector dynamically creates a SQL statement that selects and retrieves only the required attributes.

Table 10-2 shows some of the fields in the Oracle Human Resources user interface. These fields appear when you add or modify employee data.

Table 10-2 Fields in the Oracle Human Resources User Interface

ATTRIBUTE NAME	DESCRIPTION	FORM/CANVAS/FIELD_NAME
`LAST_NAME`	Last name of the person	People/Name/Last
`FIRST_NAME`	First name of the person	People/Name/First
`TITLE`	Title of the person	People/Name/Title
`SUFFIX`	Suffix—for example, Jr, Sr, Ph.D.	People/Name/Suffix
`MIDDLE_NAME`	Middle name	People/Name/Suffix
`SEX`	Sex	Gender List box
`START_DATE`	Hiring date	People/Hire Date
`DATE_OF_BIRTH`	Date of birth	People/Personal Information/Birth Date
`MARITAL_STATUS`	Marital status	People/Personal Information/Status
`NATIONAL_ INDENTIFIER`	Social security number for US residents	People/Identification/Social Security
`EMPLOYEE_NUMBER`	Employee number	People/Identification/Employee
`REGISTERD_ DISABLED_ FLAG`	Indicator that the employee has a disability	People/Personal Information/Has Disability
`EMAIL_ADDRESS`	Electronic mail address	People/Personal Information/EMail
`OFFICE_NUMBER`	Office location	People/Office Location Info/Office
`MAILSTOP`	Mail delivery stop	People/Office Location Info/Mail Stop
`INTERNAL_LOCATION`	Location	People/Office Location Info/Location
`ADDRESS_LINE1`	Address line 1	Personal Address Information/Address line 1
`ADDRESS_LINE2`	Address line 2	Personal Address Information/Address line 2
`ADDRESS_LINE3`	Address line 3	Personal Address Information/Address line 3
`TOWN_OR_CITY`	Town or city	Personal Address Information/City
`REGION_1`	First region	Personal Address Information/County
`REGION_2`	Second region	Personal Address Information/State
`POSTAL_CODE`	Postal code	Personal Address Information/Zip Code
`COUNTRY`	Country	Personal Address Information/Country
`TELEPHONE_ NUMBER_1`	First telephone number	Personal Address Information/Telephone
`TELEPHONE_ NUMBER_2`	Second telephone number	Personal Address Information/Telephone2