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

Aggregating the Payroll Table for Siebel Enterprise Workforce Analytics


To load the Payroll aggregate table (IA_PAYROLL_A4), you need to configure the post-load processing parameter file, file_parameters_plp.csv, and run the initial workflow and then the incremental workflow.

To configure the file_parameters_plp.csv parameters file

  1. Open the file_parameters_plp.csv file using Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
  2. Replace the default PARM_SVALUE2 values with your new values.

    For a list of values for each parameter see the About Aggregating the Payroll Table for Siebel Enterprise Workforce Analytics.

    The default values are shown in the following table:

PARM_TYPE
PARM_CODE
PARM_SVALUE_1
PARM_SVALUE_2
PARM_SVALUE_3

PLP

S_M_PLP_PAYROLL_A4_INIT:GRAIN

S

'MONTH'

PLP

S_M_PLP_PAYROLL_A4_POST:GRAIN

S

MONTH

MPLT_LKP_PERIOD_START_END_DK

NOTE:  You need to use single quotes for the S_M_PLP_PAYROLL_A4_INIT:GRAIN session value.

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