Results for “ben_elig_hrly_slrd_prte_f”

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

Overview

BEN.BEN_ELIG_HRLY_SLRD_PRTE_F is a table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. Its documented purpose is to identify the hourly or salaried value used for inclusion or exclusion in a compensation object. In practical terms, this table stores the eligibility rule criteria that determine whether an employee qualifies for a particular benefit based on whether the person is classified as an hourly or salaried worker. It is one of several eligibility criteria tables that feed the Benefits eligibility engine, which evaluates participant eligibility against configured benefit programs and plans.

The ETRM metadata classifies this object, heuristically, as a standalone Data Vault model. This suggests that the table can be modeled as an independent satellite-like structure anchored by its own surrogate identifier rather than as a true hub or link, since no foreign-key relationships were mined from the schema. Practitioners designing downstream data vault or warehouse models may treat it accordingly, while still recognizing the implicit association with the eligibility profile via ELIGY_PRFL_ID.

Key Information Stored

The table contains 47 documented columns in the 12.2.2 physical schema. The most significant columns are:

• ELIG_HRLY_SLRD_PRTE_ID — surrogate primary key component identifying each eligibility record.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — together with the surrogate ID, they form the composite primary key BEN_ELIG_HRLY_SLRD_PRTE_F_PK, providing the date-tracked, business-key candidate for the record.
• ELIGY_PRFL_ID — identifies the eligibility profile this criterion belongs to, linking the rule to a specific profile configuration.
• BUSINESS_GROUP_ID — the operating business group (legal entity) context for the record.
• HRLY_SLRD_CD — the hourly or salaried classification code that the rule evaluates.
• EXCLD_FLAG — indicates whether the hourly/salaried value is used to include or exclude the person from the compensation object.
• EHS_ATTRIBUTE_CATEGORY and EHS_ATTRIBUTE1 through EHS_ATTRIBUTE30 — flexible descriptive flexfield attribute slots for capturing additional qualifying criteria.
• ORDR_NUM, CRITERIA_SCORE, and CRITERIA_WEIGHT — support ordering and scoring when multiple eligibility criteria are evaluated together.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and OBJECT_VERSION_NUMBER — standard WHO columns and optimistic locking for audit and concurrency control.

Common Use Cases and Queries

This table is queried when administrators or consultants need to understand why a given employee was included in or excluded from a benefit program based on hourly versus salaried status. A typical reporting query joins the criterion to its eligibility profile and the underlying person or assignment data:

• Reviewing all hourly/salaried criteria configured for a specific eligibility profile:

  SELECT c.elig_hrly_slrd_prte_id, c.hrly_slrd_cd, c.excld_flag, c.ordr_num
  FROM   ben_elig_hrly_slrd_prte_f c
  WHERE  c.eligy_prfl_id = :p_profile_id
  AND    SYSDATE BETWEEN c.effective_start_date AND c.effective_end_date;

• Auditing configuration changes by filtering on last_update_date and last_updated_by.
• Confirming that exclusion rules (EXCLD_FLAG = 'Y') are correctly set for salaried-only or hourly-only benefit plans.
• Feeding downstream eligibility extracts or data warehouse models, where the effective-dated primary key supports slowly changing dimension logic.

Related Objects

Although the ETRM metadata describes this table as standalone with no mined foreign keys, its functional relationships within Advanced Benefits are well established:

• BEN_ELIGY_PRFL_F — the eligibility profile header, joined on ELIGY_PRFL_ID and the effective-date columns.
• BEN_ELIG_HRLY_SLRD_PRTE — the non-date-tracked base table when only current records are required.
• BEN_ELIG_HRLY_SLRD_PRTE_F_PK — the primary key index enforcing uniqueness on the surrogate ID and effective dates.
• BEN_PGM_F, BEN_PL_F — benefit program and plan definitions that consume the eligibility profile.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F — person and assignment tables supplying the hourly/salaried context evaluated against this rule.
• BEN_ELIG_*_PRTE_F tables — parallel criteria tables (age, compensation, employment, etc.) that follow the same pattern.

Together these objects form the configuration layer through which Advanced Benefits determines participant eligibility, making BEN_ELIG_HRLY_SLRD_PRTE_F a dependable reference point for debugging and reporting on compensation-based inclusion rules.