Results for “ben_back_out_chc_bnft_v”

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

Overview

BEN_BACK_OUT_CHC_BNFT_V is an Oracle E-Business Suite Advanced Benefits (BEN) view owned by the APPS schema. It presents the intersection of eligible persons and their selectable choices on the one hand, and the benefit enrollment records linked to those choices on the other. In functional terms, the view exposes the population of persons eligible for an electable choice, the choice itself, and the benefit enrollment record that results once a selection is made, so that enrollment-impacting attributes such as rollover behavior, defaulting rules, mandatory flags, and coverage start dates can be examined together. This consolidation makes the view a practical source for reporting on enrollment processing, benefits extracts, and integration routines that must reconstruct the eligibility-to-enrollment path.

The view is defined with an outer join between the eligible-person-choice table and the benefit enrollment table, so it also returns choice rows for which no benefit enrollment record yet exists. That characteristic positions it as a candidate source for identifying choices that remain unenrolled, a common requirement in enrollment auditing and back-out processing.

Underlying Base Objects

According to the documented view metadata, the view is defined over two base objects, both referenced through synonyms in the APPS schema:

• BEN_ELIG_PER_ELCTBL_CHC (aliased EPE in the view text) — the driving table, holding eligible persons, electable choice populations, plan and option identifiers, defaulting and mandatory indicators, and the rollover flag.
• BEN_ENRT_BNFT (aliased ENB) — the enrollment benefit table, supplying values, benefit type, coverage multiple, minimum/maximum/increment/default values, and the enrollment benefit identifier.

The join condition is ENB.ELIG_PER_ELCTBL_CHC_ID (+) = EPE.ELIG_PER_ELCTBL_CHC_ID, an Oracle outer join notation designating EPE as the preserved side. When no enrollment record matches, the ENB-derived columns return null and the view derives FAKE_CHOICE_ID from EPE.ELIG_PER_ELCTBL_CHC_ID through a DECODE expression.

Key Columns

The view exposes a broad column list drawn from both base objects. Notable columns include:

• PER_IN_LER_ID, PIL_ELCTBL_CHC_POPL_ID, PL_ID, OIPL_ID, PL_TYP_ID — identifiers linking the person, electable choice population, plan, option-in-plan, and plan type.
• ELIG_PER_ELCTBL_CHC_ID — the eligibility choice identifier used as the join key and as the fallback choice identifier.
• ROLL_CRS_FLAG — indicates whether the choice rolls over across enrollment periods, a frequently searched attribute.
• ELCTBL_FLAG, DFLT_FLAG, MNDTRY_FLAG, AUTO_ENRT_FLAG, CTFN_RQD_FLAG, CRNTLY_ENRD_FLAG, ENTR_VAL_AT_ENRT_FLAG — eligibility and enrollment behavior indicators.
• VAL, NNMNTRY_UOM, BNFT_TYP_CD, CVG_MLT_CD, MN_VAL, MX_VAL, INCRMT_VAL, DFLT_VAL — enrollment values and their constraints.
• ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT, ERLST_DEENRT_DT, DPNT_DSGN_CD, LER_CHG_DPNT_CVG_CD — coverage start, earliest de-enrollment, and dependent designation attributes.
• ENRT_BNFT_ID and FAKE_CHOICE_ID — the enrollment benefit identifier, and a surrogate identifier returned where no enrollment exists.
• EPE_ATTRIBUTE1 through EPE_ATTRIBUTE30 plus standard WHO and concurrent program columns — descriptive flexfield segments and audit/program metadata.

Common Use Cases and Queries

Typical usage centers on enrollment reporting, audits of unenrolled choices, and rollover analysis.

• Retrieving rollover-eligible choices for a plan or population.
• Identifying eligible persons with no corresponding enrollment record.
• Extracting enrollment values and constraints for downstream reconciliation.

Sample queries:

• SELECT PER_IN_LER_ID, PL_ID, ROLL_CRS_FLAG, ENRT_BNFT_ID FROM BEN_BACK_OUT_CHC_BNFT_V WHERE ROLL_CRS_FLAG = 'Y';
• SELECT ELIG_PER_ELCTBL_CHC_ID, PER_IN_LER_ID FROM BEN_BACK_OUT_CHC_BNFT_V WHERE ENRT_BNFT_ID IS NULL;