Search Results pay_element_entry_values_f_pk

Overview

The PAY_ELEMENT_ENTRY_VALUES_F table is a core data object within the Oracle E-Business Suite Payroll (PAY) module. It functions as the primary repository for the actual input values associated with specific element entries. In Oracle Payroll, an element entry defines an instance of a compensation or deduction element (e.g., Salary, Bonus, Tax Withholding) for an employee. This table stores the concrete values entered for each input value defined by the element's classification, such as hours worked, a monetary amount, or a percentage rate. Its role is critical for payroll calculations, as the engine references these stored values to compute earnings and deductions. The '_F' suffix denotes that it is a date-effective table, meaning it maintains a history of changes to these input values over time, which is essential for accurate retroactive processing and auditing.

Key Information Stored

The table's structure is designed to link input data to specific element entries while maintaining historical integrity. The primary key, PAY_ELEMENT_ENTRY_VALUES_F_PK, consists of ELEMENT_ENTRY_VALUE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. This composite key uniquely identifies each historical row of an input value. Key columns include ELEMENT_ENTRY_ID, which foreign keys to PAY_ELEMENT_ENTRIES_F to associate the value with a specific element entry. The INPUT_VALUE_ID links to PAY_INPUT_VALUES_F, identifying which element input (e.g., "Hours", "Amount") the row pertains to. The actual data value is stored in the SCREEN_ENTRY_VALUE column. The EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns define the period for which that specific input value is valid, enabling the system to manage changes.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting payroll calculation results by examining the precise inputs used. For example, to retrieve all current input values for a specific element entry, a common query pattern is:

• SELECT pivv.name, peev.screen_entry_value
• FROM pay_element_entry_values_f peev,
• pay_input_values_f pivv
• WHERE peev.element_entry_id = :p_element_entry_id
• AND SYSDATE BETWEEN peev.effective_start_date AND peev.effective_end_date
• AND peev.input_value_id = pivv.input_value_id
• AND SYSDATE BETWEEN pivv.effective_start_date AND pivv.effective_end_date;

This table is also central for generating custom reports on compensation data, validating batch entry of element entries, and supporting data migration or integration efforts where payroll input data needs to be extracted or validated.

Related Objects

PAY_ELEMENT_ENTRY_VALUES_F has integral relationships with several other key Payroll tables. It is a direct child of PAY_ELEMENT_ENTRIES_F, which defines the overarching element entry. It references PAY_INPUT_VALUES_F to understand the context and validation rules for the stored SCREEN_ENTRY_VALUE. The table is heavily referenced by the payroll calculation engine itself and by key summary and reporting views. For programmatic operations, the PAY_ELEMENT_ENTRY_API package is the supported public interface for creating, updating, and deleting data that ultimately resides in this table, ensuring business rule validation and maintaining data integrity.