Results for “pqh_budget_fund_srcs”

50+ results




Overview
Explore in AI Chat

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

Overview

PQH_BUDGET_FUND_SRCS is a Public Sector HR (PQH) table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Budget Cost Allocation information," identifying it as the intersection between budget elements defined for a position or budget line and the cost allocation key flexfield structures that determine how those budgeted amounts are charged to general ledger accounts. In practice, the table stores the distribution rules that connect a funded budget element to one or more cost allocation flexfield combinations, including the percentage of the budget element assigned to each combination and optional project, award, task, and expenditure type attributes used for grants and project costing.

From a Data Vault modeling perspective, the structure is best classified as a link. The table resolves many-to-many associations among budget elements, cost allocation keyflex values, and awards, rather than functioning as a descriptive hub or a satelite of a single business key. Analysts constructing a dimensional or Data Vault model around Public Sector budgeting should treat PQH_BUDGET_FUND_SRCS as a relationship table whose business keys resolve to PQH_BUDGET_ELEMENTS, PAY_COST_ALLOCATION_KEYFLEX, and IGF_AW_AWARD_ALL.

Key Information Stored

The surrogate primary key is BUDGET_FUND_SRC_ID, enforced by the constraint PQH_BUDGET_FUND_SRCS_PK. A separate uniqueness constraint, PQH_BUDGET_FUND_SRCS_UK, operates on BUDGET_ELEMENT_ID and COST_ALLOCATION_KEYFLEX_ID, making these columns the business-key candidate — a given budget element may appear only once per cost allocation combination. Together, the surrogate key and the unique composite provide both the technical identity and the natural identifier of a funding source record.

Foreign key columns carry the substantive relationships:

  • BUDGET_ELEMENT_ID — references PQH_BUDGET_ELEMENTS; identifies the budgeted line item being distributed.
  • COST_ALLOCATION_KEYFLEX_ID — references PAY_COST_ALLOCATION_KEYFLEX; identifies the GL/PA cost allocation flexfield combination receiving the charge.
  • AWARD_ID — references IGF_AW_AWARD_ALL; ties the allocation to a sponsored award where grant funding applies.
  • DISTRIBUTION_PERCENTAGE — the share of the budget element applied to the referenced cost allocation combination.
  • PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, ORGANIZATION_ID — optional project costing attributes refining where and how the allocation is charged.

Standard EBS audit columns are also present: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. The table is documented with 15 columns in the 12.2.2 physical schema.

Common Use Cases and Queries

Typical uses include verifying that a budget element distributes fully (percentages summing to 100), reporting award-funded budget allocations, and feeding project costing and grants reporting.

Example — list allocations for a budget element:

  • SELECT b.budget_element_id, b.distribution_percentage, k.* FROM pqh_budget_fund_srcs b, pay_cost_allocation_keyflex k WHERE b.cost_allocation_keyflex_id = k.cost_allocation_keyflex_id AND b.budget_element_id = :element_id;

Example — validate percentage totals:

  • SELECT budget_element_id, SUM(distribution_percentage) FROM pqh_budget_fund_srcs GROUP BY budget_element_id HAVING SUM(distribution_percentage) <> 100;

Example — award-funded allocations:

  • SELECT s.budget_fund_src_id, a.award_number, s.project_id, s.task_id, s.expenditure_type FROM pqh_budget_fund_srcs s, igf_aw_award_all a WHERE s.award_id = a.award_id;

Related Objects

  • PQH_BUDGET_ELEMENTS — parent table; joined on BUDGET_ELEMENT_ID.
  • PAY_COST_ALLOCATION_KEYFLEX — cost allocation flexfield combinations; joined on COST_ALLOCATION_KEYFLEX_ID.
  • IGF_AW_AWARD_ALL — awards for sponsored funding; joined on AWARD_ID.
  • PAY_COST_ALLOCATION_KEYFLEX_F and its _KF/_VL variants — flexfield value views resolving the keyflex ID to descriptive segments.
  • HR_ALL_ORGANIZATION_UNITS — resolves ORGANIZATION_ID to an inventory organization for reporting.
  • PA_PROJECTS_ALL and PA_TASKS — resolve PROJECT_ID and TASK_ID for project costing context.