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: BIX.BIX_DM_EMAIL_SUM

Object Details

Object Name:	BIX_DM_EMAIL_SUM
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

This table stores email center measures . The dimensions are email account, classification and time . The data is summarized to half hour bucket .

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_DM_EMAIL_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME EMAIL_ACCOUNT_ID CLASSIFICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EMAIL_SUMMARY_ID	NUMBER		Yes	Unique identifier generated from a sequence .
EMAIL_ACCOUNT_ID	NUMBER	(15)	Yes	Unique identifier for the email account .
CLASSIFICATION_ID	NUMBER	(15)	Yes	Unique identifier for the classification .
PERIOD_START_DATE	DATE		Yes	The date that the measures correspond to .
PERIOD_START_TIME	VARCHAR2	(5)	Yes	The half-hour bucket that the measures correspond to .
PERIOD_START_DATE_TIME	DATE		Yes	The date-time that the measures correspond to . This column is a concatenation of the columns period_start_date and period_start_time .
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column .
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column .
CREATION_DATE	DATE		Yes	Standard Who Column .
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column .
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column .
EMAILS_OFFERED	NUMBER			Number of emails that has come to the email server .
EMAILS_REMAINING_IN_QUEUE	NUMBER			Number of emails remaining in the system queue at the end of the time bucket .
QUEUE_TIME	NUMBER			Total time the emails were lying in the system queue before being fetched .
MAX_QUEUE_TIME	NUMBER			The maximum time an email was lying in the system queue before being fetched by an agent .
EMAILS_IN_Q_DURING_TIME_PERIOD	NUMBER			Number of emails that were in system queue during the time period .
OLDEST_MESSAGE_IN_QUEUE	DATE			The time of arrival of the email in the system queue , that has spent maximum time in system queue before being fetched by an agent .
EMAILS_FETCHED	NUMBER			Number of emails fetched from the queue by the agent .
EMAILS_REPLIED	NUMBER			Number of emails replied by the agent .
EMAILS_REPLIED_WITHIN_GOAL	NUMBER			Number of emails replied by the agent within a threshold time , defined by the user as a profile .
EMAILS_DELETED	NUMBER			Number of emails deleted by the agent .
EMAILS_TRANSFERRED	NUMBER			Number of emails transferred by the agent to another agent .
EMAILS_OPEN	NUMBER			Number of emails that are open at the end of the time bucket .
OLDEST_OPEN_MESSAGE	DATE			The fetch time of the email which is lying in the agent queue for the maximum time .
OPEN_AGE	NUMBER			The time the email was in the agent queue before it was replied or deleted or transferred .
EMAILS_OPEN_DURING_TIME_PERIOD	NUMBER			Number of emails that are open during the time period .
EMC_RESPONSE_TIME	NUMBER			The difference between the time the email has come to the system and the time the email was replied or deleted by an agent .
COMPLETE_AGENT_RESPONSE_TIME	NUMBER			The difference between the time agent has fetched the email and the time the email was replied or deleted or transferred by the agent .
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column .
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment .
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment .
SECURITY_GROUP_ID	NUMBER			Subscriber id for CRM Online Services use .
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record .
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record .
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update this record .
PROGRAM_UPDATE_DATE	DATE			Date when a concurrent program last updated this record .
OLDEST_OPEN_AGE	DATE			The no of days for which the oldest email open, is open

Query Text

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


SELECT EMAIL_SUMMARY_ID
,      EMAIL_ACCOUNT_ID
,      CLASSIFICATION_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      PERIOD_START_DATE_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EMAILS_OFFERED
,      EMAILS_REMAINING_IN_QUEUE
,      QUEUE_TIME
,      MAX_QUEUE_TIME
,      EMAILS_IN_Q_DURING_TIME_PERIOD
,      OLDEST_MESSAGE_IN_QUEUE
,      EMAILS_FETCHED
,      EMAILS_REPLIED
,      EMAILS_REPLIED_WITHIN_GOAL
,      EMAILS_DELETED
,      EMAILS_TRANSFERRED
,      EMAILS_OPEN
,      OLDEST_OPEN_MESSAGE
,      OPEN_AGE
,      EMAILS_OPEN_DURING_TIME_PERIOD
,      EMC_RESPONSE_TIME
,      COMPLETE_AGENT_RESPONSE_TIME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE14
,      ATTRIBUTE13
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OLDEST_OPEN_AGE
FROM BIX.BIX_DM_EMAIL_SUM;

Dependencies

[top of page]

BIX.BIX_DM_EMAIL_SUM does not reference any database object

BIX.BIX_DM_EMAIL_SUM is referenced by following:

APPS: BIX_DM_EMAIL_SUM