[Home] [Help] [Dependency Information]
Object Name: | BIX_EMAIL_DETAILS_STG |
---|---|
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_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
OUTCOME_ID | NUMBER | The outcome of the interaction | ||
RESULT_ID | NUMBER | The result of the interaction | ||
REASON_ID | NUMBER | Reason code of the interaction | ||
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 | ||
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 service level goal by an 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 | |
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 |
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
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, 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
, 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
, 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
FROM BIX.BIX_EMAIL_DETAILS_STG;
BIX.BIX_EMAIL_DETAILS_STG does not reference any database object
BIX.BIX_EMAIL_DETAILS_STG is referenced by following:
|
|
|