Search Results pqh_budget_details

Overview

The PQH_BUDGET_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Human Resources (PQH) module. It serves as the primary repository for storing detailed budget allocations that are linked to specific HR organizational entities. Its fundamental role is to enable granular budgeting and financial planning for personnel costs by associating budget amounts with precise organizational dimensions such as jobs, grades, positions, and organizational units. This table is essential for creating, managing, and analyzing budgets within the public sector HR context, supporting complex budgeting workflows and compliance requirements typical of government and public institutions.

Key Information Stored

The table's structure centers on a unique budget detail record identified by the primary key column, BUDGET_DETAIL_ID. Each record is fundamentally tied to a specific BUDGET_VERSION_ID, linking it to a parent budget definition. The key functional columns store identifiers for the major HR entities to which the budget is allocated: ORGANIZATION_ID, JOB_ID, POSITION_ID, and GRADE_ID. This design allows a budget line to be defined for a combination of these entities, facilitating highly targeted budget planning. The table's unique key constraint (PQH_BUDGET_DETAILS_UK) ensures that within a given budget version, a specific combination of grade, job, organization, and position is not duplicated.

Common Use Cases and Queries

A primary use case is the generation of detailed budget versus actual reports for personnel expenditure. Analysts query this table to understand the planned budget allocation across different organizational hierarchies and job structures. Common SQL patterns involve joining to related master tables to translate IDs into meaningful names. For example, to list all budget details for a specific budget version with descriptive labels, a query would join PQH_BUDGET_DETAILS to PER_JOBS, PER_GRADES, and HR_ALL_ORGANIZATION_UNITS. Another critical use case is during the budget worksheet process, where this table provides the source budget data that is copied or adjusted into PQH_WORKSHEET_DETAILS for iterative planning and what-if analysis.

Related Objects

PQH_BUDGET_DETAILS is a central hub with several documented foreign key relationships. It is a child of the PQH_BUDGET_VERSIONS table via BUDGET_VERSION_ID, defining the overall budget context. It references master HR tables to validate its dimension keys: HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID), PER_JOBS (JOB_ID), and PER_GRADES (GRADE_ID). Crucially, it acts as a parent table to two key transactional tables: PQH_BUDGET_PERIODS, which stores time-phased budget amounts (joined on BUDGET_DETAIL_ID), and PQH_WORKSHEET_DETAILS, which holds worksheet lines for budget adjustments and simulations (also joined on BUDGET_DETAIL_ID). These relationships form the backbone of the public sector HR budgeting data model.