Results for “ben_elig_dsbld_stat_cvg_v”

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

Overview

BEN_ELIG_DSBLD_STAT_CVG_V is a valid, APPS-owned database view within the Oracle Advanced Benefits (BEN) module. In the ETRM metadata it carries the description "Retrofitted," indicating that the object was migrated or regenerated to conform to a later EBS release standard, and it is documented as available in both the 12.1.1 and 12.2.2 reference environments. The view exposes effective-dated eligibility records that associate a dependent coverage eligibility profile with a disabled status and coverage start and through rules.

Functionally, the view serves as a date-effective, session-aware reporting and integration interface over the disabled status coverage eligibility entity. Because it is defined with a join to FND_SESSIONS, it returns only rows valid as of the effective date held for the current user session, which aligns the view with Oracle EBS date-tracked (datetrack) security and effective-date conventions. This makes it suitable for concurrent programs, forms-driven queries, and downstream extracts that must respect the session's effective date rather than returning all historical versions.

The object named in the user's search, EDC_ATTRIBUTE_CATEGORY, is not a standalone object; it is one of the descriptive flexfield context columns surfaced by this view, appearing alongside the EDC_ATTRIBUTE1 through EDC_ATTRIBUTE30 segments. Users searching for that term are typically attempting to locate or report on the descriptive flexfield context of disabled status coverage eligibility records.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, the view is defined over two referenced base objects:

• BEN_ELIG_DSBLD_STAT_CVG_F (accessed via a SYNONYM) — the date-tracked base table holding the disabled status coverage eligibility definition. The view selects from this table and assigns it the alias EDC.
• FND_SESSIONS (accessed via a SYNONYM) — the application sessions table, aliased SE, which supplies the user's current session effective date.

The join predicate SE.SESSION_ID = USERENV('SESSIONID') together with SE.EFFECTIVE_DATE BETWEEN EDC.EFFECTIVE_START_DATE AND EDC.EFFECTIVE_END_DATE restricts the result set to the single date-effective version of each eligibility record that applies to the active session. Consequently, the view is a filtered projection of the _F table rather than a distinct entity; no _TL or _B table is referenced, reflecting that the underlying data is not translated and does not use the _B/_F date-tracked inversion pattern exposed to the view layer.

Key Columns

The view exposes the following principal columns:

• ROW_ID — the ROWID of the underlying base-table row, exposed as ROW_ID for updateable/identifiable access.
• ELIG_DSBLD_STAT_CVG_ID — the primary key of the disabled status coverage eligibility record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity range of the record.
• BUSINESS_GROUP_ID — the business group (operating unit) to which the record belongs.
• DPNT_CVG_ELIGY_PRFL_ID — the dependent coverage eligibility profile associated with the record.
• CVG_STRT_CD / CVG_STRT_RL — the coverage start code and its associated rule or value.
• CVG_THRU_CD / CVG_THRU_RL — the coverage through (end) code and its associated rule or value.
• DSBLD_CD — the disabled status indicator for the eligibility record.
• EDC_ATTRIBUTE_CATEGORY — the descriptive flexfield context (structure) value; the column the user searched for.
• EDC_ATTRIBUTE1 … EDC_ATTRIBUTE30 — the thirty descriptive flexfield segment columns, carrying context-sensitive additional attributes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and OBJECT_VERSION_NUMBER, supporting concurrency control and audit reporting.

Common Use Cases and Queries

Typical uses include reporting on coverage start and through rules for disabled dependents, validating descriptive flexfield context values, and feeding eligibility data into integration extracts. A representative query retrieving the flexfield context for current-session records is:

• SELECT ELIG_DSBLD_STAT_CVG_ID, DPNT_CVG_ELIGY_PRFL_ID, DSBLD_CD, CVG_STRT_CD, CVG_THRU_CD, EDC_ATTRIBUTE_CATEGORY, EDC_ATTRIBUTE1 FROM APPS.BEN_ELIG_DSBLD_STAT_CVG_V WHERE BUSINESS_GROUP_ID = :p_bg_id;

To target records that carry a populated flexfield context, a filter such as WHERE EDC_ATTRIBUTE_CATEGORY IS NOT NULL is commonly applied. Because results are session-restricted, callers should set the session effective date appropriately before relying on the row set, and join related BEN tables on ELIG_DSBLD_STAT_CVG_ID where additional eligibility detail is required.