Results for “hrs_src_cd”

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

Overview

BENBV_HRS_WKD_IN_PERD_FCTR_V is an APPS-owned, read-only view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes the configuration definitions that determine how a person's hours worked in a period are calculated, evaluated, and bounded. These factors drive core benefits processing, including eligibility determination and rate calculation. The view is defined on BEN_HRS_WKD_IN_PERD_FCTR, filtered by the session's security profile business group through HR_BIS.GET_SEC_PROFILE_BG_ID, and is declared WITH READ ONLY. In EBS 12.1.1 and 12.2.2, the object remains valid and is commonly used as a reporting and integration surface, allowing external or custom code to read the underlying factor definitions without querying the base table directly. A common search entry point into this object is the PYRL_FREQ_CD column, which links each factor to a payroll frequency.

Underlying Base Objects

The documented base objects referenced by the view are:

• BEN_HRS_WKD_IN_PERD_FCTR (SYNONYM) — the driving table supplying all factor rows and columns. The view aliases it as HWF.
• HR_BIS (PACKAGE) — supplies the security profile filter (GET_SEC_PROFILE_BG_ID) and the BIS_DECODE_LOOKUP function used to translate coded values into their display meanings.

The view joins no additional tables; instead it enriches each row in place by calling BIS_DECODE_LOOKUP against several lookup types (BEN_FREQ, BEN_HRS_WKD_SRC, BEN_RNDG, BEN_HRS_WKD_DET, BEN_ONCE_R_CNTG, BEN_HRS_ALT_VAL_TO_USE, and YES_NO). This design keeps the definition self-contained while presenting both raw codes and decoded values. The BUSINESS_GROUP_ID filter ensures multi-tenant and security-profile isolation across legal entities.

Key Columns

The view returns raw configuration columns plus decoded "_M" meaning columns generated by the lookup calls. Notable items include:

• NAME, HRS_WKD_CALC_RL, HRS_WKD_DET_RL, RNDG_RL — the factor name and rule identifiers governing calculation, detail, and rounding.
• MN_HRS_NUM, MX_HRS_NUM — the minimum and maximum hours thresholds applied to the factor.
• PYRL_FREQ_CD / PYRL_FREQ_CD_M — the payroll frequency code and its decoded meaning (via BEN_FREQ).
• HRS_SRC_CD, RNDG_CD, HRS_WKD_DET_CD — source of hours, rounding rule, and hours-worked detail codes with their decoded equivalents.
• ONCE_R_CNTUG_CD, HRS_WKD_BNDRY_PERD_CD, HRS_ALT_VAL_TO_USE_CD — once-per-period contingency, boundary period, and alternate value usage codes.
• NO_MX_HRS_WKD_FLAG, NO_MN_HRS_WKD_FLAG — yes/no flags indicating the absence of maximum or minimum hours constraints.
• HRS_WKD_IN_PERD_FCTR_ID, BUSINESS_GROUP_ID, BNFTS_BAL_ID, DEFINED_BALANCE_ID — identifier columns linking the factor to a business group and to balance definitions.
• Standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY).

Common Use Cases and Queries

Typical uses include auditing hours-worked factors by frequency, validating eligibility configuration, and feeding custom benefits extracts. A representative query listing factors by payroll frequency and their decoded descriptions is:

• SELECT name, pyrl_freq_cd, pyrl_freq_cd_m, hrs_src_cd_m, mn_hrs_num, mx_hrs_num FROM apps.benbv_hrs_wkd_in_perd_fctr_v ORDER BY name;
• SELECT hrs_wkd_in_perd_fctr_id, name FROM apps.benbv_hrs_wkd_in_perd_fctr_v WHERE pyrl_freq_cd = :p_freq AND no_mx_hrs_wkd_flag = 'Y';

Because the view is read-only and decode lookups run per row, large-volume extracts benefit from filtering first on persisted codes such as PYRL_FREQ_CD or BUSINESS_GROUP_ID.