Search Results prtn_elig_prfl_id




Overview
Explore in AI Chat

Overview

The BEN_PRTN_ELIG_PRFL_F table is a core data object within the Oracle E-Business Suite (EBS) Advanced Benefits (BEN) module, specifically in versions 12.1.1 and 12.2.2. It serves as the primary repository for storing eligibility profiles. These profiles are foundational building blocks used to construct complex eligibility criteria for benefit plans, compensation plans, and other HR programs. The table's role is to define reusable sets of eligibility rules that can be associated with multiple plans, ensuring consistency and simplifying administration. The '_F' suffix denotes that it is an effective-dated table, meaning it tracks the history of profile changes over time, a critical feature for accurate auditing and retroactive processing in HR systems.

Key Information Stored

The table's structure is designed to manage the lifecycle and definition of eligibility profiles. The most critical columns, as indicated by the primary key, are PRTN_ELIG_PRFL_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The PRTN_ELIG_PRFL_ID uniquely identifies a specific profile. The effective date columns define the period during which that particular version of the profile definition is active, allowing for corrections or policy changes. While the provided metadata does not list all columns, typical data stored includes the profile name, description, business group identifier, and various flags controlling the profile's behavior and usage within the eligibility engine.

Common Use Cases and Queries

This table is central to benefits configuration and reporting. A common administrative task is to identify all active eligibility profiles for a given business group. A typical query would filter on the current system date falling between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Another critical use case is troubleshooting enrollment issues, where a developer might join this table to participant enrollment tables to verify the eligibility rules applied to a specific employee. For reporting, analysts often query this table to generate a catalog of all defined profiles and their effective periods, which is essential for audits and configuration reviews.

  • Sample SQL to find active profiles: SELECT prtn_elig_prfl_id, effective_start_date, effective_end_date FROM ben.ben_prtn_elig_prfl_f WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date;
  • Use Case: Diagnosing why an employee is ineligible for a plan by tracing back to the specific criteria defined in their assigned profile.

Related Objects

BEN_PRTN_ELIG_PRFL_F is a key parent table in the Benefits data model. Its primary key (PRTN_ELIG_PRFL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) is referenced by foreign keys in numerous child tables that define the specific criteria within a profile. While the exact foreign key relationships are not enumerated in the snippet, based on the module's design, it is fundamentally related to tables such as BEN_PRTN_ELIG_CRIT_F (which stores the individual eligibility criteria like age, service, or job-based rules that constitute a profile) and BEN_PGM_F (Programs) or BEN_PL_F (Plans), which would hold a foreign key to an eligibility profile ID. The table is also heavily accessed by the underlying PL/SQL APIs and engines that process eligibility during enrollment and life events.