[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_EMAIL_AGENT_SUM |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
This table stores email center agent related measures . The dimensions are agent , time , classification and email account . The data is stored in half hour bucket .
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_DM_EMAIL_AGENT_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
EMAIL_ACCOUNT_ID CLASSIFICATION_ID RESOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMAIL_AGENT_SUMMARY_ID | NUMBER | Yes | Unique identifier generated from the sequence . | |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Yes | Unique identifier identifying the email accounts . |
CLASSIFICATION_ID | NUMBER | (15) | Yes | Unique identifier for the classification . |
RESOURCE_ID | NUMBER | Yes | Unique identifier for the resource . | |
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_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 date 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 |
Cut, paste (and edit) the following text to query this object:
SELECT EMAIL_AGENT_SUMMARY_ID
, EMAIL_ACCOUNT_ID
, CLASSIFICATION_ID
, RESOURCE_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_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_AGENT_SUM;
BIX.BIX_DM_EMAIL_AGENT_SUM does not reference any database object
BIX.BIX_DM_EMAIL_AGENT_SUM is referenced by following:
|
|
|