Search Results ben_elig_stdnt_stat_cvg_f




Overview
Explore in AI Chat

Overview

The BEN.BEN_ELIG_STDNT_STAT_CVG_F table is a core configuration object within Oracle Advanced Benefits (BEN). It stores the student status rules that determine whether a dependent remains eligible for coverage under a specific compensation object, such as a benefit plan, program, or option. In practice, this table records the relationship between a defined student status code and the dependent coverage eligibility profile that governs enrollment, allowing plan administrators to enforce age-and-student-status-based eligibility restrictions that are common in health, dental, and life insurance offerings.

The object is registered as a VALID table owned by the BEN schema, documented against Oracle EBS 12.2.2 with 47 physical columns and a composite primary key constraint named BEN_ELIG_STDNT_STAT_CVG_F_PK. The "_F" suffix denotes a date-tracked (datetrack) entity, meaning rows are effective-dated rather than physically deleted. Based on the mined foreign-key structure, the table is a standalone entity with no documented outbound relationships to other objects; a Data Vault modeler might therefore suggest classifying it as a satellite, since it appears to capture descriptive, time-variant attributes rather than serving as a hub or link between distinct business keys.

Key Information Stored

The most significant columns in this table fall into three groups: identity, eligibility rule definition, and audit control.

The unique business-key candidate is the composite primary key (ELIG_STDNT_STAT_CVG_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE). No alternate unique index is documented, so the surrogate ID carries the business meaning of the rule set.

Common Use Cases and Queries

Typical usage centers on verifying and reporting the student-status eligibility restrictions attached to a dependent coverage profile. A common query retrieves the currently effective rules for a given profile:

  • Joining to eligibility profile tables on DPNT_CVG_ELIGY_PRFL_ID to render a human-readable rule summary.
  • Filtering by SYSDATE between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to isolate the active rule version.
  • Restricting by BUSINESS_GROUP_ID to scope results to a single legal entity or enterprise.
  • Auditing configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance or change-tracking reports.

Because the table is datetracked, historical versions remain queryable by adjusting the effective-date predicates, which supports point-in-time eligibility reporting and reconciliation of enrollment outcomes.

Related Objects

The mined FK structure classifies this object as standalone, meaning no direct foreign-key dependencies to other BEN tables are documented. Nonetheless, it participates logically in the Advanced Benefits eligibility model and is typically referenced alongside:

  • BEN_ELIGY_PRFL_F — the eligibility profile master, joined via DPNT_CVG_ELIGY_PRFL_ID.
  • BEN_ELIG_PRFL_DPNT_CVG_F — dependent coverage rules that contextualize the profile.
  • BEN_PGM_F, BEN_PL_F, and BEN_OIPL_F — compensation objects that ultimately depend on the student-status rule outcome.
  • BEN_PRTT_ENRT_RSLT_F — enrollment results that reflect the applied eligibility determination.
  • The BEN_ELIG_STDNT_STAT_CVG_F_PK constraint itself, which enforces uniqueness across the surrogate and datetrack columns.

These associations are derived from functional context rather than documented foreign keys; implementers should confirm actual join paths in their environment before relying on them for integration or extract logic.