Results for “budget_unit3_available”

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

Overview

The PQH_WORKSHEET_PERIODS_EFC table is a Public Sector HR (PQH) object owned by the HR schema in Oracle E-Business Suite. It is a functional-currency companion table to PQH_WORKSHEET_PERIODS, populated by the EFC (Euro as Functional Currency) process. Its purpose is to preserve a copy of worksheet period budget data after amounts have been restated into the Euro functional currency, keeping the converted figures addressable independently of the base transactional records.

The EFC process is invoked during European currency conversion or multi-currency budget administration, where budget unit values and availability must be recalculated and stored under a designated currency. The copy table therefore supports reconciliation, audit, and post-conversion reporting without mutating the original worksheet period rows. In Data Vault terms, the ETRM heuristic classifies this object as satellite-leaning, since it carries descriptive and measurable attributes keyed to a parent worksheet period and an EFC action rather than acting as an independent business hub.

Key Information Stored

The physical schema documents nine columns. The most significant are:

• WORKSHEET_PERIOD_ID — identifier of the parent worksheet period; part of the composite primary key and the primary business-key candidate for joins back to PQH_WORKSHEET_PERIODS.
• EFC_ACTION_ID — foreign key to HR_EFC_ACTIONS; identifies the conversion action that produced the row, and forms the second component of the composite primary key.
• CURRENCY_CODE — currency under which the copied amounts are expressed, typically the Euro after conversion.
• BUDGET_UNIT1_VALUE, BUDGET_UNIT2_VALUE, BUDGET_UNIT3_VALUE — the three budget unit amounts restated into the functional currency.
• BUDGET_UNIT1_AVAILABLE, BUDGET_UNIT2_AVAILABLE, BUDGET_UNIT3_AVAILABLE — corresponding remaining/available balances per budget unit.

The surrogate/composite primary key is the constraint PQH_WORKSHEET_PERIODS_EFC_PK on (WORKSHEET_PERIOD_ID, EFC_ACTION_ID). Because WORKSHEET_PERIOD_ID alone is the natural business key of the parent period, uniqueness is achieved only in combination with EFC_ACTION_ID.

Common Use Cases and Queries

Typical scenarios include reconciling converted budget values against the base table, reporting available budget by unit after EFC processing, and tracing which conversion action touched a period. Example query joining to the EFC action definition:

• SELECT w.WORKSHEET_PERIOD_ID, w.EFC_ACTION_ID, w.CURRENCY_CODE, w.BUDGET_UNIT1_VALUE, w.BUDGET_UNIT1_AVAILABLE FROM HR.PQH_WORKSHEET_PERIODS_EFC w WHERE w.CURRENCY_CODE = 'EUR';
• SELECT w.*, a.* FROM HR.PQH_WORKSHEET_PERIODS_EFC w, HR.HR_EFC_ACTIONS a WHERE w.EFC_ACTION_ID = a.EFC_ACTION_ID;
• Reconciliation: compare BUDGET_UNIT*_VALUE in this table against the unconverted source in PQH_WORKSHEET_PERIODS for the same WORKSHEET_PERIOD_ID.

Because EFC processing may be re-run, filter by the latest EFC_ACTION_ID when reporting current balances.

Related Objects

• PQH_WORKSHEET_PERIODS — source/base table; the parent of the copied rows, joined on WORKSHEET_PERIOD_ID.
• HR_EFC_ACTIONS — referenced by the EFC_ACTION_ID foreign key; drives the conversion process.
• PQH_WORKSHEET_PERIODS_EFC_PK — the primary key constraint (WORKSHEET_PERIOD_ID, EFC_ACTION_ID).
• Related EFC companion copies and budget worksheet tables in the PQH module populated by the same Euro conversion process.