Results for “ben_elig_hrs_wkd_prte_f”

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

Overview

BEN_ELIG_HRS_WKD_PRTE_F is an Oracle Advanced Benefits (BEN) datable table that stores the participation criteria defining which employees are included in or excluded from a compensation object based on the hours they work. In Oracle EBS 12.1.1 and 12.2.2, this table functions as a rules repository used by the Benefits eligibility engine when evaluating whether a person satisfies an eligibility profile's "hours worked" criterion. Each row represents one participation rule that references an hours-worked factor and carries an inclusion or exclusion flag.

From a Data Vault modeling perspective, the metadata's heuristic classification suggests this object is satellite-leaning. Operationally it behaves as an attribute-bearing child of a parent eligibility structure, with the descriptive rules (flag, factor reference, scoring, and descriptive flexfield attributes) attached to an identifiable rule and versioned across effective dates.

Key Information Stored

The table is date-effective and versioned, so its identity is composite.

• ELIG_HRS_WKD_PRTE_ID — the surrogate identifier for a specific hours-worked participation rule. Combined with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, it forms the unique index BEN_ELIG_HRS_WKD_PRTE_F_PK, making these three columns the business-key candidates for the row.
• HRS_WKD_IN_PERD_FCTR_ID — foreign key to BEN_HRS_WKD_IN_PERD_FCTR, pointing to the hours-worked-in-period factor that supplies the actual threshold or computed value used in the comparison.
• EXCLD_FLAG — indicates whether the rule excludes (Y) or includes (N) matching persons, controlling the direction of the eligibility outcome.
• ELIGY_PRFL_ID — associates the rule with its parent eligibility profile, tying the criterion back to the profile that owns it.
• BUSINESS_GROUP_ID — the legislative/enterprise grouping that scopes the rule.
• ORDR_NUM, CRITERIA_SCORE, and CRITERIA_WEIGHT — support ordered evaluation and, where profiles use scoring, weighted criteria assessment.
• EHW_ATTRIBUTE_CATEGORY and EHW_ATTRIBUTE1 through EHW_ATTRIBUTE30 — a descriptive flexfield structure that captures customer-defined contextual attributes for the rule.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and OBJECT_VERSION_NUMBER — the standard who-columns and optimistic-locking version stamp.

Common Use Cases and Queries

Typical use cases include auditing which hours-worked criteria belong to a given eligibility profile, reconciling inclusion versus exclusion rules, and reporting the thresholds applied to specific populations.

• Retrieve all current rules for an eligibility profile: query BEN_ELIG_HRS_WKD_PRTE_F filtering on ELIGY_PRFL_ID where SYSDATE between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
• Join to BEN_HRS_WKD_IN_PERD_FCTR on HRS_WKD_IN_PERD_FCTR_ID = HRS_WKD_IN_PERD_FCTR_ID to resolve the factor name and value behind each criterion.
• Report exclusion rules by filtering EXCLD_FLAG = 'Y' to isolate criteria that disqualify employees.
• Reconstruct historical eligibility logic by querying without the SYSDATE predicate and ordering by EFFECTIVE_START_DATE to view the version chain per ELIG_HRS_WKD_PRTE_ID.
• Extract flexfield detail for integration or interface loads by selecting EHW_ATTRIBUTE_CATEGORY and the relevant EHW_ATTRIBUTEn columns.

Related Objects

• BEN_HRS_WKD_IN_PERD_FCTR — referenced via HRS_WKD_IN_PERD_FCTR_ID; supplies the hours-worked-in-period factor used by each rule.
• BEN_ELIGY_PRFL — the eligibility profile entity associated through ELIGY_PRFL_ID that owns the participation criteria.
• BEN_ELIG_HRS_WKD_PRTE — the non-dated/interface counterpart commonly used in setup and concurrent processing flows.
• BEN_ELIG_FACTOR_SEL_F and other BEN_ELIG_*_F rule tables — sibling criteria tables within the same eligibility profile framework.
• BEN_PGM_F, BEN_PL_F, and BEN_OIPL_F — program, plan, and option-in-plan entities that ultimately consume eligibility outcomes produced by these rules.

Benefits setup, eligibility batch evaluation, and downstream compensation reporting all rely on this table to translate hours-worked policy into executable inclusion and exclusion logic.