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.
-
Rate for a bargaining unit.
-
Rate for a bargaining unit.
-
View: BEN_BRGNG_UNIT_RT_D 12.2.2
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_D·↳ BEN_BRGNG_UNIT_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_USER·Explore BEN module →
-
PACKAGE: APPS.BEN_BUR_BUS 12.2.2
-
View: BEN_BRGNG_UNIT_RT_D 12.1.1
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_D·↳ BEN_BRGNG_UNIT_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
PACKAGE: APPS.BEN_BUR_BUS 12.1.1
-
View: BEN_BRGNG_UNIT_RT_V 12.2.2
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_V·↳ BEN_BRGNG_UNIT_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_BRGNG_UNIT_RT_X 12.2.2
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_X·↳ BEN_BRGNG_UNIT_RT_F·Explore BEN module →
-
View: BEN_BRGNG_UNIT_RT_X 12.1.1
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_X·↳ BEN_BRGNG_UNIT_RT_F·Explore BEN module →
-
PACKAGE: APPS.BEN_BUR_SHD 12.1.1
-
PACKAGE: APPS.BEN_BUR_SHD 12.2.2
-
View: BEN_BRGNG_UNIT_RT 12.2.2
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT·↳ BEN_BRGNG_UNIT_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_BRGNG_UNIT_RT 12.1.1
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT·↳ BEN_BRGNG_UNIT_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_BRGNG_UNIT_RT_V 12.1.1
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_V·↳ BEN_BRGNG_UNIT_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
PACKAGE: APPS.BEN_BUR_DEL 12.1.1