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

TABLE: IEM.IEM_AGENT_SESSIONS

Object Details
Object Name: IEM_AGENT_SESSIONS
Object Type: TABLE
Owner: IEM
Subobject Name:
Status: VALID


IEM Agent Sessions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEM_AGENT_SESSIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAGENT_ID
ColumnREF_KEY
Columns
Name Datatype Length Mandatory Comments
AGENT_ID VARCHAR2 (15) Yes Agent ID
WORK_MODE VARCHAR2 (10)
Work Mode
EDIT_MODE VARCHAR2 (10)
Edit Mode
MSG_KEY VARCHAR2 (32)
MSG Key
ACCOUNT_ID VARCHAR2 (15)
Account ID
CUSTOMER_ID VARCHAR2 (15)
Customer ID
CLASSIFICATION_ID VARCHAR2 (15)
Classification ID
CLASSIFICATION VARCHAR2 (50)
Classification
IM_MSG_ID VARCHAR2 (15)
IM MSG ID
LAST_UPDATE_DATE DATE

FND Who Columns
SECURITY_GROUP_ID NUMBER

Security Group ID, used for hosted services
CONTACT_ID VARCHAR2 (15)
Customer Contact Id.
CUSTOMER_EMAIL VARCHAR2 (2000)
Customer email address.
REF_KEY VARCHAR2 (32)
Primary key in addition to Agent Id.
SERVICE_REQUEST VARCHAR2 (15)
Service Request Id associated with this message.
MCP_ID VARCHAR2 (15)
Foreign key reference to mc parameters.
INBOUND_MSG_KEY VARCHAR2 (32)
A special string version of the message key for the inbound message
LEAD_ID VARCHAR2 (15)
The Lead ID if any associated with this interaction.
Query Text

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


SELECT AGENT_ID
,      WORK_MODE
,      EDIT_MODE
,      MSG_KEY
,      ACCOUNT_ID
,      CUSTOMER_ID
,      CLASSIFICATION_ID
,      CLASSIFICATION
,      IM_MSG_ID
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      CONTACT_ID
,      CUSTOMER_EMAIL
,      REF_KEY
,      SERVICE_REQUEST
,      MCP_ID
,      INBOUND_MSG_KEY
,      LEAD_ID
FROM IEM.IEM_AGENT_SESSIONS;

Dependencies

[top of page]

IEM.IEM_AGENT_SESSIONS does not reference any database object

IEM.IEM_AGENT_SESSIONS is referenced by following:

SchemaAPPS
SynonymIEM_AGENT_SESSIONS