DBA Data[Home] [Help] [Dependency Information]

TABLE: IEM.IEM_EMAIL_CLASSIFICATIONS

Object Details
Object Name: IEM_EMAIL_CLASSIFICATIONS
Object Type: TABLE
Owner: IEM
FND Design Data: TableIEM.IEM_EMAIL_CLASSIFICATIONS
Subobject Name:
Status: VALID


This table contains classifications assigned to each email message and their scores. There can be a maximum of 7 classifications per message. This table has a high frequency of usage. The data stored here is purged on completion of an email interaction.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEM_EMAIL_CLASSIFICATIONS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_ID
ColumnEMAIL_ACCOUNT_ID
ColumnCLASSIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER (15) Yes Sequence generated identifier. Uniquely Identifies an email message.
CLASSIFICATION_ID NUMBER (15) Yes Foreign key from IEM_CLASSIFICATIONS.
SCORE NUMBER

Percentage match score.
EMAIL_ACCOUNT_ID NUMBER (15) Yes Foreign key from IEM_EMAIL_ACCOUNTS.
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.
CLASSIFICATION_STRING VARCHAR2 (4000)
Classification String
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT MESSAGE_ID
,      CLASSIFICATION_ID
,      SCORE
,      EMAIL_ACCOUNT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CLASSIFICATION_STRING
,      SECURITY_GROUP_ID
FROM IEM.IEM_EMAIL_CLASSIFICATIONS;

Dependencies

[top of page]

IEM.IEM_EMAIL_CLASSIFICATIONS does not reference any database object

IEM.IEM_EMAIL_CLASSIFICATIONS is referenced by following:

SchemaAPPS
SynonymIEM_EMAIL_CLASSIFICATIONS