Results for “ben_elig_fl_tm_pt_tm_prte_x”

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

Overview

The view APPS.BEN_ELIG_FL_TM_PT_TM_PRTE_X is a public, translation-style (non-"_F" or "_B") view belonging to the Oracle Advanced Benefits (BEN) module. In Oracle EBS 12.1.1 and 12.2.2 the BEN schema follows a standard concurrent-managed design in which the "_F" object is the physical base table that stores date-effective rows, and the "_X" sibling exposes those same rows filtered to the currently effective one. The "_X" suffix denotes "extract," "transaction," or "current-in-force" usage rather than a base table.

Specifically, this view presents rows from the eligibility profile, fast formula, plan type, and time period participation restriction entity. It is intended for reporting, integration, and downstream SQL that only needs rows valid as of the current system date. The Chinese-language description field ("Retrofitted") and status of VALID indicate this is a supported, working object that has been retrofitted into the standard directory of BEN objects.

Underlying Base Objects

The view is defined over a single documented source object: BEN_ELIG_FL_TM_PT_TM_PRTE_F, which is exposed as a SYNONYM in the ETRM metadata. The "_F" table holds all date-effective (datetrack) rows for participation restrictions between eligibility profiles and time periods. The defining query is:

SELECT EFP.* FROM BEN_ELIG_FL_TM_PT_TM_PRTE_F EFP
WHERE TRUNC(SYSDATE) BETWEEN EFP.EFFECTIVE_START_DATE AND EFP.EFFECTIVE_END_DATE

Because the "_X" view applies TRUNC(SYSDATE) filtering, it returns only the single effective row per business key as of today. Historical and future-dated rows are excluded. There is no join; the view is a direct, date-filtered projection of the base table with an alias EFP, which is why it is referred to as a "retrofitted" simple view rather than a composite one.

Key Columns

• ELIG_FL_TM_PT_TM_PRTE_ID – Primary key, system-generated identifier for the participation restriction row.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE – Datetrack bounds used by the view's WHERE clause.
• BUSINESS_GROUP_ID – Owning business group; drives multi-tenant (HR) security filtering.
• ELIGY_PRFL_ID – Foreign key to the eligibility profile to which the restriction applies.
• ORDR_NUM – Display/processing order for the restriction.
• FL_TM_PT_TM_CD – Code identifying the time period type (e.g., any time, within period).
• EXCLD_FLAG – Indicates whether the row is an inclusion (N) or exclusion (Y) rule.
• EFP_ATTRIBUTE_CATEGORY and EFP_ATTRIBUTE1–30 – Descriptive flexfield (DFF) columns. EFP_ATTRIBUTE30 is the thirtieth attribute segment and is the field commonly targeted in the user's search.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE – Standard WHO audit columns.
• OBJECT_VERSION_NUMBER – Optimistic locking column used by the OAF/BC4J framework.

Common Use Cases and Queries

Typical uses include auditing eligibility restrictions, extracting participation rules for external benefit engines, and diagnosing why an employee was excluded from a plan. Because the DFF attributes (including EFP_ATTRIBUTE30) are exposed, customers often surface custom restrictions here.

Example query for the current effective restrictions:

SELECT p.elig_fl_tm_pt_tm_prte_id,
       p.eligy_prfl_id,
       p.fl_tm_pt_tm_cd,
       p.excld_flag,
       p.efp_attribute_category,
       p.efp_attribute30
FROM   apps.ben_elig_fl_tm_pt_tm_prte_x p
WHERE  p.business_group_id = :p_bg_id
ORDER  BY p.eligy_prfl_id, p.ordr_num;

An integration query checking for a specific DFF value would add:

WHERE  p.efp_attribute30 = :p_value

For historical comparison, query the base table BEN_ELIG_FL_TM_PT_TM_PRTE_F directly and supply an effective date instead of relying on SYSDATE. This distinction is essential when building point-in-time extracts or reconciliation reports, since the "_X" view never returns more than the current-in-force row per key.