Search Results pay_event_qualifiers_f




Overview
Explore in AI Chat

Overview

PAY_EVENT_QUALIFIERS_F is a date-tracked (datetracked) definition table in the Oracle E-Business Suite Payroll (PAY) module, owned by the HR schema. It stores the configuration of event qualifiers — the rules that determine whether a business event (such as an assignment change, salary alteration, or element entry) qualifies to trigger downstream payroll processing logic. In EBS 12.1.1 and 12.2.2, this table underpins the Event Qualification framework used by payroll event processing and event groups.

The table is a DateTrack-enabled "F" (frozen/dated) table, meaning that each logical row is versioned by an effective date range rather than being updated in place. The documented physical schema in ETRM 12.2.2 lists 21 columns. Based on the FK structure mined from the metadata, the heuristic Data Vault classification for this object is standalone — it is not modeled as a hub, link, or satellite because the documented relationships do not resolve to a conformed business key hierarchy. This classification should be treated as a modeling suggestion only; in practice the table functions as a reference/definition entity whose surrogate key is EVENT_QUALIFIER_ID.

Key Information Stored

The primary key is PAY_EVENT_QUALIFIERS_F_PK, composed of EVENT_QUALIFIER_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. A unique index, PAY_EVENT_QUALIFIERS_PK, adds ZD_EDITION_NAME to those three columns, making the business-key candidate (EVENT_QUALIFIER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ZD_EDITION_NAME). The most significant columns include:

Common Use Cases and Queries

Typical uses include auditing which qualifiers are active for a given legislation, troubleshooting why a payroll event did or did not fire, and reporting on qualifier definitions that reference a specific dated table. A common query pattern filters on the effective date range and legislation:

  • SELECT event_qualifier_id, qualifier_name, legislation_code, qualifier_where_clause FROM pay_event_qualifiers_f WHERE legislation_code = :p_leg AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
  • Join to PAY_DATED_TABLES on DATED_TABLE_ID to resolve the underlying dated table name for reporting.
  • Filter by BUSINESS_GROUP_ID to scope results to a specific payroll business group.

Related Objects

  • PAY_DATED_TABLES — referenced via PAY_EVENT_QUALIFIERS_F.DATED_TABLE_ID; identifies the datetracked source table.
  • PAY_EVENT_QUALIFIERS — the corresponding non-frozen view/table alias exposing current rows.
  • Event group and event qualification setup tables in the PAY module that consume qualifier definitions.
  • HR datetrack infrastructure objects that manage effective dating for this row set.
  • Payroll event processing and payroll action APIs that evaluate qualifiers at runtime.