Search Results ben_elig_benfts_grp_prte_f

Overview

The BEN_ELIG_BENFTS_GRP_PRTE_F 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. This table functions as an eligibility participation table, establishing the critical link between compensation objects—such as plans, options, or coverage levels—and benefit groups. Its primary role is to define which benefit groups are either included in or excluded from eligibility for a given compensation object. This inclusion/exclusion logic is fundamental for configuring complex benefit enrollment rules, ensuring that offerings are correctly targeted to specific employee populations based on their assignment to predefined benefit groups. The '_F' suffix denotes that it is a date-tracked table, meaning it maintains a history of changes over time through its EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns.

Key Information Stored

The table's structure is designed to manage effective-dated assignments and relationships. The primary key is a composite of ELIG_BENFTS_GRP_PRTE_ID and EFFECTIVE_START_DATE, ensuring historical record uniqueness. The most significant columns include ELIG_BENFTS_GRP_PRTE_ID, a unique identifier for each participation record; BENFTS_GRP_ID, a foreign key linking to the BEN_BENFTS_GRP table to identify the specific benefit group; and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the period during which the inclusion/exclusion rule is active. Additional columns typically present in such structures, though not explicitly listed in the provided metadata, would define the compensation object (e.g., PLAN_ID, OPT_ID) and an inclusion/exclusion flag to specify the type of rule being applied.

Common Use Cases and Queries

This table is central to eligibility determination processes and administrative reporting. A primary use case is analyzing the benefit groups eligible for a specific benefit plan during implementation or audit. A sample SQL query would join BEN_ELIG_BENFTS_GRP_PRTE_F to BEN_BENFTS_GRP and the relevant compensation object table (e.g., BEN_PL_F) to list all active assignments. For example, to find all benefit groups included for a plan as of a specific date, one might query: SELECT bg.NAME FROM BEN_ELIG_BENFTS_GRP_PRTE_F prte, BEN_BENFTS_GRP bg WHERE prte.BENFTS_GRP_ID = bg.BENFTS_GRP_ID AND prte.PLAN_ID = :p_plan_id AND :p_effective_date BETWEEN prte.EFFECTIVE_START_DATE AND prte.EFFECTIVE_END_DATE. This data is also critical for troubleshooting enrollment issues where an employee cannot see an expected benefit offering, often traced back to their benefit group's status in this table.

Related Objects

The table maintains defined relationships with other key objects in the Advanced Benefits schema. As per the provided metadata, its most important foreign key relationship is with the BEN_BENFTS_GRP table via the BENFTS_GRP_ID column. This links the participation rule to the actual benefit group definition. Furthermore, BEN_ELIG_BENFTS_GRP_PRTE_F is itself referenced by various other eligibility and enrollment entities within the BEN schema. It is typically a child table to compensation object base tables like BEN_PL_F (Plans), BEN_OIPL_F (Plan In Programs), or BEN_OPT_F (Options). Understanding these relationships is essential for constructing accurate data models and for navigating the complex eligibility rule hierarchy during system configuration and customization.