Search Results jtf_ih_media_itm_lc_seg_tys_pk

Overview

The table JTF_IH_MEDIA_ITM_LC_SEG_TYS is a core reference data object within the Oracle E-Business Suite CRM Foundation module (JTF). It functions as a master lookup table that defines the distinct types or categories of media lifecycle segments. A media lifecycle segment represents a specific interval of time attributed to a customer interaction (media item) within the Interaction History system, such as time spent in a queue, in active service, or on hold. This table provides the standardized descriptors for these segments, enabling consistent categorization, tracking, and reporting of interaction timelines across the application. Its primary role is to maintain data integrity and provide meaning to the time intervals logged in operational tables.

Key Information Stored

The table's central purpose is to store unique identifiers and descriptions for lifecycle segment types. The most critical column is MILCS_TYPE_ID, which serves as the primary key. This numeric identifier uniquely defines each segment type, such as 'ACD_QUEUE_TIME' or 'AGENT_WORK_TIME'. While the provided metadata does not list all columns, a typical structure for such a reference table would include columns for the segment type name (e.g., NAME), a user-friendly description (e.g., DESCRIPTION), and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing. The data in this table is relatively static, populated during implementation or patch application, and defines the universe of valid segment types the system can process.

Common Use Cases and Queries

This table is primarily used in two contexts: data validation and descriptive reporting. Operationally, its MILCS_TYPE_ID values are used as foreign key constraints to ensure that only predefined segment types are logged against media items. For reporting and analytics, it is joined to transactional data to translate numeric type IDs into meaningful labels. A common query involves summarizing interaction handling times by segment type.

Sample Query:
SELECT TYP.NAME AS SEGMENT_TYPE,
       COUNT(SEG.MEDIA_ITEM_LC_SEG_ID) AS COUNT,
       SUM(SEG.DURATION) AS TOTAL_DURATION
FROM JTF_IH_MEDIA_ITEM_LC_SEGS SEG,
     JTF_IH_MEDIA_ITM_LC_SEG_TYS TYP
WHERE SEG.MILCS_TYPE_ID = TYP.MILCS_TYPE_ID
AND SEG.MEDIA_ITEM_ID = :p_media_item_id
GROUP BY TYP.NAME;

Related Objects

The table JTF_IH_MEDIA_ITM_LC_SEG_TYS has a direct parent-child relationship with the main transactional table for media lifecycle segments. The documented foreign key relationship is as follows:

• Primary Key (PK): JTF_IH_MEDIA_ITM_LC_SEG_TYS_PK on column MILCS_TYPE_ID.
• Foreign Key (FK) Reference: The table JTF_IH_MEDIA_ITEM_LC_SEGS contains a foreign key column, JTF_IH_MEDIA_ITEM_LC_SEGS.MILCS_TYPE_ID, which references JTF_IH_MEDIA_ITM_LC_SEG_TYS.MILCS_TYPE_ID. This enforces that every lifecycle segment recorded must correspond to a valid, predefined type from this reference table.

This relationship is fundamental to the data model, ensuring that all time interval data captured in the system is categorized according to a controlled, auditable set of types defined in JTF_IH_MEDIA_ITM_LC_SEG_TYS.