Search Results mndtry_flag_meaning

Overview

APPS.BEN_VRBL_RT_ELIG_PRFL_D is a descriptive (non-hooked) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the association between variable rate profiles and eligibility profiles within the Oracle Advanced Benefits (BEN) module. The suffix "D" designates a descriptive view, meaning it is intended for read-only reporting and inquiry rather than for transactional data entry; the ETRM documentation explicitly flags the object as Oracle Internal Use Only and notes that Oracle Corporation does not support direct access to this object except from standard Oracle Applications programs.

The view serves as the primary reporting and integration surface for answering the question "which eligibility profile is attached to a given variable rate profile, and is that attachment mandatory?" Because it is denormalized to carry the textual names of both profiles, it eliminates the need for downstream queries to join repeatedly against the base tables simply to render human-readable output. This is the object most commonly reached when a user searches on the term eligy_prfl_name, since that column is one of the view's identifying descriptive attributes.

Underlying Base Objects

The view is defined over three BEN synonyms and two supporting objects, consistent with the documented dependency list:

• BEN_VRBL_RT_ELIG_PRFL_F — the _F (date-tracked) base table holding the intersection of variable rate profiles and eligibility profiles, together with effective dates and the mandatory flag.
• BEN_VRBL_RT_PRFL_F — the variable rate profile definition table, joined to supply VRBL_RT_PRFL_NAME.
• BEN_ELIGY_PRFL_F — the eligibility profile definition table, joined to supply ELIGY_PRFL_NAME (the "eligy_prfl_name" the user searched for).
• HR_LOOKUPS — the lookup view resolving the MNDTRY_FLAG quickcode value into its displayed meaning.
• FND_USER — used to resolve LAST_UPDATED_BY to a user identity.
• HR_API — the HR API package supplying helper logic such as effective-date resolution.

The view is not referenced by any other database object in the documented dependency tree, confirming it is a leaf-level reporting object.

Key Columns

• VRBL_RT_ELIG_PRFL_ID (NUMBER 15) — Primary identifier of the variable rate / eligibility profile association row.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE (DATE) — Date-tracked validity window for the association.
• VRBL_RT_PRFL_NAME (VARCHAR2 240) — Name of the variable rate profile.
• ELIGY_PRFL_NAME (VARCHAR2 240) — Name of the eligibility profile; the column matching the user's search term.
• MNDTRY_FLAG_MEANING (VARCHAR2 80) — Quickcode meaning indicating whether the eligibility profile is mandatory for the variable rate profile.
• LAST_UPDATE_DATE (DATE) — Audit timestamp of the most recent modification.
• LAST_UPDATED_BY (VARCHAR2 100) — User who last modified the record, resolved via FND_USER.

Common Use Cases and Queries

Typical scenarios include auditing which eligibility profiles constrain a variable rate plan, validating mandatory eligibility configuration before a payroll or benefits run, and reconciling benefits setup during upgrades from 12.1.1 to 12.2.2. A simple lookup by eligibility profile name follows:

SELECT vrbl_rt_prfl_name, eligy_prfl_name, mndtry_flag_meaning, effective_start_date, effective_end_date FROM apps.ben_vrbl_rt_elig_prfl_d WHERE eligy_prfl_name = :p_eligy_prfl_name AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

To list all eligibility profiles attached to a specific variable rate profile, query on VRBL_RT_PRFL_NAME instead. For auditing recent configuration changes, filter on LAST_UPDATE_DATE and join LAST_UPDATED_BY to FND_USER via the standard user-name lookup, restricting MNDTRY_FLAG_MEANING where the mandatory designation is material to the analysis.