Results for “ben_elig_ppl_grp_prte_f”

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

Overview

The table BEN.BEN_ELIG_PPL_GRP_PRTE_F is a core configuration table within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its documented purpose is to identify the participant person types required for inclusion in or exclusion from a compensation object. In practice, it stores the people group criteria that define which participant populations are eligible for, or excluded from, a given eligibility profile in the benefits eligibility engine.

The object resides in the BEN schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. It is a date-tracked (effective-dated) table, evidenced by the _F suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE as part of the primary key. The heuristic Data Vault classification mined from the foreign key structure is standalone. This suggests that, from a modeling perspective, the table functions as an independent satellite-like entity rather than a pure transactional hub or link, holding descriptive and criteria attributes keyed by its own surrogate identifier.

Key Information Stored

The table contains 47 documented columns, of which the most significant are summarized below.

• ELIG_PPL_GRP_PRTE_ID — The surrogate primary key column, uniquely identifying each eligibility people-group participant record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-tracked validity columns that, together with the surrogate key, form the composite primary key BEN_ELIG_PPL_GRP_PRTE_F_PK.
• ELIGY_PRFL_ID — The eligibility profile identifier linking this criteria row to its parent eligibility profile.
• PEOPLE_GROUP_ID — The foreign key referencing PAY_PEOPLE_GROUPS, identifying the people group used as the inclusion/exclusion criterion.
• EXCLD_FLAG — Indicates whether the people group is used to exclude (rather than include) matching participants.
• ORDR_NUM — Controls the evaluation order of the criteria associated with the eligibility profile.
• CRITERIA_SCORE / CRITERIA_WEIGHT — Numeric attributes supporting scored or weighted eligibility evaluation.
• BUSINESS_GROUP_ID — The business group (operating unit) context for the record.
• EPG_ATTRIBUTE_CATEGORY and EPG_ATTRIBUTE1 through EPG_ATTRIBUTE30 — A thirty-column descriptive flexfield (DFF) block that stores installation-specific contextual attributes.
• OBJECT_VERSION_NUMBER plus the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — Provide concurrency control and audit tracking.

The only documented unique index, and therefore the sole business-key candidate, is the primary key itself; no additional unique constraints are recorded in the metadata.

Common Use Cases and Queries

This table is primarily queried during benefits eligibility determination, when the eligibility engine resolves which people groups apply to a given eligibility profile. Reporting and troubleshooting scenarios typically involve joining the profile and people group entities. A representative query pattern is:

• Identifying all people-group criteria for one eligibility profile: SELECT p.ELIG_PPL_GRP_PRTE_ID, p.PEOPLE_GROUP_ID, p.EXCLD_FLAG, p.ORDR_NUM FROM BEN.BEN_ELIG_PPL_GRP_PRTE_F p WHERE p.ELIGY_PRFL_ID = :profile_id AND TRUNC(SYSDATE) BETWEEN p.EFFECTIVE_START_DATE AND p.EFFECTIVE_END_DATE;
• Resolving the descriptive people group name by joining to PAY_PEOPLE_GROUPS on PEOPLE_GROUP_ID.
• Auditing inclusion versus exclusion logic by grouping on EXCLD_FLAG.
• Reviewing DFF-based customizations through the EPG_ATTRIBUTE* columns.

Because the table is effective-dated, all production queries should apply a date-bounded predicate to avoid returning superseded rows.

Related Objects

The most significant related objects are those joined through the documented foreign key and through the eligibility profile parent relationship.

• PAY_PEOPLE_GROUPS — Referenced directly; join on BEN_ELIG_PPL_GRP_PRTE_F.PEOPLE_GROUP_ID = PAY_PEOPLE_GROUPS.PEOPLE_GROUP_ID.
• BEN_ELIGY_PRFL — The parent eligibility profile header, linked on ELIGY_PRFL_ID.
• BEN_ELIG_PPL_GRP_PRTE — The non-date-tracked companion (view or interface) exposing the same criteria.
• BEN_ELIG_*_F family tables — Sibling eligibility criteria tables (for example, other person-type, compensation, or assignment criteria tables) that together form a complete eligibility profile.
• BEN_ELIG_PRFL_DF and related eligibility profile definition objects — Consumed by the Benefits eligibility APIs and concurrent programs.

Together these objects allow administrators and developers to configure, inspect, and troubleshoot the people-group inclusion and exclusion rules that underpin Advanced Benefits eligibility processing.