Results for “epa_attribute1”

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

Overview

The BEN_PRTN_ELIG view is an APPS-owned, valid database object in the Oracle E-Business Suite Advanced Benefits (BEN) module. It is classified in the ETRM repository as a retrofitted view, a designation applied to objects that were re-engineered during the 12.1.1 and 12.2.2 release cycles, typically to rationalize the interface between the run-time benefits engine and its base tables. The view exposes participant eligibility rule definitions maintained within the benefits plan configuration model.

Functionally, BEN_PRTN_ELIG operates as a date-tracked, session-aware presentation layer over its underlying table. Rather than surfacing every row of the base table, it constrains results to the record versions whose effective date range brackets the effective date of the current application session, as recorded in FND_SESSIONS. This guarantees that any query or concurrent program reading from the view resolves the configuration that was in force on the business date applicable to the session, not merely the latest or earliest definition. Because of this behavior, the view is a preferred access path for reporting, extracts, and integration logic that must respect eligibility rule versioning.

Underlying Base Objects

The view is defined over two documented referenced objects, both presented as synonyms in the APPS schema:

• BEN_PRTN_ELIG_F — the base table holding participant eligibility rule definitions, aliased as EPA in the view text. All columns exposed by the view originate from this table; no joins to descriptive or lookup tables are performed.
• FND_SESSIONS — the Oracle Application Object Library session table, aliased as SS. It is referenced twice in the WHERE clause, once for the lower bound and once for the upper bound of the effective date filter.

Because the view performs a straight projection of BEN_PRTN_ELIG_F columns with an effective-date predicate, it inherits the full attribute column set of the base table, including the descriptive flexfield segments EPA_ATTRIBUTE_CATEGORY through EPA_ATTRIBUTE30, the rule relationship columns (PRTN_EFF_STRT_DT_RL, PRTN_EFF_END_DT_RL), and the maximum period-of-enrollment columns (MX_POE_UOM, MX_POE_VAL, MX_POE_RL). The view is read-only in practice; inserts and updates must be directed at the base table through the standard benefits configuration forms or the supported APIs.

Key Columns

• PRTN_ELIG_ID — primary surrogate key identifying a single eligibility rule definition record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity range of the rule record; these columns drive the session filter applied by the view.
• BUSINESS_GROUP_ID — the business group owning the configuration row.
• PGM_ID, PL_ID, OIPL_ID — foreign keys to the program, plan, and option-in-plan-level entities to which the eligibility rule is attached.
• PRTN_EFF_STRT_DT_CD / PRTN_EFF_STRT_DT_RL — the code and rule defining the effective start date on which a participant becomes eligible.
• PRTN_EFF_END_DT_CD / PRTN_EFF_END_DT_RL — the corresponding code and rule for the end of eligibility.
• WAIT_PERD_VAL, WAIT_PERD_UOM, WAIT_PERD_RL, WAIT_PERD_DT_TO_USE_CD, WAIT_PERD_DT_TO_USE_RL — the waiting period value, unit of measure, associated rule, and the date basis against which the waiting period is calculated.
• TRK_SCR_FOR_INELG_FLAG — indicates whether the system tracks screening records for ineligible participants.
• EPA_ATTRIBUTE_CATEGORY and EPA_ATTRIBUTE1 through EPA_ATTRIBUTE30 — descriptive flexfield context and segment columns. A search for epa_attribute1 resolves to the first segment of this flexfield, frequently used to store client-specific eligibility classification or external system identifiers.
• MX_POE_UOM, MX_POE_VAL, MX_POE_RL, MX_POE_APLS_CD, MX_POE_DET_DT_CD, MX_POE_DET_DT_RL — maximum period of enrollment configuration, including unit of measure, applied value, applicable code, and determining date.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard audit and optimistic locking columns.

Common Use Cases and Queries

A typical reporting requirement is to list all eligibility rules attached to a plan for the session date, optionally filtered on a flexfield segment. Because the view already enforces session-effective filtering, the query requires no explicit date predicate:

• SELECT prtn_elig_id, pgm_id, pl_id, oipl_id, prtn_eff_strt_dt_cd, wait_perd_val, epa_attribute1 FROM apps.ben_prtn_elig WHERE pl_id = :p_plan_id;

Integration extracts commonly key off the flexfield segment when eligibility rules are synchronized with an external eligibility engine:

• SELECT prtn_elig_id, epa_attribute_category, epa_attribute1 FROM apps.ben_prtn_elig WHERE epa_attribute1 = :p_external_key;

A third pattern validates configuration completeness by grouping rules per plan and business group:

• SELECT business_group_id, pl_id, COUNT(*) FROM apps.ben_prtn_elig GROUP BY business_group_id, pl_id;

Queries that must return historical rather than session-effective rows should read BEN_PRTN_ELIG_F directly, or supply DATETRACK parameters, since BEN_PRTN_ELIG intentionally restricts output to the current session's effective date.