Results for “ben_los_det”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.BENBV_ELIG_SCHEDD_HRS_PRTE_V is a business-validated (BV) database view within the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents the defined rows of the Scheduled Hours eligibility profile participation and eligibility criteria rule, exposing the configuration of worked-hours thresholds that determine whether a person qualifies for a benefits program or plan. The view surfaces a subset of columns from the underlying flexfield-based rules table and enriches them with decoded lookup values, making it suitable for reporting, data extraction, and integration where raw coded values would otherwise require additional interpretation.
Because the view applies a security profile filter on the business group, its result set is automatically restricted to the business group of the session, or to all business groups when no security profile is active. This makes the view safe for use in multi-organization deployments and appropriate for both report publishers and interface programs.
Underlying Base Objects
The view is defined over a single referenced base object: the synonym BEN_ELIG_SCHEDD_HRS_PRTE_F, which resolves to the underlying BEN scheduled-hours eligibility profile rules table. It also references the HR_BIS package for lookup decoding through its BIS_DECODE_LOOKUP function.
The WHERE clause applies ESH.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ESH.BUSINESS_GROUP_ID), restricting rows to the current business group when a security profile is set. The view is created WITH READ ONLY, so it cannot be used for DML. The user's search term ben_los_det corresponds to the lookup type decoded for the DETERMINATION_CD column, which explains why this view is returned for that search.
Key Columns
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective range governing when the rule row is active.
- HRS_NUM — The numeric hours threshold defined for the criteria.
- MAX_HRS_NUM — Upper bound of hours for the rule, where applicable.
- ORDR_NUM — Sequence or ordering number for evaluating multiple criteria rows.
- DETERMINATION_RL / DETERMINATION_CD — Determination rule identifier and code. The code is decoded via
BIS_DECODE_LOOKUP('BEN_LOS_DET', ...), matching the searched term and typically representing the length-of-service/hours determination basis. - FREQ_CD — Frequency code, decoded using lookup type
FREQUENCY. - ROUNDING_RL / ROUNDING_CD — Rounding rule and code, decoded via lookup type
BEN_RNDG. - SCHEDD_HRS_RL — The scheduled-hours rule reference.
- EXCLD_FLAG — Exclusion indicator, decoded through lookup type
YES_NO. - ELIG_SCHEDD_HRS_PRTE_ID — Primary key of the underlying rule row.
- ELIGY_PRFL_ID — Foreign key to the eligibility profile that owns this criteria.
- BUSINESS_GROUP_ID — Owning business group, subject to the security profile filter.
- WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE audit fields.
Common Use Cases and Queries
Typical uses include reporting eligibility profile criteria by hours, validating configuration during implementation, and extracting decoded rule definitions for interfaces. The following query lists active scheduled-hours criteria for a given eligibility profile:
SELECT eligy_prfl_id, hrs_num, max_hrs_num, freq_cd, determination_cd, exclud_flag FROM apps.benbv_elig_schedd_hrs_prte_v WHERE eligy_prfl_id = :p_profile_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY ordr_num;
To review decoded determination and rounding values for auditing:
SELECT elig_schedd_hrs_prte_id, determination_cd, freq_cd, rounding_cd, hrs_num FROM apps.benbv_elig_schedd_hrs_prte_v WHERE created_by = :p_user;
Because the view is read-only and security-filtered by business group, it is well suited to concurrent program extracts and BI Publisher data models without additional row-level security coding.
-
Lookup Type: BEN_LOS_DET 12.2.2
-
Lookup Type: BEN_LOS_DET 12.1.1
-
VIEW: APPS.BENBV_LOS_FCTR_V 12.1.1
-
- Retrofitted
APPS.BEN_ELIG_SCHEDD_HRS_PRTE_D·↳ BEN_ELIGY_PRFL_F·↳ BEN_ELIG_SCHEDD_HRS_PRTE_F·↳ FF_FORMULAS_F·Explore BEN module →
-
VIEW: APPS.BENBV_LOS_FCTR_V 12.2.2
-
This view identifies which scheduled hours is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_SCHEDD_HRS_PRTE_V·↳ BEN_ELIG_SCHEDD_HRS_PRTE_F·↳ HR_BIS·Explore BEN module →
-
- Retrofitted
APPS.BEN_ELIG_SCHEDD_HRS_PRTE_D·↳ BEN_ELIGY_PRFL_F·↳ BEN_ELIG_SCHEDD_HRS_PRTE_F·↳ FF_FORMULAS_F·Explore BEN module →
-
This view identifies which scheduled hours is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_SCHEDD_HRS_PRTE_V·↳ BEN_ELIG_SCHEDD_HRS_PRTE_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_LOS_FCTR_V 12.2.2
This view identifies how to calculate a person's length of service for such purposes as determining eligibility and calculating rates.
APPS.BENBV_LOS_FCTR_V·↳ BEN_LOS_FCTR·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.BENBV_LOS_FCTR_V 12.2.2
-
View: BENBV_LOS_FCTR_V 12.1.1
This view identifies how to calculate a person's length of service for such purposes as determining eligibility and calculating rates.
APPS.BENBV_LOS_FCTR_V·↳ BEN_LOS_FCTR·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.BENBV_LOS_FCTR_V 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - BEN Tables and Views 12.2.2
Start and End periods.
-
eTRM - BEN Tables and Views 12.1.1
Start and End periods.