Search Results pqh_dflt_budget_sets




Overview
Explore in AI Chat

Overview

The PQH_DFLT_BUDGET_SETS table is a core data object within the Oracle E-Business Suite Public Sector Human Resources (PQH) module. It functions as a master repository for defining and storing default budget set configurations. A budget set is a logical grouping of compensation elements and their associated funding sources, which serves as a template for budgeting and financial planning within public sector organizations. The table's primary role is to provide a standardized, reusable framework for allocating salary and benefit costs across different funding lines, such as grants or appropriations, ensuring consistent budgetary control and reporting.

Key Information Stored

The table's structure is designed to uniquely identify and describe each default budget set within a specific business group context. The primary key, DFLT_BUDGET_SET_ID, is a unique system-generated identifier. A critical column is BUSINESS_GROUP_ID, a foreign key to HR_ALL_ORGANIZATION_UNITS, which scopes the budget set to a particular operational unit, enforcing data security and multi-org integrity. While the provided metadata does not list all columns, typical attributes would include a name (e.g., SET_NAME), a description, effective start and end dates for the set's validity, and creation/update audit information (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE).

Common Use Cases and Queries

This table is central to processes where predefined budget templates are applied. A common use case is during position or assignment budgeting, where a default budget set is linked to automatically propose funding allocations. Administrators may run queries to audit or maintain these sets. For example, to list all active default budget sets within a business group, a query might be: SELECT dflt_budget_set_id, set_name FROM pqh_dflt_budget_sets WHERE business_group_id = &bg_id AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE);. Reporting often involves joining this table to its child tables to analyze the composition of elements and funding sources within each set for financial forecasting.

Related Objects

PQH_DFLT_BUDGET_SETS maintains key relationships with several other PQH tables, primarily as a parent entity. The documented foreign key relationships are:

  • Parent: HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID.
  • Children:
    • PQH_BUDGET_SETS references PQH_DFLT_BUDGET_SETS via DFLT_BUDGET_SET_ID. This links the default template to specific, instance-level budget sets.
    • PQH_DFLT_BUDGET_ELEMENTS references PQH_DFLT_BUDGET_SETS via DFLT_BUDGET_SET_ID. This stores the individual compensation elements (e.g., salary, benefits) that belong to the set.
    • PQH_WORKSHEET_BUDGET_SETS references PQH_DFLT_BUDGET_SETS via DFLT_BUDGET_SET_ID. This links the default set to budget worksheets used for planning and analysis.
These relationships form the structural backbone for the budget configuration and allocation workflow in Public Sector HR.