Results for “ben_los_dt_to_use”

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

Overview

APPS.BENBV_LOS_FCTR_V is a business-group-secured reporting view over the Oracle EBS Benefits length-of-service (LOS) factor table BEN_LOS_FCTR. In Oracle Advanced Benefits (OAB), a length-of-service factor defines the rule by which an employee's length of service is calculated, rounded, and bounded for eligibility and plan-year processing. The view exposes the same logical row content as the base table, but represents coded values as their decoded user-facing meanings, resolves the descriptive flexfield reference, and filters rows according to the operator's security profile. It is the standard presentation-layer object used by Oracle Forms, OAB concurrent processes, and customer reports and interfaces that require length-of-service factor definitions.

Underlying Base Objects

The view is defined over two documented objects:

• BEN_LOS_FCTR (accessed in the view text via the alias LSF, resolved through a synonym) — the storage table holding every length-of-service factor definition, including its rules, units of measure, bounds, and code values.
• HR_BIS (package) — supplies the decoding and security functions used by the view, specifically HR_BIS.BIS_DECODE_LOOKUP and HR_BIS.GET_SEC_PROFILE_BG_ID.

The WHERE clause restricts output to LSF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, LSF.BUSINESS_GROUP_ID), so the view returns only rows belonging to the business group currently set in the user's security profile; if no profile value is derivable, all business groups are returned. The view is defined WITH READ ONLY.

Key Columns

• NAME, LOS_DET_RL, LOS_DT_TO_USE_RL, RNDG_RL, LOS_CALC_RL — the factor name and the rule identifiers governing length-of-service detail calculation, date selection, rounding, and the overall calculation.
• LOS_UOM plus decoded BIS_DECODE_LOOKUP('BEN_TM_UOM', ...) — the unit of measure in which service is expressed.
• MN_LOS_NUM / MX_LOS_NUM — minimum and maximum length-of-service values applied to the factor.
• LOS_DT_TO_USE_CD, LOS_DET_CD, RNDG_CD — coded values for date-to-use, LOS detail, and rounding, each paired with a decoded lookup column (BEN_LOS_DT_TO_USE, BEN_LOS_DET, BEN_RNDG).
• HRS_ALT_VAL_TO_USE_CD and LOS_ALT_VAL_TO_USE_CD — the alternative values to use for hours and for length of service, decoded against BEN_HRS_ALT_VAL_TO_USE and BEN_LOS_ALT_VAL_TO_USE respectively. These columns are the direct match for the search term ben_los_alt_val_to_use.
• USE_OVERID_SVC_DT_FLAG, NO_MX_LOS_NUM_APLS_FLAG, NO_MN_LOS_NUM_APLS_FLAG — Yes/No flags decoded via the YES_NO lookup governing service date overrides and suppression of the maximum/minimum LOS bounds.
• _DF:BEN:BEN_LOS_FCTR:LSF — descriptive flexfield reference token, and LOS_FCTR_ID, BUSINESS_GROUP_ID — the primary and business group identifiers.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard WHO audit columns.

Common Use Cases and Queries

Typical usage includes validating factor configuration before a plan-year run, reporting which factors rely on alternative values, and driving eligibility logic in custom extracts.

• List all factors with their decoded calculation and rounding rules for the user's business group:
• SELECT name, los_calc_rl, rndg_rl, mn_los_num, mx_los_num FROM apps.benbv_los_fctr_v ORDER BY name;
• Find factors that use an alternative length-of-service value — the scenario associated with the term ben_los_alt_val_to_use:
• SELECT name, los_alt_val_to_use_cd, los_dt_to_use_cd FROM apps.benbv_los_fctr_v WHERE los_alt_val_to_use_cd IS NOT NULL;
• Identify factors that disregard the maximum LOS bound:
• SELECT los_fctr_id, name FROM apps.benbv_los_fctr_v WHERE no_mx_los_num_apls_flag = 'Y';

Because the view is read-only and pre-filters by security profile, it is safe for concurrent-program and report queries without additional business group predicates. Where a specific factor ID is required for downstream joins, select LOS_FCTR_ID and join to BEN_LOS_FCTR or related eligibility tables.