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_DOC_USAGE_STATS

Object Details

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

This table stores one row per each document that is either inserted or attached in an outbound email from eMail Center.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_DOC_USAGE_STATS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_USAGE_STATS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_USAGE_STATS_ID	NUMBER	(15)	Yes	Primary Key.
OUTBOUND_MSG_STATS_ID	NUMBER	(15)	Yes	Foreign key into IEM_OUTBOUND_MSG_STATS.
REPLY_Y_N	VARCHAR2	(1)		Indicated if the document was inserted as part of a reply or a compose.
KB_DOC_ID	NUMBER	(15)	Yes	Document Id in the knowledge base.
TEMPLATE_Y_N	VARCHAR2	(1)		Indicates if the document is from the template category assigned in eMail Center.
REPOSITORY	VARCHAR2	(5)	Yes	Short name of the repository from where the document was taken.
MES_CATEGORY_ID	NUMBER	(15)		Category Id from which the document was taken from MES repository.
INSERTED_Y_N	VARCHAR2	(1)		Indicates if the document was inserted or attached.
TOP_RANKED_INTENT	VARCHAR2	(30)		Name of the top intent
TOP_RANKED_INTENT_ID	NUMBER	(15)		Id of the top ranked intent.
SUGGESTED_Y_N	VARCHAR2	(1)		Indicats if the document was suggested by the the processing engine.
IN_TOP_INTENT_Y_N	VARCHAR2	(1)		Indicates of the document existed in the top intent suggested by the processing engine.
INTENT	VARCHAR2	(30)		Name of the intent from where the document was taken.
INTENT_ID	NUMBER	(15)		Id of the intent from where the document was taken.
INTENT_SCORE	NUMBER			Score of the Intent from where the document was taken.
INTENT_RANK	NUMBER			Rank of the Intent from where the document was taken.
DOCUMENT_RANK	NUMBER			Rank of the document within the Intent.
DOCUMENT_SCORE	NUMBER			Score of the document within the Intent.
DATE_INSERTED	DATE			Date stamp when the document was inserted or attached.
SAVED_Y_N	VARCHAR2	(1)		Indicates if the document was saved.
DATE_SENT	DATE			Date stamp when the email was sent.
EMAIL_ACCOUNT_ID	NUMBER	(15)		Foreign key into IEM_EMAIL_ACCOUNTS from where the outbound email was sent.
AUTO_INSERT_Y_N	VARCHAR2	(1)		Indicates if the document was automatically inserted by the processing or manually.
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
SECURITY_GROUP_ID	NUMBER			Security group Identification

Query Text

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


SELECT DOC_USAGE_STATS_ID
,      OUTBOUND_MSG_STATS_ID
,      REPLY_Y_N
,      KB_DOC_ID
,      TEMPLATE_Y_N
,      REPOSITORY
,      MES_CATEGORY_ID
,      INSERTED_Y_N
,      TOP_RANKED_INTENT
,      TOP_RANKED_INTENT_ID
,      SUGGESTED_Y_N
,      IN_TOP_INTENT_Y_N
,      INTENT
,      INTENT_ID
,      INTENT_SCORE
,      INTENT_RANK
,      DOCUMENT_RANK
,      DOCUMENT_SCORE
,      DATE_INSERTED
,      SAVED_Y_N
,      DATE_SENT
,      EMAIL_ACCOUNT_ID
,      AUTO_INSERT_Y_N
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM IEM.IEM_DOC_USAGE_STATS;

Dependencies

[top of page]

IEM.IEM_DOC_USAGE_STATS does not reference any database object

IEM.IEM_DOC_USAGE_STATS is referenced by following:

APPS: IEM_DOC_USAGE_STATS