Results for “per_assignment_extra_info_efc”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PER_ASSIGNMENT_EXTRA_INFO_EFC table resides in the HR schema within Oracle E-Business Suite 12.1.1 and 12.2.2, and is classified under the PER (Human Resources) product family. It is a structural copy of the PER_ASSIGNMENT_EXTRA_INFO table, populated specifically by the EFC (Euro as Functional Currency) process. The EFC process was introduced to support the conversion of legacy European national currencies into the Euro, preserving pre-conversion values so that historical reporting remains reproducible after the functional currency change. This table therefore acts as an archival and audit-oriented companion to the live assignment extra information records, capturing the state of those records as of each EFC action.
From a Data Vault modeling perspective, the object is satellite-leaning. Its composite primary key of (ASSIGNMENT_EXTRA_INFO_ID, EFC_ACTION_ID) indicates that it records the state of an assignment extra information entity for the duration of a specific EFC action, which is characteristic of a satellite structure attached to a parent hub and qualified by an action event.
Key Information Stored
The table contains 33 documented columns. The most consequential are the following:
ASSIGNMENT_EXTRA_INFO_ID— Surrogate identifier referencing the originatingPER_ASSIGNMENT_EXTRA_INFOrecord. This column forms the first half of the primary key.EFC_ACTION_ID— Foreign key toHR_EFC_ACTIONS, identifying the specific Euro conversion action under which this snapshot was captured. This column forms the second half of the primary key.AEI_INFORMATION1throughAEI_INFORMATION30— The descriptive information flexfield segments carried over from the source table. These hold the configurable assignment-level detail values, withAEI_INFORMATION13notably absent from the documented column list.INPUT_CURRENCY_CODE— The currency in which the original entry was input, relevant for monetary flexfield segments and for tracing value translation during the EFC process.
The surrogate primary key is PER_ASSIGNMENT_EXTRA_INFO_E_PK, defined over ASSIGNMENT_EXTRA_INFO_ID and EFC_ACTION_ID. This same index serves as the documented unique business-key candidate; no separate single-column surrogate is defined.
Common Use Cases and Queries
The primary use case is historical reconciliation following a Euro conversion. Reporting teams compare the archived values against the current PER_ASSIGNMENT_EXTRA_INFO record to confirm that the conversion processed each segment correctly.
A typical query retrieves all archived snapshots for a given assignment across every EFC action:
SELECT e.EFC_ACTION_ID, e.ASSIGNMENT_EXTRA_INFO_ID, e.INPUT_CURRENCY_CODE, e.AEI_INFORMATION1 FROM PER_ASSIGNMENT_EXTRA_INFO_EFC e WHERE e.ASSIGNMENT_EXTRA_INFO_ID = :p_id ORDER BY e.EFC_ACTION_ID;
Auditors may join to the action table to filter by conversion event and timestamp, while HR analysts may compare archived and live rows to identify assignments whose flexfield data diverged after conversion. Because the table is populated by a batch process rather than by online entry, it is generally read-only in practice and should not be updated directly.
Related Objects
The following objects are most significant in relation to this table:
HR_EFC_ACTIONS— Parent object referenced byEFC_ACTION_ID, describing each Euro conversion action.PER_ASSIGNMENT_EXTRA_INFO— The source table of which this is a structural copy; joined onASSIGNMENT_EXTRA_INFO_IDfor before-and-after comparisons.PER_ASSIGNMENTS_F— Parent entity of the assignment extra information records, providing assignment context.- Assignment extra information DDF (descriptive flexfield) definitions, which govern the meaning of the
AEI_INFORMATIONsegments. - EFC conversion concurrent programs and their associated batch processes, which populate this table.
Together these objects support the audit trail and reporting requirements surrounding Euro functional currency conversion in Oracle Human Resources.
-
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
-
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person