Results for “dflt_fund_src_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQH_DFLT_FUND_SRCS is a transaction and configuration table owned by the HR schema and delivered as part of the PQH (Public Sector HR) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold cost allocation information for budget elements. In practice, the table stores the default funding source definitions that determine how a budget element's costs are distributed across cost allocation key flexfields, projects, awards, tasks, expenditure types, and organizations. It therefore acts as the bridge between the budgetary definition layer and the costing and grants accounting layers of the application.

The ETRM metadata classifies this object, using a heuristic Data Vault classification mined from its foreign key structure, as a link object. This is a modeling suggestion rather than a documented physical attribute: the table carries no natural descriptive payload of its own and instead resolves relationships among budget elements, cost allocation structures, projects, and awards. Modelers building a dimensional or Data Vault representation should treat PQH_DFLT_FUND_SRCS as an intersection or association entity whose grain is one default funding source row per budget element.

Key Information Stored

The documented physical schema for 12.2.2 contains 15 columns. The most significant are the following.

The distinction between surrogate and business key is important: only DFLT_FUND_SRC_ID is documented as unique, while the combination of budget element, allocation keyflex, project, award, task, expenditure type, and organization functions as the effective business identifier in practice.

Common Use Cases and Queries

Typical usage includes validating that distribution percentages for a budget element total 100 percent, reproducing the funding split applied to a payroll or project cost, and reporting award and project commitments derived from default funding definitions.

SELECT f.DFLT_FUND_SRC_ID,
       f.DFLT_BUDGET_ELEMENT_ID,
       f.DFLT_DIST_PERCENTAGE,
       f.PROJECT_ID,
       f.AWARD_ID,
       f.EXPENDITURE_TYPE,
       f.ORGANIZATION_ID
FROM   HR.PQH_DFLT_FUND_SRCS f
WHERE  f.DFLT_BUDGET_ELEMENT_ID = :budget_element_id
ORDER  BY f.DFLT_DIST_PERCENTAGE DESC;

A validation query to detect budget elements whose distributions do not aggregate to 100 percent uses a GROUP BY on DFLT_BUDGET_ELEMENT_ID with a HAVING clause on SUM(DFLT_DIST_PERCENTAGE). Reporting queries typically join to PQH_DFLT_BUDGET_ELEMENTS for the element name and to PAY_COST_ALLOCATION_KEYFLEX for the concatenated allocation segment values.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign key relationships.

  • PQH_DFLT_BUDGET_ELEMENTS — parent of DFLT_BUDGET_ELEMENT_ID; supplies the budget element definition for each funding source row.
  • PAY_COST_ALLOCATION_KEYFLEX — referenced through COST_ALLOCATION_KEYFLEX_ID; provides the payroll cost allocation flexfield combination.
  • IGF_AW_AWARD_ALL — referenced through AWARD_ID; supplies award attributes for grants-funded distributions.
  • PAY_COST_ALLOCATION_KEYFLEX-related allocation and costing tables within Oracle Payroll, which consume the keyflex identifier when distributing payroll costs.
  • Project and task tables referenced through PROJECT_ID and TASK_ID, used to attribute costs to project funding.
  • Organization and HR organization objects referenced through ORGANIZATION_ID for ownership and reporting hierarchies.

Because the table is a link entity, any downstream extraction should preserve its foreign keys intact; removing them collapses the association and loses the cost allocation semantics that make the object useful.