Results for “bnft_nnmntry_uom”

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

Overview

BEN_ENRT_RSLTS_INFO_V is a reporting and integration view owned by the APPS schema within the Oracle Advanced Benefits (BEN) module. It is registered in ETRM with a status of VALID and is documented as "Retrofitted," indicating that it was adapted during the upgrade path toward the 12.1.1 / 12.2.2 code lines to maintain backward compatibility for dependent forms, concurrent programs, and interfaces. The view consolidates enrollment result information by joining participant-level enrollment results with the benefit plan configuration that governs the corresponding eligibility and electable choice records. Its principal role is to present a denormalized, query-friendly projection of enrollment outcomes — plan identification, benefit values, enrollment dates, coverage start and through dates, mandatory and suspension flags, and descriptive flexfield attributes — without requiring callers to reconstruct the multi-table join themselves. Because the view is defined in the APPS schema and references synonyms and other views rather than direct table references in all cases, it serves as a stable abstraction layer for both online form lookups and custom reporting against the BEN data model.

Underlying Base Objects

In the 12.2.2 metadata, BEN_ENRT_RSLTS_INFO_V is defined over the following referenced objects: BEN_ELIG_PER_ELCTBL_CHC (synonym), BEN_ENRT_BNFT (synonym), BEN_LER_V (view), BEN_PER_IN_LER (synonym), BEN_PIL_ELCTBL_CHC_POPL (synonym), BEN_PRTT_ENRT_RSLT_F (synonym), and FND_SESSIONS (synonym). The core enrollment facts are sourced from BEN_PRTT_ENRT_RSLT_F, which supplies the participant enrollment result rows, original enrollment date, override reason and through date, coverage start and through dates, suspension flag, and the PEN_ATTRIBUTE descriptive flexfield columns. Plan-level configuration is drawn from BEN_ENRT_BNFT, providing default, minimum, maximum, increment, and certification-related values, the benefit type code, coverage multiple code, and the entry-value-at-enrollment flag. The eligibility and electable choice context comes from BEN_ELIG_PER_ELCTBL_CHC and BEN_PIL_ELCTBL_CHC_POPL, contributing plan type, plan, program, option, and plan-in-program identifiers, automatic enrollment and mandatory flags, and the CRNTLY_ENRD_FLAG source column. BEN_PER_IN_LER and BEN_LER_V resolve the participant's life event and eligibility relationship context, while FND_SESSIONS is referenced for session-level context. The view's text also exposes the PLIP and OIPL order numbers and the EPE aliased columns that map to the eligibility/electable choice population.

Key Columns

Among the most significant columns is CRNTLY_ENRD_FLAG, the field most frequently searched by users. It is derived through a nested DECODE: when the eligibility record's CRNTLY_ENRD_FLAG is 'N' the result is 'N'; when it is 'Y', the view further checks BEN_ENRT_BNFT.ENRT_BNFT_ID — if null, it returns 'Y', otherwise it returns BEN_ENRT_BNFT.CRNTLY_ENRLD_FLAG. This logic reconciles the population-level "currently enrolled" indicator with the enrollment-benefit-level indicator. Other notable columns include PL_TYP_ID, PL_ID, OIPL_ID, PGM_ID, PTIP_ID, and PLIP_ID, which identify the benefit hierarchy; ENRT_BNFT_ID and PRTT_ENRT_RSLT_ID, the surrogate keys for integration; BNFT_VAL, DFLT_VAL, MN_VAL, MX_VAL, MX_WOUT_CTFN_VAL, and INCRMT_VAL, which describe the benefit amount and its permissible ranges; ORGNL_ENRT_DT, ENRT_CVG_STRT_DT, and ENRT_CVG_THRU_DT for dating; MNDTRY_FLAG, SSPNDD_FLAG, AUTO_ENRT_FLAG, CTFN_RQD_FLAG, and INTERIM_FLAG for status evaluation; and the PEN_ATTRIBUTE1 through PEN_ATTRIBUTE27 flexfield columns for client-specific extensions. EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and OBJECT_VERSION_NUMBER are exposed as TO_CHAR strings, which is a characteristic of retrofitted views.

Common Use Cases and Queries

Typical use cases include verifying a participant's current enrollment status, reconciling benefit elections against plan limits, and feeding downstream payroll or carrier interfaces. A representative query retrieves current enrollments for a participant:

• SELECT prtt_enrt_rslt_id, pl_id, pl_typ_id, bnft_val, crntly_enrd_flag, enrt_cvg_strt_dt FROM ben_enrt_rslts_info_v WHERE crntly_enrd_flag = 'Y';
• SELECT pl_id, enrt_bnft_id, bnft_val, ctfn_rqd_flag FROM ben_enrt_rslts_info_v WHERE prtt_enrt_rslt_id = :p_result_id;
• SELECT mndtry_flag, sspndd_flag, interim_flag, effective_start_date FROM ben_enrt_rslts_info_v WHERE per_in_ler_id = :p_per_in_ler_id;

Because the view joins several BEN objects, consumers should apply selective predicates on PL_ID, PRTT_ENRT_RSLT_ID, or PER_IN_LER_ID to limit the result set and avoid unnecessary scans of the underlying enrollment result table.