Search Results ben_benfts_grp

Overview

The BEN_BENFTS_GRP table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, versions 12.1.1 and 12.2.2. It serves as a master definition table for benefit groups, which are logical grouping constructs used to manage employee eligibility for benefit offerings. Its primary role is to act as a central repository for grouping items that can be assigned to participants, enabling administrators to efficiently manage which sets of employees are eligible for the same benefits plans. This table is fundamental to the configuration and operation of the benefits eligibility engine, providing a reusable mechanism for applying consistent benefit rules across defined populations.

Key Information Stored

The table's structure is designed to uniquely identify and define each benefit group within a specific business context. The primary columns, as indicated by the primary and unique key constraints, are critical for its operation. The BENFTS_GRP_ID column serves as the system-generated primary key (BEN_BENFTS_GRP_PK), uniquely identifying each record. The NAME column holds the descriptive identifier for the benefit group, such as "US Full-Time Employees" or "Management Bonus Plan Participants." This name, in conjunction with the BUSINESS_GROUP_ID which segregates data by operating company, forms a unique key constraint (BEN_BNFTS_GRP_UK), ensuring no duplicate group names exist within a single business group. While the provided metadata does not list all columns, these core fields establish the essential identity and organizational scope of each benefit group record.

Common Use Cases and Queries

This table is central to benefits administration workflows. A primary use case is the setup and maintenance of eligibility profiles, where a benefit group is linked to specific plans or options. Administrators query this table to audit existing groups or to retrieve IDs for integration or data migration scripts. Common reporting needs include listing all defined benefit groups within a business group or identifying groups used in specific eligibility determinations. Sample SQL patterns include retrieving a list of groups: SELECT BENFTS_GRP_ID, NAME FROM BEN.BEN_BENFTS_GRP WHERE BUSINESS_GROUP_ID = &BUSINESS_GROUP ORDER BY NAME;. Another critical pattern involves joining to related tables to see which groups are applied in eligibility rules or benefit actions, using the documented foreign key relationships for the join conditions.

Related Objects

The BEN_BENFTS_GRP table maintains integral relationships with several other key tables in the Advanced Benefits schema, as documented by its foreign key references. These relationships define how benefit groups are utilized within the system:

• BEN_BENEFIT_ACTIONS: Links via BENFTS_GRP_ID. This relationship ties benefit groups to specific automated or manual benefit-related processes and transactions.
• BEN_BENFTS_GRP_RT_F: Links via BENFTS_GRP_ID. This table (a rate factor table) associates benefit groups with specific calculation factors, likely used for determining contribution rates or premium costs.
• BEN_ELIG_BENFTS_GRP_PRTE_F: Links via BENFTS_GRP_ID. This is a critical relationship that connects benefit groups to eligibility profile entries, defining the participant criteria that must be met for group membership.

These dependencies underscore that the BEN_BENFTS_GRP table is a parent entity; its records must exist before they can be referenced in these associated configuration tables.