Search Results per_periods_of_service_efc




Overview
Explore in AI Chat

Overview

The PER_PERIODS_OF_SERVICE_EFC table is a specialized data object within the Oracle E-Business Suite Human Resources (PER) 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 operation for organizations transitioning to or reporting in Euros. The table is an exact structural copy of the core PER_PERIODS_OF_SERVICE table, which stores an employee's continuous service periods. Its primary role is to preserve a pre-conversion version of employee service period data, ensuring a complete audit trail and supporting historical reporting after the EFC process alters the primary transactional data.

Key Information Stored

The table's structure mirrors that of PER_PERIODS_OF_SERVICE, capturing all columns related to an employee's service history. The most critical columns for understanding its specific EFC context are its composite primary key components. The PERIOD_OF_SERVICE_ID is the unique identifier for a service period record, linking it directly to the original data. The EFC_ACTION_ID is a foreign key that ties this snapshot to a specific run of the EFC process, recorded in the HR_EFC_ACTIONS table. This linkage allows administrators to trace which EFC conversion event created this particular historical copy. Other columns would include standard service period details such as PERSON_ID, DATE_START, ACTUAL_TERMINATION_DATE, and continuous service calculation fields.

Common Use Cases and Queries

The primary use case is auditing and reconciling data changes resulting from the Euro conversion. Analysts may query this table to compare pre- and post-conversion service period details. A typical query would join to the HR_EFC_ACTIONS table to filter snapshots by a specific conversion date or batch identifier.

  • Sample Query to Retrieve EFC Snapshot:
    SELECT p.* FROM hr.per_periods_of_service_efc p, hr.hr_efc_actions a WHERE p.efc_action_id = a.efc_action_id AND a.action_code = '&conversion_batch_code';
  • Reporting Use Case: Generating reports on employee service history as it stood on the last day before a major Euro conversion, for legal or compliance purposes, by selecting the snapshot associated with that conversion's EFC_ACTION_ID.

Related Objects

This table maintains a direct and documented relationship with one other core EFC object, as per the provided metadata.

  • HR_EFC_ACTIONS: This is the controlling table for the EFC process. The PER_PERIODS_OF_SERVICE_EFC.EFC_ACTION_ID column is a foreign key referencing HR_EFC_ACTIONS. This relationship is essential for identifying which EFC process run created the snapshot data.
  • PER_PERIODS_OF_SERVICE: As the source table, this is the primary transactional table from which the EFC snapshot is derived. While not a formal foreign key relationship, data integrity and reporting logic depend on the PERIOD_OF_SERVICE_ID being consistent between the two tables.
  • Table: PER_PERIODS_OF_SERVICE_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_PERIODS_OF_SERVICE_EFC,  object_name:PER_PERIODS_OF_SERVICE_EFC,  status:VALID,  product: PER - Human Resources ,  description: This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process. ,  implementation_dba_data: HR.PER_PERIODS_OF_SERVICE_EFC , 

  • Table: PER_PERIODS_OF_SERVICE_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_PERIODS_OF_SERVICE_EFC,  object_name:PER_PERIODS_OF_SERVICE_EFC,  status:VALID,  product: PER - Human Resources ,  description: This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process. ,  implementation_dba_data: HR.PER_PERIODS_OF_SERVICE_EFC , 

  • Table: HR_EFC_ACTIONS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS , 

  • Table: HR_EFC_ACTIONS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.HR_EFC_ACTIONS,  object_name:HR_EFC_ACTIONS,  status:VALID,  product: PER - Human Resources ,  description: Contains one row for each time the EFC conversion process or delete _EFC table data process is run. ,  implementation_dba_data: HR.HR_EFC_ACTIONS ,