Search Results ben_elig_py_bss_prte_d




Overview
Explore in AI Chat

Overview

BEN_ELIG_PY_BSS_PRTE_D is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite, shipped as part of the Advanced Benefits (BEN) product family. Its name encodes its function: eligibility (BEN_ELIG), pay basis (PY_BSS), participation Prte (PRTE), and the _D suffix mandated by Oracle's multi-language support (MLS) conventions. The view exposes pay-basis eligibility rules that determine whether a participant is eligible for a benefits program based on the pay basis assigned to that person. In EBS 12.1.1 and 12.2.2, the view is documented as VALID and is retrofitted from earlier release logic, meaning its structure has been preserved for compatibility with existing reports, extracts, and interfaces even as underlying ELIGY_PRFL and pay-basis objects evolved.

Because it resolves surrogate identifiers into human-readable names for the pay basis, exclusion lookup, and eligibility profile, the view is frequently used in ad hoc reporting and in downstream extracts where administrators need to review configured eligibility rules without navigating the setup forms.

Underlying Base Objects

The view is defined as an outer-join aggregation over the following documented objects:

All joins are outer joins (note the (+) operators), so a row is still returned even when the related pay basis, profile, lookup, or user record is missing. The documented referenced base objects also include the HR_API package, consistent with the benefits eligibility engine's reliance on HR security and date-tracked API logic.

Key Columns

  • ROW_ID — the physical row identifier of the underlying BEN_ELIG_PY_BSS_PRTE_F row.
  • ELIG_PY_BSS_PRTE_ID — primary key of the pay-basis eligibility criterion.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity window of the rule.
  • PAY_BASIS_NAME — the resolved name from PER_PAY_BASES; this is the column most directly answering the search term pay_basis_name. The underlying select expression is PAY_BASIS.NAME.
  • EXCLD_MEANING — the Yes/No meaning from HR_LOOKUPS indicating whether the criterion is an inclusion or exclusion rule.
  • ORDR_NUM — evaluation order of the criterion within the profile.
  • ELIGY_PRFL_NAME — name of the parent eligibility profile to which the criterion belongs.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include auditing pay-basis eligibility rules by profile and validating which pay bases are excluded from a program.

SELECT eligy_prfl_name,
       pay_basis_name,
       excld_meaning,
       ordr_num,
       effective_start_date,
       effective_end_date
  FROM apps.ben_elig_py_bss_prte_d
 WHERE effective_start_date <= SYSDATE
   AND NVL(effective_end_date, SYSDATE) >= SYSDATE;

To locate a specific pay basis by name:

SELECT eligy_prfl_name, pay_basis_name, excld_meaning
  FROM apps.ben_elig_py_bss_prte_d
 WHERE pay_basis_name = :p_pay_basis_name;