Results for “ben_elig_pstn_prte_f”

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

Overview

BEN_ELIG_PSTN_PRTE_F is a date-tracked (effective-dated) table in the BEN schema of Oracle E-Business Suite Advanced Benefits. It stores eligibility profile participation criteria that are driven by position assignments — that is, the rule rows that determine whether a person occupying a given position qualifies for a particular eligibility profile. Within the ETRM 12.2.2 physical schema the table contains 47 documented columns and is owned by the BEN schema under the Advanced Benefits product.

From a Data Vault modeling perspective, the mined metadata classifies this object heuristically as standalone. That classification suggests there is no documented foreign-key dependency linking it to a parent hub or link table within the reported structure; practitioners should therefore treat the object as an independent, potentially satellite-like record set whose relationships are enforced at the application layer rather than through documented referential constraints. This heuristic should be regarded as a modeling suggestion only, because the ETRM FK extraction did not surface a formal parent relationship even though the column naming clearly implies logical dependencies.

Key Information Stored

The table's surrogate primary key is defined by BEN_ELIG_PSTN_PRTE_PK, composed of ELIG_PSTN_PRTE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The same three-column combination is also reported as the unique index and business-key candidate BEN_ELIG_PSTN_PRTE_PK, so the surrogate identifier is inseparable from the datetracked range in this design.

• ELIG_PSTN_PRTE_ID — the unique identifier for each position participation criterion record; the column referenced when the user searched for "elig_pstn_prte_id".
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the datetrack validity window; together with the ID they form the primary key and the business-key candidate.
• BUSINESS_GROUP_ID — the operating business group (enterprise) that owns the criteria row.
• ELIGY_PRFL_ID — the eligibility profile to which this position criterion belongs; the logical parent reference.
• EXCLD_FLAG — indicates whether the criterion includes or excludes the matched position (inclusion versus exclusion semantics).
• POSITION_ID — the position against which eligibility is evaluated.
• ORDR_NUM — the evaluation sequence controlling the order in which criteria are applied.
• CRITERIA_SCORE and CRITERIA_WEIGHT — scoring and weighting values used where eligibility criteria are ranked or scored.
• EPS_ATTRIBUTE_CATEGORY and EPS_ATTRIBUTE1 through EPS_ATTRIBUTE30 — the descriptive flexfield segment block that stores user-defined descriptive attributes.
• OBJECT_VERSION_NUMBER — optimistic locking column.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which positions grant access to a benefits offering, troubleshooting why an employee was deemed ineligible, and validating configuration after a patch or upgrade. Because the table is date-tracked, queries must always constrain the effective range to avoid returning historical or future-dated rows.

• Retrieve all current position criteria for a profile: SELECT ELIG_PSTN_PRTE_ID, POSITION_ID, EXCLD_FLAG, ORDR_NUM FROM BEN.BEN_ELIG_PSTN_PRTE_F WHERE ELIGY_PRFL_ID = :p_profile AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
• Look up a single criterion by surrogate key, which returns the datetracked record: ... WHERE ELIG_PSTN_PRTE_ID = :p_id;
• Audit recent changes: ... WHERE LAST_UPDATE_DATE >= :p_since ORDER BY LAST_UPDATE_DATE;

The _F suffix denotes the datetracked form of the entity; corresponding _V views and _A audit or _B backup tables are conventionally associated with such objects, and reporting against the _F table is standard for point-in-time extracts.

Related Objects

The following objects are significant in the eligibility configuration chain. Exact join columns are inferred from the column names documented above.

• BEN_ELIGY_PRFL — the eligibility profile header joined on ELIGY_PRFL_ID.
• HR_ALL_POSITIONS_F — position definition joined on POSITION_ID.
• HR_ALL_ORGANIZATION_UNITS — business group context joined on BUSINESS_GROUP_ID.
• BEN_ELIG_PSTN_PRTE_F — its own datetracked backup/audit counterparts (_B, _A) used for corrections.
• Eligibility profile APIs and the Benefits eligibility engine, which consume these criteria rows at runtime.

The absence of a documented foreign key reinforces the recommendation to validate joins through application logic and release-specific testing.