Search Results psb_pay_element_rates




Overview
Explore in AI Chat

Overview

The PSB_PAY_ELEMENT_RATES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for storing the specific rate values or calculation rules associated with pay elements and their options. A pay element represents a compensation component, such as a salary step, allowance, or differential. This table enables the system to define and manage the precise monetary rates or formulas that determine the budgeted cost for each element, forming a critical link between position budgeting and compensation planning. Its role is to provide the granular rate data necessary for accurate payroll cost projections and budget formulation within public sector organizations.

Key Information Stored

The table's primary purpose is to associate a rate with a specific pay element or a more granular pay element option. Its structure is defined by key foreign key columns that establish these relationships and point to the rate's value or derivation method. The central identifier is PAY_ELEMENT_RATE_ID, which serves as the table's primary key. The PAY_ELEMENT_ID column links the rate directly to a master pay element defined in PSB_PAY_ELEMENTS. For more detailed breakdowns, the PAY_ELEMENT_OPTION_ID links to a specific variant or option within a pay element, as stored in PSB_PAY_ELEMENT_OPTIONS. The actual rate value or calculation logic is referenced via the FORMULA_ID, which points to a predefined calculation rule in PSB_FORMULAS, or the WORKSHEET_ID, which may link to a structured data source in PSB_WORKSHEETS for complex rate determination.

Common Use Cases and Queries

This table is primarily accessed for budget development, analysis, and auditing of compensation costs. A common operational use case is generating a report of all active pay rates for a given fiscal year or position classification to validate budget assumptions. Technical consultants often query this table to troubleshoot issues where budgeted payroll amounts appear incorrect, tracing from the calculated cost back to the source rate definition. A typical diagnostic SQL pattern involves joining to related master tables to get descriptive information:

  • Identifying all rates for a specific pay element: SELECT * FROM psb.psb_pay_element_rates WHERE pay_element_id = <value>;
  • Listing rates with their associated element and formula names: SELECT per.*, pe.name element_name, f.formula_name FROM psb.psb_pay_element_rates per, psb.psb_pay_elements pe, psb.psb_formulas f WHERE per.pay_element_id = pe.pay_element_id AND per.formula_id = f.formula_id(+);

Related Objects

The PSB_PAY_ELEMENT_RATES table is a child entity within a tightly integrated schema, with its relationships explicitly documented by foreign key constraints. It depends directly on several master tables for its referential integrity and context.

  • PSB_PAY_ELEMENT_OPTIONS: Joined via PSB_PAY_ELEMENT_RATES.PAY_ELEMENT_OPTION_ID. This links a rate to a specific sub-option of a pay element.
  • PSB_PAY_ELEMENTS: Joined via PSB_PAY_ELEMENT_RATES.PAY_ELEMENT_ID. This is the primary relationship, connecting the rate to the core compensation component.
  • PSB_FORMULAS: Joined via PSB_PAY_ELEMENT_RATES.FORMULA_ID. This relationship defines the computational rule used to derive the rate value.
  • PSB_WORKSHEETS: Joined via PSB_PAY_ELEMENT_RATES.WORKSHEET_ID. This links the rate to a structured data source, often used for complex or matrix-based rate schedules.

The primary key constraint, PSB_PAY_ELEMENT_RATES_PK on PAY_ELEMENT_RATE_ID, ensures each rate record is uniquely identifiable and can be reliably referenced by other objects within the PSB module.