Search Results per_pay_proposal_compon_efc_pk




Overview
Explore in AI Chat

Overview

The HR.PER_PAY_PROPOSAL_COMPONENT_EFC table is a specialized data object within the Oracle E-Business Suite (EBS) Human Resources (HR) and Payroll modules, specifically versions 12.1.1 and 12.2.2. It functions as a supporting table for the Electronic Funds Capture (EFC) process, which manages the distribution of salary payments. This table stores EFC-specific adjustments or actions linked to individual salary proposal components. Its primary role is to record how a proposed change to an employee's compensation is processed for electronic payment distribution, acting as an extension to the core salary proposal data. As indicated by the documentation warning, direct access to this table is intended for use only by standard Oracle Applications programs.

Key Information Stored

The table's structure is concise, designed to link compensation components with specific EFC actions. The key columns are:

  • COMPONENT_ID: A mandatory NUMBER column serving as a foreign key to the base salary proposal component record (e.g., in PER_PAY_PROPOSALS). It identifies the specific compensation element being adjusted.
  • EFC_ACTION_ID: A mandatory NUMBER column serving as a foreign key to HR_EFC_ACTIONS. This links the component to a defined electronic funds capture action, such as a specific bank account distribution or deduction instruction.
  • CHANGE_AMOUNT_N: A NUMBER column that stores the monetary value of the adjustment associated with the EFC action for this component.
  • INPUT_CURRENCY_CODE: A VARCHAR2(240) column that specifies the currency in which the CHANGE_AMOUNT_N is denominated.
The table's primary key, PER_PAY_PROPOSAL_COMPON_EFC_PK, is a composite key on (COMPONENT_ID, EFC_ACTION_ID), enforcing a unique relationship between a salary component and a specific EFC action.

Common Use Cases and Queries

This table is primarily accessed for auditing and reporting on how proposed salary changes are allocated for electronic payment. A typical use case involves tracing the EFC distribution details for all components within a specific employee's salary proposal. The standard query pattern, as provided in the ETRM, selects all columns directly. A more practical, joined query for reporting would be:

SELECT ppc.component_id,
      hea.efc_action_id,
      ppce.change_amount_n,
      ppce.input_currency_code
FROM hr.per_pay_proposal_component_efc ppce,
     hr.hr_efc_actions hea
WHERE ppce.efc_action_id = hea.efc_action_id
AND ppce.component_id = :p_component_id;

This table is integral to processes that generate payment instructions from approved salary proposals, ensuring the correct amounts are routed to the designated financial accounts.

Related Objects

Based on the provided metadata, the table maintains defined relationships with other key EBS objects.

  • Primary Key: The table is uniquely identified by PER_PAY_PROPOSAL_COMPON_EFC_PK (COMPONENT_ID, EFC_ACTION_ID).
  • Foreign Key Reference: The EFC_ACTION_ID column is a documented foreign key to the HR.HR_EFC_ACTIONS table, which holds the master list of available Electronic Funds Capture actions.
  • Base Table Reference: The COMPONENT_ID column references a base salary proposal component table, such as PER_PAY_PROPOSAL_COMPONENTS or a related entity, as indicated by the "Refer to column comment on base table" note.
  • Referenced By: The table is referenced by an internal object named PER_PAY_PROPOSAL_COMPONENT_EF#, which is likely a synonym, materialized view, or other derived object within the HR schema.
These relationships position PER_PAY_PROPOSAL_COMPONENT_EFC as a critical junction table connecting salary proposal details with the electronic payment execution framework.