Results for “ben_hrchy_to_use”

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

Overview

APPS.BENBV_ENRT_PERD_V is a business view (the "BV" prefix indicates a Business View exposed by the Oracle Advanced Benefits (BEN) module) defined over the enrollment period table BEN_ENRT_PERD. It presents configuration and control attributes for enrollment periods within Oracle EBS 12.1.1 and 12.2.2, and is the view that benefit administrators, concurrent processes, and integration components use to read enrollment period definitions with their associated lookup meanings already resolved.

A distinguishing feature of this view is that it exposes not only the raw code values stored on BEN_ENRT_PERD but also their decoded, user-facing descriptions via calls to HR_BIS.BIS_DECODE_LOOKUP. Columns such as HRCHY_TO_USE_CD are paired with the corresponding decoded value from the BEN_HRCHY_TO_USE lookup type. This is precisely the context in which the search term "ben_hrchy_to_use" appears: the underlying lookup type BEN_HRCHY_TO_USE governs the hierarchy-to-use code (HRCHY_TO_USE_CD) that determines which hierarchy drives processing for a given enrollment period. By decoding the code at the view layer, report writers and integrators avoid writing their own lookup joins.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following referenced base objects:

• BEN_ENRT_PERD (SYNONYM) — the enrollment period base table, aliased as ENP in the view text. This is the single source table from which all ordinary data columns are selected.
• HR_BIS (PACKAGE) — invoked as HR_BIS.BIS_DECODE_LOOKUP(lookup_type, code) to translate each stored lookup code into its descriptive meaning.

Every attribute column in the view maps directly to a column on BEN_ENRT_PERD, prefixed with the ENP alias. The view adds no joins of its own beyond the functional calls to HR_BIS, so row cardinality matches the base table, and the view inherits the base table's business group and security filtering semantics.

Key Columns

The view exposes date, control, and descriptive flexfield columns. Notable groupings include:

• Period boundaries: STRT_DT, END_DT, ENRT_CVG_STRT_DT, ENRT_CVG_END_DT, PROCG_END_DT, DFLT_ENRT_DT, and DATA_FREEZE_DATE.
• Hierarchy and enrollment control: HRCHY_RL, HRCHY_TO_USE_CD (decoded via BEN_HRCHY_TO_USE), CLS_ENRT_DT_TO_USE_CD, DFLT_WS_ACC_CD, and PRSVR_BDGT_CD.
• Rate and coverage date rules: RT_STRT_DT_RL, RT_END_DT_RL, ENRT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_RL, plus RT_STRT_DT_CD, RT_END_DT_CD, ENRT_CVG_STRT_DT_CD, and ENRT_CVG_END_DT_CD.
• Budget, worksheet, and salary updates: BDGT_UPD_STRT_DT/BDGT_UPD_END_DT, WS_UPD_STRT_DT/WS_UPD_END_DT, PERF_REVW_STRT_DT, and ASG_UPDT_EFF_DATE.
• Flags and modes: AUTO_DISTR_FLAG, USES_BDGT_FLAG, APPROVAL_MODE_CD, and SAL_CHG_REASON_CD.
• Descriptive flexfield: exposed as '_DF:BEN:BEN_ENRT_PERD:ENP'.
• Identifiers: ENRT_PERD_ID, BUSINESS_GROUP_ID, POPL_ENRT_TYP_CYCL_ID, YR_PERD_ID, LER_ID, and POS_STRUCTURE_VERSION_ID.

Common Use Cases and Queries

Typical usage includes retrieving the enrollment period definitions active for a business group, resolving which hierarchy drives processing, and driving downstream batch or reporting logic.

• Listing enrollment periods with decoded processing rules for a business group.
• Filtering by date range to identify the currently effective enrollment period.
• Resolving the hierarchy-to-use meaning for audit or configuration review.

Representative query:

SELECT ENRT_PERD_ID
     , STRT_DT
     , END_DT
     , HRCHY_TO_USE_CD
     , HRCHY_RL
     , AUTO_DISTR_FLAG
  FROM APPS.BENBV_ENRT_PERD_V
 WHERE BUSINESS_GROUP_ID = :p_business_group_id
   AND SYSDATE BETWEEN STRT_DT AND NVL(END_DT, SYSDATE + 1);

Because the view performs no joins beyond the HR_BIS decode calls, it is safe to filter and join on the ENP-derived columns without concern for duplicate rows introduced at the view layer.