Search Results ben_age_fctr




Overview
Explore in AI Chat

Overview

BEN_AGE_FCTR is a configuration table within the Oracle Advanced Benefits (BEN) module, owned by the BEN schema. Its documented purpose is to define an "age factor" — a reusable rule that determines which age value is used during benefits eligibility, rate, and vesting calculations, and how that age is rounded or measured. Rather than storing the age of any particular person, each row in BEN_AGE_FCTR describes a named age-determination rule that other benefits objects reference by surrogate identifier. This makes it a foundational reference object in the eligibility and rating engine of Oracle EBS 12.1.1 and 12.2.2.

Based on the foreign-key structure mined from the ETRM metadata, BEN_AGE_FCTR exhibits hub-leaning characteristics in a Data Vault modeling sense. It is referenced by six documented child tables but does not itself depend on a parent business entity through a foreign key, which is consistent with the role of a hub table holding a stable business key. The documented physical schema in ETRM 12.2.2 contains 51 columns.

Key Information Stored

The table's documented primary key is AGE_FCTR_ID, exposed through the unique index BEN_AGE_FCTR_PK. This surrogate identifier is the column referenced by every dependent object, and it is the only documented business-key candidate in the ETRM metadata. The most significant descriptive and operational columns include:

Common Use Cases and Queries

Administrators and developers query BEN_AGE_FCTR when diagnosing why a participant received a particular eligibility or rate outcome. A typical lookup resolves a name to its surrogate key and rule attributes:

  • SELECT age_fctr_id, name, age_uom, rndg_cd FROM ben_age_fctr WHERE business_group_id = :p_bg_id;
  • Joining to a child table to confirm which rules use a given factor: SELECT a.name, c.* FROM ben_age_fctr a, ben_elig_age_prte_f c WHERE a.age_fctr_id = c.age_fctr_id;
  • Auditing recently changed definitions: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify configuration drift.
  • Extracting flexfield attributes (AGF_ATTRIBUTE1..30) for reporting where the customer has extended the object.

Because the table is a configuration object, reporting is usually confined to setup verification, migration validation, and troubleshooting rather than high-volume transactional analytics.

Related Objects

Six documented tables reference AGE_FCTR_ID, indicating where an age factor is consumed:

These relationships establish BEN_AGE_FCTR as a shared reference hub within the Advanced Benefits eligibility, rating, and vesting subsystem.