Results for “eei_attribute1”

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

Overview

BEN.BEN_ELIG_ENRLD_ANTHR_OIPL_F is a table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Participant eligible/ineligible if covered by another option in plan." In functional terms, this table captures the rules that determine whether a participant qualifies for (or is disqualified from) an eligibility profile when the participant is already covered under another option in a plan (OIPL). It is one of the standard eligibility/eligibility-and-enrollment filter tables that participate in the Benefits eligibility engine, used at runtime when the participant is evaluated against a plan or option configuration.

Regarding the heuristic Data Vault classification mined from the foreign-key structure, the metadata classifies this object as standalone. In Data Vault modeling terms this suggests it functions as neither a classic hub, link, nor satellite, but rather as a rule or configuration table without a mined parent-child dependency in the documented FK structure. This should be treated as a modeling suggestion, not a normative statement.

Key Information Stored

The table contains 46 documented columns. The most significant are listed below; the surrogate primary key is distinguished from the business-key candidate columns documented as a unique index.

• ELIG_ENRLD_ANTHR_OIPL_ID — surrogate primary key; unique identifier for each rule row.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective range columns; part of both the primary key and the documented unique index, enabling date-tracked versions of each rule.
• OIPL_ID — the "other option in plan" reference; identifies the plan option whose coverage triggers the rule.
• ELIGY_PROFILE_ID — the eligibility profile to which the rule is attached.
• EXCLD_FLAG — flag indicating whether the participant should be excluded (ineligible) when covered by the referenced option.
• BUSINESS_GROUP_ID — the business group (HR operating unit) owning the rule.
• ENRL_DET_DT_CD — enrollment determination date code, controlling the date on which eligibility is evaluated.
• ORDR_NUM — ordinal sequence number used when multiple rules must be evaluated in order.
• OBJECT_VERSION_NUMBER — optimistic-locking version for concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO/audit columns.
• EEI_ATTRIBUTE_CATEGORY and EEI_ATTRIBUTE1..30 — descriptive flexfield (DFF) segments for customer-specific rule attributes.

The documented unique index BEN_ELIG_ENRLD_ANTHR_OIPL_PK covers (ELIG_ENRLD_ANTHR_OIPL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) and serves as the business-key candidate. The primary key constraint of the same name enforces uniqueness over that same key set.

Common Use Cases and Queries

Typical usage is in Benefits eligibility diagnostics, rule auditing, and migration/reporting. A common query resolves the current rule set for a plan option:

SELECT r.ELIG_ENRLD_ANTHR_OIPL_ID, r.OIPL_ID, r.ELIGY_PROFILE_ID, r.EXCLD_FLAG, r.ENRL_DET_DT_CD, r.ORDR_NUM
FROM BEN.BEN_ELIG_ENRLD_ANTHR_OIPL_F r
WHERE r.BUSINESS_GROUP_ID = :p_bg_id
  AND TRUNC(SYSDATE) BETWEEN r.EFFECTIVE_START_DATE AND r.EFFECTIVE_END_DATE
  AND r.OIPL_ID = :p_oipl_id;

Other scenarios include auditing which eligibility profiles carry an "other option in plan" exclusion (filter on EXCLD_FLAG), reporting effective-dated rule changes over time, and validating configuration during upgrades from 12.1.1 to 12.2.2. Flexfield-based reporting against EEI_ATTRIBUTE columns supports client-specific extensions.

Related Objects

Based on the documented relationship data (standalone classification) and functional context, the most significant related objects include:

• BEN_ELIG_ENRLD_ANTHR_OIPL — if present as the non-indexed base table, joined on ELIG_ENRLD_ANTHR_OIPL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE.
• BEN_ELIGY_PRFL_F — eligibility profile definition; joined via ELIGY_PROFILE_ID.
• BEN_OIPL_F — option-in-plan definition; joined via OIPL_ID.
• BEN_PGM_F / BEN_PL_F — program and plan definitions referenced through the option hierarchy.
• BEN_BUSINESS_GROUP_ID related HR objects / PER_BUSINESS_GROUPS — joined on BUSINESS_GROUP_ID.
• BEN_ELIG_ENRLD_ANTHR_* sibling eligibility rule tables (for example, other "another enrollment" variants) that share the same rule-engine pattern.
• BEN_ELIG_ENRLD_ANTHR_OIPL_PK — the primary key constraint/index enforcing the documented unique key.

These references reflect the documented primary key and functional linkage; deeper FK constraints are not enumerated in the provided metadata and should be confirmed against the actual 12.2.2 schema before use in production queries.