VIEW: IEM.IEM_DOC_USAGE_STATS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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