Search Results pay_people_groups

Overview

The PAY_PEOPLE_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) Payroll module (PAY). It serves as the master repository for the People Group flexfield, a key descriptive flexfield (DFF) used for segmenting and categorizing the workforce. This table stores the distinct combinations of values defined for the People Group flexfield segments, enabling organizations to classify employees and contingent workers based on custom business criteria such as project codes, funding sources, cost centers, or union affiliations. Its primary role is to provide a validated set of grouping codes that can be assigned to assignments and linked to various payroll and HR processes, ensuring data integrity and enabling rule-based processing.

Key Information Stored

The table's central column is PEOPLE_GROUP_ID, a system-generated primary key that uniquely identifies each valid people group combination. While the ETRM excerpt does not list all columns, the table's description as a flexfield information table implies it contains the concatenated segment values and their individual segment attributes. Typically, such a table includes columns for the flexfield structure (SEGMENT1, SEGMENT2, etc.), the concatenated descriptive value, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The PEOPLE_GROUP_ID is the persistent identifier referenced by all related transactional tables.

Common Use Cases and Queries

This table is central to reporting and configuring rules based on people groups. A common use case is generating a list of all active people group codes for assignment or reporting purposes. Administrators often query this table to audit assignments linked to specific groups. For example, to find all assignments associated with a particular people group, one would join PER_ALL_ASSIGNMENTS_F to PAY_PEOPLE_GROUPS. Sample SQL to retrieve a list of defined people groups is:

• SELECT PEOPLE_GROUP_ID, CONCATENATED_SEGMENTS FROM PAY_PEOPLE_GROUPS WHERE ENABLED_FLAG = 'Y' ORDER BY CONCATENATED_SEGMENTS;

Another critical use case is in payroll element eligibility, where element links can be restricted to specific people groups, controlling which employees can receive certain earnings or deductions.

Related Objects

The PAY_PEOPLE_GROUPS table is referenced by several key transactional tables via foreign key relationships, as documented in the provided metadata. These relationships are fundamental to the application's data model:

• PER_ALL_ASSIGNMENTS_F: Links a people group to an employee or contingent worker assignment via PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID.
• PAY_ELEMENT_LINKS_F: Restricts payroll element eligibility to specific people groups via PAY_ELEMENT_LINKS_F.PEOPLE_GROUP_ID.
• PER_ALL_VACANCIES: Associates a vacancy with a people group via PER_ALL_VACANCIES.PEOPLE_GROUP_ID.
• PSP_EFFORT_REPORT_TEMPLATES: Links effort reporting templates in Oracle Projects to people groups via PSP_EFFORT_REPORT_TEMPLATES.PEOPLE_GROUP_ID.

The primary key constraint PAY_PEOPLE_GROUPS_PK on PEOPLE_GROUP_ID enforces uniqueness and supports these foreign key relationships.