Search Results element_line_id

Overview

The PSB_WS_ELEMENT_LINES table is a core transactional data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, versions 12.1.1 and 12.2.2. As indicated by its description, it stores the detailed cost breakdown of total position costs by individual pay elements for a budgeting worksheet. This table enables granular financial planning by associating specific compensation components, such as base salary, bonuses, or allowances, with budgeted positions. Its role is to provide the foundational line-item detail that aggregates to form the total compensation cost for a position within a budget worksheet, facilitating detailed analysis and justification of personnel expenses. It is important to note that the PSB module is marked as obsolete in the provided documentation, indicating this table is part of a legacy offering.

Key Information Stored

The table's primary purpose is to link worksheet position lines to their constituent pay elements and store associated financial amounts. The most critical column is ELEMENT_LINE_ID, which serves as the unique primary key identifier for each cost breakdown record. Other essential foreign key columns include POSITION_LINE_ID, which links to the parent budgeted position record in the PSB_WS_POSITION_LINES table, and PAY_ELEMENT_ID, which references the specific compensation component defined in the PSB_PAY_ELEMENTS table. While the exact full column list is not provided in the excerpt, the table would logically contain columns for the monetary amount, potentially for different periods (e.g., monthly, quarterly, annual), and possibly effective date ranges for the cost assignment.

Common Use Cases and Queries

This table is central to queries that analyze the composition of personnel budgets. A common reporting use case is to generate a detailed budget worksheet showing all pay elements for each position. A typical SQL pattern involves joining to the related position and pay element tables to retrieve descriptive information. For example, to list all element lines for a specific worksheet, one might query:

• SELECT ws_pos.worksheet_id, ws_pos.position_name, pay_elem.element_name, elem_line.* FROM PSB_WS_ELEMENT_LINES elem_line JOIN PSB_WS_POSITION_LINES ws_pos ON elem_line.position_line_id = ws_pos.position_line_id JOIN PSB_PAY_ELEMENTS pay_elem ON elem_line.pay_element_id = pay_elem.pay_element_id WHERE ws_pos.worksheet_id = :p_worksheet_id;

Another critical use case is data validation, ensuring that the sum of amounts in PSB_WS_ELEMENT_LINES for a given POSITION_LINE_ID matches the total position cost stored in PSB_WS_POSITION_LINES.

Related Objects

PSB_WS_ELEMENT_LINES is a child table within the Public Sector Budgeting schema, with defined foreign key relationships to two primary parent tables, as documented in the ETRM metadata:

• PSB_WS_POSITION_LINES: The relationship is established via the column PSB_WS_ELEMENT_LINES.POSITION_LINE_ID. This links each elemental cost line back to its overarching budgeted position record within a worksheet.
• PSB_PAY_ELEMENTS: The relationship is established via the column PSB_WS_ELEMENT_LINES.PAY_ELEMENT_ID. This links the cost line to the master definition of the pay element, which provides the name, classification, and other attributes of the compensation component.

The table itself is referenced by its primary key constraint, PSB_ELEMENT_LINES_PK, on the ELEMENT_LINE_ID column.