Results for “drr_attribute_category”

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

Overview

The BEN.BEN_DSGN_RQMT_RLSHP_TYP table is a configuration and setup object within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, available in both the 12.1.1 and 12.2.2 releases. Its documented purpose is to define the required relationship type to designate against a design requirement, forming part of the flexible configuration layer that governs how benefits offerings target and constrain eligible participants. Records in this table associate a design requirement (DSGN_RQMT_ID) with a specific relationship type code (RLSHP_TYP_CD), enabling plan designers to express rules such as "this plan is available only to employees with a Spouse relationship" or "this coverage applies to Dependent children."

The ETRM metadata classifies this object heuristically as standalone under the Data Vault mining model, meaning the FK analysis did not surface conformed dimensions or parent references within the documented schema itself. In practice this table behaves as a satellite-like configuration entity attached to the design requirement, but the standalone classification is noted here as a modeling suggestion only. The table is owned by the BEN schema, carries a status of VALID, and is documented with 41 physical columns in the 12.2.2 data model.

Key Information Stored

The surrogate primary key is DSGN_RQMT_RLSHP_TYP_ID, enforced by the unique index BEN_DSGN_RQMT_RLSHP_TYP_PK. No separate business-key unique index is documented beyond this PK, so the surrogate identifier is the sole documented uniqueness guarantee.

• DSGN_RQMT_RLSHP_TYP_ID — Surrogate primary key; system-generated identifier for each required relationship type row.
• DSGN_RQMT_ID — Foreign reference to the parent design requirement that owns the relationship-type rule.
• RLSHP_TYP_CD — The designated relationship type code (for example, the relationship whose presence is required to satisfy the design requirement).
• BUSINESS_GROUP_ID — Multi-tenant discriminator identifying the business group (enterprise) that owns the configuration row.
• DRR_ATTRIBUTE_CATEGORY and DRR_ATTRIBUTE1 through DRR_ATTRIBUTE30 — A thirty-column descriptive flexfield (DFF) block used to capture customer-specific context attributes without schema change.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework (OAF) and concurrent update detection.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the last modification timestamp, user, and session login.
• CREATED_BY, CREATION_DATE — Standard WHO creation audit columns.

Common Use Cases and Queries

The primary use case is administrative: verifying which relationship types are mandated for a given design requirement during benefits plan setup or troubleshooting eligibility failures. A typical query joins the table to its parent design requirement and looks up the relationship type description:

• List all required relationship types for a design requirement: SELECT dsgn_rqmt_id, rlshp_typ_cd FROM ben.ben_dsgn_rqmt_rlshp_typ WHERE dsgn_rqmt_id = :p_id;
• Business-group scoped extract: SELECT * FROM ben.ben_dsgn_rqmt_rlshp_typ WHERE business_group_id = :bg_id;
• Audit reconciliation: filter on last_update_date and last_updated_by to detect configuration drift between environments.
• DFF reporting: project drr_attribute_category plus selected drr_attributeN columns to surface customer-specific rule metadata in extracts.

Because the table is flagged as standalone, its typical role in reporting is as a reference dimension feeding eligibility and design-requirement rule analysis, rather than as a transactional fact source.

Related Objects

Although the mined FK structure indicates a standalone classification, the columns documented above imply logical dependencies on core BEN tables. The most significant related objects include:

• BEN.BEN_DSGN_RQMT — Parent design requirement table, joined on DSGN_RQMT_ID.
• BEN.BEN_RLSHP_TYP — Relationship type definition, joined on RLSHP_TYP_CD.
• BEN.BEN_PGM and BEN.BEN_PGM_DSGN — Program-level parents that drive design requirement generation.
• BEN.BEN_ELIG_RLSHP_TYP — Related eligibility relationship configuration often consulted alongside this table.
• FND standard WHO audit views and OAF-based benefits setup pages that expose these configuration rows through the Advanced Benefits UI.