Batch Processing Output Tables

The goal of an 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 Absence Management, 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.

Tables Generated by Payee Selection Process

The payee selection process generates the following tables:

• Process Stat (status) record (GP_PYE_PRC_STAT).

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

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

• Segment Stat record (GP_PYE_SEG_STAT).

  The Segment Stat record is a child of the 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:

• Generated Positive Input (GP_GEN_PI_DATA).

  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.

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 Process Stat table (GP_PYE_PRC_STAT).

Tables Containing Absence Daily Data Results

The following table contains the absence daily data results.

Absence Daily Data (GP_RSLT_ABS)