Results for “ben_elig_prfl_type”

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

Overview

APPS.BENBV_PRTN_ELIG_PRFL_V is a read-only reporting view in the Oracle E-Business Suite Benefits (BEN) module, exposed in the APPS schema. Its name follows the standard Oracle "BV" (Business View) convention, indicating that it is intended for reporting, integration, and display purposes rather than transactional maintenance. The view presents participant eligibility profile definitions — the rule sets that determine which participants (employees, dependents, beneficiaries, and other program participants) qualify for a given benefits offering, plan, or program.

The view is particularly relevant to users searching for ben_elig_prfl_type, since it surfaces the ELIG_PRFL_TYPE_CD column together with its decoded, user-facing description, rendered through the HR_BIS.BIS_DECODE_LOOKUP function against the BEN_ELIG_PRFL_TYPE lookup type. This makes the view a natural source for reporting on the type of each participant eligibility profile without needing to join directly to the lookup tables. The view is defined with the WITH READ ONLY clause, and its WHERE predicate enforces the session's Business Group security profile by comparing BUSINESS_GROUP_ID to the value returned by HR_BIS.GET_SEC_PROFILE_BG_ID, thereby restricting rows to the operating business group of the querying user.

Underlying Base Objects

The view is defined over a single base object, the synonym BEN_PRTN_ELIG_PRFL_F, which corresponds to the participant eligibility profile table (the "_F" suffix denotes the date-tracked, effective-dated table in the BEN data model). In addition, the view references the HR_BIS package for two purposes: decoding lookup values and resolving the security profile Business Group ID.

• BEN_PRTN_ELIG_PRFL_F — the effective-dated table storing participant eligibility profile rows, aliased as CEP in the view text. Each row is associated with an eligibility profile (ELIGY_PRFL_ID), a participant eligibility definition (PRTN_ELIG_ID), and a business group.
• HR_BIS — a shared Oracle HRMS package supplying BIS_DECODE_LOOKUP (lookup translation) and GET_SEC_PROFILE_BG_ID (security profile resolution). The NVL construct permits all business groups to be returned when the security function yields no value.

The view is a pure projection: it selects, decodes, and filters columns from the base table without aggregation or additional joins, preserving the effective-dating semantics of BEN_PRTN_ELIG_PRFL_F.

Key Columns

The view exposes a compact set of columns, grouped in the source definition as descriptive flexfield, codes, ID, and WHO columns.

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity window of the eligibility profile row.
• ELIG_PRFL_TYPE_CD — the raw code for the participant eligibility profile type; this is the column that answers the ben_elig_prfl_type search. Its decoded equivalent is returned adjacently via BIS_DECODE_LOOKUP('BEN_ELIG_PRFL_TYPE', ...).
• MNDTRY_FLAG — indicates whether the profile is mandatory, with a Yes/No decoded value supplied through BIS_DECODE_LOOKUP('YES_NO', ...).
• PRTN_ELIG_PRFL_ID — primary identifier of the participant eligibility profile row.
• BUSINESS_GROUP_ID — the business group that owns the row; also the security filter key.
• ELIGY_PRFL_ID — the parent eligibility profile to which the participant eligibility definition belongs.
• PRTN_ELIG_ID — the participant eligibility definition referenced by the profile.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• Descriptive flexfield — exposed through the literal '_DF:BEN:BEN_PRTN_ELIG_PRFL_F:CEP', which instructs the Oracle Forms/Business Intelligence layer to render the DFF segment defined on the base table.

Common Use Cases and Queries

Typical uses include auditing eligibility profile configurations, validating the mandatory flag across plans, and feeding downstream extracts with pre-decoded type descriptions. Because the view already applies business group security, it is safe to expose in custom concurrent programs and OBIEE/BIP data models.

Listing all profiles with decoded type and mandatory status:

SELECT elig_prfl_type_cd,
       elig_prfl_type_cd_decoded,
       mndtry_flag,
       mndtry_flag_decoded,
       eligy_prfl_id,
       prtn_elig_id
FROM   apps.benbv_prtn_elig_prfl_v
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Filtering for a specific profile type (the column matching the user's search term):

SELECT prtn_elig_prfl_id, eligy_prfl_id
FROM   apps.benbv_prtn_elig_prfl_v
WHERE  elig_prfl_type_cd = :p_elig_prfl_type
AND    TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Verifying how a code is decoded and reviewing audit activity for a business group:

SELECT prtn_elig_prfl_id,
       elig_prfl_type_cd,
       HR_BIS.BIS_DECODE_LOOKUP('BEN_ELIG_PRFL_TYPE', elig_prfl_type_cd) typ_meaning,
       last_update_date,
       last_updated_by
FROM   apps.benbv_prtn_elig_prfl_v
ORDER  BY last_update_date DESC;

As the view is read-only and joins no additional tables, performance is essentially that of a filtered scan on BEN_PRTN_ELIG_PRFL_F; queries should constrain on effective dates and business group to exploit the underlying indexes.