Search Results pay_event_groups

Overview

The PAY_EVENT_GROUPS table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). Its primary function is to provide a mechanism for grouping related payroll events, thereby enabling user control and streamlined monitoring of event processing. This object is fundamental to the architecture of payroll calculations, particularly for managing complex scenarios like proration, retroactive pay, and time definition rules. By logically grouping events, the system can efficiently apply batch processing rules and maintain data integrity across interrelated payroll transactions.

Key Information Stored

The table stores the definitions for each event group. The most critical columns, as indicated by its primary and unique keys, are the EVENT_GROUP_ID (the surrogate primary key) and the EVENT_GROUP_NAME (a unique identifier for the group). A significant foreign key column is TIME_DEFINITION_ID, which links the group to a specific time definition in the PAY_TIME_DEFINITIONS table. This relationship is central to defining the period or rules under which the grouped events are evaluated and processed within the payroll cycle.

Common Use Cases and Queries

A primary use case is configuring proration rules for element entries. When an element type uses a proration formula, it is often linked via its PRORATION_GROUP_ID to a specific PAY_EVENT_GROUPS record. This allows the proration calculation to consider a set of related events rather than a single occurrence. Administrators may query this table to audit configuration or troubleshoot payroll runs. A common diagnostic query would join PAY_EVENT_GROUPS to PAY_ELEMENT_TYPES_F to list all elements associated with a given proration group.

SELECT petf.element_name, peg.event_group_name
FROM pay_event_groups peg,
     pay_element_types_f petf
WHERE peg.event_group_id = petf.proration_group_id
AND petf.element_name = '&ELEMENT_NAME'
AND sysdate BETWEEN petf.effective_start_date AND petf.effective_end_date;

Related Objects

PAY_EVENT_GROUPS maintains integral relationships with several other payroll tables, as documented by its foreign key constraints.

• PAY_TIME_DEFINITIONS: Linked via PAY_EVENT_GROUPS.TIME_DEFINITION_ID. This defines the temporal context for the event group.
• PAY_DATETRACKED_EVENTS: References PAY_EVENT_GROUPS.EVENT_GROUP_ID. This stores the individual payroll events that belong to a configured group.
• PAY_ELEMENT_TYPES_F: References PAY_EVENT_GROUPS.EVENT_GROUP_ID via its PRORATION_GROUP_ID column. This configures which event group is used for prorating earnings or deductions for a specific element type.