Search Results pqh_budget_fund_srcs




Overview
Explore in AI Chat

Overview

The table PQH_BUDGET_FUND_SRCS 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 budget cost allocation information, a critical function in public sector and grant-funded environments. Its role is to establish and maintain the linkage between budgeted salary or compensation elements and the specific funding sources or cost accounts from which those funds are allocated. This table enables detailed tracking and reporting of personnel costs against multiple funding lines, ensuring compliance with budgetary constraints and funding regulations.

Key Information Stored

The table's structure centers on two key foreign key relationships that define the cost allocation. The primary identifier is the BUDGET_FUND_SRC_ID, a system-generated unique key. The table's logical uniqueness is enforced by a constraint on the combination of BUDGET_ELEMENT_ID and COST_ALLOCATION_KEYFLEX_ID. The BUDGET_ELEMENT_ID column references a specific budgeted compensation line in the PQH_BUDGET_ELEMENTS table. The COST_ALLOCATION_KEYFLEX_ID column references a specific combination of accounting flexfield segments (such as Fund, Account, Department) stored in the PAY_COST_ALLOCATION_KEYFLEX table, thereby identifying the exact funding source.

Common Use Cases and Queries

This table is central to processes involving the creation, inquiry, and reporting of budgeted personnel costs by funding source. A primary use case is generating reports that show the distribution of a position's total budgeted cost across multiple grants or projects. System interfaces and custom reports often join this table to budget and accounting flexfield data. A typical query pattern retrieves all funding sources for a specific budget element:

  • SELECT bf.budget_fund_src_id, be.element_name, cak.concatenated_segments FROM pqh_budget_fund_srcs bf, pqh_budget_elements be, pay_cost_allocation_keyflex cak WHERE bf.budget_element_id = be.budget_element_id AND bf.cost_allocation_keyflex_id = cak.cost_allocation_keyflex_id AND be.budget_element_id = :p_budget_element_id;

Conversely, queries may also summarize all budget elements charged to a particular cost account for expenditure tracking.

Related Objects

PQH_BUDGET_FUND_SRCS is a child table with defined dependencies on two key master tables, as indicated by its foreign keys.

  • PQH_BUDGET_ELEMENTS: The parent table for budget details. The BUDGET_ELEMENT_ID foreign key establishes that a funding source record is associated with a single, specific budget element.
  • PAY_COST_ALLOCATION_KEYFLEX: The table storing the accounting flexfield combinations that represent valid funding sources. The COST_ALLOCATION_KEYFLEX_ID foreign key links the budget allocation to the specific accounting code.

This table is integral to the PQH budgeting workflow and is referenced by various Public Sector HR forms, processes, and likely underlying PL/SQL APIs within the module.