[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_IH_INTERACTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | JTF |
| FND Design Data: |  JTF.JTF_IH_INTERACTIONS
|
| 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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JTF_IH_INTERACTIONS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INTERACTION_ID
|
| JTF_IH_INTERACTIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESULT_ID
|
| JTF_IH_INTERACTIONS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
|
| JTF_IH_INTERACTIONS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| JTF_IH_INTERACTIONS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INTERACTION_INTERS_ID
|
| JTF_IH_INTERACTIONS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRODUCTIVE_TIME_AMOUNT
|
| JTF_IH_INTERACTIONS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTACT_PARTY_ID
|
| JTF_IH_INTERACTIONS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTACT_REL_PARTY_ID
|
| JTF_IH_INTERACTIONS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_PARTY_ID
|
| JTF_IH_INTERACTIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
HANDLER_ID
|
| JTF_IH_INTERACTIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REASON_ID
|
| JTF_IH_INTERACTIONS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OUTCOME_ID
|
| JTF_IH_INTERACTIONS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SCRIPT_ID
|
| JTF_IH_INTERACTIONS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
START_DATE_TIME
|
| JTF_IH_INTERACTIONS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
END_DATE_TIME
|
| JTF_IH_INTERACTIONS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_ID
|
| JTF_IH_INTERACTIONS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_CODE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERACTION_ID | NUMBER | (15) | Yes | Unique Interaction Identifier |
| 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 | 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 | |
| RESOURCE_ID | NUMBER | Yes | Resource Identifier for Agent | |
| 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 | ||
| TOUCHPOINT1_TYPE | VARCHAR2 | (30) | Interaction touchpoint type | |
| TOUCHPOINT2_TYPE | VARCHAR2 | (30) | Interaction touchpoint type | |
| 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). | ||
| BULK_WRITER_CODE | VARCHAR2 | (240) | Builk Writer Code | |
| BULK_BATCH_TYPE | VARCHAR2 | (240) | Subtype used by the calling Writer to categorize types of Interaction request | |
| BULK_BATCH_ID | NUMBER | Builk Batch Identifier | ||
| BULK_INTERACTION_ID | NUMBER | Interaction identifier | ||
| CONTACT_PARTY_ID | NUMBER | Contact Party Identifier | ||
| CONTACT_REL_PARTY_ID | NUMBER | Contact Party Relationship Identifier | ||
| PRIMARY_PARTY_ID | NUMBER | Primary Party Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT INTERACTION_ID
, 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
, RESOURCE_ID
, 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
, TOUCHPOINT1_TYPE
, TOUCHPOINT2_TYPE
, 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
, BULK_WRITER_CODE
, BULK_BATCH_TYPE
, BULK_BATCH_ID
, BULK_INTERACTION_ID
, CONTACT_PARTY_ID
, CONTACT_REL_PARTY_ID
, PRIMARY_PARTY_ID
FROM JTF.JTF_IH_INTERACTIONS;
JTF.JTF_IH_INTERACTIONS does not reference any database object
JTF.JTF_IH_INTERACTIONS is referenced by following:
JTF
JTF_IH_INTERACTIONS#
|
|
|
|