Search Results pqh_dflt_fund_srcs




Overview
Explore in AI Chat

Overview

The table PQH_DFLT_FUND_SRCS is a core data object within the Oracle E-Business Suite Public Sector Human Resources (PQH) module. It serves as a critical repository for storing and managing cost allocation information associated with budget elements. In the context of public sector budgeting and payroll, this table enables the systematic assignment of funding sources—such as specific grants, projects, or accounts—to personnel costs. Its primary role is to support the complex budgetary accounting and compliance requirements typical of government and public sector organizations by defining default funding distributions for budgeted positions or jobs.

Key Information Stored

The table's structure is designed to link a budget element to a specific financial distribution. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its essential components. The primary key column, DFLT_FUND_SRC_ID, uniquely identifies each cost allocation record. The table's core function is established through two critical foreign key columns: DFLT_BUDGET_ELEMENT_ID links the funding source to a specific budget element defined in the PQH_DFLT_BUDGET_ELEMENTS table, and COST_ALLOCATION_KEYFLEX_ID links to the PAY_COST_ALLOCATION_KEYFLEX table. This latter link connects the record to the actual accounting flexfield structure (e.g., Fund, Account, Department, Project), which holds the detailed financial coding for the charge.

Common Use Cases and Queries

A primary use case is the automated population of cost distribution during payroll processing or position budgeting. When a transaction references a default budget element, the system can retrieve the pre-defined funding allocation from this table. Common reporting and validation queries involve joining to related tables to analyze or audit funding setups. For instance, to list all funding sources for active budget elements, a query might join PQH_DFLT_FUND_SRCS to PQH_DFLT_BUDGET_ELEMENTS. Another critical query pattern retrieves the full accounting keyflex segments for a funding source by joining through PAY_COST_ALLOCATION_KEYFLEX to the underlying code combination table (GL_CODE_COMBINATIONS). Data integrity checks often involve verifying that every DFLT_BUDGET_ELEMENT_ID in this table has a valid parent record.

Related Objects

The table exists within a defined hierarchy of Public Sector HR objects, with specific documented relationships.

  • PQH_DFLT_BUDGET_ELEMENTS: This is a parent table. The column PQH_DFLT_FUND_SRCS.DFLT_BUDGET_ELEMENT_ID is a foreign key referencing the primary key of PQH_DFLT_BUDGET_ELEMENTS. This relationship ties a funding source to its overarching budget element.
  • PAY_COST_ALLOCATION_KEYFLEX: This is another parent table. The column PQH_DFLT_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID is a foreign key referencing PAY_COST_ALLOCATION_KEYFLEX. This relationship maps the funding source to the specific accounting code combination used for financial posting.
  • The table is also referenced by its primary key constraint, PQH_DFLT_FUND_SRCS_PK, on the column DFLT_FUND_SRC_ID.