Results for “mx_cvg”

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

Overview

APPS.BEN_LER_BNFT_RSTRN_D is a reporting and forms-support view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents a denormalized, user-readable projection of benefit restriction rules at the Life Event Reason (LER) level. The underlying transactional table, BEN_LER_BNFT_RSTRN_F, stores configuration that governs how benefit offerings, coverage amounts, and enrollment windows behave when a specific life event reason is triggered. Because that base table stores most of its business attributes as coded values (lookup codes and formula foreign keys), the view resolves those codes into descriptive meanings and formula names so that concurrent programs, Oracle Forms LOVs, OAF pages, and custom reports can display human-readable output without repeated joins in application code.

The view is a "D" (detail) view within the BEN family naming convention, meaning it is the descriptive counterpart to the base "_F" table. The name suffix also signals it is commonly referenced by Oracle Forms blocks that follow the _D view/_F table pattern, where the _D view supplies query and display data while the _F table accepts inserts and updates through the HR_API package. This view is available in both EBS 12.1.1 and 12.2.2 with identical column semantics.

The search term "unsspnd_enrt" maps directly to one of the view's key lookups: LBR.UNSSPND_ENRT_CD is joined to HR_LOOKUPS with lookup type BEN_UNSSPND_ENRT, exposing the UNSSPND_ENRT.MEANING column. This column indicates whether a pending enrollment suspended by the life event restriction should be automatically unsuspended.

Underlying Base Objects

The view is defined with the following documented referenced base objects:

• BEN_LER_BNFT_RSTRN_F (synonym) - the primary driving table; the view selects lbr.ROWID as ROW_ID for Forms row identification.
• BEN_LER_F (synonym) - Life Event Reason definition; outer-joined on LER_ID to supply LER.NAME.
• BEN_PL_F (synonym) - Plan definition; outer-joined on PL_ID to supply PL.NAME.
• FF_FORMULAS and FF_FORMULAS_F (synonyms/views) - supply formula names for MX_CVG_RL, MN_CVG_RL, and DFLT_TO_ASN_PNDG_CTFN2.
• FND_USER (synonym) - outer-joined on LAST_UPDATED_BY for audit display.
• HR_LOOKUPS (view) - referenced multiple times under aliases (UNSSPND_ENRT, CVG_INCR_R_DECR_ONLY, DFLT_TO_ASN_PNDG_CTFN, NO_MX_CVG_AMT_APLS, NO_MN_CVG_INCR_APLS, NO_MX_CVG_INCR_APLS) to translate coded columns into MEANING text.
• HR_API (package) - the interface used for DML against the base _F table, consistent with the Forms _D/_F pattern.

All joins are outer joins (+), so restriction rows are never dropped even when a lookup or formula reference is null or unconfigured.

Key Columns

• ROW_ID - ROWID of the base row; supports Forms block-level row binding.
• LER_BNFT_RSTRN_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE - primary key and datetrack columns.
• LER.NAME, PL.NAME - life event reason and plan names.
• UNSSPND_ENRT (meaning) - derived from UNSSPND_ENRT_CD / BEN_UNSSPND_ENRT; the column matching the search term "unsspnd_enrt".
• MX_CVG_ALWD_AMT, MX_CVG_INCR_ALWD_AMT, MX_CVG_INCR_WCF_ALWD_AMT, MN_CVG_AMT - maximum/minimum and incremental coverage amounts.
• MX_CVG_MLT_INCR_NUM, MX_CVG_MULT_INCR_WCF_NUM, MX_CVG_WCFN_AMT, MX_CVG_WCFN_MLT_NUM - multiple and waiver-coverage figures.
• MX_CVG.FORMULA_NAME, MN_CVG.FORMULA_NAME, DFLT_TO_ASN_PNDG_CTFN2.FORMULA_NAME - resolved formula identifiers.
• CVG_INCR_R_DECR_ONLY (meaning), DFLT_TO_ASN_PNDG_CTFN (meaning) - yes/no behavior flags.
• NO_MX_CVG_AMT_APLS, NO_MN_CVG_INCR_APLS, NO_MX_CVG_INCR_APLS - YES_NO lookups that invert the corresponding coverage limits.
• LAST_UPDATE_DATE, LAST_UPDATED_BY - audit trail joined to FND_USER.

Common Use Cases and Queries

The most frequent use is verifying enrollment-unsuspension behavior configured against a life event reason. The UNSSPND_ENRT column is the directly relevant output:

• SELECT ler_brstrn_id, name, unsspnd_enrt FROM apps.ben_ler_bnft_rstrn_d WHERE effective_start_date <= SYSDATE AND (effective_end_date IS NULL OR effective_end_date > SYSDATE);
• Joining to BEN_LER_F via LER.NAME to list all restrictions tied to a single event, or to BEN_PL_F to audit which plans carry over-age or minimum-coverage limits.
• Reporting on formula-driven coverage by selecting FORMULA_NAME columns to trace which FF_FORMULAS definitions drive maximum or minimum coverage for a plan.
• Audit queries selecting LAST_UPDATE_DATE, LAST_UPDATED_BY, and the FND_USER join to identify who last changed an unsuspension rule.

Because the view applies only outer joins and no filters, it is safe to query without additional predicates, though the effective date range should be constrained for accurate point-in-time results.