Search Results jtf_ih_interactions_stg




Overview
Explore in AI Chat

Overview

The JTF.JTF_IH_INTERACTIONS_STG table is a staging table within the JTF (CRM Foundation) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It records the contact point between a customer, customer system, or potential customer and a single human or automated agent, referred to as a Handler and Handler Resource. An interaction may be timed and carries an outcome and a result that can be tracked, and multiple activities may be associated with a single interaction. The table serves as the landing and intermediate structure through which interaction data flows before consolidation into the operational Interaction History model, supporting the CRM Foundation's telephony, telesales, and interaction-management capabilities.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as satellite-leaning. Its dependency structure—anchored on a single primary key with descriptive attributes, script references, party references, and security-group references—suggests a satellite entity attached to an interaction hub key rather than a pure transactional hub or an associative link. This classification should be treated as a modeling suggestion rather than a certified Data Vault assignment.

Key Information Stored

The table is documented with 67 columns under the JTF schema. The most significant of these are summarized below.

The primary key is purely surrogate; no documented unique business-key index is asserted in the supplied metadata, so PARTY_ID and SESSION_NO serve as candidate business identifiers for reconciliation rather than enforced uniqueness constraints.

Common Use Cases and Queries

Typical uses include validating staged interaction loads, reconciling interaction history against source telephony systems, and reporting agent productivity and interaction outcomes.

  • Locate the staged interaction for a given party: SELECT INTERACTION_ID, SESSION_NO, START_DATE_TIME, OUTCOME_ID FROM JTF.JTF_IH_INTERACTIONS_STG WHERE PARTY_ID = :party_id;
  • Measure productive versus non-productive time by handler: aggregate DURATION, PRODUCTIVE_TIME_AMOUNT, and NON_PRODUCTIVE_TIME_AMOUNT grouped by HANDLER_ID.
  • Identify records pending upgrade or originating from external systems: filter on UPGRADED_STATUS_FLAG or ORIG_SYSTEM_REFERENCE.
  • Join to JTF_IH_ACTIVITIES_STG on INTERACTION_ID to trace the activities within a staged interaction.
  • Invoke the processing concurrent program via PROGRAM_ID, REQUEST_ID, and PROGRAM_UPDATE_DATE for load-audit reporting.

Related Objects

  • JTF_IH_ACTIVITIES_STG — references this table through JTF_IH_ACTIVITIES_STG.INTERACTION_ID; the principal child table of staged interactions.
  • HZ_PARTIES — referenced by JTF_IH_INTERACTIONS_STG.PARTY_ID; supplies customer and contact party data.
  • JTF_IH_SCRIPTS — referenced by SCRIPT_ID; defines the script applied to the interaction.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; governs security grouping for row access.
  • JTF_IH_INTERACTIONS_STG_PK — the primary key constraint enforcing uniqueness of INTERACTION_ID.

Together these relationships confirm the staging table's role as a satellite structure anchored on the interaction key and integrated with the CRM Foundation's interaction, party, script, and security models.