Bookshelf Home | Contents | Index | PDF     

Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise 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 two mandatory changes to the configuration information in the Expression transformation EXP_JOBS for the mapping M_I_JOBS_EXTRACT. The configuration information includes the domain values for the following:

  • EEO Job Category Code (EEO_JOB_CAT_CODE_OUT)
  • EEO Job Category Description (EEO_JOB_CAT_DESC_OUT)

Configuring EEO Job Category Codes

The domain values for EEO Job Category Code and EEO Job Category Description in Siebel Customer-Centric Enterprise Warehouse are shown in Table 58.

Table 58. Domain Values for EEO Job Category Code and EEO Job Category Description
EEO Job Category Code
EEO Job Category Description

1

Officials and Managers

2

Professionals

3

Technicians

4

Sales Workers

5

Office and Clerical

6

Craft Workers

7

Operatives

8

Laborers

9

Service Workers

For each of these ports' expressions, it is necessary that the source-supplied values are mapped to the expected domain values so that the correct EEO job category information is supplied. For example, if the source-supplied values were as shown in Table 59 there would be a discrepancy between the domain values and source-supplied values for EEO Job Categories 1, 2, 5, and 8.

Table 59. Sample Source-Supplied EEO Job Category Code and EEO Job Category Description
EEO Job Category Code
EEO Job Category Description

1:EEO1CODE

Laborers (Unskilled)

2:EEO1CODE

Office-Clerical

3:EEO1CODE

Technicians

4:EEO1CODE

Sales Workers

5:EEO1CODE

Professionals

6:EEO1CODE

Craft Workers

7:EEO1CODE

Operatives (Semi-Skilled)

8:EEO1CODE

Officials and Managers

9:EEO1CODE

Service Workers

To modify EEO Job Category code

  1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
  2. In the M_I_JOBS_EXTRACT mapping, double-click the EXP_JOBS Expression transformation.
  3. Modify the EEO_JOB_CAT_CODE_OUT port's expression by mapping the source-supplied values to the domain values.
  4. Validate and save your changes to the repository.

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 59, 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. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
  2. In the M_I_JOBS_EXTRACT mapping, double-click the EXP_JOBS Expression transformation.
  3. Modify the EEO_JOB_CAT_DESC_OUT port's expression by mapping the source-supplied values to the domain values.
  4. Validate and save your changes to the repository.
    
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide