Results for “tsk_typ_attr_depend_id”

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

Overview

The table CUG_SR_TASK_ATTR_VALS_B is a base (B) transactional table owned by the CUG schema in Oracle E-Business Suite, introduced as part of the CUG — Citizen Interaction Center product. Its documented purpose is to store the values of Task Type Attributes for a Service Request Type. In practical terms, this is a configuration and reference table that associates a specific task type attribute mapping with the attribute dependency rules that govern how a Service Request task behaves, and with the actual values assigned.

The object contains ten documented columns and is protected by a primary key, CUG_SR_TASK_ATTR_VALS_B_PK, defined on the surrogate column SR_TASK_ATTR_VAL_ID. Based on the foreign key structure and usage patterns, the table is heuristic-classified as satellite-leaning in a Data Vault modeling sense. This indicates the table largely functions as a dependent attribute store attached to a parent hub or link rather than acting as an independent hub. No API or concurrent program references are documented in the ETRM metadata; the table is primarily populated and maintained through the Citizen Interaction Center configuration and service request setup flows.

Key Information Stored

The most significant columns in this table are:

• SR_TASK_ATTR_VAL_ID — the surrogate primary key and unique identifier for each attribute value row, defined by CUG_SR_TASK_ATTR_VALS_B_PK and repeated in unique index CUG_SR_TASK_ATTR_VALS_B_U1.
• TSK_TYP_ATTR_DEPEND_ID — foreign key to CUG_TSK_TYP_ATTR_DEPS_B, linking the value to a specific task type attribute dependency definition.
• TASK_TYPE_ATTR_MAP_ID — foreign key to CUG_TSK_TYP_ATTR_MAPS_B, identifying the task type attribute mapping the value belongs to. Together with TSK_TYP_ATTR_DEPEND_ID, this forms the business-key candidate unique index CUG_SR_TASK_ATTR_VALS_B_U2.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org and data security access control.
• OBJECT_VERSION_NUMBER — the standard EBS optimistic locking column used by the framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE — the standard EBS who-columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard who-columns capturing the last modifying user, timestamp, and login session.

The combination of the surrogate SR_TASK_ATTR_VAL_ID with the business-key candidate (TSK_TYP_ATTR_DEPEND_ID, TASK_TYPE_ATTR_MAP_ID) means that for any given dependency and attribute mapping pair only one value record should exist, and the surrogate key provides stable referential integrity for the translation table.

Common Use Cases and Queries

Typical scenarios include auditing the attribute values configured for service request task types, validating that every dependency has an assigned value, and joining to the translation table for multilingual descriptions.

A common reporting pattern resolves the descriptive text from the translation table:

SELECT b.SR_TASK_ATTR_VAL_ID,
       b.TSK_TYP_ATTR_DEPEND_ID,
       b.TASK_TYPE_ATTR_MAP_ID,
       t.DESCRIPTION
FROM   CUG.CUG_SR_TASK_ATTR_VALS_B  b,
       CUG.CUG_SR_TASK_ATTR_VALS_TL t
WHERE  b.SR_TASK_ATTR_VAL_ID = t.SR_TASK_ATTR_VAL_ID
AND    t.LANGUAGE = USERENV('LANG')
AND    b.SECURITY_GROUP_ID = :p_security_group;

A second pattern filters by attribute mapping to inspect all values assigned to a task type attribute, which is useful when troubleshooting task configuration behavior or validating setup during implementation.

Related Objects

• CUG_TSK_TYP_ATTR_DEPS_B — joined on TSK_TYP_ATTR_DEPEND_ID; defines the dependency rules for task type attributes.
• CUG_TSK_TYP_ATTR_MAPS_B — joined on TASK_TYPE_ATTR_MAP_ID; defines the mapping of attributes to task types.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs data security access.
• CUG_SR_TASK_ATTR_VALS_TL — the translation table, joined on SR_TASK_ATTR_VAL_ID; holds language-specific descriptions of each value record.