Results for “ler_name”

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

Overview

BEN_FLX_ENRT_PGM_INFO_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Advanced Benefits (BEN) product. In the ETRM documentation for release 12.1.1 and 12.2.2, the view carries the annotation "Retrofitted," and its status is listed as VALID. The purpose of the view is to present a consolidated, session-filtered projection of enrollment program information for the currently connected user. It joins program definitions, person-in-life-event-role records, life event role details, eligible-choice population data, and the current FND session to return only those program rows that are active and applicable to the user's present effective date and session.

Because the view resolves against USERENV('SESSIONID') and FND_SESSIONS, its output is inherently user- and session-dependent. This makes it unsuitable for general-purpose bulk reporting, but valuable for interactive flows, self-service pages, and integration touchpoints that need to reflect the enrollment program context of the logged-in user at runtime. The view exposes the program-identifying attribute PGM_TYP_CD, which is the column most commonly searched for when analyzing this object.

Underlying Base Objects

The view is defined over six documented base objects, all referenced through synonyms or a nested view:

• BEN_ELIG_PER_ELCTBL_CHC (synonym) — supplies eligibility and electable choice rows; aliased EPE.
• BEN_PIL_ELCTBL_CHC_POPL (synonym) — enrollment population and period data; aliased PEL.
• BEN_PGM_F (synonym) — the program definition table; aliased PGM.
• BEN_PER_IN_LER (synonym) — person-in-life-event-role assignments; aliased PIL.
• BEN_LER_V (view) — life event role definition view; aliased LER.
• FND_SESSIONS (synonym) — the current session record; aliased SE.

The joins enforce that the session effective date falls within the program's effective range and within the enrollment period (using NVL fallbacks on start and end dates), that the person-in-life-event-role is shared across the population, LER, and eligibility tables, and that the current session matches USERENV('SESSIONID'). Filters restrict output to active programs (PGM_STAT_CD = 'A'), started person-in-LER records (PER_IN_LER_STAT_CD = 'STRTD'), eligible choices (ELCTBL_FLAG = 'Y'), and exclude compensation levels PLANFC and PLANIMP as well as life event role types COMP, IREC, and GSP.

Key Columns

• PGM_NAME — name of the enrollment program (from BEN_PGM_F).
• PGM_ID — unique program identifier; primary join key across the view.
• PGM_TYP_CD — program type code; the column users most frequently filter on when distinguishing program categories.
• PERSON_ID — the person associated with the life event role.
• PER_IN_LER_ID — person-in-life-event-role identifier linking person, LER, and population rows.
• LER_ID / LER_NAME — life event role identifier and descriptive name.
• BUSINESS_GROUP_ID — the business group owning the program record.
• ENRT_PERD_ID / LEE_RSN_ID — enrollment period and life event reason identifiers.
• CLS_ENRT_DT_TO_USE_CD — code indicating which date to use for close enrollment processing.

Common Use Cases and Queries

Typical scenarios include validating which enrollment programs are visible to a user during an active session, driving self-service enrollment pages, and debugging why a program does or does not appear. Sample query:

SELECT pgm_name, pgm_id, pgm_typ_cd, person_id, ler_name
FROM   apps.ben_flx_enrt_pgm_info_v;

To restrict to a specific program type:

SELECT pgm_name, pgm_id, pgm_typ_cd
FROM   apps.ben_flx_enrt_pgm_info_v
WHERE  pgm_typ_cd = :p_pgm_typ_cd;

Because results depend on FND_SESSIONS and USERENV, testing should be performed from within a valid EBS session context rather than through standalone SQL*Plus connections that lack session data.