Search Results per_pay_proposals_efc




Overview
Explore in AI Chat

Overview

The PER_PAY_PROPOSALS_EFC table is a specialized data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the HR (Human Resources) schema. It functions as a historical snapshot table created and populated by the Euro as Functional Currency (EFC) conversion process. This process is a critical component for organizations operating in the Eurozone, enabling them to convert and maintain historical payroll and compensation data from legacy national currencies to the Euro. The table is an exact structural copy of the core PER_PAY_PROPOSALS table, which stores salary change proposals for employees. Its primary role is to preserve the original, pre-conversion compensation data for audit, reporting, and compliance purposes after the EFC process has updated the live transactional tables.

Key Information Stored

The table stores a complete replica of all rows from the PER_PAY_PROPOSALS table at the point of EFC conversion, keyed to the specific conversion event. Its structure is defined by a composite primary key consisting of PAY_PROPOSAL_ID and EFC_ACTION_ID. The PAY_PROPOSAL_ID column holds the unique identifier for the original salary proposal, linking the snapshot back to the corresponding record in the live PER_PAY_PROPOSALS table. The EFC_ACTION_ID is a foreign key that critically ties each snapshot row to a specific run of the EFC process, recorded in the HR_EFC_ACTIONS table. Other columns mirror those in the base table, such as ASSIGNMENT_ID, CHANGE_DATE, PROPOSED_SALARY_N, and SALARY_REVIEW_REASON, capturing the precise compensation details in the original currency before conversion.

Common Use Cases and Queries

The primary use case for this table is historical auditing and reconciliation. It allows analysts to compare pre- and post-Euro conversion compensation data to verify the accuracy of the EFC process. Common queries involve joining this table with the live PER_PAY_PROPOSALS table and the HR_EFC_ACTIONS control table to track changes for specific employees or conversion events. A typical reporting pattern is to retrieve the original and converted salary values side-by-side for a given assignment or time period. For example:

  • Identifying all salary proposals converted in a specific EFC run: SELECT * FROM per_pay_proposals_efc WHERE efc_action_id = &action_id;
  • Comparing original and current salary for an employee: SELECT hist.proposed_salary_n AS original_salary, curr.proposed_salary_n AS current_salary FROM per_pay_proposals_efc hist JOIN per_pay_proposals curr ON hist.pay_proposal_id = curr.pay_proposal_id WHERE curr.assignment_id = &assign_id;

Related Objects

This table maintains a direct and essential relationship with the EFC process control mechanism. The documented foreign key relationship is:

  • HR_EFC_ACTIONS: The PER_PAY_PROPOSALS_EFC.EFC_ACTION_ID column references the HR_EFC_ACTIONS table. This join provides metadata about the specific EFC conversion job, such as the run date and parameters.

As a snapshot table, its most significant relationship is with its source table, PER_PAY_PROPOSALS, via the PAY_PROPOSAL_ID column, although this is not enforced as a foreign key in the snapshot. The table is intrinsically linked to the overall EFC framework, which similarly creates snapshot tables (suffixed with _EFC) for other core HR entities like PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F.

  • Table: PER_PAY_PROPOSALS_EFC 12.2.2

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

  • Table: PER_PAY_PROPOSALS_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_PAY_PROPOSALS_EFC,  object_name:PER_PAY_PROPOSALS_EFC,  status:VALID,  product: PER - Human Resources ,  description: This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process. ,  implementation_dba_data: HR.PER_PAY_PROPOSALS_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 ,