eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JTF.JTF_IH_INTERACTIONS_STG

Object Details

Object Name:	JTF_IH_INTERACTIONS_STG
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_IH_INTERACTIONS_STG
Subobject Name:
Status:	VALID

A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Interaction Activities can occur during an Interaction. A single Interaction can be can include multiple forms of communications (Media Items) between the customer and agent. An Interaction can be related to Customers, Campaigns, Users, Orders, Quotes, etc

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_IH_INTERACTIONS_STG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERACTION_ID
JTF_IH_INTERACTIONS_STG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERACTION_ID	NUMBER	(15)	Yes	Unique Interaction Identifier
SESSION_NO	NUMBER			Session Number for JTF_IH_IMPORT
SESSION_DATE	DATE			Session Date for JTF_IH_IMPORT
STATUS_FL	NUMBER	(1)		Status Flag for JTF_IH_IMPORT
OBJECT_VERSION_NUMBER	NUMBER	(9)		Sequential number used for database locking control when using HTML as a user interface.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
INTERACTION_INTERS_ID	NUMBER			Links Interactions
OBJECT_ID	NUMBER			The Primary Key for the Oracle Marketing table relating to the object type.
OBJECT_TYPE	VARCHAR2	(30)		Oracle Marketing type of source code.
SOURCE_CODE	VARCHAR2	(100)		Source Code provided by the customer
SOURCE_CODE_ID	NUMBER			Unique identifier for Marketing Source Code
REFERENCE_FORM	VARCHAR2	(1000)		Legacy column for 3i Interaction Manager
DURATION	NUMBER			The number of seconds that the interaction was active
END_DATE_TIME	DATE			The date and time the interaction ended
FOLLOW_UP_ACTION	VARCHAR2	(80)		Legacy column for 3i Interaction Manager
NON_PRODUCTIVE_TIME_AMOUNT	NUMBER			The number of seconds the agent was considered non-productive since the end of the last interaction and end of the current interaction.
RESULT_ID	NUMBER			Result Identifier
REASON_ID	NUMBER			Reason Identifier
START_DATE_TIME	DATE			The date and time the interaction started
OUTCOME_ID	NUMBER		Yes	Outcome Identifier
PREVIEW_TIME_AMOUNT	NUMBER			The number of seconds the agent previewed the interaction item before initiating the interaction
PRODUCTIVE_TIME_AMOUNT	NUMBER			The number of seconds the agent was considered productive since the end of the last interaction and end of the current interaction.
HANDLER_ID	NUMBER		Yes	Handler Identifier from FND_APPLICATION
INTER_INTERACTION_DURATION	NUMBER			The number of seconds between the end of the last interaction and the beginning of the current interaction
WRAP_UP_TIME_AMOUNT	NUMBER			The number of seconds that agent spent on the interaction from the closing of the last media item to the conclusion of the interaction.
SCRIPT_ID	NUMBER			Script Identifier
PARTY_ID	NUMBER		Yes	Party Identifier for Customer
TOUCHPOINT1_TYPE	VARCHAR2	(30)		Interaction touchpoint type
RESOURCE_ID	NUMBER		Yes	Resource Identifier for Agent
TOUCHPOINT2_TYPE	VARCHAR2	(30)		Interaction touchpoint type
METHOD_CODE	VARCHAR2	(30)		Legacy column for 3i Interaction Manager
ORG_ID	NUMBER	(32)		Organization identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ACTIVE	VARCHAR2	(1)	Yes	Used for Interaction History caching.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PUBLIC_FLAG	VARCHAR2	(1)		Public Flag
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)		Orig System Reference
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Orig System Reference Id
UPGRADED_STATUS_FLAG	VARCHAR2	(1)		Upgrade Status Flag
UPG_ORIG_SYSTEM_REF	VARCHAR2	(60)		Upg Orig System Ref
UPG_ORIG_SYSTEM_REF_ID	NUMBER			Upg Orig System Ref Id
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
CONTACT_PARTY_ID	NUMBER			Contact Party Identifier
CONTACT_REL_PARTY_ID	NUMBER			Contact Party Relationship Identifier
PRIMARY_PARTY_ID	NUMBER			Primary Party Identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERACTION_ID
,      SESSION_NO
,      SESSION_DATE
,      STATUS_FL
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INTERACTION_INTERS_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      REFERENCE_FORM
,      DURATION
,      END_DATE_TIME
,      FOLLOW_UP_ACTION
,      NON_PRODUCTIVE_TIME_AMOUNT
,      RESULT_ID
,      REASON_ID
,      START_DATE_TIME
,      OUTCOME_ID
,      PREVIEW_TIME_AMOUNT
,      PRODUCTIVE_TIME_AMOUNT
,      HANDLER_ID
,      INTER_INTERACTION_DURATION
,      WRAP_UP_TIME_AMOUNT
,      SCRIPT_ID
,      PARTY_ID
,      TOUCHPOINT1_TYPE
,      RESOURCE_ID
,      TOUCHPOINT2_TYPE
,      METHOD_CODE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACTIVE
,      SECURITY_GROUP_ID
,      PUBLIC_FLAG
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPGRADED_STATUS_FLAG
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CONTACT_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      PRIMARY_PARTY_ID
FROM JTF.JTF_IH_INTERACTIONS_STG;

Dependencies

[top of page]

JTF.JTF_IH_INTERACTIONS_STG does not reference any database object

JTF.JTF_IH_INTERACTIONS_STG is referenced by following:

JTF: JTF_IH_INTERACTIONS_STG#