Search Results psbbv_budget_groups




Overview
Explore in AI Chat

Overview

PSBBV_BUDGET_GROUPS is a read-only view owned by the APPS schema within the Public Sector Budgeting (PSB) product family. It presents budget group definitions together with the resolved short name of each group's root (top-level) budget group, allowing both the group itself and the root of its hierarchy to be reported in a single row. The view is defined as WITH READ ONLY, which explicitly prevents DML through the view and signals that it is intended strictly for query, reporting, and integration consumption rather than maintenance.

Budget groups in PSB represent the containers within which budgeting activities are organized, including the number of proposed years defined for a group, hierarchy freeze status, and descriptive attributes. Because a budget group can belong to a hierarchy in which it is a subordinate member, the view joins the group to its root group and exposes the root's short name in a dedicated column. This is particularly relevant when users search for budget_group_short_name, since the view returns the short name of the group itself (BUDGET_GROUP_SHORT_NAME) alongside the root short name (ROOT_SHORT_NAME), enabling clear differentiation between a group and its hierarchy root.

Underlying Base Objects

The view is defined over two references to the same base table, PSB_BUDGET_GROUPS, using the aliases BG and BGR:

  • PSB_BUDGET_GROUPS BG — the primary source of the budget group record, supplying short name, name, dates, proposed years, hierarchy flag, descriptions, identifiers, and audit columns.
  • PSB_BUDGET_GROUPS BGR — the joined root group, supplying the root short name. The join predicate is BG.ROOT_BUDGET_GROUP_ID = BGR.BUDGET_GROUP_ID (+), an outer join that preserves budget groups with no matching root (for example, groups that are themselves roots or have an unresolved root reference).

The view text is as follows:

No additional base objects are documented for this view; it is a self-join over PSB_BUDGET_GROUPS.

Key Columns

  • BUDGET_GROUP_SHORT_NAME — the short name (BG.SHORT_NAME) of the budget group. This is the column most commonly targeted when searching on budget_group_short_name.
  • ROOT_SHORT_NAME — the short name (BGR.SHORT_NAME) of the root budget group, obtained through the outer join. Null when no matching root exists.
  • BUDGET_GROUP_NAME — the descriptive name of the budget group.
  • START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — the effective date range governing when the group is active.
  • BUDGET_GROUP_NUM_PROPOSED_YRS — the number of proposed years configured for the group.
  • ROOT_BUDGET_GROUP — the root budget group value stored on the record.
  • FREEZE_HIERARCHY_FLAG — indicates whether the group hierarchy is frozen against structural change.
  • BUDGET_GROUP_DESCRIPTION / NARRATIVE_DESCRIPTION — textual description and narrative attribute for the group.
  • BUDGET_GROUP_ID / ROOT_BUDGET_GROUP_ID — primary key of the group and the identifier linking it to its root group.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard audit columns.

Common Use Cases and Queries

A frequent requirement is locating a budget group by its short name and retrieving its hierarchy context:

  • SELECT budget_group_short_name, budget_group_name, root_short_name FROM apps.psbbv_budget_groups WHERE budget_group_short_name = :p_short_name;

The view is also used to enumerate all groups belonging to a given root hierarchy, or to list groups whose hierarchy is frozen. Because the view is read-only, it is well suited to custom reporting, concurrent program queries, and data extraction into external systems where only read access is required.