Search Results psb_position_fte




Overview
Explore in AI Chat

Overview

The PSB_POSITION_FTE table is a data object within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically belonging to the Public Sector Budgeting (PSB) module. As indicated by its "Obsolete" status, this module and its associated tables are part of a legacy offering that is no longer under active development. The table's core purpose is to store Full-Time Equivalent (FTE) information related to position control. In public sector budgeting, position control is a critical process for managing and budgeting for authorized staff positions. This table would have served as a repository for FTE data linked to specific budgeted positions, enabling detailed workforce planning and cost allocation within the budgetary framework.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a primary key and foreign key relationships. The primary key is PSB_POSITION_FTE_PK, which is based on the column POSITION_FTE_LINE_ID. This unique identifier ensures each FTE record is distinct. The table maintains two critical foreign key relationships. The first links to the PSB_POSITIONS table via the POSITION_ID column, anchoring each FTE entry to a specific budgeted position. The second links to the PSB_BUDGET_REVISIONS table via the BUDGET_REVISION_ID column, associating the FTE data with a particular budget revision cycle. While specific data columns for FTE values, effective dates, or status are not detailed in the excerpt, the table would logically store the planned or actual FTE percentage or count for a position within a given budget revision.

Common Use Cases and Queries

This table would have been central to generating reports and analyses on workforce budgeting. Common use cases include calculating total budgeted salary expense by aggregating FTE data linked to position salary rates, tracking changes in authorized staffing levels across budget revisions, and ensuring compliance with position count or FTE caps. A typical analytical query might join PSB_POSITION_FTE with PSB_POSITIONS and PSB_BUDGET_REVISIONS to summarize FTE by department for a specific budget version. However, a crucial note from the metadata is the "Not implemented in this database" status under Implementation/DBA Data. This strongly suggests that while the table is defined in the data dictionary, it may not be populated or actively used in a standard installation, limiting practical querying.

Related Objects

  • PSB_POSITIONS: This is the primary parent table, as defined by the foreign key relationship. It contains the master definition of budgeted positions to which the FTE records are attached.
  • PSB_BUDGET_REVISIONS: This table is another key parent, providing the context of the budget cycle or revision under which the FTE information is recorded.
  • PSB_POSITION_FTE_PK: The primary key constraint ensuring data integrity for the table's records.
  • The broader suite of Public Sector Budgeting (PSB) tables, which would include related objects for budget lines, funds, and appropriations, potentially linking to position and FTE data for a complete budgetary picture.