[Home] [Help] [Dependency Information]
Object Name: | IEM_AGENT_SESSIONS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
IEM Agent Sessions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_AGENT_SESSIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AGENT_ID
REF_KEY |
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. |
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;
IEM.IEM_AGENT_SESSIONS does not reference any database object
IEM.IEM_AGENT_SESSIONS is referenced by following:
|
|
|