Search Results per_absence_attendances_efc




Overview
Explore in AI Chat

Overview

The PER_ABSENCE_ATTENDANCES_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It functions as a historical snapshot table, created and populated by the Euro as Functional Currency (EFC) conversion process. This process is a critical financial and legal requirement for organizations operating in the Eurozone, enabling them to report and maintain transactional data in Euros alongside their primary functional currency. The table is an exact structural copy of the core PER_ABSENCE_ATTENDANCES table, which stores records of employee absences. Its primary role is to preserve a permanent, unaltered record of absence attendance data as it existed at the moment of an EFC conversion event, ensuring auditability and compliance.

Key Information Stored

The table's structure mirrors that of PER_ABSENCE_ATTENDANCES, meaning it contains all columns from the original table to capture the complete absence record. Based on the provided metadata, two columns are of paramount importance for its specific function. The ABSENCE_ATTENDANCE_ID is the unique identifier for the absence record copied from the source table. The EFC_ACTION_ID is a foreign key that links the snapshot record to the HR_EFC_ACTIONS table. This key is crucial as it identifies the specific EFC conversion run that created this snapshot, providing a historical audit trail. Together, these two columns form the table's composite primary key (PER_ABSENCE_ATTENDANCES_EFC_PK), ensuring each snapshot record is uniquely identifiable by both the original data and the conversion event that captured it.

Common Use Cases and Queries

The primary use case for this table is regulatory auditing and historical reporting related to the EFC process. Auditors may need to verify the state of HR data before and after a currency conversion. A typical query would involve joining this snapshot table with the live PER_ABSENCE_ATTENDANCES table and the HR_EFC_ACTIONS control table to analyze differences for a specific conversion period.

  • Retrieving Snapshot for a Specific EFC Run: SELECT * FROM hr.per_absence_attendances_efc WHERE efc_action_id = <action_id>;
  • Comparing Snapshot to Current Data: SELECT efc.*, curr.* FROM hr.per_absence_attendances_efc efc FULL OUTER JOIN hr.per_absence_attendances curr ON efc.absence_attendance_id = curr.absence_attendance_id WHERE efc.efc_action_id = <action_id>;

Direct reporting or transactional processes should always use the primary PER_ABSENCE_ATTENDANCES table; this EFC table is for historical reference only.

Related Objects

The PER_ABSENCE_ATTENDANCES_EFC table has defined dependencies within the HR schema, primarily serving as a child table in a key relationship.

  • HR_EFC_ACTIONS: This is the central control table for the EFC process. PER_ABSENCE_ATTENDANCES_EFC references it via the foreign key PER_ABSENCE_ATTENDANCES_EFC.EFC_ACTION_ID → HR_EFC_ACTIONS. This relationship ties every snapshot row to a master record of the conversion action, containing details like the conversion date and status.
  • PER_ABSENCE_ATTENDANCES: As the source table, it is intrinsically related. While no formal foreign key is documented from the EFC table back to the source, the ABSENCE_ATTENDANCE_ID column originates from and corresponds to the primary key of PER_ABSENCE_ATTENDANCES, enabling comparative analysis.