Search Results pre_tax_rt_id




Overview
Explore in AI Chat

Overview

APPS.BEN_ENRT_USED_INFO_V is a supplementary database view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It is classified as a "View Type: supplementary view used to simplify forms coding," meaning it exists primarily to support Oracle Forms-based user interfaces rather than to serve as a public reporting or integration interface. The Oracle documentation explicitly warns that querying or altering data through this view is not recommended, as its definition may change substantially between minor or major releases. In both EBS 12.1.1 and 12.2.2, the view carries a VALID status with FND Design Data reference BEN.BEN_ENRT_USED_INFO_V, owned by the APPS schema. The view exposes enrollment cost and coverage information across pre-tax, after-tax, and net value dimensions, making it conceptually relevant to benefit plan configuration and enrollment processing.

Underlying Base Objects

The view is defined over four documented base objects, accessed via APPS synonyms: BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_BNFT, BEN_ENRT_RT, and BEN_PER_IN_LER. BEN_ELIG_PER_ELCTBL_CHC stores eligibility-to-electable-choice relationships, linking persons to the benefit choices for which they qualify. BEN_ENRT_BNFT holds enrollment benefit records, representing the actual selections made by participants. BEN_ENRT_RT stores enrollment rate and cost information, which supplies the monetary columns such as pre-tax, after-tax, and net values. BEN_PER_IN_LER represents the person-in-life-event-reason association, connecting participants to qualifying life events. The view does not itself serve as a dependency for any other database object, confirming its role as a terminal, presentation-layer construct rather than a building block for downstream logic.

Key Columns

The view exposes twenty-one columns. Primary keys and foreign keys include PL_TYP_ID, PL_ID (foreign key to BEN_PL_F), OIPL_ID (foreign key to BEN_OIPL_F), PGM_ID, PTIP_ID (foreign key to BEN_PTIP_F), and PLIP_ID, which collectively identify plan type, plan, option-in-plan, program, plan type-in-program, and plan-in-program context. Coverage amounts are represented by BNFT_VAL, PRE_TAX_VAL, AFTR_TAX_VAL, and NET_VAL. The PRE_TAX_VAL column corresponds directly to the user's search term and holds the pre-tax monetary value of the enrollment, while AFTR_TAX_VAL holds the after-tax equivalent and NET_VAL the combined net figure. DFLT_FLAG indicates default selections. Relationship identifiers include ELIG_PER_ELCTBL_CHC_ID, PER_IN_LER_ID (foreign key to BEN_PER_IN_LER), PRTT_ENRT_RSLT_ID, ENRT_BNFT_ID, and BUSINESS_GROUP_ID (foreign key to HR_ORGANIZATION_UNITS). Rate-related columns include PRE_TAX_RT_ID, AFTR_TAX_RT_ID, PRE_TAX_RT_POOL_ID, and AFTR_TAX_RT_POOL_ID. MYROW is a forms-navigation helper column.

Common Use Cases and Queries

Although direct querying is discouraged, developers and analysts sometimes reference this view when troubleshooting forms behavior or reconstructing enrollment cost breakdowns. Typical scenarios include verifying how pre-tax and after-tax amounts are split for a participant's enrollment, auditing default flag behavior, and tracing rate pool assignments. A sample query follows:

  • SELECT PL_ID, PTIP_ID, ELIG_PER_ELCTBL_CHC_ID, PRE_TAX_VAL, AFTR_TAX_VAL, NET_VAL, DFLT_FLAG FROM APPS.BEN_ENRT_USED_INFO_V WHERE BUSINESS_GROUP_ID = :p_bg_id AND PRE_TAX_VAL > 0;
  • SELECT ENRT_BNFT_ID, PER_IN_LER_ID, PRE_TAX_RT_ID, AFTR_TAX_RT_ID, PRE_TAX_RT_POOL_ID FROM APPS.BEN_ENRT_USED_INFO_V WHERE ELIG_PER_ELCTBL_CHC_ID = :p_choice_id;
  • SELECT PL_TYP_ID, COUNT(*) FROM APPS.BEN_ENRT_USED_INFO_V GROUP BY PL_TYP_ID ORDER BY PL_TYP_ID;

Because the view is forms-oriented and unsupported for direct access, Oracle recommends that reports and integrations instead source data from the underlying base tables BEN_ENRT_BNFT, BEN_ENRT_RT, BEN_ELIG_PER_ELCTBL_CHC, and BEN_PER_IN_LER, or from supported public APIs and extract views within the BEN module.