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 product documentation for more information.