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: TableJTF.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_IH_INTERACTIONS_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERACTION_ID
JTF_IH_INTERACTIONS_STG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_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:

SchemaJTF
ViewJTF_IH_INTERACTIONS_STG#