Results for “sal_chg_reason_cd”

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

Overview

BENBV_ENRT_PERD_V is a business view in the Oracle Advanced Benefits (BEN) module, defined in the APPS schema and shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. It identifies a specific instance of an enrollment period for a program or plan within a defined enrollment type cycle, such as an open enrollment, a life event, or a periodic enrollment. The view is the standard reporting and integration interface for enrollment period configuration data, exposing the date rules, coverage start and end rules, budget and worksheet update windows, approval settings, and hierarchy controls that govern how eligibility and rate processing behave during a given enrollment cycle.

The object is a VIEW with a status of VALID. Its role is consistent with other BENBV_* business views: it decouples consumers from the underlying table structure, adds descriptive flexfield support, and enriches coded columns with decoded meanings through the HR_BIS package. This makes it suitable for concurrent program report queries, Oracle BI Publisher data models, and inbound/outbound interface extracts.

Underlying Base Objects

The documented base objects for BENBV_ENRT_PERD_V are BEN_ENRT_PERD (referenced through a SYNONYM) and the HR_BIS package. BEN_ENRT_PERD is the principal table storing enrollment period definitions; the view selects its columns and aliases them with the ENP prefix. The HR_BIS package supplies the BIS_DECODE_LOOKUP function, which is invoked repeatedly in the view text to translate lookup codes into user-facing descriptions. No joins to other base tables are documented in the excerpt, so the view is effectively a single-table projection over BEN_ENRT_PERD with lookup decoding applied. Descriptive flexfield attributes are surfaced through the special '_DF:BEN:BEN_ENRT_PERD:ENP' token, which the BEN framework expands at runtime.

Key Columns

• STRT_DT / END_DT — the effective start and end dates of the enrollment period.
• ENRT_CVG_STRT_DT / ENRT_CVG_END_DT — the enrollment coverage start and end dates used for election processing.
• ENRT_CVG_STRT_DT_RL / ENRT_CVG_END_DT_RL / RT_STRT_DT_RL / RT_END_DT_RL — date rule references that drive coverage and rate start/end derivation.
• RT_STRT_DT / RT_END_DT and their associated rule columns — rate effective windows.
• DFLT_ENRT_DT — the default enrollment date applied to participants.
• BDGT_UPD_STRT_DT / BDGT_UPD_END_DT and WS_UPD_STRT_DT / WS_UPD_END_DT — the windows during which budgets and worksheets may be updated.
• HRCHY_RL — the hierarchy rule identifier; this is the column associated with the user search term "hrchy_rl." It stores the reference to the reporting hierarchy used for enrollment processing, and the companion column HRCHY_TO_USE_CD is decoded via BEN_HRCHY_TO_USE to indicate whether the hierarchy is used.
• HRCHY_AME_TRN_CD — the AME transaction code related to hierarchy approvals.
• AUTO_DISTR_FLAG — indicates whether automatic distribution is enabled, decoded through YES_NO.
• CLS_ENRT_DT_TO_USE_CD, EMP_INTERVIEW_TYPE_CD, PRSVR_BDGT_CD, SAL_CHG_REASON_CD, APPROVAL_MODE_CD — coded controls, each paired with a BIS_DECODE_LOOKUP value.
• DATA_FREEZE_DATE, ASG_UPDT_EFF_DATE, ASND_LF_EVT_DT, PERF_REVW_STRT_DT, PROCG_END_DT — processing-related dates.

Common Use Cases and Queries

Typical scenarios include auditing enrollment period configuration, validating coverage and rate date rules before an open enrollment, reconciling budget and worksheet windows against payroll calendars, and confirming which hierarchy rule governs a cycle. A representative query is:

SELECT strt_dt, end_dt, enrt_cvg_strt_dt, enrt_cvg_end_dt,
       hrchy_rl, auto_distr_flag
  FROM apps.benbv_enrt_perd_v;

To inspect decoded controls, select the paired descriptor columns alongside their code columns. Reporting joins typically link HRCHY_RL back to BEN's hierarchy rule tables where a descriptive name is required, since the view itself exposes the rule identifier rather than its label.