Results for “psb_budget_stage_sets”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PSB_BUDGET_STAGE_SETS table is a core configuration object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It stores the definitions of budget stage sets and the associated budget category sets that govern how budgeting workflows, review cycles, and worksheet groupings are organized for public sector and government entities. Each row represents a named stage set that aggregates one or more budget stages, enabling the budgeting application to move budget data through a defined lifecycle — for example, from entry to review to approval and posting.

Given the documented foreign key relationships and its role as the parent of PSB_BUDGET_STAGES, PSB_WORKSHEETS, and PSB_GL_INTERFACES, the heuristic Data Vault classification of this object is hub-leaning. As a modeling suggestion, PSB_BUDGET_STAGE_SETS functions as a hub whose business key is BUDGET_STAGE_SET_ID, with dependent stage and worksheet records acting as satellites or links in a downstream model. It should be treated as a reference or master data object rather than a transactional fact.

Key Information Stored

The documented physical schema contains 20 columns. The most significant are:

• BUDGET_STAGE_SET_ID — The surrogate primary key (PSB_BUDGET_STAGE_SET_PK) and also the sole business-key candidate exposed through the unique index PSB_BUDGET_STAGE_SET_U1. This is the value most users search for when tracing budget configuration.
• NAME — The user-facing identifier for the stage set, typically displayed in budgeting setup forms and list of values.
• DESCRIPTION — Free-text explanation of the stage set's purpose.
• STAGE_TYPE — Classifies the type of the stage set, determining the nature of the budgeting stages it governs.
• CONTEXT — The descriptive flexfield context, indicating which DFF structure applies.
• ATTRIBUTE1–ATTRIBUTE10 — Ten descriptive flexfield segments for extensible, customer-defined attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS audit columns supporting Who-column tracking and concurrent program auditing.

The distinguishing feature of this table is that its surrogate primary key column doubles as the unique business-key candidate, so BUDGET_STAGE_SET_ID serves both referential integrity and query-join roles across the module.

Common Use Cases and Queries

Typical use cases include setup validation, worksheet assignment reporting, and GL interface reconciliation. A common query retrieves all stage sets with their stages:

SELECT s.BUDGET_STAGE_SET_ID, s.NAME, s.STAGE_TYPE,
       st.BUDGET_STAGE_ID, st.NAME
FROM   PSB_BUDGET_STAGE_SETS s,
       PSB_BUDGET_STAGES st
WHERE  s.BUDGET_STAGE_SET_ID = st.BUDGET_STAGE_SET_ID
ORDER BY s.NAME;

To identify worksheets tied to a stage set:

SELECT w.WORKSHEET_ID, w.STAGE_SET_ID
FROM   PSB_WORKSHEETS w
WHERE  w.STAGE_SET_ID = :budget_stage_set_id;

Analysts also join to PSB_GL_INTERFACES via BUDGET_STAGE_ID to trace postings into the General Ledger, and use the DFF attributes for custom reporting through the standard descriptive flexfield views.

Related Objects

• PSB_BUDGET_STAGES — Child table; joined on PSB_BUDGET_STAGES.BUDGET_STAGE_SET_ID = PSB_BUDGET_STAGE_SETS.BUDGET_STAGE_SET_ID. Defines individual stages belonging to a set.
• PSB_WORKSHEETS — References via PSB_WORKSHEETS.STAGE_SET_ID; links worksheet entry data to a stage set.
• PSB_GL_INTERFACES — References via PSB_GL_INTERFACES.BUDGET_STAGE_ID; carries budget postings to the GL interface.
• PSB_BUDGET_STAGE_SET_PK — Primary key constraint on BUDGET_STAGE_SET_ID.
• PSB_BUDGET_STAGE_SET_U1 — Unique index supporting business-key lookups.

Together these objects form the backbone of PSB stage management, with PSB_BUDGET_STAGE_SETS serving as the central hub driving stage, worksheet, and GL interface processing.