Search Results ben_wthn_yr_perd

Overview

The BEN_WTHN_YR_PERD table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically in releases 12.1.1 and 12.2.2. It serves as a master table for defining and storing "within year periods." These periods are critical scheduling constructs used to manage the timing and frequency of various benefit plan activities, such as enrollment windows, eligibility calculations, and life event processing. The table's primary role is to provide a structured framework for segmenting a benefit year into smaller, manageable intervals, enabling precise control over when specific benefit rules and processes are applied.

Key Information Stored

The table's central column is the primary key, WTHN_YR_PERD_ID, which uniquely identifies each within-year period record. The most significant foreign key column is YR_PERD_ID, which links the within-year period to its parent benefit year period defined in the BEN_YR_PERD table. This relationship ensures that every within-year period is logically scoped within a specific benefit year. While the provided metadata does not list all columns, typical attributes for such a table would include fields for the period's start date, end date, sequence number, name, and a code to signify its type or purpose within the benefit administration lifecycle.

Common Use Cases and Queries

This table is essential for configuring and reporting on time-sensitive benefit operations. A primary use case is defining the specific windows during which employees can enroll in or change their benefit elections outside of a standard open enrollment. For reporting, administrators often query this table to list all active periods within a given benefit year or to validate period dates. A common SQL pattern involves joining to the BEN_YR_PERD table to get a complete time context.

SELECT w.wthn_yr_perd_id,
       w.yr_perd_id,
       y.perd_name AS year_period_name,
       w.perd_name,
       w.perd_start_dt,
       w.perd_end_dt
FROM ben_wthn_yr_perd w,
     ben_yr_perd y
WHERE w.yr_perd_id = y.yr_perd_id
AND y.perd_end_dt >= SYSDATE
ORDER BY w.perd_start_dt;

Related Objects

The BEN_WTHN_YR_PERD table has a direct and documented foreign key relationship with the BEN_YR_PERD table, which defines the overarching benefit year periods. This relationship is implemented via the column BEN_WTHN_YR_PERD.YR_PERD_ID, which references the primary key of the BEN_YR_PERD table. As a foundational setup table, BEN_WTHN_YR_PERD is likely referenced by numerous other Benefits tables that govern enrollment, eligibility, and life events, though these specific relationships are not detailed in the provided excerpt. The primary key constraint for this table is named BEN_WTHN_YR_PERD_PK.