Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise 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 in the Expression transformation EXP_EMPLOYEES for the mapping M_I_EMPLOYEES_EXTRACT.

The configuration information includes the domain values for the following:

• Ethnic Group Code (ETHN_GRP_CODE_OUT)
• Ethnic Group Description (ETHN_GRP_DESC_OUT)
• Veteran Status Code (VETERAN_STAT_CODE_OUT)
• Veteran Status Description (VETERAN_STAT_DESC_OUT)

Configuring Ethnic Group Codes

The domain values for Ethnic Group Code and Ethnic Group Description in Siebel Customer-Centric Enterprise Warehouse are shown in Table 54.

For each of these ports' expressions, it is necessary that the source-supplied values are mapped to the expected domain values so that correct ethnic group and veteran status information is supplied. For example, if the source-supplied values were as shown in Table 55, there would be a discrepancy between the domain values in Siebel Customer-Centric Enterprise Warehouse and source-supplied value for Ethnic Group Code 1, 2, and 4.

To modify the Ethnic Group code

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the M_I_EMPLOYEES_EXTRACT mapping, double-click the EXP_EMPLOYEES Expression transformation.
3. Modify the ETHN_GRP_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 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. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the M_I_EMPLOYEES_EXTRACT mapping, double-click the EXP_EMPLOYEES Expression transformation.
3. Modify the ETHN_GRP_DESC_OUT port's expression by mapping the source-supplied values to the domain values.
4. Validate and save your changes to the repository.

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 56.

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 veteran status information is supplied. For example, if the source-supplied values for Veteran Status Code and Veteran Status Description were as shown in Table 57, there would be a discrepancy between the domain values and source-supplied values for all codes.

To modify Veteran Status code

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. In the M_I_EMPLOYEES_EXTRACT mapping, double-click the EXP_EMPLOYEES Expression transformation.
3. Modify the VETERAN_STAT_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 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 57, the source system uses the description Other Veterans instead of Other Protected Veterans for source-supplied code VET.

To modify Veteran Status description

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