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

Configuring the Employees Dimension for U.S. Statutory Compliance

This task is a step in the Process of Configuring Workforce Operations for Oracle 11i.

Within the Employees dimension, there are mandatory changes to the configuration information about 3 sets of columns, as follows:

• Ethnic Group Code (W_ETHNIC_GRP_CODE)
• Ethnic Group Description (W_ETHNIC_GRP_DESC)
• Veteran Status Code (W_VETERAN_STATUS_CODE)
• Veteran Status Description (W_VETERAN_STATUS_DESC)
• Sex Code (W_SEX_MF_CODE)
• Sex Description (W_SEX_MF_DESC)

Configuring Ethnic Group Codes

The domain values for Ethnic Group Code and Ethnic Group Description in Oracle Business Analytics Warehouse are shown in Table 79.

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.

NOTE:  This example CSV lookup file specifies that the Ethnic Code "7" signifies the group 'American Indian/Alaskan Native'. However, you should use the Ethnic Code used by your source system.

To modify the Ethnic Group code

1. Edit the file "domainValues_Employee_Ethnic_Group_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the W_ETHINIC_CODE column (the source code) as required so that it maps correctly in the corresponding domain values in the table above.
3. Save the file.

Configuring Ethnic Group Descriptions

For the Ethnic Group Description, make sure that the description used with the source-specified code matches the description defined in the domain values. For example, if the source system uses the description, African American, instead of Black for code 2, the description must be modified to reflect the descriptive value of Black.

To modify the Ethnic Group description

1. Edit the file "domainValues_Employee_Ethnic_Group_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the W_ETHNIC_GRP_DESC column (the domain value description) as required (that is, as specified by your source system).
3. Save the file.

NOTE:  You might need to change the metric names in the reporting data to use more suitable names.

Configuring Veteran Status Codes

The steps to resolve the Veteran Status Code and the Veteran Status Description requirements are very similar to those for Ethnic Group. The domain values for Veteran Status Code and Veteran Status Description are shown in Table 81.

It is recommended that you do not change the pre-packaged domain values. Changing the pre-packaged domain values 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 modify that file according to values that your source provides. An example of the CSV lookup file is shown in Table 82.

NOTE:  This example CSV lookup file specifies that the Veteran Status Code "VIETVETDIS" signifies the status 'Special Disabled Veteran'. However, you should use the Veteran Status Code used by your source system.

To modify Veteran Status code

1. Edit the file "domainValues_Employee_Veteran_Status_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the VETERAN_STATUS_CODE column (the source code) as required so that it maps correctly in the corresponding domain values in the table above.
3. Save the file.

NOTE:  You might need to change the metric names in the reporting data to use more suitable names.

Configuring Veteran Status Descriptions

As with the Ethnic Group Description, make sure that the Veteran Status Description used with the source-specified code matches the description defined in the domain values. For example, in the sample source data in Table 82, the source system uses the description Other Veterans instead of Other Protected Veterans for source-supplied code VET.

To modify Veteran Status description

1. Edit the file "domainValues_Employee_Veteran_Status_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the W_VETERAN_STATUS_DESC column (the domain value description) as required so that it maps correctly in the corresponding domain values in the table above.
3. Save the file.