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

Configuring the Jobs Dimension for U.S. Statutory Compliance

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

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

• EEO Job Category Code (W_EEO_JOB_CAT_CODE)
• EEO Job Category Description (W_EEO_JOB_CAT_DESC)
• FLSA Status Code (W_FLSA_STATUS_CODE)
• FLSA Status Description (W_FLSA_STATUS_DESC)

Configuring EEO Job Category Codes

The domain values for EEO Job Category Code and EEO Job Category Description in Oracle Business Analytics Warehouse are shown in Table 85.

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 file is shown in Table 86.

NOTE:  This example CSV lookup file specifies that the EEO Job Category Code "1:EEO1CODE" signifies the group 'Laborers (Unskilled)'. However, you should use the EEO Job Category Code used by your source system.

To modify EEO Job Category code

1. Edit the file "domainValues_Job_Eeo_Cat_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the EEO_JOB_CAT_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 EEO Job Category Descriptions

As with the Ethnic Group Description and Veteran Status Description, make sure that the EEO Job Category Description used with the source-specified code matches the description defined in the domain values. For example, in the sample source data in Table 86, the source system uses the description Office-Clerical instead of Office and Clerical for source-supplied Code 2.

To modify the EEO Job Category description

1. Edit the file "domainValues_Job_Eeo_Cat_Code_ora11i.csv" in the $pmserver\LkpFiles directory using in a text editor.
2. Modify the W_EEO_JOB_CAT_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.

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