Search Results ben_tcs_stmt_task




Overview
Explore in AI Chat

Overview

BEN_TCS_STMT_TASK is a transactional table within the BEN (Advanced Benefits) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It identifies the tasks associated with a benefits statement, forming the operational link between a statement record and the discrete task lines that must be completed, tracked, or communicated as part of that statement. This object supports benefits statement generation and the downstream task-driven workflow used by plan administrators and participants.

From a Data Vault modeling perspective, the heuristic classification supplied for this object is standalone. The table carries its own surrogate primary key and a foreign key to BEN_TCS_STMT, but the FK structure does not suggest a broader hub-and-link network. In dimensional terms it behaves as a child/detail table hanging off the statement header.

Key Information Stored

The table contains eleven documented columns. The most significant are:

  • STMT_TASK_ID — Surrogate primary key, defined by the BEN_TCS_STMT_TASK_PK constraint. Uniquely identifies each statement-task row and is the value other objects would use in a foreign key relationship.
  • STMT_ID — Foreign key to BEN_TCS_STMT. Associates the task with its parent statement and is the primary join column in most queries.
  • TASK_CD — The task code, and the leading column of the unique index BEN_TCS_STMT_TASK_U1 (paired with STMT_ID). This is the business-key candidate that, together with the statement, determines the logical uniqueness of a task line.
  • TASK_NUMBER — The ordinal or sequence number for the task within the statement, used for display ordering and enumeration.
  • STAT_CD — Status code reflecting the current state of the task (for example, open or complete, per the applicable lookup).
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording when, by whom, and through which login the row was last modified.
  • CREATED_BY, CREATION_DATE — Standard EBS audit columns recording row creation.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle AOL framework to detect concurrent updates and prevent lost updates during concurrent processing.

The distinction between the surrogate key (STMT_TASK_ID, enforced by BEN_TCS_STMT_TASK_PK) and the business-key candidate (STMT_ID plus TASK_CD, enforced by BEN_TCS_STMT_TASK_U1, which references STMT_TASK_ID in the documented definition) is important when designing extracts and integration interfaces.

Common Use Cases and Queries

Typical reporting and integration scenarios include extracting all tasks for a given statement, monitoring outstanding items by status, and joining statement tasks back to the statement header for participant-facing communications.

  • Retrieve all tasks for a statement: SELECT STMT_TASK_ID, STMT_ID, TASK_CD, TASK_NUMBER, STAT_CD FROM BEN.BEN_TCS_STMT_TASK WHERE STMT_ID = :stmt_id ORDER BY TASK_NUMBER;
  • Count open tasks per statement for workload reporting: group by STMT_ID and filter on STAT_CD.
  • Reconcile statement tasks with the parent statement using BEN_TCS_STMT_TASK.STMT_ID = BEN_TCS_STMT.STMT_ID.
  • Detect stale or concurrent updates by checking OBJECT_VERSION_NUMBER values against the source system during migration or interface loads.

Related Objects

  • BEN_TCS_STMT — Parent statement table; joined on STMT_ID. The sole documented foreign key target.
  • BEN_TCS_STMT_TASK_PK / BEN_TCS_STMT_TASK_U1 — Primary and unique constraints governing row identity.
  • BEN_TCS_* statement family — Sibling detail tables (for example statement recipient and delivery objects) that share the STMT_ID lineage and are commonly queried together.
  • FND lookup tables (FND_LOOKUP_VALUES) — Resolve STAT_CD and TASK_CD to their display meanings.
  • BEN_TCS_STMT_TASK views and PL/SQL APIs — Application-level entry points used by the Advanced Benefits statement program to insert and maintain task rows.