Results for “los_fctr_id”

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

Overview

BENBV_CMBN_AGE_LOS_FCTR_V is a read-only Oracle EBS Advanced Benefits (BEN) view owned by the APPS schema. It exposes the calculation rules that Oracle Advanced Benefits uses to derive a person's combined age and length of service for eligibility determination and rate calculation. In benefits administration, many plan eligibility rules and rate structures depend not on age alone or length of service alone, but on a combined "age-plus-service" value (for example, the "rule of 75" used in many retirement and life insurance plans). This view surfaces the configured factors — the minimum and maximum combined values, the ordering sequence, and the associated age and length-of-service factor references — that drive those calculations.

The view is exposed to end users through the descriptive flexfield mechanism, as indicated by the literal '_DF:BEN:BEN_CMBN_AGE_LOS_FCTR:CLA' column aliased as "_DF:CLA". This makes the view suitable for both seeded Oracle forms and custom reporting against the benefits configuration model. Because the view is WITH READ ONLY, it cannot be used for DML; it is strictly a query and reporting object.

Underlying Base Objects

The view is defined over a single base object, BEN_CMBN_AGE_LOS_FCTR (referenced in the documentation as a synonym), aliased as CLA. The base table stores the combined age/length-of-service factor configuration records. A second documented reference is the HR_BIS package, invoked as HR_BIS.GET_SEC_PROFILE_BG_ID within the WHERE clause. This is a security profile function that returns the business group ID for the current session, enforcing business-group-level data security on the returned rows.

Column inheritance is essentially one-to-one: every column in the view maps directly to a column in BEN_CMBN_AGE_LOS_FCTR, with only the addition of the descriptive flexfield literal. No joins or aggregations are performed in the view text, so column values and data types mirror the base table exactly.

Key Columns

• NAME — The user-defined name of the combined age/length-of-service factor record.
• CMBND_MIN_VAL — The lower bound of the combined age-plus-service value for which this factor row applies. This is likely the column associated with the search term cmbnd_max_val's companion lower threshold.
• CMBND_MAX_VAL — The upper bound of the combined age-plus-service value for which this factor row applies. This is the column most closely matching the user's search term "cmbnd_max_val" and defines the ceiling of the applicable range.
• ORDR_NUM — The evaluation order used when multiple factor rows could apply, enabling deterministic selection of the correct range.
• "_DF:CLA" — Descriptive flexfield context token for the underlying base record, enabling display of configured DFF segments.
• CMBN_AGE_LOS_FCTR_ID — Primary key of the combined age/length-of-service factor record.
• LOS_FCTR_ID — Foreign key reference to the associated length-of-service factor definition.
• AGE_FCTR_ID — Foreign key reference to the associated age factor definition.
• BUSINESS_GROUP_ID — The business group that owns the record; filtered by the session security profile.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard WHO (audit) columns recording creation and modification metadata.

Common Use Cases and Queries

Typical uses include auditing benefit eligibility configurations, reconciling combined age/service ranges against plan documentation, and feeding downstream rate-calculation reports. Because business group security is enforced via HR_BIS.GET_SEC_PROFILE_BG_ID, the view returns only rows for the session's business group unless the security profile returns NULL, in which case all rows are visible.

A representative query listing all combined age/length-of-service factors with their value ranges is shown below:

• SELECT name, cmbnd_min_val, cmbnd_max_val, ordr_num
• FROM apps.benbv_cmbn_age_los_fctr_v
• WHERE cmbnd_max_val IS NOT NULL
• ORDER BY ordr_num;

To isolate the columns most relevant to the "cmbnd_max_val" search, a focused projection can be used:

• SELECT cmbn_age_los_fctr_id, name, cmbnd_min_val, cmbnd_max_val
• FROM apps.benbv_cmbn_age_los_fctr_v
• WHERE business_group_id = :p_business_group_id;

Because the view is read-only, all consumer code should treat it purely as a reporting surface. Implementers should note that the min/max values represent the boundaries of the combined age-plus-service band; eligibility logic elsewhere evaluates a person's computed combined value against these thresholds, while ORDR_NUM governs the precedence when ranges overlap.