Search Results excld_meaning




Overview
Explore in AI Chat

Overview

APPS.BEN_ELIG_PY_BSS_PRTE_D is a descriptive (denormalized) view within the Oracle EBS Benefits (BEN) product family. It exposes eligibility criteria records associated with the Pay Basis restriction rule type, presenting the underlying configuration in a form that is convenient for reporting. The "_D" suffix is the Oracle EBS convention for a descriptive or translated view that surfaces user-facing derived columns rather than raw identifiers, and the "_PY_BSS_PRTE" component identifies the eligibility criteria as a Pay Basis restriction criterion. The view is defined in the APPS schema with FND Design Data identifier BEN.BEN_ELIG_PY_BSS_PRTE_D and is documented with a status of VALID in the ETRM repository for both 12.1.1 and 12.2.2.

The object carries the standard Oracle warning that it is for internal use only and that access should occur from standard Oracle Applications programs. Consequently, it is best treated as a read-only reporting or integration surface rather than a supported extension point for custom data manipulation.

Underlying Base Objects

The view resolves against a set of base tables, synonyms, and PL/SQL objects owned by the APPS schema:

  • BEN_ELIG_PY_BSS_PRTE_F — the eligibility Pay Basis restriction entity table holding the core criterion rows.
  • BEN_ELIGY_PRFL_F — the eligibility profile table providing the profile name associated with each criterion.
  • PER_PAY_BASES — the pay basis lookup table supplying the pay basis name.
  • HR_LOOKUPS — the lookup view used to derive the exclusion meaning and other code-to-meaning values.
  • FND_USER — the standard Who column source for LAST_UPDATED_BY.
  • FND_GLOBAL and the HR_API package support the session and date-effective resolution logic.

Because the view is defined over date-effective (_F) entities, the records exposed are typically the currently effective editions of the eligibility criteria, with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE reflecting the effective date range of each row.

Key Columns

  • ROW_ID — the ROWID of the underlying criterion row.
  • ELIG_PY_BSS_PRTE_ID — the unique identifier for the Pay Basis restriction criterion.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective range that governs when the criterion is applicable.
  • PAY_BASIS_NAME — the descriptive name of the pay basis associated with the criterion.
  • EXCLD_MEANING — the translated meaning of the exclusion flag, indicating whether the pay basis specified is included or excluded from the eligibility determination. Users searching on "excld_meaning" will find this the operative column.
  • ORDR_NUM — the ordering sequence for the criterion within the eligibility profile.
  • ELIGY_PRFL_NAME — the name of the parent eligibility profile.
  • CRITERIA_WEIGHT / CRITERIA_SCORE — weighting and scoring values used when the profile evaluates criteria.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — standard audit columns captured from the source row.

Common Use Cases and Queries

The view is most commonly used for auditing and reporting on how eligibility profiles treat pay bases, and for diagnosing why a particular assignment or employee qualifies or fails a benefits eligibility rule. A typical query lists the criteria for a given profile:

SELECT eligy_prfl_name, pay_basis_name, excld_meaning, ordr_num
FROM apps.ben_elig_py_bss_prte_d
WHERE eligy_prfl_name = :p_profile_name
AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

To isolate exclusion rules, filter directly on the column the user searched for:

SELECT elig_py_bss_prte_id, pay_basis_name, excld_meaning
FROM apps.ben_elig_py_bss_prte_d
WHERE excld_meaning = 'Exclude';

Integrations typically select ROW_ID, ELIG_PY_BSS_PRTE_ID, PAY_BASIS_NAME, and EXCLD_MEANING to reconcile Benefits configuration against downstream payroll or HR systems. Because the view is designated for internal use, any custom usage should be limited to read-only extraction.

  • VIEW: APPS.BEN_ELIG_PY_BSS_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_PY_BSS_PRTE_D,  object_name:BEN_ELIG_PY_BSS_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_CMBN_AGE_LOS_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_CMBN_AGE_LOS_RT_D,  object_name:BEN_CMBN_AGE_LOS_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_DPNT_CVRD_OTHR_PGM_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_DPNT_CVRD_OTHR_PGM_RT_D,  object_name:BEN_DPNT_CVRD_OTHR_PGM_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_PPL_GRP_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_PPL_GRP_RT_D,  object_name:BEN_PPL_GRP_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_TBCO_USE_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_TBCO_USE_RT_D,  object_name:BEN_TBCO_USE_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_HRS_WKD_IN_PERD_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_HRS_WKD_IN_PERD_RT_D,  object_name:BEN_HRS_WKD_IN_PERD_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_FL_TM_PT_TM_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_FL_TM_PT_TM_PRTE_D,  object_name:BEN_ELIG_FL_TM_PT_TM_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_PRTT_ANTHR_PL_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_PRTT_ANTHR_PL_PRTE_D,  object_name:BEN_ELIG_PRTT_ANTHR_PL_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_PRTT_ANTHR_PL_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_PRTT_ANTHR_PL_RT_D,  object_name:BEN_PRTT_ANTHR_PL_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_LOS_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_LOS_RT_D,  object_name:BEN_LOS_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_LVG_RSN_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_LVG_RSN_PRTE_D,  object_name:BEN_ELIG_LVG_RSN_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_COMP_LVL_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_COMP_LVL_PRTE_D,  object_name:BEN_ELIG_COMP_LVL_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_AGE_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_AGE_RT_D,  object_name:BEN_AGE_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PGM_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_ENRLD_ANTHR_PGM_D,  object_name:BEN_ELIG_ENRLD_ANTHR_PGM_D,  status:VALID, 

  • VIEW: APPS.BEN_ENRLD_ANTHR_PLIP_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ENRLD_ANTHR_PLIP_RT_D,  object_name:BEN_ENRLD_ANTHR_PLIP_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_BRGNG_UNIT_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_BRGNG_UNIT_PRTE_D,  object_name:BEN_ELIG_BRGNG_UNIT_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_LOS_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_LOS_PRTE_D,  object_name:BEN_ELIG_LOS_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_HRS_WKD_IN_PERD_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_HRS_WKD_IN_PERD_RT_D,  object_name:BEN_HRS_WKD_IN_PERD_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_LOA_RSN_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_LOA_RSN_PRTE_D,  object_name:BEN_ELIG_LOA_RSN_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_AGE_CVG_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_AGE_CVG_D,  object_name:BEN_ELIG_AGE_CVG_D,  status:VALID, 

  • VIEW: APPS.BEN_COMP_LVL_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_COMP_LVL_RT_D,  object_name:BEN_COMP_LVL_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_PCT_FL_TM_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_PCT_FL_TM_RT_D,  object_name:BEN_PCT_FL_TM_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_LBR_MMBR_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_LBR_MMBR_PRTE_D,  object_name:BEN_ELIG_LBR_MMBR_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_AGE_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_AGE_PRTE_D,  object_name:BEN_ELIG_AGE_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PLIP_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_ENRLD_ANTHR_PLIP_D,  object_name:BEN_ELIG_ENRLD_ANTHR_PLIP_D,  status:VALID, 

  • VIEW: APPS.BEN_GRADE_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_GRADE_RT_D,  object_name:BEN_GRADE_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_SVC_AREA_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_SVC_AREA_PRTE_D,  object_name:BEN_ELIG_SVC_AREA_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_PY_BSS_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_PY_BSS_RT_D,  object_name:BEN_PY_BSS_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_FL_TM_PT_TM_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_FL_TM_PT_TM_RT_D,  object_name:BEN_FL_TM_PT_TM_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_GRD_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_GRD_PRTE_D,  object_name:BEN_ELIG_GRD_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_PER_TYP_PRTE_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_PER_TYP_PRTE_D,  object_name:BEN_ELIG_PER_TYP_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_BRGNG_UNIT_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_BRGNG_UNIT_RT_D,  object_name:BEN_BRGNG_UNIT_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_HRLY_SLRD_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_HRLY_SLRD_PRTE_D,  object_name:BEN_ELIG_HRLY_SLRD_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_PCT_FL_TM_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_PCT_FL_TM_RT_D,  object_name:BEN_PCT_FL_TM_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_JOB_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_JOB_PRTE_D,  object_name:BEN_ELIG_JOB_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_DPNT_CVRD_PLIP_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_DPNT_CVRD_PLIP_RT_D,  object_name:BEN_DPNT_CVRD_PLIP_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_LER_RQRS_ENRT_CTFN_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_LER_RQRS_ENRT_CTFN_D,  object_name:BEN_LER_RQRS_ENRT_CTFN_D,  status:VALID, 

  • VIEW: APPS.BEN_BRGNG_UNIT_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_BRGNG_UNIT_RT_D,  object_name:BEN_BRGNG_UNIT_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_LVG_RSN_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_LVG_RSN_PRTE_D,  object_name:BEN_ELIG_LVG_RSN_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_AGE_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_AGE_RT_D,  object_name:BEN_AGE_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_LOA_RSN_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_LOA_RSN_RT_D,  object_name:BEN_LOA_RSN_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_PRTT_ANTHR_PL_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_PRTT_ANTHR_PL_PRTE_D,  object_name:BEN_ELIG_PRTT_ANTHR_PL_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_LBR_MMBR_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_LBR_MMBR_RT_D,  object_name:BEN_LBR_MMBR_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_BRGNG_UNIT_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_BRGNG_UNIT_PRTE_D,  object_name:BEN_ELIG_BRGNG_UNIT_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_GNDR_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_GNDR_RT_D,  object_name:BEN_GNDR_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ENRLD_ANTHR_PTIP_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ENRLD_ANTHR_PTIP_RT_D,  object_name:BEN_ENRLD_ANTHR_PTIP_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_FL_TM_PT_TM_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_FL_TM_PT_TM_RT_D,  object_name:BEN_FL_TM_PT_TM_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_HRLY_SLRD_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_HRLY_SLRD_RT_D,  object_name:BEN_HRLY_SLRD_RT_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_BENFTS_GRP_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_BENFTS_GRP_PRTE_D,  object_name:BEN_ELIG_BENFTS_GRP_PRTE_D,  status:VALID, 

  • VIEW: APPS.BEN_ELIG_ASNT_SET_PRTE_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ELIG_ASNT_SET_PRTE_D,  object_name:BEN_ELIG_ASNT_SET_PRTE_D,  status:VALID,