Search Results excld_flag_meaning




Overview
Explore in AI Chat

Overview

APPS.BEN_ELIG_ENRLD_ANTHR_OIPL_D is a denormalized, descriptive (translation/"_D") view within the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents eligibility profile rule configuration relating to "enrollment and other" eligibility determination, exposing the descriptive meaning attributes that would otherwise require joining multiple enabled-language lookup and base tables. The view carries an internal "Oracle Internal Use Only" designation, meaning Oracle does not formally support direct customer access; it is intended to be consumed by standard Oracle Applications programs and by extension reporting or integration layers that require a flattened, human-readable representation of benefit eligibility setup.

The "_D" suffix is conventional in Oracle EBS views of this family and signals that the view resolves foreign-key identifiers into display meanings (typically via HR_LOOKUPS) while retaining the internal primary key and effective-dating columns. The object status is VALID, and its FND Design Data registration is BEN.BEN_ELIG_ENRLD_ANTHR_OIPL_D.

Underlying Base Objects

The view is defined over several base objects registered as APPS synonyms. These include BEN_ELIG_ENRLD_ANTHR_OIPL_F, the primary "_F" (foundation) table holding the eligibility/enrollment/other-eligible row, and supporting descriptive tables BEN_ELIGY_PRFL_F (eligibility profile), BEN_OIPL_F (other-eligible profile), and BEN_OPT_F (option). Standard "Who" information is resolved against FND_USER. Two additional referenced objects, the HR_API package and the HR_LOOKUPS view, supply the mechanism used to translate stored lookup codes into their user-facing meanings. The view is not referenced by any other database object, confirming it sits at the outer edge of the dependency tree as a reporting surface.

Key Columns

  • ROW_ID — ROWID discriminator for unique row identity.
  • ELIG_ENRLD_ANTHR_OIPL_ID — Primary key linking back to the foundation table row.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective boundaries governing when the configuration is active.
  • ORDR_NUM — Sequencing/ordering value for the rule.
  • EXCLD_FLAG_MEANING — The descriptive meaning of the exclusion flag; this is the column associated with the user's search term "excld_flag_meaning". It resolves the encoded exclusion indicator into a readable value (for example, whether the qualifying item is included or excluded from the eligibility result).
  • ENRL_DET_DT_MEANING — Descriptive meaning for the enrollment determination/date rule.
  • OPT_NAME — Name of the associated benefit option.
  • ELIGY_PRFL_NAME — Name of the eligibility profile.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — Standard audit columns identifying the user and timestamp of the last change.

Common Use Cases and Queries

This view is typically used to report and audit eligibility profile configuration, particularly where the exclusion flag must be presented in business terminology rather than its underlying code. Integration routines and extract programs use the "_D" view to avoid redundant lookup joins.

  • Auditing which options and eligibility profiles carry an exclusion flag, including the readable flag meaning.
  • Building configuration comparison reports between environments by filtering on effective dates.
  • Feeding downstream interfaces that require descriptive eligibility rule content.
SELECT elig_enrld_anthr_oipl_id,
       eligy_prfl_name,
       opt_name,
       excld_flag_meaning,
       enrl_det_dt_meaning,
       effective_start_date,
       effective_end_date
FROM   apps.ben_elig_enrld_anthr_oipl_d
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date
ORDER  BY eligy_prfl_name, ordr_num;

Because the object is flagged Oracle Internal Use Only, any direct query should be treated as unsupported and subject to change across releases such as 12.1.1 and 12.2.2.