Search Results psp_element_groups




Overview
Explore in AI Chat

Overview

The PSP_ELEMENT_GROUPS table is a core data structure within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It serves as the master repository for element group definitions, which are logical collections of earning or deduction elements used for reporting, costing, and distribution purposes. In the context of payroll and labor accounting, an element group allows administrators to aggregate related payroll elements—such as regular wages, overtime, or specific bonuses—into a single reporting unit. This grouping is fundamental for streamlining the allocation of labor costs across projects, tasks, and organizations, enabling precise and auditable labor distribution.

Key Information Stored

While the provided ETRM metadata specifies the primary key but not the full column list, the table's purpose dictates its critical attributes. The primary key, ELEMENT_GROUP_ID, uniquely identifies each group definition. Other essential columns typically include the ELEMENT_GROUP_NAME and a DESCRIPTION for user identification. The table likely contains control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing. Crucially, it stores configuration flags that define the group's behavior, such as its status (active/inactive) and potentially its type (e.g., for costing, reporting, or funding). The specific elements assigned to a group are typically stored in a related child table, not explicitly listed in the provided metadata.

Common Use Cases and Queries

This table is central to configuring and querying labor distribution setups. A primary use case is generating reports that summarize labor costs by predefined element groups rather than individual, granular payroll elements, providing a higher-level view for project or financial managers. Administrators query this table to maintain group definitions. Common SQL patterns include listing all active element groups or identifying groups used in specific distribution schedules. For example:

  • SELECT element_group_id, element_group_name FROM psp_element_groups WHERE enabled_flag = 'Y' ORDER BY element_group_name;
  • SELECT seg.element_group_name, COUNT(*) element_count FROM psp_element_groups seg, [child_element_table] cet WHERE seg.element_group_id = cet.element_group_id GROUP BY seg.element_group_name;

These queries support audit trails, setup validation, and integration with downstream reporting tools.

Related Objects

PSP_ELEMENT_GROUPS has defined relationships with other Labor Distribution tables, forming a key part of the module's data model. As per the documented foreign key relationship, the PSP_SCHEDULE_HIERARCHY table references PSP_ELEMENT_GROUPS via the ELEMENT_GROUP_ID column. This link is critical, as it ties a defined element group to a specific schedule within the labor distribution hierarchy, determining which grouped elements are processed for a given distribution run. The primary key constraint PSP_ELEMENT_GROUPS_PK on ELEMENT_GROUP_ID ensures referential integrity for this and any other undocumented relationships. The table is also conceptually related to the underlying payroll element definitions in the PAY_ELEMENT_TYPES_F table, though this link is managed through application logic or intermediate assignment tables.