Search Results per_work_incident_efc_pk

Overview

The PER_WORK_INCIDENTS_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module. It functions as a temporary copy of the core PER_WORK_INCIDENTS table, which stores records related to workplace incidents. Its primary role is to support the Euro as Functional Currency (EFC) process, a regulatory and accounting framework for managing currency conversion and reporting when the Euro is adopted as a company's functional currency. The table is populated during the EFC process to hold a snapshot of incident data for the purpose of currency revaluation and reporting, ensuring historical financial accuracy related to incident costs is maintained during the transition.

Key Information Stored

The table's structure mirrors that of its source table, PER_WORK_INCIDENTS, but is keyed to a specific EFC process run. The most critical columns define its composite primary key and its relationship to the EFC process control mechanism. The INCIDENT_ID column holds the identifier linking each record back to the original work incident in the base table. The EFC_ACTION_ID column is a foreign key that ties the copied incident data to a specific execution instance in the HR_EFC_ACTIONS control table, which tracks EFC process runs. This pairing ensures data lineage and process auditability. While the full column list is not detailed in the provided metadata, it would typically include all relevant incident details such as dates, descriptions, associated costs, and employee information from the source table at the time of the EFC snapshot.

Common Use Cases and Queries

The primary use case is auditing and reporting on the financial impact of work incidents as part of Euro conversion compliance. It allows historical reporting on incident-related costs (like compensation or fines) in both the original transactional currency and the converted Euro values. Common queries involve joining this table to the EFC actions table for process context and to the base incidents table for detailed information. A typical reporting pattern would be to retrieve all incidents processed in a specific EFC run:

• SELECT pwie.*, hrea.action_code FROM hr.per_work_incidents_efc pwie JOIN hr.hr_efc_actions hrea ON pwie.efc_action_id = hrea.efc_action_id WHERE hrea.action_code = '&RUN_CODE';

Another critical use is reconciliation, comparing data between the EFC copy and the base table to validate the accuracy and completeness of the EFC snapshot for a given incident ID range.

Related Objects

The table has defined dependencies on other core EBS HR objects, as per the provided relationship data.

• Primary Key: PER_WORK_INCIDENT_EFC_PK on columns (INCIDENT_ID, EFC_ACTION_ID). This enforces uniqueness for each incident snapshot per EFC process run.
• Foreign Key (References): The table has a single documented foreign key relationship. The column PER_WORK_INCIDENTS_EFC.EFC_ACTION_ID references the HR_EFC_ACTIONS table. This is the master table that logs and controls all EFC process executions within the HR module.
• Source Table: While not a formal foreign key relationship, the table is a direct copy of PER_WORK_INCIDENTS, the principal table for storing occupational health and safety incident records.