Search Results ben_acty_vrbl_rt_f




Overview
Explore in AI Chat

Overview

BEN_ACTY_VRBL_RT_F is a dated (effective-dated) table in the BEN schema of Oracle E-Business Suite Advanced Benefits. Its documented purpose is to store variable rates for activity rates. In the Benefits rate engine, an activity rate represents a per-unit cost or credit associated with a participant activity, and that rate frequently varies according to a variable rate profile — for example, an age band, a service band, a salary tier, or a coverage-amount bracket. BEN_ACTY_VRBL_RT_F holds the individual rate rows that a variable rate profile produces for a given activity base rate, so that the rate engine can resolve the correct value during enrollment, rate calculation, and premium determination.

From a modeling perspective, the mined relationship metadata classifies this object as standalone, meaning no foreign key dependencies were detected in the documented FK structure. This should be treated as a heuristic suggestion rather than a definitive statement; functionally the table carries the characteristics of a rate-value satellite keyed by an activity variable rate identifier and effective dates. All rate resolution in Advanced Benefits is date-sensitive, and this table follows that convention through its effective start and end date columns.

Key Information Stored

The table is documented with 44 columns in the 12.2.2 physical schema. The most significant are:

Common Use Cases and Queries

The principal use case is rate verification and reconciliation: confirming which variable rate value the Benefits engine will select for a participant given a rate profile, base rate, and effective date. A second common use is configuration auditing — identifying gaps or overlaps in effective date ranges that would cause rate calculation failures. Reporting on historical rates (for example, reconstructing the rate in force on a prior payroll period) relies on querying as of a specific date.

A representative query pattern resolves the currently effective rate for a base rate:

  • Filter by ACTY_BASE_RT_ID and BUSINESS_GROUP_ID.
  • Constrain SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE.
  • Order by ORDR_NUM to respect the evaluation sequence.
  • Join to the variable rate profile to retrieve the profile's qualifying criteria.

Detecting date-range anomalies uses a self-join on ACTY_VRBL_RT_ID where one row's EFFECTIVE_END_DATE exceeds the next row's EFFECTIVE_START_DATE, or where a gap exists between consecutive rows. Reporting extracts typically decode the AVR_ATTRIBUTE columns using the flexfield definition registered against AVR_ATTRIBUTE_CATEGORY.

Related Objects

Because the documented model classifies this table as standalone, join relationships below are inferred from the documented column names rather than confirmed foreign keys:

  • BEN_ACTY_BASE_RT_F — the parent activity base rate; joined on ACTY_BASE_RT_ID.
  • BEN_VRBL_RT_PRFL_F — the variable rate profile that defines the variation criteria; joined on VRBL_RT_PRFL_ID.
  • BEN_ACTY_RT_F — the activity rate definition that owns the base rate consumed here.
  • BEN_ACTY_VRBL_RT — the non-dated (or translated/interface) counterpart frequently paired with this _F table.
  • BEN_PRTT_RT_VRBL_F — participant-level variable rate results derived from these definitions during enrollment processing.
  • BEN_ACTY_VRBL_RT_F_PK — the unique index enforcing the composite primary key on ACTY_VRBL_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE.

Rate maintenance is performed through the Benefits plan configuration and rate setup forms rather than through a public PL/SQL API; direct DML is not supported and should be avoided.