Results for “ben_hrly_slrd_rt_f”

50+ results




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

Overview

The BEN_HRLY_SLRD_RT_F table resides in the BEN schema and is a core configuration object within the Oracle Advanced Benefits (BEN) module. It stores the rates applicable to Hourly or Salaried workers, serving as the repository for rate definitions that drive eligibility, contribution, and cost calculations for compensation-based benefit plans. In Oracle EBS 12.1.1 and 12.2.2, this table is registered as VALID and is documented with 45 physical columns in the ETRM 12.2.2 repository.

From a heuristic Data Vault modeling perspective, the ETRM metadata classifies this object as standalone. This classification reflects the absence of mined foreign key relationships in the documented structure, suggesting the object functions as an independent reference or rate definition entity rather than participating in a conventional hub-link-satellite topology. The standalone designation should be treated as a modeling suggestion; the table's effective-dated key structure nonetheless exhibits date-tracked, historized characteristics typical of satellite patterns.

Key Information Stored

The table is defined by a composite primary key constraint, BEN_HRLY_SLRD_RT_F_PK, comprising HRLY_SLRD_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. This triple forms both the surrogate identity and the effective-dating mechanism, allowing multiple historical versions of a rate definition to coexist. The metadata reports no additional unique indexes, so these three columns remain the sole documented business-key candidates.

Common Use Cases and Queries

The primary use case is resolving the effective rate for an hourly or salaried worker at a point in time. Reporting queries typically constrain on the effective date window to avoid overlapping versions.

  • Current active rate lookup: SELECT HRLY_SLRD_RT_ID, HRLY_SLRD_CD FROM BEN_HRLY_SLRD_RT_F WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND BUSINESS_GROUP_ID = :p_bg_id;
  • Historical audit trail of rate changes ordered by ORDR_NUM.
  • Flexfield-based reporting on HSR_ATTRIBUTE1..30 for client-specific rate segmentation.
  • Data extraction into downstream payroll or benefits cost models using VRBL_RT_PRFL_ID linkage.

Related Objects

The ETRM metadata documents this object as standalone with no mined foreign key relationships. Practically, the following BEN-module objects are commonly referenced alongside it through application logic and shared identifiers such as HRLY_SLRD_RT_ID, VRBL_RT_PRFL_ID, and BUSINESS_GROUP_ID: