Search Results ben_tcs_row_in_cat




Overview
Explore in AI Chat

Overview

BEN.BEN_TCS_ROW_IN_CAT is a table within the Oracle Advanced Benefits (BEN) module, documented as VALID across Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to identify the rows that belong to a compensation category — that is, it defines the individual line items that make up a compensation object structure used by Total Compensation Setup (TCS) and related Advanced Benefits processing.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is standalone. This means BEN_TCS_ROW_IN_CAT is not a connector/link table between two hubs, nor a satellite carrying descriptive attributes of another hub. It is better treated as an independent reference or configuration table (effectively its own hub), with its outbound dependency on BEN_TCS_CAT being a lookup relationship rather than a many-to-many resolution. Analysts building a Data Vault or star-schema layer should model it as a standalone dimension keyed by its surrogate primary key.

Key Information Stored

The table carries a documented physical schema of 12 columns owned by BEN. The most significant columns are:

  • ROW_IN_CAT_ID — the surrogate primary key, enforced by the constraint BEN_TCS_ROW_IN_CAT_PK and also backed by the unique index BEN_TCS_ROW_IN_CAT_U1. This is the single unique business-key candidate documented for the table.
  • CAT_ID — the foreign key to BEN_TCS_CAT, tying each row to its owning compensation category. This is the join column that gives the table its contextual meaning.
  • DISPLAY_NAME — the user-facing label for the row within the category.
  • ORDR_NUM — the sequence or ordering number controlling how the row is presented relative to sibling rows in the same category.
  • URL — an optional link associated with the row, supporting navigation or drill-down behavior.
  • STMT_GENERATED — a flag indicating whether the row is generated for statement purposes.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns that record who created and last modified the row and when.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the EBS framework to detect concurrent updates.

Note that the surrogate key (ROW_IN_CAT_ID) is distinct from the descriptive attributes; no natural composite business key is documented beyond this single unique index.

Common Use Cases and Queries

Typical usage centers on reporting and validation of compensation category configuration. Common patterns include retrieving all rows for a given category, checking ordering, and joining to the parent category:

  • Listing configured rows for a category: SELECT r.row_in_cat_id, r.display_name, r.ordr_num FROM ben.ben_tcs_row_in_cat r WHERE r.cat_id = :cat_id ORDER BY r.ordr_num;
  • Confirming a row appears in downstream hierarchy tables by joining on ROW_IN_CAT_ID.
  • Audit reporting using LAST_UPDATE_DATE and LAST_UPDATED_BY to trace configuration changes.

Because the table is configuration-oriented and relatively small, it is frequently used as a lookup dimension joined to the hierarchy tables listed below.

Related Objects

The table participates in a defined foreign key network that should be respected in any query or data model:

These relationships confirm that BEN_TCS_ROW_IN_CAT acts as an anchor for hierarchy and category-item definitions within Total Compensation Setup, making it a foundational reference point when tracing how compensation categories are composed and rendered.