Results for “elig_ppl_grp_prte_id”

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

Overview

The view APPS.BEN_ELIG_PPL_GRP_PRTE_D is a descriptive (denormalized) reporting view within the Oracle Advanced Benefits (BEN) module. It exposes the participation prerequisite rules that govern which People Groups are included in or excluded from an eligibility profile. In Oracle EBS Benefits configuration, an eligibility profile determines who qualifies for a plan or program. One of the criteria that can be attached to a profile is a "People Group" participation prerequisite, stored in the underlying BEN_ELIG_PPL_GRP_PRTE_F table. That table holds only surrogate identifiers and flags; the _D (descriptive) view resolves those identifiers into business-meaningful text such as the eligibility profile name, the people group name, and the yes/no meaning of the exclude flag. The view is owned by the APPS schema and carries a VALID status in ETRM 12.2.2. Because it joins the base configuration tables and lookup values into a single flattened result set, it is suited to reporting, data extraction, and integration scenarios where eligibility rule definitions must be presented in human-readable form rather than as raw foreign keys.

Underlying Base Objects

The view is defined over the following documented objects:

• BEN_ELIG_PPL_GRP_PRTE_F (SYNONYM) — the driving base table holding the people-group participation prerequisite rows, including eligibility profile reference, people group reference, exclude flag, order number, and effective dates.
• BEN_ELIGY_PRFL_F (SYNONYM) — supplies the eligibility profile name via ELIGY_PRFL_ID.
• PAY_PEOPLE_GROUPS (SYNONYM) — supplies the people group name via PEOPLE_GROUP_ID.
• HR_LOOKUPS (VIEW) — resolves the EXCLD_FLAG against LOOKUP_TYPE = 'YES_NO' to yield the exclude meaning.
• FND_USER (SYNONYM) — resolves LAST_UPDATED_BY to the application user.
• HR_API (PACKAGE) — referenced for date-effective (effective start/end date) handling and security context.

All joins to the lookup, profile, people group, and user tables are outer joins in the view text, ensuring that a prerequisite row is still returned even if a related descriptor is missing. The view selects the ROWID of the base _F row as ROW_ID, which is typical of Oracle's descriptive view pattern and supports row-level identification for downstream processing.

Key Columns

• ROW_ID — the ROWID of the underlying BEN_ELIG_PPL_GRP_PRTE_F row.
• ELIG_PPL_GRP_PRTE_ID — primary key of the people group participation prerequisite record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective range for the rule row.
• EXCLD_MEANING — decoded EXCLD_FLAG from HR_LOOKUPS (YES_NO), indicating whether the people group is excluded from or included in the profile.
• ORDR_NUM — evaluation sequence of the prerequisite.
• ELIGY_PRFL_NAME — descriptive name of the parent eligibility profile.
• PEOPLE_GROUP_NAME — descriptive name of the referenced people group.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns reflecting the most recent modification.

Common Use Cases and Queries

This view is commonly queried to audit eligibility configuration, to document which people groups are tied to a profile, or to feed downstream extracts and integrations that require readable eligibility rule data.

List all people group rules for a given eligibility profile:

• SELECT eligy_prfl_name, people_group_name, excld_meaning, ordr_num
• FROM apps.ben_elig_ppl_grp_prte_d
• WHERE eligy_prfl_name = :profile_name
• ORDER BY ordr_num;

Identify excluded people groups across all profiles:

• SELECT eligy_prfl_name, people_group_name
• FROM apps.ben_elig_ppl_grp_prte_d
• WHERE excld_meaning = 'Yes';

Because the view already resolves descriptive names, it reduces the need to re-join BEN_ELIGY_PRFL_F, PAY_PEOPLE_GROUPS, and HR_LOOKUPS in custom reports, making it a practical starting point for eligibility-related SQL in Oracle EBS 12.1.1 and 12.2.2 environments.