Results for “ben_elig_prbtn_perd_prte_v”

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

Overview

BEN_ELIG_PRBTN_PERD_PRTE_V is a reporting and integration view owned by the APPS schema within the Oracle Advanced Benefits (BEN) product. It exposes eligibility profile probation-period participation records, providing a date-effective, session-filtered window onto the underlying eligibility criteria definitions used by Benefits administrators. In Oracle EBS 12.1.1 and 12.2.2, the view is registered as VALID and is typically consumed by concurrent programs, custom reports, and integration interfaces that must resolve which probation-period rules participate in a given eligibility profile.

The view performs two significant functions. First, it joins the base table to FND_SESSIONS so that the currently effective rows are returned for the active user session, applying the condition that the session effective date falls between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Second, it exposes all thirty descriptive flexfield attribute columns (EPN_ATTRIBUTE_CATEGORY and EPN_ATTRIBUTE1 through EPN_ATTRIBUTE30), which is the reason it is frequently located by searches such as "epn_attribute1." The presence of these columns allows DFF-enabled attributes captured against the probation period rule to be reported alongside the standard eligibility data.

Underlying Base Objects

The documented base objects for this view are:

• BEN_ELIG_PRBTN_PERD_PRTE_F (referenced as a synonym) — the eligibility probation period participation rule table. This is the primary source of all business columns, including the surrogate key ELIG_PRBTN_PERD_PRTE_ID, the date-effective range, the eligibility profile reference, and the DFF attribute segments.
• FND_SESSIONS (referenced as a synonym) — the Oracle Application Object Library session table, used to derive the effective date for the current session through USERENV('SESSIONID').

The view text aliases the base table as EPN and selects EPN.ROWID as the ROW_ID column, ensuring each returned row remains uniquely addressable. This date-effective pattern is standard across BEN eligibility views, which return only the row whose effective range contains the session's effective date, thereby avoiding duplicate historical versions in downstream processing.

Key Columns

• ROW_ID — the ROWID of the underlying row in BEN_ELIG_PRBTN_PERD_PRTE_F; useful for direct row identification.
• ELIG_PRBTN_PERD_PRTE_ID — the primary key of the participation rule record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective bounds that determine visibility for the session.
• BUSINESS_GROUP_ID — the business group that owns the rule, essential for multi-organization filtering.
• ELIGY_PRFL_ID — the eligibility profile to which the probation-period rule is attached; the principal join path to BEN_ELIGY_PRFL.
• EXCLD_FLAG — indicates whether the rule is an inclusion or exclusion criterion.
• PROBATION_PERIOD / PROBATION_UNIT — the qualifying length of service and its unit of measure (for example, days or months).
• ORDR_NUM — the evaluation sequence of the rule within the profile.
• CRITERIA_SCORE / CRITERIA_WEIGHT — the scoring values used when the eligibility profile is evaluated in scored mode.
• EPN_ATTRIBUTE_CATEGORY and EPN_ATTRIBUTE1–EPN_ATTRIBUTE30 — descriptive flexfield context and segment values captured against the rule, including EPN_ATTRIBUTE1, the column most often targeted by ad hoc queries.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.

Common Use Cases and Queries

Typical scenarios include auditing probation-period eligibility rules for an active profile, extracting DFF attribute values for interfaces or data conversions, and validating effective-dated rule sets ahead of an open enrollment cycle. Because the filter depends on USERENV('SESSIONID'), the view returns the effective-dated row appropriate to the calling session's context.

To list currently effective probation-period rules for a profile:

• SELECT elig_prbtn_perd_prte_id, eligy_prfl_id, probation_period, probation_unit, ordr_num FROM ben_elig_prbtn_perd_prte_v WHERE eligy_prfl_id = :p_profile_id;

To retrieve the DFF attribute requested by the "epn_attribute1" search:

• SELECT elig_prbtn_perd_prte_id, epn_attribute_category, epn_attribute1, epn_attribute2 FROM ben_elig_prbtn_perd_prte_v WHERE epn_attribute_category IS NOT NULL;

To inspect inclusion versus exclusion rules with their scoring:

• SELECT elig_prbtn_perd_prte_id, excld_flag, criteria_score, criteria_weight, probation_period FROM ben_elig_prbtn_perd_prte_v ORDER BY ordr_num;

All queries should join to BEN_ELIGY_PRFL when profile names are required, and filter on BUSINESS_GROUP_ID in multi-organization deployments to avoid cross-group rule leakage.