[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIX_EMAIL_DETAILS_F |
|---|---|
| Object Type: | TABLE |
| Owner: | BIX |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BIX_EMAIL_DETAILS_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 EMAIL_ACCOUNT_ID
EMAIL_CLASSIFICATION_ID
AGENT_ID
PARTY_ID
OUTCOME_ID
RESULT_ID
REASON_ID
TIME_ID
PERIOD_TYPE_ID
PERIOD_START_DATE
PERIOD_START_TIME
|
| BIX_EMAIL_DETAILS_F_N5 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
REQUEST_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AGENT_ID | NUMBER | Yes | Foreign key to agent dimension | |
| EMAIL_ACCOUNT_ID | NUMBER | Yes | Foreign key to email account dimension | |
| EMAIL_CLASSIFICATION_ID | NUMBER | Yes | Foreign key to email classification dimension | |
| PARTY_ID | NUMBER | Yes | Customer id from whom email was received | |
| TIME_ID | NUMBER | Yes | Foreign key to time dimension | |
| PERIOD_TYPE_ID | NUMBER | Yes | Identifies the period type (day, week,month, quarter, year) | |
| PERIOD_START_DATE | DATE | Yes | Start date of the period for which email details are summarized | |
| PERIOD_START_TIME | VARCHAR2 | (5) | Yes | Start time of the period for which email details are summarized |
| CREATED_BY | NUMBER | Yes | Standard WHO column | |
| CREATION_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
| EMAILS_OFFERED_IN_PERIOD | NUMBER | New messages received in the time bucket | ||
| EMAILS_FETCHED_IN_PERIOD | NUMBER | Emails fetched by the agents from the queue in the time bucket | ||
| EMAILS_REPLIED_IN_PERIOD | NUMBER | Emails replied by the agents in the time bucket | ||
| EMAILS_RPLD_BY_GOAL_IN_PERIOD | NUMBER | Emails replied by the agents in the time bucket within the time period set as goal | ||
| EMAILS_DELETED_IN_PERIOD | NUMBER | Emails deleted by the agents in the time bucket | ||
| EMAILS_TRNSFRD_OUT_IN_PERIOD | NUMBER | Emails transferred out of the inbox by agents in the time bucket | ||
| EMAILS_TRNSFRD_IN_IN_PERIOD | NUMBER | Emails transferred by the agents in the time bucket | ||
| EMAILS_RSL_AND_TRFD_IN_PERIOD | NUMBER | Emails that are resolved in the time bucket which are transferred at least once | ||
| EMAILS_ASSIGNED_IN_PERIOD | NUMBER | Emails that are assigned to the agent in the time bucket | ||
| EMAILS_AUTO_ROUTED_IN_PERIOD | NUMBER | Emails automatically routed to the agent inbox in the time bucket | ||
| EMAILS_AUTO_UPTD_SR_IN_PERIOD | NUMBER | Emails resulting in automatic updating of the service request in the time bucket | ||
| SR_CREATED_IN_PERIOD | NUMBER | Total number of service requests created in the time bucket | ||
| ACCUMULATED_OPEN_EMAILS | NUMBER | Total number of emails remaining open at the end of the time bucket | ||
| ACCUMULATED_OPEN_AGE | NUMBER | Total open age of the emails remaining open during the time bucket | ||
| OLDEST_EMAIL_OPEN_DATE | DATE | Open date of the oldest message remaining open at the end of the time bucket | ||
| ACCUMULATED_EMAILS_IN_QUEUE | NUMBER | Total emails remaining in the queue at the end of the time bucket | ||
| ACCUMULATED_QUEUE_TIME | NUMBER | Total queue time for all the emails that are in queue during the time bucket | ||
| OLDEST_EMAIL_QUEUE_DATE | DATE | Date of arrival of the oldest email in the queue during the time bucket | ||
| EMAIL_RESP_TIME_IN_PERIOD | NUMBER | Total email response time for emails responded in the time bucket | ||
| AGENT_RESP_TIME_IN_PERIOD | NUMBER | Total agent response time for emails responded in the time bucket | ||
| ACCUMULATED_EMAILS_ONE_DAY | NUMBER | Backlogged emails that are less than 1 day old | ||
| ACCUMULATED_EMAILS_THREE_DAYS | NUMBER | Backlogged emails that are more than 1 day old but less than 3 days old | ||
| ACCUMULATED_EMAILS_WEEK | NUMBER | Backlogged emails that are more than 3 days old but less than 1 week old | ||
| ACCUMULATED_EMAILS_WEEK_PLUS | NUMBER | Backlogged emails that are more than 7 days old | ||
| ONE_RSLN_IN_PERIOD | NUMBER | Emails that are resolved in one reply in the period | ||
| TWO_RSLN_IN_PERIOD | NUMBER | Emails that are resolved in two replies in the period | ||
| THREE_RSLN_IN_PERIOD | NUMBER | Emails that are resolved in three replies in the period | ||
| FOUR_RSLN_IN_PERIOD | NUMBER | Emails that are resolved in four replies in the period | ||
| INTERACTION_THREADS_IN_PERIOD | NUMBER | Number of interaction threads in the bucket | ||
| 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 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | 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 | ||
| OUTCOME_ID | NUMBER | The outcome of the interaction | ||
| RESULT_ID | NUMBER | The result of the interaction | ||
| REASON_ID | NUMBER | Reason code of the interaction | ||
| EMAILS_AUTO_REPLIED_IN_PERIOD | NUMBER | Number of incoming emails that were automatically responded to | ||
| EMAILS_AUTO_DELETED_IN_PERIOD | NUMBER | Number of incoming emails that were automatically deleted | ||
| EMAILS_AUTO_RESOLVED_IN_PERIOD | NUMBER | Number of incoming emails for which a custom procedure or workflow was executed and the interaction closed | ||
| EMAILS_ORR_COUNT_IN_PERIOD | NUMBER | Number of interactions with the combination of outcome, result and reason | ||
| EMAILS_COMPOSED_IN_PERIOD | NUMBER | Number of new outbound emails (not replies) generated from Email Center | ||
| LEADS_CREATED_IN_PERIOD | NUMBER | Total number of leads generated from Email Center | ||
| EMAILS_REROUTED_IN_PERIOD | NUMBER | Total number of emails processed through the rerouting of email | ||
| AGENT_EMAILS_RPLD_BY_GOAL | NUMBER | The number of emails replied within the service level goal, by an agent |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_ID
, EMAIL_ACCOUNT_ID
, EMAIL_CLASSIFICATION_ID
, PARTY_ID
, TIME_ID
, PERIOD_TYPE_ID
, PERIOD_START_DATE
, PERIOD_START_TIME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EMAILS_OFFERED_IN_PERIOD
, EMAILS_FETCHED_IN_PERIOD
, EMAILS_REPLIED_IN_PERIOD
, EMAILS_RPLD_BY_GOAL_IN_PERIOD
, EMAILS_DELETED_IN_PERIOD
, EMAILS_TRNSFRD_OUT_IN_PERIOD
, EMAILS_TRNSFRD_IN_IN_PERIOD
, EMAILS_RSL_AND_TRFD_IN_PERIOD
, EMAILS_ASSIGNED_IN_PERIOD
, EMAILS_AUTO_ROUTED_IN_PERIOD
, EMAILS_AUTO_UPTD_SR_IN_PERIOD
, SR_CREATED_IN_PERIOD
, ACCUMULATED_OPEN_EMAILS
, ACCUMULATED_OPEN_AGE
, OLDEST_EMAIL_OPEN_DATE
, ACCUMULATED_EMAILS_IN_QUEUE
, ACCUMULATED_QUEUE_TIME
, OLDEST_EMAIL_QUEUE_DATE
, EMAIL_RESP_TIME_IN_PERIOD
, AGENT_RESP_TIME_IN_PERIOD
, ACCUMULATED_EMAILS_ONE_DAY
, ACCUMULATED_EMAILS_THREE_DAYS
, ACCUMULATED_EMAILS_WEEK
, ACCUMULATED_EMAILS_WEEK_PLUS
, ONE_RSLN_IN_PERIOD
, TWO_RSLN_IN_PERIOD
, THREE_RSLN_IN_PERIOD
, FOUR_RSLN_IN_PERIOD
, INTERACTION_THREADS_IN_PERIOD
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, EMAILS_AUTO_REPLIED_IN_PERIOD
, EMAILS_AUTO_DELETED_IN_PERIOD
, EMAILS_AUTO_RESOLVED_IN_PERIOD
, EMAILS_ORR_COUNT_IN_PERIOD
, EMAILS_COMPOSED_IN_PERIOD
, LEADS_CREATED_IN_PERIOD
, EMAILS_REROUTED_IN_PERIOD
, AGENT_EMAILS_RPLD_BY_GOAL
FROM BIX.BIX_EMAIL_DETAILS_F;
BIX.BIX_EMAIL_DETAILS_F does not reference any database object
BIX.BIX_EMAIL_DETAILS_F is referenced by following:
APPS
BIX_EMAIL_DETAILS_F
BIX_EMAIL_DETAILS_MV
|
|
|
|