Search Results psb_budget_positions_pk

Overview

The PSB_BUDGET_POSITIONS table is a core data structure within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. It functions as a junction or detail table that stores the expanded list of individual positions associated with a defined position set. In the context of public sector budgeting, position sets are logical groupings used to allocate budget amounts to specific jobs or roles. This table is essential for linking high-level budgetary controls and account assignments to the granular level of specific positions, enabling detailed personnel cost planning, forecasting, and budget execution tracking.

Key Information Stored

The table's primary purpose is to map positions to their parent sets. Its structure is defined by a composite primary key and several foreign key relationships. The critical columns include ACCOUNT_POSITION_SET_ID, which links each record to its parent position set defined in the PSB_ACCOUNT_POSITION_SETS table. The POSITION_ID column stores the identifier for a specific job position, linked to the PSB_POSITIONS table. An additional foreign key, DATA_EXTRACT_ID, references the PSB_DATA_EXTRACTS table, indicating this table can be populated or associated with data from external extraction processes. Together, these columns maintain the integrity of the position set membership list.

Common Use Cases and Queries

A primary use case is generating reports on all positions included in a specific budget scenario or organizational unit. For instance, budget analysts may query this table to validate position counts or to list all positions funded under a particular budget line. Common SQL patterns involve joining to related tables to get descriptive information. A typical query might retrieve a readable list of positions within a set:

• SELECT pbp.POSITION_ID, pos.POSITION_NAME, aps.SET_NAME FROM PSB.PSB_BUDGET_POSITIONS pbp JOIN PSB.PSB_POSITIONS pos ON pbp.POSITION_ID = pos.POSITION_ID JOIN PSB.PSB_ACCOUNT_POSITION_SETS aps ON pbp.ACCOUNT_POSITION_SET_ID = aps.ACCOUNT_POSITION_SET_ID WHERE aps.SET_NAME = '&SET_NAME';

This table is also crucial during budget formulation when assigning salary and benefit costs to positions and during period-end processes for comparing budgeted versus actual personnel expenditures.

Related Objects

The PSB_BUDGET_POSITIONS table is centrally connected to several key PSB tables, as defined by its foreign keys. Its main parent table is PSB_ACCOUNT_POSITION_SETS, which defines the header record for the position set. The POSITION_ID column derives its valid values from the PSB_POSITIONS table, which contains the master list of all budgeted positions. The relationship with PSB_DATA_EXTRACTS suggests that position sets can be populated via data import utilities. The table is protected by the primary key constraint PSB_BUDGET_POSITIONS_PK on (ACCOUNT_POSITION_SET_ID, POSITION_ID), ensuring no duplicate position assignments exist within a single set.