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_POST_MDTS

Object Details

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

Processed Meta Data information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_POST_MDTS_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	MESSAGE_ID
IEM_POST_MDTS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMAIL_ACCOUNT_ID RT_CLASSIFICATION_ID GROUP_ID
IEM_POST_MDTS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AGENT_ID
IEM_POST_MDTS_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RFC822_MESSAGE_ID
IEM_POST_MDTS_U5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
IEM_POST_MDTS_U7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMAIL_ACCOUNT_ID RECEIVED_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
MESSAGE_ID	NUMBER	(15)	Yes	Mail messages OES ID
EMAIL_ACCOUNT_ID	NUMBER	(15)		Id of the email account
RT_CLASSIFICATION_ID	NUMBER	(15)		Route classification Id
AGENT_ID	NUMBER	(15)		Agent Id
GROUP_ID	NUMBER	(15)		ID of the routing group
MESSAGE_SIZE	NUMBER	(15)		Size of the message
SENDER_NAME	VARCHAR2	(128)		Name of the sender
USER_NAME	VARCHAR2	(256)		Users Name
DOMAIN_NAME	VARCHAR2	(128)		Name of the domain
PRIORITY	VARCHAR2	(20)		Priority of the message
MSG_STATUS	VARCHAR2	(50)		Status of the message
SUBJECT	VARCHAR2	(240)		Subject of the message
SENT_DATE	DATE			Date on which message was sent
CUSTOMER_ID	NUMBER	(15)		Customer Identification
PRODUCT_ID	NUMBER	(15)		Product Indentification
EMAIL_CLASSIFICATION	VARCHAR2	(50)		Name of the Top Classification for the message
SCORE_PERCENT	NUMBER			Score of the classification
ICENTER_MAP_ID	NUMBER	(15)		Interaction Center Map Id
IH_MEDIA_ITEM_ID	NUMBER	(15)		Interaction History Media Id
RFC822_MESSAGE_ID	VARCHAR2	(300)		Internal Indentification of the message
MESSAGE_UID	NUMBER	(15)		Message identifier
LANGUAGE	VARCHAR2	(50)		Langauge of the message
CONTENT_TYPE	VARCHAR2	(300)		Content type of the message
MAILER	VARCHAR2	(300)		Name of the Mailer
ORGANIZATION	VARCHAR2	(100)		Name fo the Oraganization
DFLT_AGT_ID	NUMBER	(15)		Default Agent Id
MESSAGE_TYPE	VARCHAR2	(30)		Type of the message
RECEIVED_DATE	DATE			Date of Receipt
END_DATE	DATE			Date of End Iteraction
MAIL_ITEM_STATUS	VARCHAR2	(30)		Status of the mail items
SOURCE_MESSAGE_ID	NUMBER	(15)		OES Message ID
ATTRIBUTE1	VARCHAR2	(150)		Attribute column number 1 descriptive flexfild segment
ATTRIBUTE2	VARCHAR2	(150)		Attribute column number 2 descriptive flexfild segment
ATTRIBUTE3	VARCHAR2	(150)		Attribute column number 3 descriptive flexfild segment
ATTRIBUTE4	VARCHAR2	(150)		Attribute column number 4 descriptive flexfild segment
ATTRIBUTE5	VARCHAR2	(150)		Attribute column number 5 descriptive flexfild segment
ATTRIBUTE6	VARCHAR2	(150)		Attribute column number 6 descriptive flexfild segment
ATTRIBUTE7	VARCHAR2	(150)		Attribute column number 7 descriptive flexfild segment
ATTRIBUTE8	VARCHAR2	(150)		Attribute column number 7 descriptive flexfild segment
ATTRIBUTE9	VARCHAR2	(150)		Attribute column number 9 descriptive flexfild segment
ATTRIBUTE10	VARCHAR2	(150)		Attribute column number 10 descriptive flexfild segment
ATTRIBUTE11	VARCHAR2	(150)		Attribute column number 11 descriptive flexfild segment
ATTRIBUTE12	VARCHAR2	(150)		Attribute column number 12 descriptive flexfild segment
ATTRIBUTE13	VARCHAR2	(150)		Attribute column number 13 descriptive flexfild segment
ATTRIBUTE14	VARCHAR2	(150)		Attribute column number 14 descriptive flexfild segment
ATTRIBUTE15	VARCHAR2	(150)		Attribute column number 15 descriptive flexfild segment
SECURITY_GROUP_ID	NUMBER			Security group Identification
CREATED_BY	NUMBER	(15)	Yes	FND Who Columns
CREATION_DATE	DATE		Yes	FND Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	FND Who Columns
LAST_UPDATE_DATE	DATE		Yes	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		FND Who Columns
FROM_AGENT_ID	NUMBER	(15)		Stores the agent_id of the previous resource that has transferred this email item.
QUEUE_STATUS	VARCHAR2	(1)		Indicates the staus of the email in the queue.
IH_INTERACTION_ID	NUMBER	(15)		Interaction Id.
MESSAGE_FLAG	VARCHAR2	(1)		Message Flag. 'E' for Escalated.
TO_ADDRESS	VARCHAR2	(240)		To address of the email header.
CATEGORY_MAP_ID	NUMBER			Stores MES category Id for messages that are processed using alternate suggested response.

Query Text

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


SELECT MESSAGE_ID
,      EMAIL_ACCOUNT_ID
,      RT_CLASSIFICATION_ID
,      AGENT_ID
,      GROUP_ID
,      MESSAGE_SIZE
,      SENDER_NAME
,      USER_NAME
,      DOMAIN_NAME
,      PRIORITY
,      MSG_STATUS
,      SUBJECT
,      SENT_DATE
,      CUSTOMER_ID
,      PRODUCT_ID
,      EMAIL_CLASSIFICATION
,      SCORE_PERCENT
,      ICENTER_MAP_ID
,      IH_MEDIA_ITEM_ID
,      RFC822_MESSAGE_ID
,      MESSAGE_UID
,      LANGUAGE
,      CONTENT_TYPE
,      MAILER
,      ORGANIZATION
,      DFLT_AGT_ID
,      MESSAGE_TYPE
,      RECEIVED_DATE
,      END_DATE
,      MAIL_ITEM_STATUS
,      SOURCE_MESSAGE_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FROM_AGENT_ID
,      QUEUE_STATUS
,      IH_INTERACTION_ID
,      MESSAGE_FLAG
,      TO_ADDRESS
,      CATEGORY_MAP_ID
FROM IEM.IEM_POST_MDTS;

Dependencies

[top of page]

IEM.IEM_POST_MDTS does not reference any database object

IEM.IEM_POST_MDTS is referenced by following:

IEM: IEM_POST_MDTS#