Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Workforce Analytics >

Configuring Domain Values and CSV Worksheet Files for Siebel Enterprise Workforce Analytics

You need to configure the CSV files in Siebel Enterprise Workforce Analytics by mapping domain values to columns. The CSV worksheet files for Siebel Enterprise Workforce Analytics are in the $pmserver\LkpFiles folder.

For more information on configuring domain values with CSV worksheet files, see About Domain Values and Configuring the Domain Value Set with CSV Worksheet Files.

To configure the domainValues_Employment_ora11i.csv

1. Identify the Person Types in your Orace11i source system by using the following SQL:

   SELECT DISTINCT SYSTEM_PERSON_TYPE, USER_PERSON_TYPE FROM

   PER_PERSON_TYPES

   WHERE SYSTEM_PERSON_TYPE IN

   ('EMP','OTHER','EMP_APL','EX_EMP','EX_EMP_APL','RETIREE','PRTN')

   ORDER BY 1, 2

   NOTE:  If you have modified the Payroll filter, you need to also modify the SQL. For more information on modifying Payroll filters, see Modifying the Workforce Payroll Filters.

2. Open the domainValues_Employment_ora11i.csv file using Microsoft WordPad or Notepad in the $pmserver\lkpfiles folder.
3. Copy the Person Types to the SYSTEM_PERSON_TYPE and USER_PERSON_TYPE columns.

   Use commas to separate the entries.

4. Map each User Person Type to one domain value.

   System Person Types are also extracted with User Person Type to help you map the domain values.

   For more information Employment domain values, see Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

   NOTE:  Incorrect mappings result in inaccurate calculations of Siebel Business Analytics metrics.

5. Save and close the file.

To configure the domainValues_Pay_Types_ora11i.csv

1. Identify the Pay Elements in your Orace11i source system by using the following SQL:

   SELECT DISTINCT CLASSIFICATION_NAME, ELEMENT_NAME

   FROM

   PAY_ELEMENT_TYPES_F,

   PAY_ELEMENT_CLASSIFICATIONS

   WHERE

   PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_ID = PAY_ELEMENT_TYPES_F.CLASSIFICATION_ID AND

   CLASSIFICATION_NAME NOT LIKE '%Information%' AND

   CLASSIFICATION_NAME NOT LIKE '%Employer%' AND

   CLASSIFICATION_NAME NOT LIKE '%Balance%'

   ORDER BY 1, 2

2. Open the domainValues_Pay_Types_ora11i.csv file using Microsoft WordPad or Notepad in the $pmserver\lkpfiles folder.
3. Copy the Pay Elements to the CLASSIFICATION_NAME and ELEMENT_NAME columns.

   Use commas to separate the entries.

4. Map each Element Name to one domain value.

   Classification Names are also extracted with Element Names to help you map the domain values. If the element is not related to Payroll Pay Check, you can map the element to Other.

   For more information on Pay Type domain values, see Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

   NOTE:  Incorrect mappings result in inaccurate calculations of Siebel Business Analytics metrics.

5. Save and close the file.

To configure the domainValues_EventTypes_ora11i.csv

1. Identify the Event Types in your Orace11i source system by using the following SQL:

   SELECT DISTINCT LOOKUP_TYPE, LOOKUP_CODE, MEANING

   FROM FND_LOOKUP_VALUES

   WHERE LOOKUP_TYPE IN

   ('EMP_ASSIGN_REASON',

   'LEAV_REAS',

   'PROPOSAL_REASON')

   ORDER BY 1, 2, 3

2. Open the domainValues_EventTypes_ora11i.csv file using Microsoft WordPad or Notepad in the $pmserver\lkpfiles folder.
3. Except the first five rows in the file, delete all the other rows.
4. Copy the Event Types to the LOOKUP_TYPE, LOOKUP_CODE, and MEANING columns from row 6.

   Use commas to separate the entries.

5. Map each Event Type (LOOKUP_CODE) to one domain value for each of the 3 domain columns— IA_EVENT_GRP_CODE, IA_EVENT_SUBG_CODE, and IA_EVENT_REASON_CODE.

   Event Category (LOOKUP_TYPE) and Event Description (MEANING) are also extracted with Event Type to help you map the domain values.

   For more information on Event Type domain values, see Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

   NOTE:  Incorrect mappings result in inaccurate calculations of Siebel Business Analytics metrics.

6. Save and close the file.