Results for “mndtry_flag_m”

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

Overview

The view BENBV_ELIG_CMBN_AGE_LOS_PRTE_V, owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, belongs to the Advanced Benefits (BEN) module. It presents the combined age and length-of-service criteria used within an eligibility profile, identifying which combinations are included in or excluded from that profile. An eligibility profile in Advanced Benefits determines which persons qualify for a given benefit program, plan, or option; the combined age and length-of-service factor is one of the configurable criteria that the profile may evaluate.

This is a business-facing, non-key view. It exposes the decoded descriptive and mandatory indicators alongside the raw flag values, which makes it suitable for reporting and integration scenarios where human-readable output is required. The view is defined with WITH READ ONLY, and it applies a security predicate against the current security profile business group. Specifically, records are filtered by ECP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ECP.BUSINESS_GROUP_ID), restricting the result set to the business group associated with the session's security profile. The view is documented as VALID in the ETRM repository.

Underlying Base Objects

The view is defined over a single documented base object: the table BEN_ELIG_CMBN_AGE_LOS_PRTE_F (referenced through a SYNONYM), aliased as ECP in the view text. This is the "F" (base/foundation) table that physically stores the combined age and length-of-service eligibility criteria records. The view does not introduce joins to other entity tables; it is a projection and decoding layer over that foundation table.

A second referenced object, the package HR_BIS, is used for two purposes. First, the function HR_BIS.BIS_DECODE_LOOKUP decodes the YES_NO lookup type to produce meaningful descriptions for the EXCLD_FLAG and MNDTRY_FLAG columns. Second, HR_BIS.GET_SEC_PROFILE_BG_ID supplies the security-profile business group identifier used in the WHERE clause. Because the view is read-only and built directly on the foundation table, it inherits the effective-dating structure of that table.

Key Columns

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective range for which the criterion row is valid.
• ORDR_NUM — Ordering number controlling the sequence in which criteria are evaluated or presented.
• EXCLD_FLAG — Indicates whether the criterion is used to exclude (Y) or include (N) eligible persons.
• EXCLD_FLAG_M — The decoded lookup meaning for EXCLD_FLAG (for example, Yes/No) returned by BIS_DECODE_LOOKUP('YES_NO', ...).
• MNDTRY_FLAG — Indicates whether the criterion is mandatory for the profile. The user search term "mndtry_flag_m" corresponds to the decoded meaning column derived from this flag.
• MNDTRY_FLAG_M — The decoded lookup meaning for MNDTRY_FLAG.
• ELIG_CMBN_AGE_LOS_PRTE_ID — Primary identifier for the combined age and length-of-service criterion row.
• BUSINESS_GROUP_ID — Owning business group; also the column used for security filtering.
• CMBN_AGE_LOS_FCTR_ID — Foreign key to the combined age and length-of-service factor definition.
• ELIGY_PRFL_ID — Foreign key to the eligibility profile to which this criterion belongs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard WHO audit columns.

The view text also emits a descriptive flexfield token, '_DF:BEN:BEN_ELIG_CMBN_AGE_LOS_PRTE_F:ECP', which resolves to the DFF segment columns and surfaces as the column labeled "_DF:ECP" in the column list.

Common Use Cases and Queries

Typical use cases include reporting on which eligibility profiles contain combined age and length-of-service criteria, verifying whether such criteria are mandatory or exclusionary, and validating configuration during implementation or audit. The decoded *_M columns allow reports to display Yes/No values without additional lookup joins.

To list all criteria for a specific eligibility profile:

• SELECT eligy_prfl_id, ordr_num, exCLD_FLAG_M, mndtry_flag_M, cmbn_age_los_fctr_id FROM apps.benbv_elig_cmbn_age_los_prte_v WHERE eligy_prfl_id = :p_profile_id ORDER BY ordr_num;

To identify mandatory criteria across all visible profiles:

• SELECT eligy_prfl_id, elig_cmbn_age_los_prte_id, mndtry_flag, mndtry_flag_m FROM apps.benbv_elig_cmbn_age_los_prte_v WHERE mndtry_flag = 'Y';

Because the view filters on the active security profile business group, queries automatically return only records within the caller's authorized business group. Any reporting built upon this view should therefore be run in a session whose security profile is correctly assigned. For point-in-time or effective-dated analysis, additional filtering on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE is required.