Results for “ben_hrs_wkd_in_perd_fctr”

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

Overview

BEN_HRS_WKD_IN_PERD_FCTR is a configuration table owned by the BEN schema within Oracle Advanced Benefits (BEN). The object stores the definitions used to determine how many hours an employee is treated as having worked within a benefits period. Rather than holding transactional results, it holds the rule parameters — such as the source of hours, frequency basis, rounding behavior, and optional minimum or maximum boundaries — that drive eligibility and rate processing elsewhere in the application.

The table has a documented primary key, BEN_HRS_WKD_IN_PERD_FCTR_PK, and 56 columns in the ETRM 12.2.2 physical schema. The heuristic Data Vault classification mined from its foreign key structure is hub-leaning. In modeling terms, this suggests treating the object as a reference or hub entity that enumerates distinct hours-worked-in-period factor definitions, with dependent tables acting as links or satellites that point to a given factor ID.

Key Information Stored

The surrogate primary key is HRS_WKD_IN_PERD_FCTR_ID, defined by BEN_HRS_WKD_IN_PERD_FCTR_PK. Several columns carry the substantive configuration:

• BUSINESS_GROUP_ID — the operating unit or business group owning the definition, the principal natural discriminator.
• NAME — the descriptive label for the factor.
• PYRL_FREQ_CD — payroll frequency used as the period basis.
• HRS_SRC_CD — indicates the source from which hours are drawn.
• HRS_WKD_CALC_RL and HRS_WKD_DET_RL — rules governing calculation and detail selection for hours worked.
• HRS_WKD_DET_CD — the detailed code describing how hours are determined.
• RNDG_CD and RNDG_RL — the rounding code and rounding rule applied to computed hours.
• MN_HRS_NUM and MX_HRS_NUM — numeric minimum and maximum hour thresholds, alongside the flags NO_MN_HRS_WKD_FLAG and NO_MX_HRS_WKD_FLAG that suppress those bounds.
• BNFTS_BAL_ID and DEFINED_BALANCE_ID — references to benefits and defined balances consulted during determination.
• HRS_WKD_BNDRY_PERD_CD and HRS_ALT_VAL_TO_USE_CD — period boundary and alternate value behavior.

The HWF_ATTRIBUTE* columns supply a twenty-attribute descriptive flexfields segment, and the standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER) provide concurrency and lineage control.

Common Use Cases and Queries

Developers and analysts query this table when tracing eligibility failures, validating hours-based rate calculations, or extracting configuration during implementation migrations. A typical lookup by business group and name resembles:

• SELECT hrs_wkd_in_perd_fctr_id, name, py rl_freq_cd, hrs_src_cd, rndg_cd FROM ben.ben_hrs_wkd_in_perd_fctr WHERE business_group_id = :p_bg_id;
• Joining to eligibility prerequisites: ... FROM ben_elig_hrs_wkd_prte_f p, ben_hrs_wkd_in_perd_fctr f WHERE p.hrs_wkd_in_perd_fctr_id = f.hrs_wkd_in_perd_fctr_id;
• Reporting minimum and maximum boundaries with their suppression flags to confirm no unintended cap applies.

These queries support audit of benefits program setup, troubleshooting inconsistent hours determinations, and building configuration comparison reports between environments.

Related Objects

The documented foreign key relationships identify the principal dependents of this table. BEN_ELIG_HRS_WKD_PRTE_F references HRS_WKD_IN_PERD_FCTR_ID to attach an hours-worked factor to an eligibility prerequisite, and BEN_HRS_WKD_IN_PERD_RT_F references the same column to attach the factor to a rate definition. Both joins are one-to-many from the factor to the dependent rows. Additional relationships to benefits balance, defined balance, and payroll frequency reference data complete the configuration picture, however the two documented foreign keys are the primary integration points for eligibility and rate processing.