Search Results cvg_thru_meaning




Overview
Explore in AI Chat

Overview

APPS.BEN_ELIG_STDNT_STAT_CVG_D is a documented Oracle E-Business Suite view in the Benefits (BEN) product family. Its name reflects its purpose: it exposes configuration data for student status coverage eligibility rules within dependent coverage eligibility profiles. In Oracle Advanced Benefits, an eligibility profile can restrict which dependents qualify for a plan based on a student status criterion, and can additionally define the period during which coverage is permitted ("coverage start" and "coverage through" rules). This view consolidates those rules together with their descriptive lookup meanings, denormalizing the underlying foreign-key identifiers into human-readable text.

The view is classified as Oracle Internal Use Only and its view type is documented as Internal. Oracle does not support direct access to application data through this object except from standard Oracle Applications programs. It therefore functions primarily as an internal data source consumed by Benefits setup forms, concurrent programs, and related application logic rather than as a supported public integration interface. Reported status is VALID, and the object is owned by the APPS schema. One notable characteristic is the presence of the standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY), which allows auditing of the most recent change to each configuration row.

Underlying Base Objects

The documented dependency list identifies the following referenced objects: BEN_ELIG_STDNT_STAT_CVG_F and BEN_DPNT_CVG_ELIGY_PRFL_F (both synonyms to the underlying BEN base tables), FF_FORMULAS_F (the FastFormula definition table, used because eligibility criteria can be driven by formulas), FND_USER (joined to resolve the identity of the last updater), HR_API (a package referenced in the view definition, commonly used for date or security resolution), and HR_LOOKUPS (the lookups view that supplies the meaning values exposed by the *_MEANING columns).

The core relationship is: BEN_ELIG_STDNT_STAT_CVG_F stores the student status coverage rule rows for a dependent coverage eligibility profile, and BEN_DPNT_CVG_ELIGY_PRFL_F supplies the parent eligibility profile context (surfaced through DPNT_CVG_ELIGY_PRFL_NAME). Because HR_LOOKUPS is joined, the view resolves internal lookup codes (such as those identifying coverage start and coverage through options) into user-facing meanings. The view is referenced by a PUBLIC synonym, BEN_ELIG_STDNT_STAT_CVG_D, which permits schema-qualified access without the APPS prefix where granted.

Key Columns

  • ROW_ID — ROWID of the underlying row; useful for direct row addressing, but unstable if the base row migrates.
  • ELIG_STDNT_STAT_CVG_ID — Primary key of the student status coverage rule row.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-tracked effective range of the configuration, allowing the same rule to exist in multiple dated versions.
  • DPNT_CVG_ELIGY_PRFL_NAME — Name of the dependent coverage eligibility profile to which the student status rule belongs.
  • CVG_STRT_MEANING / CVG_STRT_NAME — Meaning and short name of the coverage start rule, respectively (the meaning derived from the associated lookup).
  • CVG_THRU_MEANING / CVG_THRU_NAME — Meaning and short name of the coverage through rule. This is the column of interest when searching for cvg_thru_meaning: it converts the coverage-through lookup code into a readable description such as a date, plan year end, or similar coverage-termination convention.
  • STDNT_STAT_MEANING — Lookup meaning of the student status value used as the eligibility criterion (for example, full time or part time student status), depending on the configured lookup.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — Standard WHO audit columns; LAST_UPDATED_BY is a foreign key to FND_USER.USER_ID, resolved here only as the ID, and available for change-tracking queries.

Common Use Cases and Queries

This view is typically used by Benefits administrators and technical teams to audit or report on how student status eligibility and coverage-through rules are configured across dependent coverage eligibility profiles. Because coverage through rules affect when a dependent's enrollment terminates, reconciliation and "what-if" analysis of dependent coverage terminations frequently begins with a query against this view.

A simple listing of all configured rules with their resolved meanings:

SELECT elig_stdnt_stat_cvg_id,
       dpnt_cvg_eligy_prfl_name,
       cvg_strt_meaning,
       cvg_thru_meaning,
       stdnt_stat_meaning,
       effective_start_date,
       effective_end_date
FROM   apps.ben_elig_stdnt_stat_cvg_d
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Isolating the coverage-through convention used for each profile (the typical cvg_thru_meaning lookup):

SELECT dpnt_cvg_eligy_prfl_name,
       cvg_thru_meaning,
       COUNT(*)
FROM   apps.ben_elig_stdnt_stat_cvg_d
GROUP  BY dpnt_cvg_eligy_prfl_name, cvg_thru_meaning
ORDER  BY 1, 3 DESC;

Auditing recent changes to student status rules:

SELECT elig_stdnt_stat_cvg_id,
       dpnt_cvg_eligy_prfl_name,
       cvg_thru_meaning,
       last_update_date,
       last_updated_by
FROM   apps.ben_elig_stdnt_stat_cvg_d
WHERE  last_update_date >= TRUNC(SYSDATE) - 30
ORDER  BY last_update_date DESC;

Because the object is flagged Oracle Internal Use Only, reporting should be limited to read-only queries, and any integration should rely on supported public APIs rather than direct DML against the base tables. Queries joining this view to FND_USER for the updater name will require an additional join, since the view exposes only LAST_UPDATED_BY as a numeric user ID.