Search Results ben_prtt_rt_val




Overview
Explore in AI Chat

Overview

The BEN_PRTT_RT_VAL table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically for releases 12.1.1 and 12.2.2. It serves as the primary repository for storing the calculated or assigned rate values for participants enrolled in compensation-related objects. These objects typically include elements such as stock options, bonuses, or other variable compensation plans managed within the system. The table's existence is critical for the compensation life cycle, as it holds the definitive rate data that drives eligibility, enrollment, and payout calculations for participants in these benefit programs.

Key Information Stored

The table's primary identifier is the PRTT_RT_VAL_ID column, which is the primary key. Based on the provided foreign key relationships, the table is fundamentally linked to the life event enrollment process. The key foreign key columns are PER_IN_LER_ID and ENDED_PER_IN_LER_ID, both referencing the BEN_PER_IN_LER table. These columns associate a specific rate value with a participant's enrollment record during a life event (LER) and can track the record that ended it. While the exact column list is not fully detailed in the provided metadata, a table of this nature would typically store columns for the rate value itself (e.g., a number, percentage, or monetary amount), the effective start and end dates, the associated compensation object or plan, the participant identifier, and audit columns such as CREATED_BY and LAST_UPDATE_DATE.

Common Use Cases and Queries

This table is central to reporting and auditing compensation enrollment data. A common use case is generating a report of all active rate assignments for participants in a specific stock option plan. Another is auditing historical rate changes triggered by specific life events, such as promotions. A typical query would join BEN_PRTT_RT_VAL to BEN_PER_IN_LER and participant tables to retrieve a comprehensible list.

Sample Query Pattern:
SELECT pv.prtt_rt_val_id, pv.rate_val, pil.per_in_ler_id, pil.ler_id
FROM ben_prtt_rt_val pv,
ben_per_in_ler pil
WHERE pv.per_in_ler_id = pil.per_in_ler_id
AND pil.ler_id = 12345 -- Specific Life Event
AND SYSDATE BETWEEN pv.effective_start_date AND pv.effective_end_date;

Related Objects

The table maintains defined foreign key relationships with the BEN_PER_IN_LER table, which stores information about persons in a life event. This is the primary documented relationship.

  • BEN_PER_IN_LER: Linked via the PER_IN_LER_ID column. This joins a participant's rate value to their specific life event enrollment record.
  • BEN_PER_IN_LER: Also linked via the ENDED_PER_IN_LER_ID column. This relationship is used to track which subsequent life event enrollment record ended or superseded a particular rate value, maintaining historical data integrity.

As a central compensation rate table, it would also be referenced by various Advanced Benefits views and APIs responsible for compensation calculation and reporting, though these are not specified in the provided metadata.