Search Results hr_summary_efc




Overview
Explore in AI Chat

Overview

The HR_SUMMARY_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER (Personnel) product family. Its primary role is to support the Euro as Functional Currency (EFC) process. This table is an exact structural copy of the standard HR_SUMMARY table, which typically stores consolidated employee-level information. The EFC process populates this separate table to maintain a distinct, parallel dataset where all monetary values are converted and stored in Euros, enabling reporting and compliance for organizations operating under the Euro currency regime alongside other functional currencies within the same EBS instance.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's definition as a copy of HR_SUMMARY implies it holds aggregated employee compensation and assignment data. The documented primary and foreign keys are critical for understanding its structure. The table uses a composite primary key (HR_SUMMARY_EFC_PK) consisting of ID_VALUE and EFC_ACTION_ID. The ID_VALUE likely corresponds to a unique employee or assignment identifier, linking to the summarized data. The EFC_ACTION_ID is a foreign key that ties each record to a specific run of the EFC process in the HR_EFC_ACTIONS table, providing an audit trail and process context for the Euro-converted data stored within.

Common Use Cases and Queries

The primary use case for HR_SUMMARY_EFC is generating financial and HR reports where all currency amounts must be presented uniformly in Euros, regardless of the original transaction currency. This is essential for consolidated group reporting within the European Union. Common queries involve joining this table to master employee data while filtering by a specific EFC process run. A typical reporting pattern would be:

  • Retrieving Euro-converted summary payroll data for a set of employees processed in the latest EFC batch.
  • Comparing summarized costs between standard (HR_SUMMARY) and Euro-converted (HR_SUMMARY_EFC) tables for reconciliation.
  • Generating audit reports by joining HR_SUMMARY_EFC to HR_EFC_ACTIONS to list all data created by a specific process execution.

Sample SQL to retrieve EFC-summarized data for a specific process run might be: SELECT s.* FROM hr.hr_summary_efc s, hr.hr_efc_actions a WHERE s.efc_action_id = a.efc_action_id AND a.action_status = 'COMPLETE'.

Related Objects

The HR_SUMMARY_EFC table has a direct and documented dependency within the EFC process architecture. Its primary relationship is defined by a foreign key constraint.

  • HR_EFC_ACTIONS: This is the key controlling table for the EFC process. The column HR_SUMMARY_EFC.EFC_ACTION_ID references HR_EFC_ACTIONS. This relationship ensures every record in the summary table is linked to a specific instance of the EFC process execution, which tracks parameters, status, and timing.
  • HR_SUMMARY: Although not listed as a formal foreign key, the table's definition states it is a copy of HR_SUMMARY. This indicates a strong logical relationship, where HR_SUMMARY_EFC is the Euro-converted counterpart to the base HR_SUMMARY table, and they are likely populated from common source transactions.