Search Results ben_dsbld_rt_f_pk




Overview
Explore in AI Chat

Overview

BEN_DSBLD_RT_F is a table in the BEN (Advanced Benefits) product module of Oracle E-Business Suite, holding the rate definitions associated with disability plans and options. The suffix _F denotes a date-tracked (datetrack) table, meaning every row is bounded by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE so that historical rate configurations are preserved alongside current ones. The table is owned by the BEN schema and is documented as a VALID object in both ETRM 12.1.1 and 12.2.2 releases.

Functionally, the table records how a disability benefit is priced — the disability code, whether the row is excluded, and the variable rate profile that drives the calculation — along with descriptive flexfield attributes and standard WHO columns. Because it is classified heuristically as a standalone Data Vault object (no incoming or outgoing foreign-key links were mined), it is best modeled as a satellite: a descriptive, rate-bearing object keyed by its own surrogate identifier rather than as a hub or link connecting multiple business entities.

Key Information Stored

The documented physical schema reports 45 columns. The most significant are:

  • DSBLD_RT_ID — the surrogate primary key component, uniquely identifying a disability rate record together with its datetrack dates.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the datetrack boundaries that complete the primary key and support date-effective querying.
  • DSBLD_CD — the disability code that ties the rate to a specific disability definition.
  • EXCLD_FLAG — indicates whether the rate record is excluded from eligibility or processing.
  • VRBL_RT_PRFL_ID — references the variable rate profile used to compute the disability rate.
  • BUSINESS_GROUP_ID — the HR business group owning the record, used for multi-tenant filtering.
  • DBR_ATTRIBUTE_CATEGORY and DBR_ATTRIBUTE1 … DBR_ATTRIBUTE30 — the descriptive flexfield segments that capture client-specific attributes.
  • ORDR_NUM — the ordering sequence applied when displaying or processing rate rows.
  • OBJECT_VERSION_NUMBER — used for optimistic locking by the Oracle Applications framework.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard WHO audit columns.

The unique index BEN_DSBLD_RT_F_PK on (DSBLD_RT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) is the business-key candidate; DSBLD_RT_ID alone is the surrogate identifier, with the dates providing temporal uniqueness.

Common Use Cases and Queries

Typical scenarios include validating which disability rates are currently effective, identifying excluded rates for a plan, and reporting on rate configurations by business group. A current-effective query pattern is:

  • SELECT DSBLD_RT_ID, DSBLD_CD, VRBL_RT_PRFL_ID, ORDR_NUM FROM BEN.BEN_DSBLD_RT_F WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND BUSINESS_GROUP_ID = :p_bg_id;
  • Filtering excluded rows: add AND NVL(EXCLD_FLAG,'N') = 'N'.
  • Auditing recent changes: order by LAST_UPDATE_DATE DESC and restrict by LAST_UPDATED_BY.

Reporting use cases include reconstructing historical disability rates as of a past date and joining the variable rate profile to explain how a premium was derived.

Related Objects

Based on the documented FK/PK structure, BEN_DSBLD_RT_F is standalone with no mined foreign keys. The most significant associated objects are therefore join targets rather than dependent children, and include the disability definition tables keyed by DSBLD_CD, the variable rate profile tables referenced through VRBL_RT_PRFL_ID, the HR business group table referenced by BUSINESS_GROUP_ID, and the standard date-track and WHO audit infrastructure shared across BEN datetrack tables. The primary key BEN_DSBLD_RT_F_PK is the principal documented relationship anchor for query joins within the Advanced Benefits module.