Results for “compute_score_flag”

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

Overview

The view APPS.BEN_PRTN_ELIG_PRFL_D is a reporting and integration object within the Oracle Advanced Benefits (BEN) module. It exposes the participation eligibility profile definition records maintained for benefits offerings, presenting a denormalized and user-readable projection of the underlying BEN_PRTN_ELIG_PRFL_F table. Rather than requiring report authors and integration developers to join multiple lookup and user tables manually, the view resolves code values into their corresponding descriptive meanings at query time.

The _D suffix convention in Oracle EBS indicates a descriptive or "denormalized" view, typically used to populate read-only form blocks, concurrent program outputs, and ad hoc reporting queries. The object carries a status of VALID in the APPS schema and is cataloged as "Retrofitted," meaning its definition was migrated or re-documented as part of a release upgrade rather than originally authored in its present form.

Underlying Base Objects

The documented base objects for this view are BEN_PRTN_ELIGY_PRFL_F (the primary driving table, aliased CEP), BEN_ELIGY_PRFL_F (aliased ELP), FND_USER, HR_LOOKUPS, and the HR_API package. All table references are resolved through APPS synonyms.

• BEN_PRTN_ELIG_PRFL_F — the participation eligibility profile entity, supplying the profile identifier, effective dates, mandatory flag, compute score flag, profile type code, and audit columns.
• BEN_ELIGY_PRFL_F — the parent eligibility profile, joined on ELIGY_PRFL_ID and constrained by an effective-date range comparison between the two date-tracked entities, yielding the profile name.
• HR_LOOKUPS — joined three times (aliased HL1, HL2, HL3) against lookup types YES_NO and BEN_ELIG_PRFL_TYPE to translate coded values into meanings.
• FND_USER — resolves the LAST_UPDATED_BY user identifier into a user name.
• HR_API — referenced for date-tracked entity handling.

All joins to the lookup, user, and eligibility profile tables are outer joins (denoted by the (+) operator), ensuring that a row from the driving table is returned even when no matching lookup meaning or parent profile exists.

Key Columns

• PRTN_ELIG_PRFL_ID — primary identifier of the participation eligibility profile record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity window of the record.
• PROFILE_NAME — descriptive name of the associated eligibility profile, sourced from BEN_ELIGY_PRFL_F.NAME.
• PROFILE_TYPE — decoded meaning of ELIG_PRFL_TYPE_CD via lookup type BEN_ELIG_PRFL_TYPE.
• MNDTRY_FLAG — decoded meaning of the mandatory flag (lookup type YES_NO), indicating whether the profile must be satisfied. This is the column most commonly targeted by the search term "mndtry_flag."
• COMPUTE_SCORE_FLAG — decoded meaning indicating whether a score is computed for the profile.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit trail columns, with the user identifier expanded to USER_NAME.

Common Use Cases and Queries

Typical usage includes auditing mandatory eligibility configurations, validating profile setup during implementations, and feeding downstream reports that require human-readable lookup values.

To list mandatory participation eligibility profiles:

• SELECT prtn_elig_prfl_id, profile_name, profile_type, mndtry_flag, compute_score_flag FROM apps.ben_prtn_elig_prfl_d WHERE mndtry_flag = 'Yes';

To review profiles modified by a specific user:

• SELECT profile_name, mndtry_flag, last_update_date, last_updated_by FROM apps.ben_prtn_elig_prfl_d WHERE last_updated_by = 'SYSADMIN' ORDER BY last_update_date DESC;

Because lookup joins are outer, rows with unmapped codes return NULL meanings; queries intended to enforce a mandatory condition should account for that possibility or filter explicitly.