Results for “enb_attribute1”

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

Overview

BEN_ENRT_BNFT is the core transactional table within the Oracle Advanced Benefits (BEN) module that stores enrollment benefit records. In Oracle EBS 12.1.1 and 12.2.2, this table represents the benefit elections an eligible person has made for a specific benefit offering within a compensation object or program. Each row captures the enrollment decision for one benefit, linked to the person's eligibility and electable choice record. The table is owned by the BEN schema and is classified as VALID in the ETRM documentation.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure indicates this table is hub-leaning. This suggests that ENRT_BNFT_ID functions as the central business key around which satellite and link structures could be organized. The table sits at the intersection of eligibility configuration, enrollment processing, and premium/rate calculation, making it a critical junction in the Benefits data model.

Key Information Stored

The primary key of BEN_ENRT_BNFT is the surrogate identifier ENRT_BNFT_ID, enforced by the unique index BEN_ENRT_BNFT_PK. Among the 64 documented columns, the most operationally significant include:

• ENRT_BNFT_ID — Surrogate primary key uniquely identifying each enrollment benefit record.
• ELIG_PER_ELCTBL_CHC_ID — Foreign key to BEN_ELIG_PER_ELCTBL_CHC, linking the enrollment to the person's eligible electable choice.
• COMP_LVL_FCTR_ID — Foreign key to BEN_COMP_LVL_FCTR, associating the enrollment with a compensation level factor.
• BUSINESS_GROUP_ID — Identifies the HR business group (operating unit) that owns the record.
• DFLT_FLAG and DFLT_VAL — Indicate whether the benefit was defaulted and the default value applied.
• CRNTLY_ENRLD_FLAG — Marks whether the person is currently enrolled in this benefit.
• CTFN_RQD_FLAG — Indicates whether certification is required for this enrollment.
• BNFT_TYP_CD and RT_TYP_CD — Benefit type and rate type codes controlling calculation behavior.
• MN_VAL, MX_VAL, INCRMT_VAL — Minimum, maximum, and incremental values governing enrollment amounts.
• VAL and NNMNTRY_UOM — The enrolled value and its unit of measure for non-monetary benefits.
• ENTR_VAL_AT_ENRT_FLAG — Determines whether the value is entered at enrollment time.
• PRTT_ENRT_RSLT_ID — Links to proration enrollment results.
• BNDRY_PERD_CD — Boundary period code for enrollment validity windows.

The ENB_ATTRIBUTE1 through ENB_ATTRIBUTE30 columns provide a flexible descriptive flexfield (DFF) mechanism for extending enrollment benefit data without schema changes. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER) support auditability and optimistic locking.

Common Use Cases and Queries

BEN_ENRT_BNFT is queried extensively for benefits administration, payroll deduction verification, and open enrollment reporting. A typical query retrieves all current benefit enrollments for a person by joining through the eligibility path:

• Reporting on actively enrolled benefits filtered by CRNTLY_ENRLD_FLAG = 'Y' and BUSINESS_GROUP_ID.
• Identifying defaulted elections using DFLT_FLAG = 'Y' for audit or compliance review.
• Reconciling enrollment values (VAL, MN_VAL, MX_VAL) against premium records in BEN_ENRT_PREM and rate records in BEN_ENRT_RT.
• Extracting flexfield data via ENB_ATTRIBUTE1..30 for custom integrations.
• Joining to BEN_ELIG_PER_ELCTBL_CHC to resolve the eligible person and electable choice context for a given enrollment.

A representative join pattern is: SELECT e.ENRT_BNFT_ID, e.VAL, e.DFLT_FLAG FROM BEN_ENRT_BNFT e JOIN BEN_ELIG_PER_ELCTBL_CHC c ON e.ELIG_PER_ELCTBL_CHC_ID = c.ELIG_PER_ELCTBL_CHC_ID WHERE e.CRNTLY_ENRLD_FLAG = 'Y';

Related Objects

The following objects have documented foreign key relationships with BEN_ENRT_BNFT:

• BEN_ELIG_PER_ELCTBL_CHC — Referenced via ELIG_PER_ELCTBL_CHC_ID; provides eligibility context.
• BEN_COMP_LVL_FCTR — Referenced via COMP_LVL_FCTR_ID; supplies compensation level factors.
• BEN_ENRT_PREM — References ENRT_BNFT_ID; stores premium amounts per enrollment benefit.
• BEN_ENRT_RT — References ENRT_BNFT_ID; stores rate details per enrollment benefit.
• BEN_ELCTBL_CHC_CTFN — References ENRT_BNFT_ID; holds certification data for electable choices.
• BEN_ENRT_RT_RBV, BEN_ENRT_PREM_RBV, BEN_ENRT_BNFT_RBV — Read-only business views exposing enrollment, rate, and premium data.
• BEN_ELCTBL_CHC_CTFN_RBV — Read-only view for certification information.
• BEN_LE_CLSN_N_RSTR — References ENRT_BNFT_ID; manages life event closure and restriction logic.

These relationships confirm BEN_ENRT_BNFT as a hub-like entity whose children fan out into premium, rate, certification, and restriction satellites, consistent with the hub-leaning classification identified in the metadata.