Search Results vrbl_rt_prfl_name




Overview
Explore in AI Chat

Overview

APPS.BEN_DPNT_OTHR_PTIP_RT_D is a reporting view in the Oracle EBS Advanced Benefits (BEN) module. It exposes dependent-other participant eligibility and rate linkage data, specifically the association between a program, plan type, plan, and the variable rate profile applied to a dependent or "other" participant. The view is classified as Oracle Internal Use Only, meaning Oracle Corporation does not support direct data access through this object except from standard Oracle Applications programs. The view type is Internal and the object is stored in the APPS schema with the FND Design Data reference BEN.BEN_DPNT_OTHR_PTIP_RT_D.

The object name expands logically: DPNT (dependent) + OTHR (other) + PTIP (participant type / plan type) + RT (rate) + _D denoting the view layer. This view is primarily a denormalized, effective-dated presentation layer over the underlying _F (date-tracked) base tables and is typically consumed by Benefits setup reports, enrollment processing, or custom extracts.

Underlying Base Objects

The view is defined over the following base objects, all reached through APPS synonyms:

Because dependencies resolve through APPS synonyms, and the _F suffix indicates date-tracked tables, join logic is driven by effective start and end dates and a surrogate primary key. The view also exposes a PUBLIC synonym BEN_DPNT_OTHR_PTIP_RT_D, meaning it is published for broader visibility within the database, notwithstanding the Oracle Internal Use Only warning.

Key Columns

  • DPNT_OTHR_PTIP_RT_ID (NUMBER(15)) — primary identifier for the dependent/other participant type rate row.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity window governing when the row is active.
  • EXCLD_FLAG (VARCHAR2(30)) — indicates inclusion or exclusion of the associated rate or participant grouping.
  • ORDR_NUM (NUMBER(15)) — sequence number controlling display or processing order.
  • PTIP (VARCHAR2(481)) — concatenated participant type description (the 481 length reflects a display-format concatenation of the PTIP definition).
  • VRBL_RT_PRFL_NAME (VARCHAR2(240)) — name of the variable rate profile attached to the row; this is the column most commonly used in rate-profile lookups and is the search term of interest.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — standard WHO audit columns for change tracking.

Common Use Cases and Queries

Typical uses include auditing which variable rate profiles are assigned to dependent/other participant types, validating effective dating, and feeding downstream enrollment or payroll rate calculations via custom extracts. Because VRBL_RT_PRFL_NAME is a denormalized display value, lookups against it should be treated as read-only reporting.

Sample query filtering on the searched term:

  • SELECT dpnt_othr_ptip_rt_id, effective_start_date, effective_end_date, ptip, vrbl_rt_prfl_name FROM apps.ben_dpnt_othr_ptip_rt_d WHERE vrbl_rt_prfl_name = :p_profile_name AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

A broader audit query joining the WHO columns would be:

  • SELECT a.dpnt_othr_ptip_rt_id, a.ptip, a.vrbl_rt_prfl_name, a.last_update_date, b.user_name FROM apps.ben_dpnt_othr_ptip_rt_d a, applsys.fnd_user b WHERE a.last_updated_by = b.user_id AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date ORDER BY a.ordr_num;

Given the Internal Use Only designation, these queries should be limited to diagnostic or read-only reporting purposes rather than embedded in production integration code.

  • VIEW: APPS.BEN_DPNT_OTHR_PTIP_RT_D 12.1.1

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

  • VIEW: APPS.BEN_ACTL_PREM_VRBL_RT_D 12.2.2

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

  • VIEW: APPS.BEN_ACTL_PREM_VRBL_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ACTL_PREM_VRBL_RT_D,  object_name:BEN_ACTL_PREM_VRBL_RT_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_VRBL_RT_PRFL_RL_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_VRBL_RT_PRFL_RL_D,  object_name:BEN_VRBL_RT_PRFL_RL_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_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_EE_STAT_RT_D 12.2.2

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

  • VIEW: APPS.BEN_NO_OTHR_CVG_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_NO_OTHR_CVG_RT_D,  object_name:BEN_NO_OTHR_CVG_RT_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_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_COMPTNCY_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_COMPTNCY_RT_D,  object_name:BEN_COMPTNCY_RT_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_PSTL_ZIP_RT_D 12.2.2

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

  • VIEW: APPS.BEN_SCHEDD_HRS_RT_D 12.2.2

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

  • VIEW: APPS.BEN_QUAL_TITL_RT_D 12.2.2

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

  • VIEW: APPS.BEN_LOA_RSN_RT_D 12.2.2

    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_DPNT_CVRD_PLIP_RT_D 12.2.2

    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_DPNT_CVRD_OTHR_PGM_RT_D 12.2.2

    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_COMP_LVL_RT_D 12.2.2

    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_ENRLD_ANTHR_PGM_RT_D 12.2.2

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

  • VIEW: APPS.BEN_LOS_RT_D 12.2.2

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

  • VIEW: APPS.BEN_PRTT_ANTHR_PL_RT_D 12.1.1

    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_OTHR_PTIP_RT_D 12.1.1

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

  • VIEW: APPS.BEN_LVG_RSN_RT_D 12.1.1

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

  • VIEW: APPS.BEN_SCHEDD_HRS_RT_D 12.1.1

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

  • VIEW: APPS.BEN_ENRLD_ANTHR_PGM_RT_D 12.1.1

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

  • VIEW: APPS.BEN_DPNT_CVRD_OTHR_PL_RT_D 12.1.1

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

  • VIEW: APPS.BEN_OPTD_MDCR_RT_D 12.1.1

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

  • VIEW: APPS.BEN_NO_OTHR_CVG_RT_D 12.2.2

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

  • VIEW: APPS.BEN_COMPTNCY_RT_D 12.2.2

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

  • VIEW: APPS.BEN_ENRLD_ANTHR_PTIP_RT_D 12.1.1

    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_PER_TYP_RT_D 12.2.2

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

  • VIEW: APPS.BEN_VRBL_RT_ELIG_PRFL_D 12.1.1

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

  • VIEW: APPS.BEN_OPTD_MDCR_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_OPTD_MDCR_RT_D,  object_name:BEN_OPTD_MDCR_RT_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_PTIP_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_DPNT_CVRD_OTHR_PTIP_RT_D,  object_name:BEN_DPNT_CVRD_OTHR_PTIP_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_ENRLD_ANTHR_OIPL_RT_D 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_ENRLD_ANTHR_OIPL_RT_D,  object_name:BEN_ENRLD_ANTHR_OIPL_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_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_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_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_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_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_VRBL_MTCHG_RT_D 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BEN_VRBL_MTCHG_RT_D,  object_name:BEN_VRBL_MTCHG_RT_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,