Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Workforce Analytics > Process of Configuring Workforce Operations for Oracle 11i >

Configuring Sex Codes


The steps for configuring Sex Codes and Sex Descriptions are similar to those for configuring Ethic Groups. The domain values for Sex Code and Sex Description are shown in Table 83.

Table 83. Domain Values for Sex Code and Sex Description
Sex Code
Sex Description

F

Female

M

Male

U

Unknown

It is recommended that you do not change the pre-packaged domain values. If you do so, there will be impacts on the Dashboards and the reporting metadata. You should limit yourselves to just 'mapping' the source supplied values against the packaged set of domain values. A sample set of domain value 'maps' is provided as a CSV lookup file - you should be modifying that file according to values that your source provides. An example of the CSV lookup is shown in Table 80.

Table 84. Sample Source Values for Sex Code and Sex Description
SEX
W_SEX_MF_CODE
W_SEX_MF_DESC

F

F

Female

M

M

Male

 

U

Unknown

NOTE:  This example CSV lookup file specifies that the Sex Code "F" signifies the group 'Female'. However, you should use the Sex Code used by your source system.

To modify the Sex Code

  1. Edit the file "domainValues_Employee_Sex_MF_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
  2. Modify the Sex column (the source code) as required so that it maps correctly in the corresponding domain values in the table above.
  3. Save the file.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.