Results for “epn_attribute_category”

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

Overview

BEN_ELIG_PRBTN_PERD_PRTE is an APPS-owned view within the Oracle Advanced Benefits (BEN) module. It exposes configuration data that defines the probation period rule used by eligibility profiles. In Oracle EBS, eligibility profiles determine whether a person qualifies for a program, plan, or plan option. The probation period rule allows an eligibility profile to require that an employee complete a defined waiting interval — a probation period — before becoming eligible. This view is a key reference for anyone searching on probation_unit, as that column specifies the unit of measure (for example, days, months, or years) applied to the probation period.

The view is a runtime, effective-dated presentation of the underlying table. Its WHERE clause filters records against the current session effective date, so queries against the view return only the row versions valid at the session date. This makes it suitable for reporting, data extraction, and integrations that must reflect the configured rule as of a given point in time, without requiring the caller to manually apply date-track logic.

Underlying Base Objects

The view is defined over two referenced base objects, both accessed through synonyms in the APPS schema:

• BEN_ELIG_PRBTN_PERD_PRTE_F — the effective-dated (date-tracked) base table that stores the probation period rule definitions. The view selects all columns from this table, aliased as EPN.
• FND_SESSIONS — the Oracle Application Object Library session table. The view joins to it to obtain the effective date for the current user session (matched by SESSION_ID = USERENV('SESSIONID')).

The effective-dating predicate is: EFFECTIVE_START_DATE <= session effective date AND EFFECTIVE_END_DATE >= session effective date. Only rows whose date range brackets the session date are returned. The view contains no joins beyond this session lookup and no aggregation, so it is a straightforward filtered projection of the _F table.

Key Columns

• ELIG_PRBTN_PERD_PRTE_ID — primary identifier for the probation period rule record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-track range governing when the record version is active.
• BUSINESS_GROUP_ID — the business group (enterprise) that owns the configuration.
• ELIGY_PRFL_ID — foreign key to the eligibility profile to which this probation rule is attached.
• EXCLD_FLAG — indicates whether the rule is an inclusion or exclusion criterion within the profile.
• PROBATION_PERIOD — the numeric length of the probation interval.
• PROBATION_UNIT — the unit of measure applied to PROBATION_PERIOD (for example day, month, or year), completing the interval definition.
• EPN_ATTRIBUTE_CATEGORY and EPN_ATTRIBUTE1–30 — descriptive flexfield (DFF) columns for customer-defined attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard WHO audit and concurrency columns.

Common Use Cases and Queries

Typical scenarios include auditing probation rules by profile, reporting which eligibility profiles impose a probation condition, and integrating eligibility configuration into downstream systems. A basic query retrieving all active probation period rules is:

• SELECT ELIG_PRBTN_PERD_PRTE_ID, ELIGY_PRFL_ID, PROBATION_PERIOD, PROBATION_UNIT, EXCLD_FLAG FROM APPS.BEN_ELIG_PRBTN_PERD_PRTE;

To report the configured interval for a specific eligibility profile:

• SELECT ELIGY_PRFL_ID, PROBATION_PERIOD, PROBATION_UNIT FROM APPS.BEN_ELIG_PRBTN_PERD_PRTE WHERE ELIGY_PRFL_ID = :p_eligy_prfl_id;

Because the view already enforces session-date effective filtering, callers need not add date predicates. For historical analysis, query the base table BEN_ELIG_PRBTN_PERD_PRTE_F directly with explicit date ranges. When joining to eligibility profile definitions, use ELIGY_PRFL_ID as the linking key.