Search Results psb_parameter_formulas_pk

Overview

The PSB_PARAMETER_FORMULAS table is a core data structure within the now-obsolete Public Sector Budgeting (PSB) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role was to store the definitions of parameterized formulas used in the complex budgetary calculations and compensation modeling specific to public sector entities. These formulas were essential for automating and standardizing the computation of budget figures, salary adjustments, and other financial parameters based on defined rules, inputs, and relationships with other budgeting components. The table's existence is critical for understanding the historical data model of PSB implementations, though the module itself is marked as obsolete.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique formula identifier and its relationships to other key PSB entities. The primary column is PARAMETER_FORMULA_ID, which serves as the unique identifier for each formula definition (Primary Key: PSB_PARAMETER_FORMULAS_PK). The table's foreign key columns reveal the critical linkages that contextualize each formula: PAY_ELEMENT_ID links the formula to specific compensation components in the PSB_PAY_ELEMENTS table; PARAMETER_ID associates it with a defined parameter in the PSB_ENTITY table; and BUDGET_YEAR_TYPE_ID connects it to a fiscal calendar or period type defined in PSB_BUDGET_YEAR_TYPES. While the exact formula syntax or additional descriptive columns are not detailed in the excerpt, this relationship framework indicates the table stored the formula's operational context.

Common Use Cases and Queries

This table was central to reporting and validating the configuration of the PSB module. Common operational use cases included auditing the formulas applied to specific pay elements, tracing parameter dependencies, and generating configuration documentation. A typical query would join PSB_PARAMETER_FORMULAS to its related tables to retrieve a comprehensive view of a formula's definition and usage. For example, to list all formulas for a specific budget year type, one might use a SQL pattern such as: SELECT pf.*, byt.NAME FROM PSB_PARAMETER_FORMULAS pf INNER JOIN PSB_BUDGET_YEAR_TYPES byt ON pf.BUDGET_YEAR_TYPE_ID = byt.BUDGET_YEAR_TYPE_ID WHERE byt.NAME = 'FISCAL_YEAR_2024';. Data extraction for legacy reporting or migration projects would also heavily rely on queries against this table and its relationships.

Related Objects

The PSB_PARAMETER_FORMULAS table is integrally connected to several other core PSB tables via foreign key relationships, as documented in the ETRM metadata. These relationships are:

• PSB_PAY_ELEMENTS: Linked via the column PSB_PARAMETER_FORMULAS.PAY_ELEMENT_ID. This joins formula definitions to specific salary or compensation components.
• PSB_ENTITY: Linked via the column PSB_PARAMETER_FORMULAS.PARAMETER_ID. This associates formulas with the specific budgetary or calculation parameters they utilize.
• PSB_BUDGET_YEAR_TYPES: Linked via the column PSB_PARAMETER_FORMULAS.BUDGET_YEAR_TYPE_ID. This ties each formula to a specific budgetary timeframe or fiscal calendar type.

These relationships form a foundational part of the obsolete PSB module's data model, defining how calculation rules were applied within the system.