Search Results psb_ws_position_project_pk




Overview
Explore in AI Chat

Overview

The PSB_WS_POSITION_LINES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. It functions as the primary transactional table for storing individual position instances within a budgeting worksheet. This table is essential for position-based budgeting, a critical requirement in public sector and other organizations where personnel costs are planned and controlled by specific job roles or positions. Each record represents a unique position entry on a worksheet, serving as a central hub that links to detailed financial, account, and full-time equivalent (FTE) data for comprehensive budget planning and analysis.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the structure and relationships define its critical data role. The primary identifier, POSITION_LINE_ID, is a unique system-generated key for each worksheet position instance. Based on its central function and foreign key relationships, this table typically stores worksheet identifiers, position master data references (like job codes or position numbers), and associated header-level information. It acts as the anchor point, holding the fundamental definition of a budgeted position, to which granular details—such as salary amounts, benefits costs, account distributions, and FTE schedules—are attached via related child tables.

Common Use Cases and Queries

This table is central to queries and reports that analyze personnel budget components. Common use cases include generating position summary reports for a specific budget worksheet, tracing all financial details for a particular budgeted role, and auditing changes to position lines during the budget cycle. A fundamental query pattern involves joining this table to its related detail tables to assemble a complete budget picture for a position. For example, to retrieve all account distributions for positions in a specific worksheet, one would join PSB_WS_POSITION_LINES to PSB_WS_ACCOUNT_LINES via the POSITION_LINE_ID column. Similarly, analyzing FTE projections over time would involve a join to PSB_WS_FTE_LINES.

Related Objects

The PSB_WS_POSITION_LINES table has a defined primary key constraint (PSB_WS_POSITION_PROJECT_PK) on POSITION_LINE_ID. It serves as a parent table to several key child tables, as documented by the following foreign key relationships:

  • PSB_WS_ACCOUNT_LINES: Links position instances to general ledger account distributions (PSB_WS_ACCOUNT_LINES.POSITION_LINE_ID).
  • PSB_WS_ELEMENT_LINES: Links position instances to compensation element details like salary and benefits (PSB_WS_ELEMENT_LINES.POSITION_LINE_ID).
  • PSB_WS_FTE_LINES: Links position instances to full-time equivalent scheduling data (PSB_WS_FTE_LINES.POSITION_LINE_ID).
  • PSB_WS_LINES_POSITIONS: Provides a further association layer, likely for grouping or additional assignment logic (PSB_WS_LINES_POSITIONS.POSITION_LINE_ID).
These relationships illustrate that PSB_WS_POSITION_LINES is a pivotal integration point within the worksheet budgeting structure.