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: IEM.IEM_RT_INTERACTIONS

Object Details

Object Name:	IEM_RT_INTERACTIONS
Object Type:	TABLE
Owner:	IEM
Subobject Name:
Status:	VALID

Contains information about an agents current interactions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_RT_INTERACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RT_INTERACTION_ID
IEM_RT_INTERACTIONS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RT_INTERACTION_ID	NUMBER	(15)	Yes	Primary Key
CUSTOMER_ID	NUMBER	(15)		Customer ID from TCA
INTERACTION_ID	NUMBER	(15)		Interaction ID from TCA
RESOURCE_ID	NUMBER	(15)		RESOURCE; Agent_ID
STATUS	VARCHAR2	(2)		Work_In-Progress P ; Wrapup W; "Check Constraint allowable values P, W"
TYPE	VARCHAR2	(2)		Inbound I; Outbound O; "Check Constraint allowable values I,0"
EXPIRE	VARCHAR2	(1)		Expire ID
CREATED_BY	NUMBER		Yes	FND Who Columns
CREATION_DATE	DATE		Yes	FND Who Columns
LAST_UPDATED_BY	NUMBER		Yes	FND Who Columns
LAST_UPDATE_DATE	DATE		Yes	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER			FND Who Columns
SECURITY_GROUP_ID	NUMBER			Security Group ID, used for hosted services
SERVICE_REQUEST_ID	NUMBER	(15)		A service request id for an SR associated with this email
SERVICE_REQUEST_ACTION	VARCHAR2	(8)		Set depending on whether the SR was created or updated by email center.
CONTACT_ID	NUMBER	(15)		The HZ PARTY Id of the contact.
MC_PARAMETER_ID	NUMBER	(15)		Foreign key reference to message component parameter data.
IH_CREATOR	VARCHAR2	(1)		Indicates if eMC Client is the creator of the interaction.
INB_TAG_ID	VARCHAR2	(30)		Original Inbound message's tag Id.
PARENT_INTERACTION_ID	NUMBER	(15)		Original inbound message's interaction id.
ACTION_ID	NUMBER	(15)		Action ID to use with Outbox processing
ACTION_ITEM_ID	NUMBER	(15)		Action Item Id to use with Outbox processing.
REASON_ID	NUMBER	(15)		Reason Id to use with Outbox processing.
RESULT_ID	NUMBER	(15)		Result Id to use with Outbox processing.
OUTCOME_ID	NUMBER	(15)		Outcome Id to use with Outbox processing.
TO_RESOURCE_ID	NUMBER	(15)		Transfer Agent Id.
APPLICATION_ID	NUMBER	(15)		Application Id of the application entering this item in the Outbox.
RESPONSIBILITY_ID	NUMBER	(15)		Responsibility Id of the application entering this item in the Outbox.
LEAD_ID	NUMBER	(15)		Lead Id if any associated with this interaction.
LEAD_ACTION	VARCHAR2	(8)		The create/update actions.
SPV_RESOURCE_ID	NUMBER			Supervisor Resource Id.
RELATIONSHIP_ID	NUMBER	(15)		Party Relationship PARTY_ID related to the interaction.

Query Text

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


SELECT RT_INTERACTION_ID
,      CUSTOMER_ID
,      INTERACTION_ID
,      RESOURCE_ID
,      STATUS
,      TYPE
,      EXPIRE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      SERVICE_REQUEST_ID
,      SERVICE_REQUEST_ACTION
,      CONTACT_ID
,      MC_PARAMETER_ID
,      IH_CREATOR
,      INB_TAG_ID
,      PARENT_INTERACTION_ID
,      ACTION_ID
,      ACTION_ITEM_ID
,      REASON_ID
,      RESULT_ID
,      OUTCOME_ID
,      TO_RESOURCE_ID
,      APPLICATION_ID
,      RESPONSIBILITY_ID
,      LEAD_ID
,      LEAD_ACTION
,      SPV_RESOURCE_ID
,      RELATIONSHIP_ID
FROM IEM.IEM_RT_INTERACTIONS;

Dependencies

[top of page]

IEM.IEM_RT_INTERACTIONS does not reference any database object

IEM.IEM_RT_INTERACTIONS is referenced by following:

IEM: IEM_RT_INTERACTIONS#