Results for “benbv_los_fctr_v”

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

Overview

BENBV_LOS_FCTR_V is an APPS-owned, read-only view in the Oracle E-Business Suite Advanced Benefits (BEN) product. It exposes the configuration of length-of-service (LOS) factors — the rules that determine how a person's length of service is calculated for purposes such as eligibility determination, rate calculation, and benefit administration. The view is a business-facing, secured projection over the underlying BEN_LOS_FCTR table, adding decoded (meaning) columns for every coded attribute so that report authors and integrators do not need to join to lookup tables manually.

The view is defined as WITH READ ONLY and filters the base table by the business group returned from the security profile function HR_BIS.GET_SEC_PROFILE_BG_ID, falling back to the row's own BUSINESS_GROUP_ID when no security profile value is available. This means any query executed by a user naturally returns only the LOS factors visible to that user's security profile, making the view suitable for concurrent programs, BI Publisher data models, and custom reports that must respect Oracle HRMS security.

Underlying Base Objects

The documented base objects referenced by this view are:

• BEN_LOS_FCTR (SYNONYM) — the synonym in the APPS schema that resolves to the BEN product's length-of-service factor definition table. This table stores each LOS factor row, including its calculation rules, units of measure, rounding rules, minimum and maximum service limits, and the numerous coded attributes exposed by the view.
• HR_BIS (PACKAGE) — the RDBMS package that supplies two functions used throughout the view: BIS_DECODE_LOOKUP, which translates stored codes into their descriptive meanings via lookup types, and GET_SEC_PROFILE_BG_ID, which derives the effective business group from the user's security profile.

The view is a 1:1 projection of BEN_LOS_FCTR rows; it performs no aggregation or joining beyond the inline decoding calls. Each coded column is paired with a corresponding _M (meaning) column produced by BIS_DECODE_LOOKUP.

Key Columns

• NAME — the user-defined name of the length-of-service factor.
• LOS_UOM / LOS_UOM_M — the unit of measure for service (for example, days, months, years), decoded against the lookup BEN_TM_UOM.
• LOS_DT_TO_USE_CD / LOS_DT_TO_USE_CD_M — the date to use when counting service, decoded against BEN_LOS_DT_TO_USE.
• LOS_DET_CD / LOS_DET_CD_M — the LOS determination code, decoded against BEN_LOS_DET.
• RNDG_CD / RNDG_CD_M — the rounding rule applied to the calculated service, decoded against BEN_RNDG.
• HRS_ALT_VAL_TO_USE_CD / HRS_ALT_VAL_TO_USE_CD_M — the alternate hours value to use in the LOS calculation, decoded against BEN_HRS_ALT_VAL_TO_USE. This is the column most directly associated with the search term hrs_alt_val_to_use_cd.
• LOS_ALT_VAL_TO_USE_CD / LOS_ALT_VAL_TO_USE_CD_M — the alternate length-of-service value to use, decoded against BEN_LOS_ALT_VAL_TO_USE.
• MN_LOS_NUM, MX_LOS_NUM — the minimum and maximum service numbers bounding the calculation.
• NO_MX_LOS_NUM_APLS_FLAG, NO_MN_LOS_NUM_APLS_FLAG, USE_OVERID_SVC_DT_FLAG — YES/NO flags (decoded against YES_NO) indicating whether the maximum or minimum limits apply and whether an overridden service date is used.
• LOS_FCTR_ID, BUSINESS_GROUP_ID — the primary key and the owning business group, the latter used for the security filter.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard WHO audit columns.

Common Use Cases and Queries

The view is typically used to report, audit, or migrate LOS factor definitions, and to feed integration extracts with human-readable meanings rather than raw codes.

Listing all LOS factors for the current security profile with decoded meanings:

• SELECT LOS_FCTR_ID, NAME, LOS_UOM_M, LOS_DET_CD_M, RNDG_CD_M FROM BENBV_LOS_FCTR_V ORDER BY NAME;

Finding factors that reference a specific alternate hours value, which directly addresses the hrs_alt_val_to_use_cd search:

• SELECT LOS_FCTR_ID, NAME, HRS_ALT_VAL_TO_USE_CD, HRS_ALT_VAL_TO_USE_CD_M FROM BENBV_LOS_FCTR_V WHERE HRS_ALT_VAL_TO_USE_CD IS NOT NULL;

Auditing configuration changes for a date range:

• SELECT LOS_FCTR_ID, NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM BENBV_LOS_FCTR_V WHERE LAST_UPDATE_DATE >= :p_from_date;

Because the view enforces business-group security through HR_BIS.GET_SEC_PROFILE_BG_ID and presents decoded columns, it is the preferred source for custom reports and extracts over the BEN_LOS_FCTR base table.