[Home] [Help] [Dependency Information]
Object Name: | IEM_DOC_USAGE_STATS# |
---|---|
Object Type: | VIEW |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_USAGE_STATS_ID | NUMBER | (15) | Yes | |
OUTBOUND_MSG_STATS_ID | NUMBER | (15) | Yes | |
REPLY_Y_N | VARCHAR2 | (1) | ||
KB_DOC_ID | NUMBER | (15) | Yes | |
TEMPLATE_Y_N | VARCHAR2 | (1) | ||
REPOSITORY | VARCHAR2 | (5) | Yes | |
MES_CATEGORY_ID | NUMBER | (15) | ||
INSERTED_Y_N | VARCHAR2 | (1) | ||
TOP_RANKED_INTENT | VARCHAR2 | (30) | ||
TOP_RANKED_INTENT_ID | NUMBER | (15) | ||
SUGGESTED_Y_N | VARCHAR2 | (1) | ||
IN_TOP_INTENT_Y_N | VARCHAR2 | (1) | ||
INTENT | VARCHAR2 | (30) | ||
INTENT_ID | NUMBER | (15) | ||
INTENT_SCORE | NUMBER | |||
INTENT_RANK | NUMBER | |||
DOCUMENT_RANK | NUMBER | |||
DOCUMENT_SCORE | NUMBER | |||
DATE_INSERTED | DATE | |||
SAVED_Y_N | VARCHAR2 | (1) | ||
DATE_SENT | DATE | |||
EMAIL_ACCOUNT_ID | NUMBER | (15) | ||
AUTO_INSERT_Y_N | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER |
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#;
|
|
|