Completing Survey Mapping Definitions

To map survey data, use the WA_MAP_TREE_TBL.GBL, WA_JOB_MAP_DFN.GBL, WA_COMP_MAP_DFN.GBL, WA_GEO_MAP_DFN.GBL, WA_IND_MAP_DFN.GBL, WA_FIN_MAP_DFN.GBL, and WA_UNIT_MAP_DFN.GBL components.

This section provides an overview of survey mapping definitions and discusses how to:

Set up workforce trees.
Map job codes.
Map survey compensation codes.
Map geography IDs.
Map industry codes.
Map financial codes.
Map unit codes.

Pages Used to Complete Survey Mapping Definitions

Page Name	Definition Name	Navigation	Usage
Workforce Trees	WA_MAP_TREE_TBL	select Workforce Analytics, then select Workforce Analytics Setup, then select Setup Workforce Trees, then select Workforce Trees	Specify the SetID, effective date, and names of the trees that you want the system to use. In Workforce Rewards (external surveys, market compensation) and Workforce Planning, many of the main dimensions get their hierarchical structure from trees.
Job Code Map	WA_JOB_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Job Code	Use this page to map survey job codes to nodes on the Workforce Analytics JOBCODE tree.
Mapping Notes	WA_DESCR_SPNL	From the Job Code Map, Compensation Code Map, Geography ID Map, Industry Map, Financial Code Map, or Unit Code Map page, click the Description button.	Enter a long description or more detailed mapping notes for any of the following primary pages that are applicable: Job Code Map, Compensation Code Map, Geography ID Map, Industry Code Map, Financial Code Map, or Unit Code Map.
Compensation Code Map	WA_COMP_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Compensation Code	Map survey compensation codes to nodes on the Workforce Analytics COMPCODE tree.
Geography ID Map	WA_GEO_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Geography ID	Map survey geography IDs to nodes on the Workforce Analytics GEOGRAPHY tree.
Industry ID Map	WA_IND_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Industry ID	Map survey industry IDs to nodes on the Workforce Analytics INDUSTRY tree.
Financial Code Map	WA_FIN_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Financial Code	Map survey financial codes to nodes on the Workforce Analytics FINCODE tree.
Unit Code Map	WA_UNIT_MAP_DFN	select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Unit Code	Map survey unit codes to nodes on the Workforce Analytics UNITCODE tree.

Understanding Survey Mapping Definitions

When you run the setup batch for salary surveys and benchmark surveys, the system partially populates the following OWE mapping tables: WA_COMP_MAP_DFN, WA_FIN_MAP_DFN, WA_GEO_MAP_DFN, WA_IND_MAP_DFN, WA_JOB_MAP_DFN, and WA_UNIT_MAP_DFN. Your next task is to complete the data mapping definitions using the access pages for these tables. The mapping definitions are needed to prepare for your second set of ETLs. In this step you map survey data to previously defined EPM dimensions (JOB, COMPENSATION, GEOGRAPHY, INDUSTRY, FINANCIAL, and UNIT) and trees (JOBCODE, COMPCODE, GEOGRAPHY, INDUSTRY, FINCODE, and UNITCODE).

Common Elements

The following common elements apply to this section:

SetID

Select a SetID to access the survey mapping pages.

Survey Instance

Select a survey instance to access the survey mapping pages.

Note: Depending upon the page, you also specify one of the following: a survey job code, survey compensation code, survey geography ID, survey industry code, survey financial code, or survey unit code. The values for these fields are in the system for you to use as prompts after you have run the Setup batch of ETLs.

Survey

Displays the survey author ID that is associated with this survey instance.

Description

Click access the Mapping Notes page, where you can enter a long description or more detailed mapping notes (Access this page from these other pages: Job Code Map, Compensation Code Map, Geography ID Map, Industry Map, Financial Code Map, or Unit Code Map page, click the Description button. Access the Mapping Notes page by clicking the Description button).

View Tree

Click to access the Tree Viewer page, where you can specify the name of the tree node or detail to which you want to map your survey value. The system also displays the name of the current selection for the appropriate default tree. You indicated this tree on the Workforce Trees page.

Workforce Trees Page

Use the Workforce Trees page (WA_MAP_TREE_TBL) to specify the SetID, effective date, and names of the trees that you want the system to use.

In Workforce Rewards (external surveys, market compensation) and Workforce Planning, many of the main dimensions get their hierarchical structure from trees.

Navigation

select Workforce Analytics, then select Workforce Analytics Setup, then select Setup Workforce Trees, then select Workforce Trees

Image: Workforce Trees setup page

This example illustrates the fields and controls on the Workforce Trees setup page. You can find definitions for the fields and controls later on this page.

Note: This page has SetID as a key. When you specify a default tree on this page for use with a Workforce Rewards application, the tree mapping value must remain constant. That is, the tree mapping must remain unchanged from the start of your market compensation survey import through your use of the survey data in the Workforce Rewards business process modules.

Job Code Tree, Compensation Code Tree, Geography Tree, Organization Tree, Account Tree, Position Tree, and Business Unit Tree

These trees are used in one or more of the workforce analytic applications. Prompt values are from the PF_METATREE_TBL table. This ensures that only those trees that have tree metadata are available to map.

Industry Tree, Financial Code Tree, and Unit Code Tree

These trees are used in the Workforce Rewards application. Prompt values are from the WA_INDTREE_VW, WA_FINCODE_VW, and WA_UNITCODE_VW tables, respectively.

Competency Tree

This tree is used in the Workforce Planning application. Prompt values are from the WA_CMPT_TREE_VW table.

Job Code Map Page

Use the Job Code Map page (WA_JOB_MAP_DFN) to use this page to map survey job codes to nodes on the Workforce Analytics JOBCODE tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Job Code

Image: Job Code Map setup page

This example illustrates the fields and controls on the Job Code Map setup page. You can find definitions for the fields and controls later on this page.

Survey

Displays the description, FLSA status, and total points from the WA_SUR_JOB_VW table.

Workforce Analytics

Select the job code set to which you want to map the survey job code (EPM Foundation, Business Metadata, OW-E Dimension Maintenance, HRMS, Employee and Job, Job Code Set).

Job Code Set

Job Code Set prompts you from the WA_JBCDSET_VW table. A job code set is a group of related job codes belonging to the same node on the JOBCODE tree. A leaf or detail on the tree is an individual job code.

Compensation Code Map Page

Use the Compensation Code Map page (WA_COMP_MAP_DFN) to map survey compensation codes to nodes on the Workforce Analytics COMPCODE tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Compensation Code

Survey

Displays the description from the WA_SUR_COMP_VW table.

Workforce Analytics

Select the compensation code to which you want to map the survey compensation code.

Compensation Code

Compensation Code prompts you from the COMPCODE_VW table.

Geography ID Map Page

Use the Geography ID Map page (WA_GEO_MAP_DFN) to map survey geography IDs to nodes on the Workforce Analytics GEOGRAPHY tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Geography ID

Survey

Displays the description from the WA_SUR_GEO_VW table.

Workforce Analytics

Select the geography ID to which you want to map the survey geography ID (EPM Foundation, Business Metadata, OW-E Dimension Maintenance, Common, Geography).

Geography ID

Geography ID prompts you from the GEOGRAPHY_VW table.

Industry ID Map Page

Use the Industry ID Map page (WA_IND_MAP_DFN) to map survey IDs to nodes on the Workforce Analytics INDUSTRY tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey , then select Map Industry ID

Survey

Displays the description from the WA_SUR_IND_VW table.

Workforce Analytics

Select the industry ID to which you want to map the survey industry ID.

Industry ID

Industry ID prompts you from the WA_INDUSTRY_VW table.

Financial Code Map Page

Use the Financial Code Map page (WA_FIN_MAP_DFN) to map survey financial codes to nodes on the Workforce Analytics FINCODE tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Financial Code

Survey

Displays the description, from value and to value from the WA_SUR_FIN_VW table.

Workforce Analytics

Select the financial code to which you want to map the survey financial code.

Financial Code

Financial Code prompts you from the WA_FINCODE_VW table. When you use the Tab key to move through the field, the system displays the associated from value andto value.

Unit Code Map Page

Use the Unit Code Map page (WA_UNIT_MAP_DFN) to map survey unit codes to nodes on the Workforce Analytics UNITCODE tree.

Navigation

select EPM Foundation, then select Business Metadata, then select OW-E Dimension Maintenance, then select HRMS, then select Survey, then select Map Unit Code

Survey

Displays the description, from value and to value from the WA_SUR_UNIT_VW table.

Workforce Analytics

Select the unit code to which you want to map the survey unit code.

Unit Code

Unit Code prompts you from the WA_UNITCODE_VW table. When you use the Tab key to move through the field, the system displays the associated from value andto value.