Results for “pqh_budget_sets_efc”

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

Overview

PQH_BUDGET_SETS_EFC is a table owned by the HR schema within the Public Sector HR (PQH) product family, a module primarily associated with Oracle E-Business Suite implementations serving government, education, and public administration organizations. The object is documented as a copy of the PQH_BUDGET_SETS table populated by the EFC (Euro as Functional Currency) process, indicating that its core purpose is to preserve an alternate, currency-restated snapshot of budget set data for organizations that have migrated or dual-maintain their functional currency to the Euro. This pattern is common in European public sector deployments where regulatory or reporting requirements mandate a distinct Euro-denominated view of budgetary structures alongside the primary ledger.

The table contains nine documented columns in the 12.2.2 physical schema and is classified as VALID in the ETRM metadata. From a heuristic Data Vault perspective, the mined classification is standalone, suggesting the table behaves as an isolated entity without downstream dependents or hub-like role in the modeled relationships. Modelers may treat it as a satellite-style snapshot copy rather than a strict hub or link, since its membership is fully governed by the EFC population process rather than by organic transactional key growth.

Key Information Stored

The surrogate primary key is BUDGET_SET_ID, enforced through the constraint PQH_BUDGET_SETS_EFC_PK. Because the table mirrors PQH_BUDGET_SETS, BUDGET_SET_ID is the only documented key candidate; no additional unique business-key index is described in the metadata, so it should be treated as the primary and only documented unique identifier for this copy.

• BUDGET_SET_ID — surrogate primary key and join key back to the source budget set.
• CURRENCY_CODE — the currency associated with the restated budget set; central to the EFC process semantics.
• EFC_ACTION_ID — foreign key to HR_EFC_ACTIONS, tying each row to the originating currency conversion/action run.
• BUDGET_UNIT1_VALUE, BUDGET_UNIT2_VALUE, BUDGET_UNIT3_VALUE — the three budgeted amounts across the three unit dimensions.
• BUDGET_UNIT1_AVAILABLE, BUDGET_UNIT2_AVAILABLE, BUDGET_UNIT3_AVAILABLE — the remaining available balances per unit dimension, used in funds-checking and budget consumption reporting.

The paired value/available columns make this table useful for both allocation and remaining-capacity analysis under the Euro functional currency.

Common Use Cases and Queries

Typical scenarios include Euro-denominated budget reporting, reconciliation between the original and EFC copy, and audit tracing of conversion actions. A representative reconciliation query joining the copy back to its source and to the action table:

• Listing all budget sets restated under a specific EFC action: SELECT b.BUDGET_SET_ID, b.CURRENCY_CODE, b.BUDGET_UNIT1_VALUE FROM PQH_BUDGET_SETS_EFC b WHERE b.EFC_ACTION_ID = :action_id;
• Computing available-versus-budgeted variance: SELECT BUDGET_SET_ID, BUDGET_UNIT1_VALUE - BUDGET_UNIT1_AVAILABLE AS REMAINING FROM PQH_BUDGET_SETS_EFC;
• Joining to HR_EFC_ACTIONS to attribute each row to a conversion run and its timestamp for audit reporting.
• Comparing PQH_BUDGET_SETS and PQH_BUDGET_SETS_EFC on BUDGET_SET_ID to detect rows not yet converted.

Related Objects

• HR_EFC_ACTIONS — referenced by PQH_BUDGET_SETS_EFC.EFC_ACTION_ID; the driving object of the EFC process.
• PQH_BUDGET_SETS — the source table from which this EFC copy is populated; primary join via BUDGET_SET_ID.
• PQH_BUDGET_SET_ITEMS — the line-level companion to budget sets, typically joined on BUDGET_SET_ID for detail reporting.
• PQH_BUDGETS — parent budgeting entity associated with budget sets.
• GENERIC_CURRENCIES / FND_CURRENCIES — currency validation for CURRENCY_CODE.

These relationships reflect the metadata's documented FK structure, supplemented by standard Public Sector HR budgeting joins.