Use Gender Lookup Type in the EEO Report

In this example, you will learn what you need to do so that the Oracle delivered United States Equal Employment Opportunity (EEO) report operates correctly if you add a new lookup code in the SEX lookup type.

Kate Williams is the Director of Human Resources and she wants her employees in the United States to be able to select a value of "Undeclared" while specifying the gender.

As a part of this, you will create a new lookup code in the SEX lookup type with a value of "Undeclared" and a tag of "+US", and map this to the Oracle delivered Gender of a person (System Lookup).

Note: This is an example of the mapping that needs to be done if you add a new lookup code. Oracle doesn't recommend that the "Undeclared" value always be mapped to the "Male" value for EEO reporting purposes.

Create a New Code

1. Click Setup and Maintenance under the name menu.

2. Search for and click the Manage Common Lookups task.

3. Enter SEX as the Lookup Type and click Search.

4. Click the + icon (New) in the SEX: Lookup Codes section and enter this information.

   Field	Value
   Lookup Code	UNDECLARED
   Enabled	Select the check box
   Start Date	01/01/2000
   Meaning	Undeclared
   Tag	+ US

5. Click Save and Close.

Map the New Lookup Code to the System Lookup

1. Click Setup and Maintenance link under the name menu.

2. Search for and click the Manage Extended Lookup Codes task.

3. Navigate to and select Gender of a person (System Lookup) in the Lookup Type region.

4. Click Add to enter this information.

   Field	Value
   Country	United States
   Lookup Code	Male
   Extended Code	UNDECLARED (this is the value added in the Lookup Code in the above task)
   Extended Name	Undeclared (this is the value added in the Meaning in the above task)
   All Enterprises	Yes

5. Click Save and Close.

   The EEO report will now display all employees who have selected a gender of "Undeclared" as "Male".