Search Results ben_cmbn_age_los_fctr




Overview
Explore in AI Chat

Overview

BEN_CMBN_AGE_LOS_FCTR is a configuration table within the Oracle Advanced Benefits (BEN) module. It defines a "combination age and length of service factor" — a composite eligibility construct that allows plan administrators to express participation rules as an intersection of a participant's age and the participant's length of service, rather than managing those two dimensions independently. Each row represents the cross-product definition between a single age factor (referenced through AGE_FCTR_ID) and a single length-of-service factor (referenced through LOS_FCTR_ID), bounded by a combined minimum and maximum value.

In Oracle EBS 12.1.1 and 12.2.2 the table is owned by the BEN schema and is validated with 45 documented columns. The primary key BEN_CMBN_AGE_LOS_FCTR_PK is composed of the surrogate column CMBN_AGE_LOS_FCTR_ID. From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification: the table hangs off two upstream reference parents (BEN_AGE_FCTR and BEN_LOS_FCTR) and carries descriptive, versioned attributes describing the combination itself. It is also referenced downstream by rate and eligibility tables, giving it a limited link character as well.

Key Information Stored

The most operationally significant columns include:

  • CMBN_AGE_LOS_FCTR_ID — the system-generated surrogate primary key and the value propagated to all dependent tables.
  • NAME — the user-visible identifier for the combination factor.
  • AGE_FCTR_ID — foreign key to BEN_AGE_FCTR, defining the age dimension.
  • LOS_FCTR_ID — foreign key to BEN_LOS_FCTR, defining the length-of-service dimension.
  • BUSINESS_GROUP_ID — the enterprise or business group ownership key, controlling multi-tenant visibility.
  • CMBND_MIN_VAL and CMBND_MAX_VAL — the lower and upper bounds of the combined factor.
  • ORDR_NUM — sequencing used to present or evaluate the combinations in a deterministic order.
  • CLA_ATTRIBUTE_CATEGORY and CLA_ATTRIBUTE1–CLA_ATTRIBUTE30 — the standard Oracle descriptive flexfield (DFF) segment columns for customer-extensible attributes.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle "WHO" audit columns.
  • OBJECT_VERSION_NUMBER — the optimistic-locking counter used by the OAF/BC4J middle tier.

The documented unique index is BEN_CMBN_AGE_LOS_FCTR_PK on CMBN_AGE_LOS_FCTR_ID; no separate business-key unique index is documented, so NAME serves only as a descriptive key and not as a database-enforced uniqueness constraint.

Common Use Cases and Queries

Typical scenarios include auditing eligibility rule setup, migrating benefit configurations between environments, and troubleshooting why a participant was or was not deemed eligible. A common join pattern resolves the two parent factors for reporting:

  • Join BEN_CMBN_AGE_LOS_FCTR to BEN_AGE_FCTR on AGE_FCTR_ID and to BEN_LOS_FCTR on LOS_FCTR_ID to display the underlying age and service ranges.
  • Join BEN_CMBN_AGE_LOS_FCTR to BEN_CMBN_AGE_LOS_RT_F on CMBN_AGE_LOS_FCTR_ID to retrieve the associated rate factors.
  • Join BEN_CMBN_AGE_LOS_FCTR to BEN_ELIG_CMBN_AGE_LOS_PRTE_F on CMBN_AGE_LOS_FCTR_ID to see which eligibility profile uses a given combination.

A representative query filters by business group and orders by ORDR_NUM to reproduce the configured evaluation sequence. Reports frequently select NAME, CMBND_MIN_VAL, and CMBND_MAX_VAL alongside the resolved age and loss factor names to give administrators a readable rule inventory. Because the table uses standard DFF columns, queries that surface CLA_ATTRIBUTE values should also join FND_DESCR_FLEX_COL_USAGE_VL to render prompt labels.

Related Objects

The following objects are the most significant dependencies based on documented foreign-key relationships:

  • BEN_AGE_FCTR — parent reference table; joined on AGE_FCTR_ID.
  • BEN_LOS_FCTR — parent reference table; joined on LOS_FCTR_ID.
  • BEN_CMBN_AGE_LOS_RT_F — child table storing rates; references this table on CMBN_AGE_LOS_FCTR_ID.
  • BEN_ELIG_CMBN_AGE_LOS_PRTE_F — eligibility prerequisite/profile table; references this table on CMBN_AGE_LOS_FCTR_ID.
  • BEN_BENEFIT_ACTIONS — references CMBN_AGE_LOS_FCTR_ID, linking combination factors to participant benefit actions.
  • BEN_CMBN_AGE_LOS_FCTR_PK — the primary key index enforcing uniqueness on CMBN_AGE_LOS_FCTR_ID.

Together these objects form the age-and-service eligibility subsystem within Advanced Benefits; the combination factor table occupies the central position between the atomic age and service factor definitions and the eligibility, rate, and action tables that consume them.