Search Results pqh_worksheet_budget_sets




Overview
Explore in AI Chat

Overview

The PQH_WORKSHEET_BUDGET_SETS table is a core data object within the Oracle E-Business Suite Public Sector Human Resources (PQH) module, specifically for versions 12.1.1 and 12.2.2. It serves as a junction table that facilitates the budget set-wise distribution of a worksheet. In the context of public sector budgeting and position control, a worksheet is a tool for planning and allocating financial resources across different budget sets, which are predefined groupings of budget elements or funds. This table establishes the critical link between a specific worksheet period (a defined timeframe for budgeting) and the default budget sets that will be used to distribute the worksheet's financial allocations. Its primary role is to enable detailed and structured budget planning by associating high-level worksheet periods with the granular budget sets where actual financial figures are assigned.

Key Information Stored

The table's structure is designed to manage the relationships between worksheets and budget sets. The most critical columns, as indicated by the primary and unique keys, are the identifiers that forge these links. The WORKSHEET_BUDGET_SET_ID column is the table's primary surrogate key, ensuring each record is uniquely identifiable. The WORKSHEET_PERIOD_ID is a foreign key that points to a specific period in the PQH_WORKSHEET_PERIODS table, anchoring the budget set distribution to a particular planning cycle. The DFLT_BUDGET_SET_ID is a foreign key referencing the PQH_DFLT_BUDGET_SETS table, identifying which predefined budget set is being associated with the worksheet period for distribution purposes. The uniqueness constraint on the combination of WORKSHEET_PERIOD_ID and DFLT_BUDGET_SET_ID ensures that a given budget set is not duplicated for the same worksheet period.

Common Use Cases and Queries

This table is central to queries that analyze or report on how a worksheet's budget is distributed across different funding sources or organizational units (represented by budget sets). A common operational use case is validating the setup of a worksheet during the budget planning phase, ensuring all required budget sets are linked. For reporting, a typical query would join this table to its related entities to produce a distribution summary. For example, to list all budget sets assigned to a specific worksheet period, one might use a SQL pattern such as:

  • SELECT wbs.WORKSHEET_BUDGET_SET_ID, wp.PERIOD_NAME, dbs.BUDGET_SET_NAME FROM PQH_WORKSHEET_BUDGET_SETS wbs JOIN PQH_WORKSHEET_PERIODS wp ON wbs.WORKSHEET_PERIOD_ID = wp.WORKSHEET_PERIOD_ID JOIN PQH_DFLT_BUDGET_SETS dbs ON wbs.DFLT_BUDGET_SET_ID = dbs.DFLT_BUDGET_SET_ID WHERE wp.WORKSHEET_PERIOD_ID = :p_period_id;

Another critical use case involves data integrity checks, such as identifying worksheet periods that have no budget sets assigned, which would indicate an incomplete configuration.

Related Objects

The PQH_WORKSHEET_BUDGET_SETS table exists within a tightly integrated schema for public sector HR budgeting. Its documented relationships, as per the provided metadata, are as follows:

  • Referenced Foreign Keys (Parent Tables):
    • PQH_WORKSHEET_PERIODS: Linked via the column PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_PERIOD_ID. This defines the worksheet timeframe for the budget set distribution.
    • PQH_DFLT_BUDGET_SETS: Linked via the column PQH_WORKSHEET_BUDGET_SETS.DFLT_BUDGET_SET_ID. This provides the specific budget set to be used.
  • Referencing Foreign Key (Child Table):
    • PQH_WORKSHEET_BDGT_ELMNTS: This table references PQH_WORKSHEET_BUDGET_SETS via its column PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID. This is where the actual budget element details and monetary allocations are stored, making PQH_WORKSHEET_BUDGET_SETS a parent entity for granular budget line items.