Search Results ben_age_fctr_pk

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:

• NAME — the user-facing name of the age factor, used to identify the rule in setup and configuration screens.
• BUSINESS_GROUP_ID — the operating unit or business group that owns the definition, enabling multi-tenant partitioning of configuration data.
• MX_AGE_NUM and MN_AGE_NUM — the maximum and minimum age numeric bounds applied by the rule.
• NO_MX_AGE_FLAG and NO_MN_AGE_FLAG — flags indicating that no maximum or minimum age constraint applies.
• AGE_UOM — the unit of measure for the age value (for example, years or months).
• AGE_TO_USE_CD — the code determining which age to use in the calculation.
• RNDG_CD and RNDG_RL — the rounding code and rounding rule applied to the computed age.
• AGE_DET_CD and AGE_DET_RL — the age-determination code and rule controlling how the age is derived.
• AGE_CALC_RL — the rule governing the age calculation itself.
• OBJECT_VERSION_NUMBER and the standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard concurrent-safe versioning and who-columns.
• AGF_ATTRIBUTE_CATEGORY and AGF_ATTRIBUTE1 through AGF_ATTRIBUTE30 — a 30-column descriptive flexfield block that allows customer-specific extensions without schema change.

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:

• BEN_AGE_RT_F via AGE_FCTR_ID — age-based rate definitions.
• BEN_CMBN_AGE_LOS_FCTR via AGE_FCTR_ID — combined age and length-of-service factors.
• BEN_ELIG_AGE_CVG_F via AGE_FCTR_ID — age eligibility rules by coverage.
• BEN_ELIG_AGE_PRTE_F via AGE_FCTR_ID — age eligibility rules by participant eligibility.
• BEN_VSTG_AGE_RQMT via AGE_FCTR_ID — age requirements within vesting rules.
• BEN_BENEFIT_ACTIONS via AGE_FCTR_ID — benefits actions that apply an age factor.

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