Results for “num_value2”

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

Overview

HR_SUMMARY_EFC is a table in the HR schema within the PER (Human Resources) product module of Oracle E-Business Suite. It is a structural copy of the HR_SUMMARY table, populated specifically by the EFC (Euro as Functional Currency) process. The EFC initiative was introduced to support organizations transitioning their functional currency to the Euro, and summary-level HR data required re-expression under the new functional currency. HR_SUMMARY_EFC serves as the target of that re-expression, preserving the same logical shape as the source summary table while isolating the results generated by the conversion process. In Oracle EBS 12.1.1 and 12.2.2, the object retains a VALID status and remains owned by the HR schema.

Applying a heuristic Data Vault classification consistent with its foreign key structure, HR_SUMMARY_EFC is satellite-leaning. Its composite primary key, together with a foreign key dependency on a parent EFC action record, suggests it behaves as a descriptive, context-bearing table attached to a governing entity rather than as an independent hub or an association link.

Key Information Stored

The documented physical schema for Oracle EBS 12.2.2 contains four columns. The most significant are the following:

• ID_VALUE — Part of the composite primary key. It carries the identifying value for the summarized HR record being held, mirroring the corresponding key in HR_SUMMARY.
• EFC_ACTION_ID — The second component of the composite primary key and simultaneously a foreign key to HR_EFC_ACTIONS. It ties each row to the specific EFC execution that produced it, enabling multiple conversion runs or currency re-expressions to coexist.
• NUM_VALUE1 — A numeric column holding a summarized monetary or quantitative measure re-expressed under the Euro functional currency context.
• NUM_VALUE2 — A second numeric measure, providing capacity for alternate summary values such as a secondary total, comparison amount, or derived balance.

The surrogate-style unique index HR_SUMMARY_EFC_PK is defined over (ID_VALUE, EFC_ACTION_ID), making this pair the business-key candidate that guarantees one row per identifier per EFC action. There is no separately documented single-column surrogate key beyond this composite construction.

Common Use Cases and Queries

Typical usage centers on validating and reporting the output of the Euro functional currency conversion. A common pattern joins the table to its EFC action parent to isolate rows for a particular run:

• Reconciling converted summary amounts: selecting NUM_VALUE1 and NUM_VALUE2 for a known ID_VALUE and EFC_ACTION_ID to compare against the pre-conversion HR_SUMMARY figures.
• Auditing a specific EFC process execution by filtering on EFC_ACTION_ID and joining to HR_EFC_ACTIONS for action-level metadata.
• Reporting aggregated numeric summaries across a set of identifiers for a completed conversion, supporting financial restatement or reconciliation documentation.

A representative query joins the satellite to its governing action record to restrict results to a single conversion run:

SELECT s.ID_VALUE, s.NUM_VALUE1, s.NUM_VALUE2 FROM HR.HR_SUMMARY_EFC s, HR.HR_EFC_ACTIONS a WHERE s.EFC_ACTION_ID = a.EFC_ACTION_ID AND s.EFC_ACTION_ID = :action_id;

Related Objects

• HR_EFC_ACTIONS — The parent table referenced by the foreign key HR_SUMMARY_EFC.EFC_ACTION_ID → HR_EFC_ACTIONS.EFC_ACTION_ID. This is the principal relationship governing the table and identifies the conversion action that generated each row.
• HR_SUMMARY — The source table of which HR_SUMMARY_EFC is a copy; it provides the pre-conversion baseline data against which EFC results are compared.
• HR_SUMMARY_EFC_PK — The unique index enforcing uniqueness on (ID_VALUE, EFC_ACTION_ID) and serving as the business-key candidate.

Beyond these documented relationships, applications and concurrent programs that execute the EFC process in the PER module are the functional consumers of this table, reading its numeric summaries after each conversion action completes.