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

Configuring Phone Types for Workforce Profile

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

There are four phone related fields in the Employee dimension table, as follows:

• Fax
• Work phone
• Pager
• Mobile phone

The following logic is used to arrive at the various types of addresses:

• Fax: Phone Type = 'WF' (Work Fax)
• Work Phone: Phone Type = 'W1' (First work phone, if there are more than one)
• Pager: Phone Type = 'P' (Pager)
• Mobile: Phone Type = 'M' (Mobile)

You can modify this logic if required. For example, if your system tracks the primary work phone with a special phone type 'WP', instead of W1, then you should be able to modify the existing logic. The same applies for other phone types as well.

To configure Phone Type

1. In PowerCenter Designer, open the SDE_ORA1158_Adapter folder.
2. In Mapplet Designer, open the mplt_SA_ORA_EmployeeDimension mapplet.
3. Locate the expression transformation Exp_SA_Employee and scroll down the ports to get to the output ports "EXT_FAX_PH_NUM", "EXT_WORK_PHONE", "EXT_PAGER_NUM" and "EXT_MOBILE_NUM".

   For example, if you have a specific phone type for the primary work phone, 'WP', you would modify the expression for the output port EXT_WORK_PHONE as follows:

   From: :LKP.Lkp_Phone_Number(INP_PERSON_ID, 'W1', INP_EFFECTIVE_END_DATE, INP_DATASOURCE_NUM_ID)

   To: :LKP.Lkp_Phone_Number(INP_PERSON_ID, 'WP', INP_EFFECTIVE_END_DATE, INP_DATASOURCE_NUM_ID)

4. Validate and save changes to the repository. If you are using the version controlling for the Informatica repository, you will have to check in your changes as well.