Results for “ppl_grp_rt_id”

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

Overview

BEN_PPL_GRP_RT_D is a denormalized reporting view owned by the APPS schema within the Oracle Advanced Benefits (BEN) product family. Its name follows the standard Oracle EBS convention for a "_D" descriptive view: it flattens a foreign-key-driven entity into human-readable attribute names so that reports, concurrent programs, and integration extracts do not have to resolve the underlying identifiers themselves. The view exposes configuration for People Group Rate records, the mechanism by which Advanced Benefits links a defined people group to a variable rate profile and optionally excludes that group from the rate calculation. Because the view was designed for query rather than maintenance, it is read-only and carries no DML capability. It remains valid in both Oracle EBS 12.1.1 and 12.2.2, and is documented in ETRM with the same column footprint in each release.

Underlying Base Objects

The view's text joins five documented objects. BEN_PPL_GRP_RT_F is the driving table and supplies the primary key, effective dating, ordering, and exclusion attributes. FND_USER is joined on LAST_UPDATED_BY to resolve the application user who last touched the record. BEN_VRBL_RT_PRFL_F is joined on VRBL_RT_PRFL_ID to supply the variable rate profile name. PAY_PEOPLE_GROUPS is joined on PEOPLE_GROUP_ID to supply the people group name. HR_LOOKUPS is the only non-synonym base object and is joined on LOOKUP_CODE with a fixed LOOKUP_TYPE of 'YES_NO' to translate the EXCLD_FLAG into the EXCLD_MEANING column. Every join except the driving table is outer-joined with the (+) operator, so a rate row is still returned even when the referenced user, profile, people group, or lookup value is missing.

Key Columns

• ROW_ID — the ROWID of the BEN_PPL_GRP_RT_F row; useful for identifying or de-duplicating source records.
• PPL_GRP_RT_ID — the surrogate primary key of the people group rate record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity window inherited from the _F table.
• ORDR_NUM — the sequence number controlling the order in which multiple rate rows are evaluated.
• EXCLD_MEANING — the decoded Yes/No meaning of the exclusion flag, indicating whether the people group is excluded from the rate profile.
• VRBL_RT_PRFL_NAME — the descriptive name of the associated variable rate profile.
• PEOPLE_GROUP_NAME — the descriptive name of the associated people group.
• LAST_UPDATE_DATE / LAST_UPDATED_BY — the standard audit columns, with the latter returning the numeric user identifier.

Common Use Cases and Queries

The view is typically used to audit or report on how rate profiles are scoped by people group, and to reconcile configuration before a benefits open enrollment cycle. A representative query retrieves current, non-excluded assignments as of a given date:

• SELECT PPL_GRP_RT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PEOPLE_GROUP_NAME, VRBL_RT_PRFL_NAME, EXCLD_MEANING FROM APPS.BEN_PPL_GRP_RT_D WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND EXCLD_MEANING = 'No' ORDER BY PEOPLE_GROUP_NAME, ORDR_NUM;
• SELECT VRBL_RT_PRFL_NAME, ORDR_NUM, NVL(PEOPLE_GROUP_NAME,'<unassigned>') PEOPLE_GROUP, NVL(EXCLD_MEANING,'<unknown>') EXCLUDED FROM APPS.BEN_PPL_GRP_RT_D WHERE EFFECTIVE_START_DATE = :p_effective_date;

Because the joins are outer, the second query deliberately uses NVL to surface orphaned references where a people group or lookup value has since been removed. When embedding these queries in concurrent programs, always constrain by effective dates to avoid returning superseded row versions.