Search Results psb_ws_fte_lines




Overview
Explore in AI Chat

Overview

The PSB_WS_FTE_LINES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It serves a critical function in the detailed budgeting process for government and public sector entities by storing full-time equivalency (FTE) data segmented by budget periods for positions defined within a budgeting worksheet. This table enables the granular allocation and tracking of personnel costs across different fiscal periods, which is a fundamental requirement for accurate multi-year budget planning, forecasting, and compliance reporting. Its role is to provide the underlying data structure that links position-level budgeting with temporal FTE distribution.

Key Information Stored

The table's primary purpose is to record FTE allocations per budget period for a specific worksheet position line. While the full column list is not detailed in the provided metadata, the structure centers on the primary key, FTE_LINE_ID, which uniquely identifies each FTE period record. A critical foreign key column is POSITION_LINE_ID, which links each FTE distribution record back to its parent position definition in the PSB_WS_POSITION_LINES table. Other columns typically found in such a structure would include fields for the BUDGET_PERIOD (or similar identifier), the assigned FTE_VALUE (e.g., 1.0 for a full-time position), and potentially effective date ranges. This design allows a single position line to have multiple associated records in PSB_WS_FTE_LINES, each representing the FTE for a distinct period within the budget cycle.

Common Use Cases and Queries

A primary use case is generating reports that show how FTEs for budgeted positions are phased across quarters or years, which is essential for cash flow analysis and headcount planning. Budget analysts run queries to validate that the sum of FTE values across periods for a position aligns with its total approved FTE. A common SQL pattern involves joining this table to position and worksheet headers to analyze FTE distribution at an organizational level. For example, a query to list all FTE periods for positions in a specific worksheet would filter from PSB_WS_HEADERS through PSB_WS_POSITION_LINES to PSB_WS_FTE_LINES. Data from this table is also crucial for integrations with General Ledger and Human Capital Management modules to facilitate accrual accounting and position control.

Related Objects

The table maintains a direct and documented foreign key relationship with the PSB_WS_POSITION_LINES table, which is its primary parent object. The relationship is defined as follows:

  • Foreign Key From: PSB_WS_FTE_LINES.POSITION_LINE_ID
  • References Table: PSB_WS_POSITION_LINES

This relationship ensures that every FTE period distribution is tied to a valid budget worksheet position line. Consequently, PSB_WS_FTE_LINES is a child table in the PSB worksheet hierarchy, which typically flows from PSB_WS_HEADERS to PSB_WS_POSITION_LINES and then to PSB_WS_FTE_LINES. Other related objects may include PSB_WS_SALARY_LINES for associated compensation data and various PSB budget formulation and publishing views that aggregate this detailed FTE information for reporting.