Search Results psp_group_element_list_pk

Overview

The PSP_GROUP_ELEMENT_LIST table is a core intersection table within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as a many-to-many resolution table, defining the specific relationships between Element Groups (PSP_ELEMENT_GROUPS) and Element Types (PSP_ELEMENT_TYPES). Its primary role is to manage the assignment of individual earning and deduction elements to logical groupings, which is a fundamental configuration step for processing labor distributions, payroll calculations, and associated costing. This table ensures that the correct set of elements is considered for specific distribution rules and reporting purposes.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies each valid assignment of an element type to a group for a given period. The key columns are ELEMENT_GROUP_ID, which references a specific grouping, and ELEMENT_TYPE_ID, which references a specific payroll element. The inclusion of START_DATE_ACTIVE in the primary key enables effective-dated tracking of these assignments, allowing for historical and future-dated changes to group membership. The foreign key relationships enforce referential integrity, ensuring that only valid, existing element types and groups can be linked.

Common Use Cases and Queries

This table is central to queries that list all elements belonging to a particular group for reporting, validation, or data extraction. A common use case is generating a list of all active element types within a specific group for a given payroll period. For instance, an integration or custom report might use a query such as:

• SELECT gel.ELEMENT_GROUP_ID, gel.ELEMENT_TYPE_ID, et.ELEMENT_NAME FROM PSP_GROUP_ELEMENT_LIST gel, PSP_ELEMENT_TYPES et WHERE gel.ELEMENT_TYPE_ID = et.ELEMENT_TYPE_ID AND gel.ELEMENT_GROUP_ID = :group_id AND :effective_date BETWEEN gel.START_DATE_ACTIVE AND NVL(gel.END_DATE_ACTIVE, :effective_date);

Administrators and developers also interact with this table when troubleshooting labor distribution results or when configuring new element groups via the application's front-end, which maintains the underlying data in this table.

Related Objects

PSP_GROUP_ELEMENT_LIST sits at the intersection of two primary master tables, as documented in the provided metadata.

• PSP_ELEMENT_TYPES: This table is referenced via a foreign key relationship. The column PSP_GROUP_ELEMENT_LIST.ELEMENT_TYPE_ID (and START_DATE_ACTIVE) references PSP_ELEMENT_TYPES, ensuring each entry points to a valid payroll element definition.
• PSP_ELEMENT_GROUPS: While not explicitly listed in the foreign key metadata, the column ELEMENT_GROUP_ID is part of the primary key and logically references the PSP_ELEMENT_GROUPS table, which stores the definition of the groups themselves.

The table's primary key constraint, PSP_GROUP_ELEMENT_LIST_PK, enforces uniqueness on the combination of ELEMENT_GROUP_ID, ELEMENT_TYPE_ID, and START_DATE_ACTIVE.