Search Results psb_pay_elements_v




Overview
Explore in AI Chat

Overview

PSB_PAY_ELEMENTS_V is a reporting view historically associated with the Public Sector Budgeting (PSB) module in Oracle E-Business Suite 12.1.1 and 12.2.2. PSB was designed to support budget formulation and salary/position budgeting for public sector organizations, and this view exposes pay element definitions extracted from the budgeting data extraction model. In the schema provided, the object is documented as obsolete and "Not implemented in this database," meaning the underlying tables and the view itself are typically absent in a standard EBS installation unless PSB was licensed and deployed. Where present, the view presents a denormalized, user-facing representation of pay element configuration, resolving raw lookup codes into descriptive meanings.

Its primary role is to support budget data extraction review, reporting, and integration, giving form and report logic a single queryable source for pay element attributes without requiring joins across multiple lookup tables.

Underlying Base Objects

The view is defined over a small set of core tables joined to several instances of FND_LOOKUPS:

All FND_LOOKUPS joins are outer joins, so pay elements with unpopulated codes still appear with null meanings.

Key Columns

Common Use Cases and Queries

Typical scenarios include reviewing configured pay elements within an extraction, verifying which element carries a given processing type, and feeding downstream budget calculations. A representative query returning the processing type meaning follows:

SELECT pay_element_id,
       name,
       data_extract_name,
       processing_type,
       processing_type_meaning
FROM   psb_pay_elements_v
WHERE  processing_type = 'M'
ORDER  BY name;

To locate salary-type attributes across budget sets:

SELECT pe.name, pe.salary_flag, pe.salary_type_meaning
FROM   psb_pay_elements_v pe
WHERE  pe.budget_set_name IS NOT NULL;

Because the object is obsolete and not implemented, queries should be preceded by a check of ALL_VIEWS to confirm existence; alternate extraction or HR pay element views should be used in modern implementations.