Search Results psb_pay_elements




Overview
Explore in AI Chat

Overview

The PSB_PAY_ELEMENTS table is a core data object within the Oracle E-Business Suite module Public Sector Budgeting (PSB), which is designated as obsolete. This table serves as the master repository for pay element definitions. A pay element is a fundamental component in budgeting for personnel costs, representing distinct types of compensation or benefits, such as base salary, overtime, bonuses, or various allowances. The table's primary role is to define and store the configuration and rules for each pay element, enabling the system to calculate, allocate, and forecast position-related expenses during the budget formulation process. Its extensive foreign key relationships indicate it is a central hub for linking pay definitions to formulas, rates, assignments, and cost calculations.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented primary and foreign key relationships reveal the critical data points stored. The primary key, PAY_ELEMENT_ID, uniquely identifies each pay element definition. Essential descriptive attributes would typically include an element name, code, and classification. The foreign keys FORMULA_ID and DATA_EXTRACT_ID are crucial, linking each pay element to a calculation rule (in PSB_FORMULAS) and potentially to a source data definition (in PSB_DATA_EXTRACTS) for populating values. Other inferred columns would define the element's behavior, such as its category (e.g., recurring, one-time), its impact on benefits, its taxability, and its accounting flexfield mapping for generating budgetary journal entries.

Common Use Cases and Queries

The primary use case is the administration and inquiry of all configured pay elements within the Public Sector Budgeting module. Common operational and reporting activities include validating the setup of compensation structures, auditing which formulas are applied to specific elements, and generating lists of elements used in position budgeting. A typical query would join PSB_PAY_ELEMENTS to its related tables to analyze the complete setup. For example, to list all pay elements with their associated calculation formulas, one might use:

SELECT pe.PAY_ELEMENT_ID, pe.ELEMENT_NAME, f.FORMULA_NAME
FROM PSB_PAY_ELEMENTS pe, PSB_FORMULAS f
WHERE pe.FORMULA_ID = f.FORMULA_ID(+);

Another common scenario involves tracing where a specific pay element is assigned, requiring joins to tables like PSB_POSITION_ASSIGNMENTS or PSB_DEFAULT_ASSIGNMENTS.

Related Objects

As evidenced by the foreign key relationships, PSB_PAY_ELEMENTS is a central table with numerous dependencies. The documented relationships are as follows:

This network of relationships shows the table's integral role in connecting pay element definitions to their specific rates, assignment rules, cost calculations, and worksheet lines within the budgeting workflow.