Search Results ben_tcs_stmt

Overview

BEN_TCS_STMT is a table within the Advanced Benefits (BEN) module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It identifies a compensation structure definition used by the Total Compensation Statement (TCS) functionality. A statement acts as the top-level container that is composed of compensation categories and compensation items, allowing an organization to present a consolidated view of an employee's total compensation — salary, benefits, and other employer-provided contributions — in a single formatted output.

The table is owned by the BEN schema and is documented with 20 physical columns. Its primary key is BEN_TCS_STMT_PK, defined on the surrogate column STMT_ID. Based on the mined foreign-key structure, the heuristic Data Vault classification for this object is a standalone entity, suggesting it functions as a reference or definition master rather than a pure hub, link, or satellite within a dimensional model. In practice, it behaves as the anchor record against which downstream statement, category, and assignment records are registered.

Key Information Stored

The most significant columns include:

STMT_ID — the surrogate primary key, populated for every statement record and referenced by all dependent tables.
NAME — the user-facing name of the compensation statement, and a likely business-key candidate alongside the unique index BEN_TCS_STMT_U1 on STMT_ID.
BUSINESS_GROUP_ID — the operating unit or business group context governing the statement.
EE_PROFILE_ID — the employee profile association controlling eligibility for the statement.
STAT_CD and STATUS-related flags — the lifecycle state of the statement definition.
SHOW_WLCM_PG_CD — controls display of the welcome page in the generated statement.
STMT_GENERATED_FLAG and INDICATE_ESTIMATE_FLAG — indicate whether the statement has been produced and whether estimated amounts are shown.
MSG_TEXT — the message text presented to the recipient.
Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and OBJECT_VERSION_NUMBER for concurrency and traceability.
Email distribution columns EMAIL_PASSWORD_PROTECTED, EMAIL_CC_MANAGER, EMAIL_SUBJECT, EMAIL_CONTENT, and EMAIL_SAMPLE_ADDRESS support secure delivery of statements.

The unique index set includes BEN_TCS_STMT_U1 (STMT_ID) along with two system LOB indexes (SYS_IL0000394806C00008$$, SYS_IL0000394806C00019$$), which imply LOB columns are present among the documented attribute list.

Common Use Cases and Queries

Typical scenarios include reporting on defined compensation structures, verifying configuration before running statement generation, and auditing email distribution settings. A simple listing query returns all active statements for a business group:

SELECT stmt_id, name, stat_cd, business_group_id FROM ben.ben_tcs_stmt WHERE business_group_id = :p_bg_id;
Joining to the period and category tables retrieves statement contents: SELECT s.stmt_id, s.name, c.category_id FROM ben.ben_tcs_stmt s, ben.ben_tcs_stmt_cat c WHERE s.stmt_id = c.stmt_id;
Checking generation status: SELECT stmt_id, stmt_generated_flag, indicate_estimate_flag FROM ben.ben_tcs_stmt WHERE stat_cd = 'A';

Related Objects

The table is referenced by several dependent BEN objects through STMT_ID:

BEN_TCS_STMT_CAT — statement-to-category mapping (STMT_ID).
BEN_TCS_CAT_ITEM_HRCHY — category and item hierarchy (STMT_ID).
BEN_TCS_STMT_PERD and BEN_TCS_PER_STMT_PERD — period definitions for the statement.
BEN_TCS_ASG_STMT — assignment of the statement to persons (STMT_ID).
BEN_TCS_PER_ITEM — per-person compensation item values (STMT_ID).
BEN_TCS_REPORT_DETAILS and BEN_TCS_STMT_TASK — reporting and concurrent task tracking (STMT_ID).

Table: BEN_TCS_STMT 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT, object_name:BEN_TCS_STMT, status:VALID, product: BEN - Advanced Benefits , description: BEN_TCS_STMT identifies a compensation structure. Statement is composed of compensation categories and compensation items. , implementation_dba_data: BEN.BEN_TCS_STMT ,
Table: BEN_TCS_STMT 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT, object_name:BEN_TCS_STMT, status:VALID, product: BEN - Advanced Benefits , description: BEN_TCS_STMT identifies a compensation structure. Statement is composed of compensation categories and compensation items. , implementation_dba_data: BEN.BEN_TCS_STMT ,
SYNONYM: APPS.BEN_TCS_STMT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_TCS_STMT, status:VALID,
VIEW: BEN.BEN_TCS_STMT# 12.2.2
owner:BEN, object_type:VIEW, object_name:BEN_TCS_STMT#, status:VALID,
SYNONYM: APPS.BEN_TCS_STMT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_TCS_STMT, status:VALID,
VIEW: BEN.BEN_TCS_STMT# 12.2.2
TABLE: BEN.BEN_TCS_STMT 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT, object_name:BEN_TCS_STMT, status:VALID,
TABLE: BEN.BEN_TCS_STMT 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT, object_name:BEN_TCS_STMT, status:VALID,
TRIGGER: APPS.BEN_TCS_STMT_WHO 12.1.1
TRIGGER: APPS.BEN_TCS_STMT_WHO 12.1.1
owner:APPS, object_type:TRIGGER, object_name:BEN_TCS_STMT_WHO, status:VALID,
TRIGGER: APPS.BEN_TCS_STMT_WHO 12.2.2
owner:APPS, object_type:TRIGGER, object_name:BEN_TCS_STMT_WHO, status:VALID,
TABLE: BEN.BEN_TCS_CAT_SUBCAT_HRCHY 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_CAT_SUBCAT_HRCHY, object_name:BEN_TCS_CAT_SUBCAT_HRCHY, status:VALID,
TABLE: BEN.BEN_TCS_CAT_SUBCAT_HRCHY 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_CAT_SUBCAT_HRCHY, object_name:BEN_TCS_CAT_SUBCAT_HRCHY, status:VALID,
PACKAGE BODY: APPS.BEN_TCS_STMT_PROCESS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_TCS_STMT_PROCESS, status:VALID,
TRIGGER: APPS.BEN_TCS_STMT_WHO 12.2.2
TABLE: BEN.BEN_TCS_CAT_ITEM_HRCHY 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_CAT_ITEM_HRCHY, object_name:BEN_TCS_CAT_ITEM_HRCHY, status:VALID,
APPS.BEN_TCS_STMT_PROCESS SQL Statements 12.2.2
TABLE: BEN.BEN_TCS_CAT_ITEM_HRCHY 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_CAT_ITEM_HRCHY, object_name:BEN_TCS_CAT_ITEM_HRCHY, status:VALID,
PACKAGE BODY: APPS.BEN_TCS_STMT_PROCESS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_TCS_STMT_PROCESS, status:VALID,
TABLE: BEN.BEN_TCS_STMT_TASK 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_TASK, object_name:BEN_TCS_STMT_TASK, status:VALID,
TABLE: BEN.BEN_TCS_REPORT_DETAILS 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_REPORT_DETAILS, object_name:BEN_TCS_REPORT_DETAILS, status:VALID,
TABLE: BEN.BEN_TCS_STMT_TASK 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_TASK, object_name:BEN_TCS_STMT_TASK, status:VALID,
TABLE: BEN.BEN_TCS_STMT_CAT 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_CAT, object_name:BEN_TCS_STMT_CAT, status:VALID,
APPS.BEN_TCS_STMT_PROCESS SQL Statements 12.1.1
TABLE: BEN.BEN_TCS_PER_ITEM 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_PER_ITEM, object_name:BEN_TCS_PER_ITEM, status:VALID,
TABLE: BEN.BEN_TCS_PER_ITEM 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_PER_ITEM, object_name:BEN_TCS_PER_ITEM, status:VALID,
TABLE: BEN.BEN_TCS_REPORT_DETAILS 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_REPORT_DETAILS, object_name:BEN_TCS_REPORT_DETAILS, status:VALID,
TABLE: BEN.BEN_TCS_ASG_STMT 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_ASG_STMT, object_name:BEN_TCS_ASG_STMT, status:VALID,
TABLE: BEN.BEN_TCS_PER_STMT_PERD 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_PER_STMT_PERD, object_name:BEN_TCS_PER_STMT_PERD, status:VALID,
TABLE: BEN.BEN_TCS_PER_STMT_PERD 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_PER_STMT_PERD, object_name:BEN_TCS_PER_STMT_PERD, status:VALID,
TABLE: BEN.BEN_TCS_STMT_CAT 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_CAT, object_name:BEN_TCS_STMT_CAT, status:VALID,
TABLE: BEN.BEN_TCS_STMT_PERD 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_PERD, object_name:BEN_TCS_STMT_PERD, status:VALID,
TABLE: BEN.BEN_TCS_STMT_PERD 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_STMT_PERD, object_name:BEN_TCS_STMT_PERD, status:VALID,
TABLE: BEN.BEN_TCS_ASG_STMT 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_TCS_ASG_STMT, object_name:BEN_TCS_ASG_STMT, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_STMT 12.2.2
APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_STMT 12.1.1
PACKAGE BODY: APPS.BEN_TCS_STMT_PROCESS 12.2.2
PACKAGE BODY: APPS.BEN_TCS_STMT_PROCESS 12.1.1
APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_STMT_PERD 12.2.2
APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_STMT_PERD 12.1.1