PeopleSoft Enterprise Global Payroll 9.1 PeopleBook

Integrating with PeopleSoft Enterprise Performance Management

This chapter provides an overview of the Performance Management interface and discusses how to:

Review the delivered setup values.
Extract data to the Performance Management tables.

Understanding the Performance Management Interface

You can interface your Global Payroll system with the data warehouse in Performance Management. Through the Finalize phase of the Payroll COBOL process (GPPDPRUN), you can send earning, deduction, and accumulator information into Global Payroll "EPM" tables, where the Performance Management product can access and receive the data.

The major tasks involved in preparing and extracting data for integration with Performance Management are:

Reviewing the delivered setup data that enables you to extract data to Performance Management tables and creating country specific versions, if necessary.
Running the Finalize phase of the Payroll process, which loads the data into the Performance Management tables.

See Processing Payroll.

Once you have completed these steps, and completed all of the integration prerequisites in your Performance Management database, you can import the data into your Performance Management database. Performance Management integration prerequisites, as well as the process of importing of data from Global Payroll into Performance Management, are discussed in the Performance Management PeopleBook.

Reviewing Delivered Setup Data in the Global Payroll Database

The Global Payroll database must be set up to send payroll data to Performance Management. PeopleSoft delivers all of the sample data necessary for this purpose. However, you may need to modify this data so that it is country specific. The following is a list of PeopleSoft delivered data that must be defined in your Global Payroll database for integration with Performance Management:

Writable Array: GP WA GUIDE.
Report Data: GP_EPM.
PSJob Job Definition: GP_PAYE.

Pages Used to Review Delivered Setup Data

Page Name	Definition Name	Navigation	Usage
Writable Array Name	GP_PIN	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Writable Array Name	Review the writable array name details.
Definition and Fields	GP_WRITABLE_ARRAY	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Definition and Fields	Review the writable array definition and writable array fields.
Define Report Data	GP_RPT_TBL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Define Report Data, Define Report Data	Assign the output table, writable array, primary input table type, and segment option.
Report Data Process Details	GP_RPT_DTL_SEC	Click the Details link on the Define Report Data page.	Map fields and create filters used to generate the output table.
Job Definition	PRCSJOBDEFN	PeopleTools, Process Scheduler, Jobs, Job Definition	Review details of the GP_PAYE PSJob definition.

Reviewing the Delivered Writable Array Name

Access the Writable Array Name page for element GP WA GUIDE (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Writable Array Name).

Note. You must put the writable array in a Global Payroll section that will be executed. You do this on the Define Report Data page.

Reviewing the Delivered Writable Array Definition

Access the Definition and Fields page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Supporting Elements, Writable Arrays, Definition and Fields).

Reviewing Delivered Report Data

Access the Define Report Data page for GP_EPM (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Define Report Data, Define Report Data).

See Selecting Output Tables and Primary Input Tables.

Reviewing Report Data Details

Access the Report Data Process Details page (click the Details link on the Define Report Data page).

See Mapping Fields.

Reviewing the Delivered GP_PAYE Job Definition

Access the Job Definition page for the PSJob of GP_PAYE (PeopleTools, Process Scheduler, Jobs, Job Definition).

GP_PAYE consists of two Application Engine programs. The first program stores run control data in a temporary table (GP_RUNCTL_TMP). The second program checks to see if the payroll process had been finalized successfully, and if so, calls the program that launches the Report Data process. The Report Data process populates the Global Payroll "EPM" tables with earning, deduction, and accumulator information for all processed payees.

Loading Data into the Global Payroll EPM Tables

During successful Payroll Finalize processes, the system populates the following Global Payroll "EPM" tables with earning, deduction, and accumulator information, including absence accumulators:

Table	Name	Description
GP_EPM_GUI_TMP	Report Guide Table	This record serves as a header for the detail of the payroll results. Each row in this table represents a segment calculated for the calendar group.
GP_EPM_DTL_TMP	Report Detail Table	This record stores all earnings, deductions, and accumulators of payroll results.
GP_PIN_USER_FLD	Pin User Field Name by Element	By earning, deduction, or accumulator, this record stores the pin name of each user field for earnings and deductions, and stores all user keys for accumulators.
GP_SEG_GUIDE_WA	Segment Guide Writable Array	This record stores selected HR data as of the calculation of payroll versus from JOB.
GP_RUNCTL_TMP	Save of GP_RUNCTL	This record stores data from the payroll run control.
GP_RUNCTL_AET	Stat Record for AE	This is a technical record which references GP_PAYAFTER.

Once all data is loaded into the tables, the Performance Management Data Warehouse feature can access and import the data. See your Performance Management PeopleBook for more information.