Batch Processing Output Tables

The goal of a payroll or absence batch processing run is to produce a set of output tables, where your important batch processing data results reside. Once you know the type of information that resides in the output tables that are generated by Global Payroll, you can use those tables to produce reports and other data manipulations that are relevant to your organization's needs.

This diagram shows the relationships between the batch processing output tables.

Relationships Between batch processing output tables

Tables Generated by Payee Selection Process

The payee selection process generates the following tables:

  • Pay Process Stat (status) record (GP_PYE_PRC_STAT).

    There is one Pay Process Stat record for every EMPLID/EMPL_RCD combination per calendar.

    There is a one-to-one/many relationship between the Pay Process Stat record and the Segment Stat record.

  • Segment Stat record (GP_PYE_SEG_STAT).

    The Segment Stat record is a child of the Pay Process Stat record. There is one Segment Stat record for each gross to net within the calendar.

Tables Containing Element Results

The following tables contain element results:

  • Earnings/Deductions (GP_RSLT_ERN_DED).

    Contains the results of earnings and deductions after batch processing.

  • Other Elements (GP_RSLT_PIN).

    Contains the results of miscellaneous element resolutions after batch processing including the results for absence entitlement elements.

Table Containing Accumulator Results

The Accumulators table (GP_RSLT_ACUM) contains the results of accumulators after batch processing.

Table Containing Deltas

The Deltas table (GP_RSLT_DELTA) contains deltas, which are the differences between two element results. This data is often important for processing retroactivity. This table is a child table to the Segment Stat (segment status) table (GP_PYE_SEG_STAT), which is a child of the Pay Process Stat table (GP_PYE_PRC_STAT).

Tables Containing Positive Input Results

The following tables contain positive input results:

  • Positive Input Data (GP_RSLT_PI_DATA).

    Contains the results of positive input calculations after batch processing. Only the positive input rows that were used in the calculation are included in this table.

  • Positive Input Supporting Element Overrides (GP_RSLT_PI_SOVR).

    Contains the results of supporting element overrides after batch processing.

  • Absence Daily Data (GP_RSLT_ABS).

    Contains the absence daily data results.