Search Results event_qualifier_id




Overview
Explore in AI Chat

Overview

The PAY_EVENT_VALUE_CHANGES_F table is a core configuration entity within the Oracle EBS Payroll (PAY) module, owned by the HR schema. Its documented purpose is to define "values changes that cause an event" — that is, the rules that determine when a change in a payroll attribute value should trigger a datetracked event. This makes the table central to Oracle Payroll's event-driven architecture, where events such as a change in salary, a grade step alteration, or a rate adjustment must be detected and processed by payroll runs, retroactive calculations, and eligibility routines.

Based on the heuristic Data Vault classification mined from its foreign key structure, the object is best modeled as a standalone entity. It carries no child links or dependent satellites in the documented relationship data, containing its own business attributes alongside a reference to its parent event definition. In dimensional terms it behaves as a configuration/reference table rather than a transactional fact or a resolvable business hub. The table is effective-dated, reflecting the datetracked nature of payroll configuration, and is editioned via the ZD_EDITION_NAME column, consistent with the 12.2.2 edition-based redefinition (EBR) architecture.

Key Information Stored

The table is uniquely identified by the primary key PAY_EVENT_VALUE_CHANGES_F_PK, composed of EVENT_VALUE_CHANGE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. Under 12.2.2 EBR, the documented unique index also includes ZD_EDITION_NAME, forming the full business-key candidate. EVENT_VALUE_CHANGE_ID therefore acts as the surrogate identifier, while the effective date pair and edition name provide the datetracked uniqueness.

Common Use Cases and Queries

Payroll implementers query this table to audit which value transitions raise events, to trace why a particular payroll event fired, and to reconcile configured rules against the DATETRACKED_EVENT_ID chain.

  • Listing all active value-change rules for a business group and legislation within a given date window.
  • Joining FROM_VALUE/TO_VALUE transitions to the parent event to explain payroll run behavior.
  • Reporting on proration styles applied to qualified events for cost analysis.
SELECT evc.EVENT_VALUE_CHANGE_ID,
       evc.DATETRACKED_EVENT_ID,
       evc.FROM_VALUE,
       evc.TO_VALUE,
       evc.PRORATION_STYLE
FROM   HR.PAY_EVENT_VALUE_CHANGES_F evc
WHERE  evc.BUSINESS_GROUP_ID = :p_bg_id
AND    evc.LEGISLATION_CODE = :p_leg_code
AND    TRUNC(SYSDATE) BETWEEN evc.EFFECTIVE_START_DATE
                          AND evc.EFFECTIVE_END_DATE;

Related Objects

  • PAY_DATETRACKED_EVENTS — referenced via DATETRACKED_EVENT_ID; the parent event definition this table qualifies.
  • PAY_EVENT_VALUE_CHANGES_F_PK — the primary key index enforcing the composite uniqueness.
  • PAY_EVENT_QUALIFIERS — associated through EVENT_QUALIFIER_ID for qualifier definitions.
  • PAY_EVENT_UPDATES — consumes value-change rules when events are raised during payroll processing.
  • PAY_ELEMENT_TYPES_F — event rules feed element eligibility and processing logic.
  • FND_BUSINESS_GROUPS — provides BUSINESS_GROUP_ID context.
  • HR_ALL_ORGANIZATION_UNITS — relevant when rules scope to organizational qualifiers.