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

TABLE: APPS.BIX_AO_CALL_DETAILS_MV

Object Details
Object Name: BIX_AO_CALL_DETAILS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIX_AO_CALL_DETAILS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIX_AO_CALL_DETAIL FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_START_DATE")
ColumnSYS_OP_MAP_NONNULL("SERVER_GROUP_ID")
ColumnSYS_OP_MAP_NONNULL("DIALING_METHOD")
ColumnSYS_OP_MAP_NONNULL("CAMPAIGN_ID")
ColumnSYS_OP_MAP_NONNULL("SCHEDULE_ID")
ColumnSYS_OP_MAP_NONNULL("SOURCE_CODE_ID")
ColumnSYS_OP_MAP_NONNULL("OUTCOME_ID")
ColumnSYS_OP_MAP_NONNULL("RESULT_ID")
ColumnSYS_OP_MAP_NONNULL("REASON_ID")
ColumnSYS_OP_MAP_NONNULL("RESOURCE_ID")
ColumnSYS_OP_MAP_NONNULL("PARTY_ID")
ColumnSYS_OP_MAP_NONNULL("G_ID")
BIX_AO_CALL_DETAILS_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnROW_TYPE
ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnSERVER_GROUP_ID
ColumnCAMPAIGN_ID
ColumnRESOURCE_ID
BIX_AO_CALL_DETAILS_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnROW_TYPE
ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnOUTCOME_ID
ColumnRESULT_ID
ColumnREASON_ID
ColumnSERVER_GROUP_ID
ColumnCAMPAIGN_ID
BIX_AO_CALL_DETAILS_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnROW_TYPE
ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnDIALING_METHOD
ColumnSERVER_GROUP_ID
ColumnCAMPAIGN_ID
Columns
Name Datatype Length Mandatory Comments
G_ID NUMBER

Grouping Set identifier
ROW_TYPE VARCHAR2 (7)
Summarization level identifier to distinguish between the different grouping sets
TIME_ID NUMBER

Foreign key to time dimension
PERIOD_TYPE_ID NUMBER

Identifies the period type (day, week,month, quarter, year)
PERIOD_START_DATE DATE

Start date of the period for which call information is summarized
SERVER_GROUP_ID NUMBER

Call Center for which call information is summarized
RESOURCE_ID NUMBER

Resource Id for which call information is summarized
PARTY_ID NUMBER

Customer id for which call information is summarized
CAMPAIGN_ID NUMBER

Campaign id for which call information is summarized
SCHEDULE_ID NUMBER

Campaign Schedule id for which call information is summarized
SOURCE_CODE_ID NUMBER

Source Code id of the Campaign/Campaign Schedule id for which call information is summarized
DIALING_METHOD VARCHAR2 (30)
Dialing method of the outbound calls (Predictive,Preview or Progressive)
OUTCOME_ID NUMBER

Outcome id for which call information is summarized
RESULT_ID NUMBER

Result id for which call information is summarized
REASON_ID NUMBER

Reason id for which call information is summarized
CALL_CALLS_OFFERED_TOTAL NUMBER

Total number of inbound calls
CALLS_OFFERED_TOTAL_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_OFFERED_ABOVE_TH NUMBER

Number of calls offered excluding the shortcalls
CALLS_OFFERED_ABOVE_TH_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_HANDLED_TOTAL NUMBER

Total number of calls answered by agents
CALLS_HANDLED_TOTAL_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_HANDLED_ABOVE_TH NUMBER

Number of calls answered by agents, where the call duration is greater than pre-defined threshold (profile value)
CALLS_HANDLED_ABOVE_TH_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_ABANDONED NUMBER

Number of calls which were not handled by an agent (abandoned in queue)
CALLS_ABANDONED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_ABANDONED_US NUMBER

Number of calls which are considered to be abandoned, as per FTC regulations
CALLS_ABANDONED_US_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CALLS_TRANSFERRED NUMBER

Number of calls transferred
CALLS_TRANSFERRED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_IVR_TIME NUMBER

Amount of time spent in IVR
IVR_TIME_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_ROUTE_TIME NUMBER

Amount of time that was spent in ROUTING
ROUTE_TIME_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_QUEUE_TIME NUMBER

Amount of time that was spent in queue
QUEUE_TIME_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_TOT_QUEUE_TO_ABANDON NUMBER

Total amount of time spent in queue for abandoned calls
TOT_QUEUE_TO_ABANDON_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_TOT_QUEUE_TO_ANSWER NUMBER

Total amount of time spent in queue for handled calls
TOT_QUEUE_TO_ANSWER_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_TALK_TIME NUMBER

Amount of time that was spent talking on calls
TALK_TIME_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CONT_CALLS_OFFERED_NA NUMBER

Number of offered calls which continued from the previous time bucket
CONT_CALLS_OFFERED_NA_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
CALL_CONT_CALLS_HANDLED_TOT_NA NUMBER

Number of handled calls which continued from the previous time bucket
CONT_CALLS_HANDLED_TOT_NA_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_TALK_TIME_NAC NUMBER

Amount of time spent by the resource in talking
TALK_TIME_NAC_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_WRAP_TIME_NAC NUMBER

Amount of time spent by the resource in wrapping up the interaction
WRAP_TIME_NAC_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CALLS_TRAN_CONF_TO_NAC NUMBER

Number of calls in which the agent was transferred-in or conferenced-in to a call
CALLS_TRAN_CONF_TO_NAC_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CALLS_HANDLED_TOTAL NUMBER

Total number of calls handled by the agent
AGENT_HANDLED_TOTAL_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CALLS_HANDLED_ABOVE_TH NUMBER

Number of calls handled by the agent where the call duration was more than the threshold value
AGENT_HANDLED_ABOVE_TH_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CALLS_ANSWERED_BY_GOAL NUMBER

Number of calls handled by the agent where the call was answered within the servicelevel goal
AGENT_ANSWERED_BY_GOAL_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_SR_CREATED NUMBER

Number of service requests created by the agent
SR_CREATED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_LEADS_CREATED NUMBER

Number of leads created by the agent
LEADS_CREATED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_LEADS_AMOUNT NUMBER

Amount of leads created by the agent
LEADS_AMOUNT_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_LEADS_CONVERTED_TO_OPP NUMBER

N/A (future release)
LEADS_CONVERTED_TO_OPP_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_CREATED NUMBER

Number of opportunities created by the agent
OPPORTUNITIES_CREATED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_WON NUMBER

Number of opportunities won by the agent
OPPORTUNITIES_WON_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_WON_AMOUNT NUMBER

Amount of the opportunities won by the agent
OPPORTUNITIES_WON_AMOUNT_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_CROSS_SOLD NUMBER

N/A (future release)
OPPORTUNITIES_CROSS_SOLD_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_UP_SOLD NUMBER

N/A (future release)
OPPORTUNITIES_UP_SOLD_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_DECLINED NUMBER

N/A (future release)
OPPORTUNITIES_DECLINED_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_OPPORTUNITIES_LOST NUMBER

N/A (future release)
OPPORTUNITIES_LOST_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_PREVIEW_TIME NUMBER

N/A (future release)
PREVIEW_TIME_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENTCALL_ORR_COUNT NUMBER

Count of the outcome, result, and reason combination for the agent
CALL_ORR_COUNT_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENTCALL_PR_COUNT NUMBER

Count of positive responses in interactions handled by the agent
CALL_PR_COUNT_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENTCALL_CONTACT_COUNT NUMBER

Count of the contact outcomes in interactions handled by the agent
CALL_CONTACT_COUNT_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CONT_CALLS_HAND_NA NUMBER

Number of calls handled by the agent which continued from the previous time bucket
CONT_CALLS_HAND_NA_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
AGENT_CONT_CALLS_TC_NA NUMBER

Number of calls transferred to the agent which continued from the previous time bucket
CONT_CALLS_TC_NA_XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
XCNT NUMBER

Mandatory Column for enabling fast refresh of MV
Query Text

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


SELECT G_ID
,      ROW_TYPE
,      TIME_ID
,      PERIOD_TYPE_ID
,      PERIOD_START_DATE
,      SERVER_GROUP_ID
,      RESOURCE_ID
,      PARTY_ID
,      CAMPAIGN_ID
,      SCHEDULE_ID
,      SOURCE_CODE_ID
,      DIALING_METHOD
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      CALL_CALLS_OFFERED_TOTAL
,      CALLS_OFFERED_TOTAL_XCNT
,      CALL_CALLS_OFFERED_ABOVE_TH
,      CALLS_OFFERED_ABOVE_TH_XCNT
,      CALL_CALLS_HANDLED_TOTAL
,      CALLS_HANDLED_TOTAL_XCNT
,      CALL_CALLS_HANDLED_ABOVE_TH
,      CALLS_HANDLED_ABOVE_TH_XCNT
,      CALL_CALLS_ABANDONED
,      CALLS_ABANDONED_XCNT
,      CALL_CALLS_ABANDONED_US
,      CALLS_ABANDONED_US_XCNT
,      CALL_CALLS_TRANSFERRED
,      CALLS_TRANSFERRED_XCNT
,      CALL_IVR_TIME
,      IVR_TIME_XCNT
,      CALL_ROUTE_TIME
,      ROUTE_TIME_XCNT
,      CALL_QUEUE_TIME
,      QUEUE_TIME_XCNT
,      CALL_TOT_QUEUE_TO_ABANDON
,      TOT_QUEUE_TO_ABANDON_XCNT
,      CALL_TOT_QUEUE_TO_ANSWER
,      TOT_QUEUE_TO_ANSWER_XCNT
,      CALL_TALK_TIME
,      TALK_TIME_XCNT
,      CALL_CONT_CALLS_OFFERED_NA
,      CONT_CALLS_OFFERED_NA_XCNT
,      CALL_CONT_CALLS_HANDLED_TOT_NA
,      CONT_CALLS_HANDLED_TOT_NA_XCNT
,      AGENT_TALK_TIME_NAC
,      TALK_TIME_NAC_XCNT
,      AGENT_WRAP_TIME_NAC
,      WRAP_TIME_NAC_XCNT
,      AGENT_CALLS_TRAN_CONF_TO_NAC
,      CALLS_TRAN_CONF_TO_NAC_XCNT
,      AGENT_CALLS_HANDLED_TOTAL
,      AGENT_HANDLED_TOTAL_XCNT
,      AGENT_CALLS_HANDLED_ABOVE_TH
,      AGENT_HANDLED_ABOVE_TH_XCNT
,      AGENT_CALLS_ANSWERED_BY_GOAL
,      AGENT_ANSWERED_BY_GOAL_XCNT
,      AGENT_SR_CREATED
,      SR_CREATED_XCNT
,      AGENT_LEADS_CREATED
,      LEADS_CREATED_XCNT
,      AGENT_LEADS_AMOUNT
,      LEADS_AMOUNT_XCNT
,      AGENT_LEADS_CONVERTED_TO_OPP
,      LEADS_CONVERTED_TO_OPP_XCNT
,      AGENT_OPPORTUNITIES_CREATED
,      OPPORTUNITIES_CREATED_XCNT
,      AGENT_OPPORTUNITIES_WON
,      OPPORTUNITIES_WON_XCNT
,      AGENT_OPPORTUNITIES_WON_AMOUNT
,      OPPORTUNITIES_WON_AMOUNT_XCNT
,      AGENT_OPPORTUNITIES_CROSS_SOLD
,      OPPORTUNITIES_CROSS_SOLD_XCNT
,      AGENT_OPPORTUNITIES_UP_SOLD
,      OPPORTUNITIES_UP_SOLD_XCNT
,      AGENT_OPPORTUNITIES_DECLINED
,      OPPORTUNITIES_DECLINED_XCNT
,      AGENT_OPPORTUNITIES_LOST
,      OPPORTUNITIES_LOST_XCNT
,      AGENT_PREVIEW_TIME
,      PREVIEW_TIME_XCNT
,      AGENTCALL_ORR_COUNT
,      CALL_ORR_COUNT_XCNT
,      AGENTCALL_PR_COUNT
,      CALL_PR_COUNT_XCNT
,      AGENTCALL_CONTACT_COUNT
,      CALL_CONTACT_COUNT_XCNT
,      AGENT_CONT_CALLS_HAND_NA
,      CONT_CALLS_HAND_NA_XCNT
,      AGENT_CONT_CALLS_TC_NA
,      CONT_CALLS_TC_NA_XCNT
,      XCNT
FROM APPS.BIX_AO_CALL_DETAILS_MV;

Dependencies

[top of page]

APPS.BIX_AO_CALL_DETAILS_MV does not reference any database object

APPS.BIX_AO_CALL_DETAILS_MV is referenced by following:

SchemaAPPS
Materialized ViewBIX_AO_CALL_DETAILS_MV