Results for “ben_brgng_unit_rt_f”

50+ results




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

Overview

BEN_BRGNG_UNIT_RT_F is a date-tracked (effective-dated) table in the BEN schema of Oracle E-Business Suite Advanced Benefits (BEN). It stores rates associated with a bargaining unit, allowing benefit administrators to define and maintain rate values that apply to specific bargaining units over defined periods of time. The table forms part of the compensation and rate configuration layer of Advanced Benefits, linking a bargaining unit identifier to a variable rate profile so that the correct rate is applied when benefits eligibility and calculations are processed.

The "_F" suffix indicates that the table follows Oracle's standard date-effective (datetrack) design pattern, where rows are versioned using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Based on the mined foreign-key structure, this object is classified heuristically as standalone under Data Vault modeling conventions. In practice, this suggests it may best be modeled as a satellite-style table keyed by its own identifier and effective dates, rather than as a hub or link, though this classification is a modeling suggestion rather than a documented constraint.

Key Information Stored

Each row represents a rate for a bargaining unit effective over a specific date range. The primary key BEN_BRGNG_UNIT_RT_F_PK is composed of BRGNG_UNIT_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, uniquely identifying each rate version. The most significant columns are:

  • BRGNG_UNIT_RT_ID — surrogate primary key identifier for the bargaining unit rate record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective bounds defining when this rate version applies.
  • BUSINESS_GROUP_ID — the business group (enterprise) that owns the record, supporting multi-tenant partitioning.
  • BRGNG_UNIT_CD — the bargaining unit code identifying which unit the rate applies to.
  • VRBL_RT_PRFL_ID — reference to the variable rate profile that supplies the actual rate values.
  • EXCLD_FLAG — indicates whether the record or its members are excluded from a rate or processing rule.
  • ORDR_NUM — ordering sequence used when multiple rate rows are presented or evaluated.
  • BUR_ATTRIBUTE_CATEGORY and BUR_ATTRIBUTE1 … BUR_ATTRIBUTE30 — the descriptive flexfield (DFF) context and segment columns, allowing customers to extend the table with organization-specific attributes.
  • OBJECT_VERSION_NUMBER — optimistic locking version, used to detect concurrent updates.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle WHO audit columns.

The business-key candidate is the unique index BEN_BRGNG_UNIT_RT_F_PK, distinguishing it from the surrogate BRGNG_UNIT_RT_ID alone.

Common Use Cases and Queries

Typical uses include resolving the effective rate for a bargaining unit on a given date, auditing rate history, and driving rate-dependent benefit calculations. A date-effective lookup pattern is common:

  • Identify the effective rate profile for a bargaining unit as of a date: filter on BRGNG_UNIT_CD or BRGNG_UNIT_RT_ID where SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE, and BUSINESS_GROUP_ID equals the target enterprise.
  • Reconstruct historical rate changes by ordering rows by EFFECTIVE_START_DATE for a given BRGNG_UNIT_RT_ID.
  • Report all bargaining units not carrying a rate profile, or those flagged via EXCLD_FLAG, to support configuration audits.
  • Join to the variable rate profile to expand actual rate amounts for payroll or benefits costing analysis.

Related Objects

The documented relationship metadata classifies this object as standalone, meaning no foreign keys were mined directly. In Advanced Benefits, it physically relates to the following logical dependencies:

  • BEN_VRBL_RT_PRFL_F — referenced via VRBL_RT_PRFL_ID; supplies the rate profile definition.
  • BEN_BRGNING_UNIT_F — the bargaining unit master, joined via BRGNG_UNIT_CD or the unit identifier.
  • PER_BUSINESS_GROUPS — joined via BUSINESS_GROUP_ID for enterprise context.
  • Advanced Benefits UI and the Benefits Administration responsibility, which maintain these rate records through concurrent programs and forms.
  • The BEN_WHO audit columns align with standard EBS audit conventions shared across BEN tables.