Results for “ben_bnfts_grp_uk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN.BEN_BENFTS_GRP is a core Oracle E-Business Suite Benefits configuration table that stores the definition of benefits groups. A benefits group assigns a name and description to a set of persons who share common benefits processing characteristics, most commonly related to eligibility rules or to variable contribution rates applied to a plan. By defining a benefits group, administrators avoid maintaining individual-level overrides and instead drive benefits logic at a population level. The table resides in the BEN schema, is registered as valid in ETRM 12.1.1 and 12.2.2, and is owned physically by the APPS schema under tablespace APPS_TS_TX_DATA with a PCT Free of 10.

From a Data Vault modeling heuristic, the table is classified as hub-leaning: its surrogate primary key BENFTS_GRP_ID identifies a durable business concept (a benefits group), while the unique business key (NAME, BUSINESS_GROUP_ID) is stable across source systems. Descriptive columns such as BNG_DESC and the descriptive flexfield segments are better modeled as satellite attributes, while the many child tables that reference BENFTS_GRP_ID function as link or satellite structures branching from this hub.

Key Information Stored

The object contains 41 documented columns. The most significant are:

• BENFTS_GRP_ID — NUMBER(15), mandatory, the surrogate primary key defined by BEN_BENFTS_GRP_PK. It uniquely identifies each benefits group record and is the foreign key target for downstream tables such as BEN_BENEFIT_ACTIONS, BEN_BENFTS_GRP_RT_F, and BEN_ELIG_BENFTS_GRP_PRTE_F.
• NAME — VARCHAR2(240), the user-facing name of the benefits group. Together with BUSINESS_GROUP_ID it forms the unique business-key candidate BEN_BNFTS_GRP_UK, ensuring group names are unique within a business group.
• BUSINESS_GROUP_ID — NUMBER(15), foreign key to HR_ORGANIZATION_UNITS, scoping each group to a specific business group (enterprise/legal entity context). Indexed non-uniquely as BEN_BENFTS_GRP_FK1.
• BNG_DESC — the descriptive text for the group; in the ETRM physical schema it is the final attribute column, though the NAME-level documentation emphasizes the description assigned to each group.
• BNG_ATTRIBUTE_CATEGORY and BNG_ATTRIBUTE1 … BNG_ATTRIBUTE30 — the descriptive flexfield defining column plus thirty segment columns used to capture customer-specific extension data without schema changes.
• Object versioning and audit columns — OBJECT_VERSION_NUMBER supports OAF-based optimistic locking, while CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and LAST_UPDATE_DATE provide the standard WHO audit trail.

Common Use Cases and Queries

Benefits groups are consulted whenever eligibility or rate processing requires population-level categorization. A typical operational query lists all groups within a business group for a pick-list or validation routine:

SELECT bng.benfts_grp_id, bng.name, bng.bng_desc
FROM   ben_benfts_grp bng
WHERE  bng.business_group_id = :p_business_group_id
ORDER  BY bng.name;

To identify which benefit actions reference a given group — for example, during a purge or reconfiguration of Vision Corporation’s Company Car plan — the following join is common:

SELECT a.benefit_action_id, a.benfts_grp_id, g.name
FROM   ben_benefit_actions a, ben_benfts_grp g
WHERE  a.benfts_grp_id = g.benfts_grp_id
AND    g.name = 'Company Car Eligible';

Reporting use cases include: auditing which groups drive special contribution rates (self-insured life plans), determining eligibility population sizes for open enrollment, and reconciling flexfield extension data across releases. Because the group is referenced by both action and eligibility tables, it functions as a central anchor for benefits-rule analysis.

Related Objects

• BEN_BENEFIT_ACTIONS — references BENFTS_GRP_ID on BEN_BENFTS_GRP.BENFTS_GRP_ID, linking groups to benefit actions.
• BEN_BENFTS_GRP_RT_F — references BENFTS_GRP_ID, storing rate-related configuration keyed to groups.
• BEN_ELIG_BENFTS_GRP_PRTE_F — references BENFTS_GRP_ID, expressing eligibility predicate rules that use groups.
• HR_ORGANIZATION_UNITS — target of BUSINESS_GROUP_ID, defining the business-group scope.
• BEN_BENFTS_GRP_F — the foreign-key documentation source for BENFTS_GRP_ID noted in the column comments.
• FND/APPS interfaces — descriptive flexfield structures referenced through BNG_ATTRIBUTE_CATEGORY.

Together these objects confirm that BEN_BENFTS_GRP acts as a hub of benefits-group identity, with action, rate, and eligibility tables as dependent satellites.