Results for “ben_tcs_cat_u1”

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

Overview

BEN.BEN_TCS_CAT is an Oracle E-Business Suite table that stores the Compensation Category definition for a Total Compensation statement. Total Compensation statements in Oracle Advanced Benefits aggregate salary, benefits, and other compensation elements into a consolidated view presented to employees. Each row in BEN_TCS_CAT represents one category (or section) of that statement, defining how a group of compensation items is titled, charted, and rendered on the statement output. The table resides in the APPS_TS_TX_DATA tablespace and is owned by the BEN schema.

From a dimensional modeling perspective, the Data Vault classification heuristic identifies this object as standalone, which suggests it behaves as a reference or hub-like entity rather than a transactional link or a satellite. Its surrogate primary key, BEN_TCS_CAT_PK on CAT_ID, anchors a set of child tables that reference categories by CAT_ID, reinforcing its role as a definition/master record within the statement configuration model.

Key Information Stored

The table carries eighteen documented columns. The most significant are the following:

• CAT_ID (NUMBER 15, mandatory) — the system-generated surrogate primary key. It is the column backing the unique index BEN_TCS_CAT_U1, making it the definitive unique identifier for a category row.
• NAME (VARCHAR2 240) — the category name used in setup and displayed on the statement.
• CAT_TYPE_CD (VARCHAR2 30) — the category type code; it is indexed non-uniquely via BEN_TCS_CAT_N1, supporting filtering by category type.
• CHART_TYPE_CD and CHART_ATTRIBUTE_CD (VARCHAR2 30) — control the charting behavior applied to the category.
• CONTRIBUTOR_CD and COMP_TYPE_CD (VARCHAR2 30) — identify the contributor and compensation type associated with the category.
• BUSINESS_GROUP_ID (NUMBER 15) — foreign key to HR_ORGANIZATION_UNITS, scoping the category to a specific business group.
• SHOW_CONTAINER_LINKS_FLAG (VARCHAR2 30) — Y/N flag controlling whether container links are shown; defaults to N.
• CONTAINER_TITLE (VARCHAR2 240) — the title shown for the container of links.
• NUMBER_OF_COLUMNS (NUMBER) — the count of custom columns defined in the category.
• NNMNTRY_UOM (VARCHAR2 30) — nonmonetary code for nonmonetary compensation categories.
• OBJECT_VERSION_NUMBER — optimistic locking column incremented on each update.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

The only documented unique index, BEN_TCS_CAT_U1 on CAT_ID, confirms CAT_ID as the business-key candidate for joins and lookups.

Common Use Cases and Queries

Typical usage centers on configuring and reporting on Total Compensation statement categories. A common query retrieves all categories for a business group ordered by name, and another filters by category type to inventory how categories are distributed.

• Setup verification: SELECT cat_id, name, cat_type_cd FROM ben.ben_tcs_cat WHERE business_group_id = :p_bg_id ORDER BY name;
• Category type inventory: SELECT cat_type_cd, COUNT(*) FROM ben.ben_tcs_cat GROUP BY cat_type_cd;
• Join to statement categories to list categories attached to a statement using BEN_TCS_STMT_CAT.CAT_ID.
• Audit of recently changed definitions using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Impact analysis: locate category usages across columns, rows, and objects in category via the child tables keyed on CAT_ID.

Related Objects

BEN_TCS_CAT is referenced by numerous dependent tables through CAT_ID. The most significant include:

• BEN_TCS_STMT_CAT — links categories to statements (CAT_ID).
• BEN_TCS_COL_IN_CAT — defines the columns within a category (CAT_ID).
• BEN_TCS_ROW_IN_CAT — defines the rows within a category (CAT_ID).
• BEN_TCS_ALL_OBJECTS_IN_CAT — enumerates objects assigned to a category (CAT_ID).
• BEN_TCS_CAT_LINK — holds container link definitions (CAT_ID).
• OKC_K_ARTICLES_BH and OKC_ARTICLE_TRANS_H — contract article tables referencing CAT_ID.
• OKC_SECTION_CONTENTS_H and OKC_K_ART_VARIABLES — additional OKC contract structures (CAT_ID).
• FA_XLA_EXT_LINES_B_GT and FA_XLA_EXT_LINES_STG_GT — global temporary staging tables referencing CAT_ID.

These relationships confirm the table's role as a definition hub consumed across benefits statement configuration and adjacent contract and subledger staging processes.