Results for “per_work_incidents_efc”

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

Overview

PER_WORK_INCIDENTS_EFC is a table in the HR schema of Oracle E-Business Suite, belonging to the PER (Human Resources) product family. As documented in the ETRM 12.2.2 repository, it is a copy of the PER_WORK_INCIDENTS table that is populated by the EFC (Euro as Functional Currency) process. The EFC process was introduced to support the transition of certain European implementations to the Euro as the functional currency, creating parallel or mirrored records where monetary amounts are re-expressed in the new functional currency without altering the original transactional data. This table is therefore an ancillary, process-generated structure rather than an operational entry point for work-incident or compensation data.

The documented schema is compact: the HR-owned table contains four columns, with a single unique index, PER_WORK_INCIDENT_EFC_PK, defined on (INCIDENT_ID, EFC_ACTION_ID). From a heuristic Data Vault modeling perspective, the object is classified as satellite-leaning. This suggests it is best understood as a descriptive, context-bearing companion to a core hub or link, carrying attributes qualified by the EFC process run that produced them. In practice, it behaves as an EFC-controlled snapshot of work-related incident compensation information, keyed by the underlying incident and the specific EFC action that generated the mirrored row.

Key Information Stored

Although only four columns are documented for this table, each plays a defined role in the EFC mirroring model:

• INCIDENT_ID — Identifier of the underlying work incident, inherited from the source PER_WORK_INCIDENTS record. It forms the first component of the composite primary key.
• EFC_ACTION_ID — Identifier of the EFC action under which the mirrored record was created. It forms the second component of the composite primary key and is also the table's sole foreign key column.
• COMPENSATION_AMOUNT — The compensation amount associated with the incident, re-stated under the EFC process. This is the principal monetary attribute that the EFC run exists to convert.
• COMPENSATION_CURRENCY — The currency in which the converted compensation amount is expressed, reflecting the Euro functional-currency context of the EFC process.

The surrogate-style unique key is PER_WORK_INCIDENT_EFC_PK on (INCIDENT_ID, EFC_ACTION_ID). No separate single-column surrogate is documented. The business-key candidate is therefore the composite of incident and EFC action, meaning the same incident may appear multiple times when processed through more than one EFC action.

Common Use Cases and Queries

The primary reporting scenario is reconciling original work-incident compensation against its Euro-converted counterpart. A typical query joins the EFC table to the source incident table on INCIDENT_ID and filters by a specific EFC action:

• Audit conversion results: SELECT e.INCIDENT_ID, e.EFC_ACTION_ID, e.COMPENSATION_AMOUNT, e.COMPENSATION_CURRENCY FROM PER_WORK_INCIDENTS_EFC e WHERE e.EFC_ACTION_ID = :action_id;
• Trace which EFC action produced a given converted row: join HR_EFC_ACTIONS on EFC_ACTION_ID to retrieve action context and timing.
• Detect duplicate processing: group by INCIDENT_ID having COUNT(*) > 1 to find incidents touched by multiple EFC actions.
• Currency exposure reporting: aggregate COMPENSATION_AMOUNT by COMPENSATION_CURRENCY to validate that converted amounts are consistently expressed.

Because rows are generated by the EFC process, queries should generally be scoped by EFC_ACTION_ID to avoid mixing results from separate conversion runs.

Related Objects

The following objects are most significant in relation to this table:

• HR_EFC_ACTIONS — Referenced through the foreign key PER_WORK_INCIDENTS_EFC.EFC_ACTION_ID → HR_EFC_ACTIONS. This is the authoritative parent of the EFC action context.
• PER_WORK_INCIDENTS — The operational source table of which this object is a documented copy; joined by INCIDENT_ID.
• PER_WORK_INCIDENTS_EFC primary key index — PER_WORK_INCIDENT_EFC_PK (INCIDENT_ID, EFC_ACTION_ID), enforcing uniqueness of incident-and-action combinations.
• Additional PER EFC mirrored tables — Companion EFC copies within the PER module follow the same EFC_ACTION_ID pattern, supporting cross-object reconciliation.

Together these objects implement the EFC conversion layer, with PER_WORK_INCIDENTS_EFC serving as the incident-compensation satellite within that framework.