Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Workforce Analytics > Process of Configuring Workforce Payroll for Oracle 11i >

Modifying the Workforce Payroll Filters


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

Siebel Customer-Centric Enterprise Warehouse is preconfigured to extract the input value name of Pay Value. Siebel Customer-Centric Enterprise Warehouse does not extract classification elements such as Information, Balance, or Employer. To modify the Payroll filter perform the following procedure.

NOTE:  If you change the Payroll filter, you need to also change the Siebel Business Analytics metadata, so your reports are run correctly.

To modify the Payroll filters

  1. Open the FILE_PARAMETERS_ORA11i.CSV file using Notepad in the installation directory in $pmserver\srcfiles.
  2. Search for the strings in the following table, and change or delete these to match your requirements.

    PAY_INPUT_VALUES_F.NAME='Pay Value'

    CLASSIFICATION_NAME NOT LIKE '%Information%'

    CLASSIFICATION_NAME NOT LIKE '%Employer%'

    CLASSIFICATION_NAME NOT LIKE '%Balance%

    NOTE:  There are two entries for each string—Payroll Extract and Pay Type Extract. You need to make the same changes for both entries.

  3. Save and close the file.
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide