Search Results pqh_worksheet_fund_srcs




Overview
Explore in AI Chat

Overview

The PQH_WORKSHEET_FUND_SRCS 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 transactional table that stores detailed cost allocation information for budget elements. Its primary role is to facilitate the distribution and tracking of budgeted costs across different funding sources or cost centers during the workforce budgeting process. By linking a budget worksheet element to a specific cost allocation key flexfield structure, it enables precise financial planning and accountability, which is critical for public sector and other organizations requiring granular fund accounting.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which anchor its transactional integrity. The primary identifier is the WORKSHEET_FUND_SRC_ID, a system-generated unique key for each cost allocation record. The two critical foreign key columns establish the essential relationships for the table's function: WORKSHEET_BDGT_ELMNT_ID links the allocation to a specific line item in a budget worksheet (PQH_WORKSHEET_BDGT_ELMNTS), and COST_ALLOCATION_KEYFLEX_ID links to the specific combination of accounting segments (e.g., fund, department, account) defined in the PAY_COST_ALLOCATION_KEYFLEX table. This design allows a single budget worksheet element to be split and allocated across multiple funding sources.

Common Use Cases and Queries

A primary use case is generating reports to analyze budget proposals by funding source. Analysts can query this table to understand how a proposed position's salary and benefits are distributed across different grants, projects, or departments. Common SQL patterns involve joining to the parent tables to retrieve descriptive information. For example, to list all cost allocations for a specific budget worksheet, a query would join on WORKSHEET_BDGT_ELMNT_ID. Another critical use is during the budget validation process, where the system ensures that the sum of allocated amounts from this table matches the total amount specified in the parent worksheet budget element. Troubleshooting often involves verifying these allocations exist and are correctly linked when budget data appears incomplete.

Related Objects

The PQH_WORKSHEET_FUND_SRCS table is centrally connected to two key master or transactional tables via documented foreign key relationships:

  • PQH_WORKSHEET_BDGT_ELMNTS: This is the parent table for budget worksheet elements. The relationship is maintained through the column PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID, which references the primary key of PQH_WORKSHEET_BDGT_ELMNTS. This defines which budget line item the funding source is for.
  • PAY_COST_ALLOCATION_KEYFLEX: This table stores the valid accounting flexfield combinations for cost allocation. The relationship is maintained through the column PQH_WORKSHEET_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID, which references the primary key of PAY_COST_ALLOCATION_KEYFLEX. This defines the specific funding source or cost center combination being charged.

These relationships are fundamental, meaning that every record in PQH_WORKSHEET_FUND_SRCS must have a valid corresponding record in both of these referenced tables.