[Home] [Help] [Dependency Information]
Object Name: | IEM_RT_INTERACTIONS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Contains information about an agents current interactions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
IEM.IEM_RT_INTERACTIONS does not reference any database object
IEM.IEM_RT_INTERACTIONS is referenced by following:
|
|
|