Results for “ben_los_fctr”

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

Overview

BEN_LOS_FCTR is a configuration table in the Oracle Advanced Benefits (BEN) module that defines length-of-service (LOS) factors. These factors translate an employee's continuous service duration into a normalized numeric value that the benefits engine uses to drive eligibility, rate calculation, vesting, and age-plus-service combination logic. Rather than hard-coding service thresholds throughout the product, Oracle EBS centralizes the calculation rules — the date basis, rounding conventions, unit of measure, and minimum/maximum application caps — into reusable factor records identified by LOS_FCTR_ID.

From a Data Vault modeling perspective, the metadata heuristic classifies BEN_LOS_FCTR as hub-leaning. The table holds a stable, uniquely identified business concept (a defined LOS factor) referenced by multiple dependent tables; a modeling exercise would likely treat LOS_FCTR_ID as a hub key, with the descriptive and behavioral columns carried as satellite attributes.

Key Information Stored

The surrogate primary key is LOS_FCTR_ID, enforced by the unique index BEN_LOS_FCTR_PK. It is the sole documented business-key candidate and the column users search for when tracing factor references. Notable descriptive and controlling columns include:

• NAME — user-defined factor name shown in the Benefits setup UI.
• BUSINESS_GROUP_ID — the organization context (legislation/business group) that scopes the factor.
• LOS_DT_TO_USE_CD / LOS_DT_TO_USE_RL — which service date (e.g., hire date, adjusted service date) the calculation anchors to.
• LOS_UOM — the unit of measure (days, months, years) applied to service length.
• RNDG_CD / RNDG_RL — rounding rules applied to the derived service value.
• LOS_DET_CD / LOS_DET_RL — detail code and rule governing the service determination.
• MN_LOS_NUM / MX_LOS_NUM — minimum and maximum service bounds applied to the factor.
• NO_MN_LOS_NUM_APLS_FLAG / NO_MX_LOS_NUM_APLS_FLAG — flags suppressing the minimum or maximum application.
• USE_OVERID_SVC_DT_FLAG — indicates that an overridden service date should be honored.
• HRS_ALT_VAL_TO_USE_CD / LOS_ALT_VAL_TO_USE_CD / LOS_CALC_RL — alternate value selection and the calculation rule linkage.
• OBJECT_VERSION_NUMBER and the standard WHO audit columns (LAST_UPDATE_DATE, CREATED_BY, etc.) — concurrency control and row auditing.
• LSF_ATTRIBUTE1 through LSF_ATTRIBUTE30 plus LSF_ATTRIBUTE_CATEGORY — a 30-column descriptive flexfield for customer-defined extensions.

Common Use Cases and Queries

Typical scenarios include verifying which LOS factor a plan or eligibility rule points to, auditing factor naming and scope, and reporting the minimum/maximum service bounds applied to a benefit program.

• Resolve a factor by ID: SELECT name, los_uom, mn_los_num, mx_los_num FROM ben_los_fctr WHERE los_fctr_id = :p_id;
• List factors for a business group: filter by BUSINESS_GROUP_ID to enumerate configuration for a legislation.
• Trace usage: join BEN_LOS_RT_F (rates), BEN_ELIG_LOS_PRTE_F (eligibility prerequisites), BEN_VSTG_LOS_RQMT (vesting requirements), BEN_CMBN_AGE_LOS_FCTR (age-plus-service combinations), or BEN_BENEFIT_ACTIONS on LOS_FCTR_ID to see where a factor is consumed.
• Audit recent changes: order by LAST_UPDATE_DATE to review configuration edits since a given date.

Related Objects

BEN_LOS_FCTR is referenced by several dependent tables through LOS_FCTR_ID:

• BEN_LOS_RT_F — links LOS factors to benefit rate definitions (BEN_LOS_RT_F.LOS_FCTR_ID).
• BEN_ELIG_LOS_PRTE_F — eligibility prerequisites that evaluate length of service.
• BEN_VSTG_LOS_RQMT — vesting requirements expressed in service terms.
• BEN_CMBN_AGE_LOS_FCTR — combined age-and-service factor lookups.
• BEN_BENEFIT_ACTIONS — benefit action configuration referencing the factor.

These relationships make BEN_LOS_FCTR a shared reference hub across eligibility, rate, vesting, and action processing within Oracle Advanced Benefits.