Results for “pay_element_entry_values_f”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_ELEMENT_ENTRY_VALUES_F is a core Payroll (PAY) module table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the HR schema. It stores the actual input values captured against specific element entries — the individual data points that drive how an element (such as a salary, allowance, deduction, or statutory contribution) is calculated for a given assignment or payroll run. Where PAY_ELEMENT_ENTRY_F captures the header-level relationship between an assignment and an element, this table captures the granular, per-input value that the element's processing rules consume.

The table is date-tracked: it carries EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, making it a datable entity consistent with EBS's DateTrack architecture. This allows historical input values to be retained while newer values supersede older ones without destroying the audit trail. Based on the documented FK structure, the heuristic Data Vault classification is standalone, meaning the table is modeled as an independent structure rather than as a clearly linked hub or satellite. This should be treated as a modeling suggestion only; in practice the table behaves much like a versioned satellite keyed on a business-populated surrogate identifier.

Key Information Stored

• ELEMENT_ENTRY_VALUE_ID — the surrogate primary key component uniquely identifying each input value record for an element entry.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the DateTrack validity range that, together with ELEMENT_ENTRY_VALUE_ID, forms the full composite primary key PAY_ELEMENT_ENTRY_VALUES_F_PK.
• ELEMENT_ENTRY_ID — the foreign reference back to the parent element entry record (PAY_ELEMENT_ENTRY_F), linking this value to a specific assignment-to-element relationship.
• INPUT_VALUE_ID — identifies which element input (defined in the element's input value setup) this record supplies a value for, tying the row to the input definition such as Amount, Rate, or Hours.
• SCREEN_ENTRY_VALUE — the user-entered value captured on the element entry form, stored as text and later converted according to the input value's data type and units.

The primary key PAY_ELEMENT_ENTRY_VALUES_F_PK is the only documented unique index and is composed of ELEMENT_ENTRY_VALUE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, with ELEMENT_ENTRY_VALUE_ID serving as the effective surrogate identifier.

Common Use Cases and Queries

Typical scenarios include verifying the inputs supplied for a given element entry, reconciling payroll results back to entered values, and auditing changes over time through DateTrack ranges.

• Listing current inputs for a specific element entry, filtering on effective dates to retrieve only the active row.
• Reporting historical input changes by ordering rows on EFFECTIVE_START_DATE.
• Joining values to input definitions and element entries to produce a full audit or payroll validation report.

A representative query pattern:

SELECT peev.ELEMENT_ENTRY_VALUE_ID,
       peev.ELEMENT_ENTRY_ID,
       peev.INPUT_VALUE_ID,
       peev.SCREEN_ENTRY_VALUE,
       peev.EFFECTIVE_START_DATE,
       peev.EFFECTIVE_END_DATE
FROM   HR.PAY_ELEMENT_ENTRY_VALUES_F peev
WHERE  peev.ELEMENT_ENTRY_ID = :p_entry_id
AND    TRUNC(SYSDATE) BETWEEN peev.EFFECTIVE_START_DATE
                          AND NVL(peev.EFFECTIVE_END_DATE, TRUNC(SYSDATE)+1);

This time-window predicate is the standard idiom for retrieving the single dated row in effect as of a given date.

Related Objects

• PAY_ELEMENT_ENTRY_F — parent of the entry; joined on ELEMENT_ENTRY_ID.
• PAY_INPUT_VALUES_F — defines the element input referenced by INPUT_VALUE_ID.
• PAY_ELEMENT_TYPES_F — defines the element to which the entry belongs.
• PAY_ELEMENT_ENTRIES / element entry views — frequently used with this table for reporting and reconciliation.
• PAY_RUN_RESULTS_F — payroll results that consume these input values during processing.

Together these objects form the element entry to payroll result chain central to Oracle Payroll processing.