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.
HRLY_SLRD_RT_ID— surrogate identifier for the rate definition record.EFFECTIVE_START_DATE/EFFECTIVE_END_DATE— the date-tracked validity window of the rate.HRLY_SLRD_CD— the code distinguishing hourly versus salaried rate behavior.BUSINESS_GROUP_ID— multi-tenant partition identifying the enterprise group owning the record.EXCLD_FLAG— inclusion/exclusion indicator applied to the rate rule.ORDR_NUM— sequencing attribute controlling evaluation or display order.VRBL_RT_PRFL_ID— reference to the associated variable rate profile.HSR_ATTRIBUTE_CATEGORYandHSR_ATTRIBUTE1throughHSR_ATTRIBUTE30— a flexible descriptive flexfield (DFF) block for customer-defined attributes.OBJECT_VERSION_NUMBER,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE— standard Oracle EBS audit and concurrency-control columns.
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..30for client-specific rate segmentation. - Data extraction into downstream payroll or benefits cost models using
VRBL_RT_PRFL_IDlinkage.
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:
BEN_VRBL_RT_PRFL_F— variable rate profile header joined viaVRBL_RT_PRFL_ID.BEN_VRBL_RT_RL_F— variable rate rules parented by the rate profile.BEN_PGM_F— program definitions referencing rate setups.BEN_PL_F— plan definitions that consume hourly/salaried rates.BEN_ELIG_F— eligibility definitions using rate criteria.FND_OBJECTS/FND_FORM_FUNCTIONS— registration of the maintaining forms and functions.
-
Rate applicable to Hourly or Salaried workers.
-
Rate applicable to Hourly or Salaried workers.
-
PACKAGE: APPS.BEN_HSR_BUS 12.1.1
-
View: BEN_HRLY_SLRD_RT_D 12.2.2
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_D·↳ BEN_HRLY_SLRD_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_USER·Explore BEN module →
-
PACKAGE: APPS.BEN_HSR_BUS 12.2.2
-
View: BEN_HRLY_SLRD_RT_D 12.1.1
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_D·↳ BEN_HRLY_SLRD_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
PACKAGE: APPS.BEN_HSR_SHD 12.2.2
-
PACKAGE: APPS.BEN_HSR_SHD 12.1.1
-
View: BEN_HRLY_SLRD_RT_X 12.1.1
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_X·↳ BEN_HRLY_SLRD_RT_F·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT_X 12.2.2
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_X·↳ BEN_HRLY_SLRD_RT_F·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT_V 12.1.1
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_V·↳ BEN_HRLY_SLRD_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT 12.1.1
- Retrofitted
APPS.BEN_HRLY_SLRD_RT·↳ BEN_HRLY_SLRD_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT 12.2.2
- Retrofitted
APPS.BEN_HRLY_SLRD_RT·↳ BEN_HRLY_SLRD_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT_V 12.2.2
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_V·↳ BEN_HRLY_SLRD_RT_F·↳ FND_SESSIONS·Explore BEN module →