[Home] [Help] [Dependency Information]
Object Name: | IEM_THEMES |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_THEMES |
Subobject Name: | |
Status: | VALID |
This table contains themes and their scores generated for an email by iMT. This table can be edited by the user, who can add, delete and reprioritize the themes and scores. The themes are identified as an Incoming email theme or as a response selection theme, based on their named purpose.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_THEMES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | THEME_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
THEME_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
CLASSIFICATION_ID | NUMBER | (15) | Yes | Sequence generated identifier. Foreign key from IEM_CLASSIFICATIONS table. |
THEME | VARCHAR2 | (1996) | InterMedia Text generated theme. These themes can also be entered by users. | |
SCORE | NUMBER | Percentage match score. | ||
QUERY_RESPONSE | VARCHAR2 | (1) | Q or R. Q denotes themes that are used to classify emails. R denoted themes that are used to query knowledge bases to generate suggested responses. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
DOC_COUNT | NUMBER | Holds number of documents containing this theme |
Cut, paste (and edit) the following text to query this object:
SELECT THEME_ID
, CLASSIFICATION_ID
, THEME
, SCORE
, QUERY_RESPONSE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, DOC_COUNT
FROM IEM.IEM_THEMES;
IEM.IEM_THEMES does not reference any database object
IEM.IEM_THEMES is referenced by following:
|
|
|