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.MLOG$_BIX_CALL_DETAILS_F

Object Details

Object Name:	MLOG$_BIX_CALL_DETAILS_F
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

snapshot log for master table BIX.BIX_CALL_DETAILS_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
AGENTCALL_CONTACT_COUNT	NUMBER
AGENTCALL_ORR_COUNT	NUMBER
AGENTCALL_PR_COUNT	NUMBER
AGENT_CALLS_ANSWERED_BY_GOAL	NUMBER
AGENT_CALLS_HANDLED_ABOVE_TH	NUMBER
AGENT_CALLS_HANDLED_TOTAL	NUMBER
AGENT_CALLS_TRAN_CONF_TO_NAC	NUMBER
AGENT_CONT_CALLS_HAND_NA	NUMBER
AGENT_CONT_CALLS_TC_NA	NUMBER
AGENT_LEADS_AMOUNT	NUMBER
AGENT_LEADS_CONVERTED_TO_OPP	NUMBER
AGENT_LEADS_CREATED	NUMBER
AGENT_OPPORTUNITIES_CREATED	NUMBER
AGENT_OPPORTUNITIES_CROSS_SOLD	NUMBER
AGENT_OPPORTUNITIES_DECLINED	NUMBER
AGENT_OPPORTUNITIES_LOST	NUMBER
AGENT_OPPORTUNITIES_UP_SOLD	NUMBER
AGENT_OPPORTUNITIES_WON	NUMBER
AGENT_OPPORTUNITIES_WON_AMOUNT	NUMBER
AGENT_PREVIEW_TIME	NUMBER
AGENT_SR_CREATED	NUMBER
AGENT_TALK_TIME_NAC	NUMBER
AGENT_WRAP_TIME_NAC	NUMBER
CALL_CALLS_ABANDONED	NUMBER
CALL_CALLS_ABANDONED_US	NUMBER
CALL_CALLS_HANDLED_ABOVE_TH	NUMBER
CALL_CALLS_HANDLED_TOTAL	NUMBER
CALL_CALLS_OFFERED_ABOVE_TH	NUMBER
CALL_CALLS_OFFERED_TOTAL	NUMBER
CALL_CALLS_TRANSFERRED	NUMBER
CALL_CONT_CALLS_HANDLED_TOT_NA	NUMBER
CALL_CONT_CALLS_OFFERED_NA	NUMBER
CALL_IVR_TIME	NUMBER
CALL_QUEUE_TIME	NUMBER
CALL_ROUTE_TIME	NUMBER
CALL_TALK_TIME	NUMBER
CALL_TOT_QUEUE_TO_ABANDON	NUMBER
CALL_TOT_QUEUE_TO_ANSWER	NUMBER
CAMPAIGN_ID	NUMBER
CLASSIFICATION_VALUE	VARCHAR2	(64)
DAY_OF_WEEK	NUMBER
DIALING_METHOD	VARCHAR2	(30)
DIRECTION	VARCHAR2	(30)
DNIS_NAME	VARCHAR2	(30)
MEDIA_ITEM_TYPE	VARCHAR2	(80)
OUTCOME_ID	NUMBER
PARTITION_KEY	VARCHAR2	(2)
PARTY_ID	NUMBER
PERIOD_START_DATE	DATE
PERIOD_START_TIME	VARCHAR2	(5)
PERIOD_TYPE_ID	NUMBER
REASON_ID	NUMBER
RESOURCE_ID	NUMBER
RESULT_ID	NUMBER
SCHEDULE_ID	NUMBER
SERVER_GROUP_ID	NUMBER
SOURCE_CODE_ID	NUMBER
TIME_ID	NUMBER
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)

Query Text

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


SELECT AGENTCALL_CONTACT_COUNT
,      AGENTCALL_ORR_COUNT
,      AGENTCALL_PR_COUNT
,      AGENT_CALLS_ANSWERED_BY_GOAL
,      AGENT_CALLS_HANDLED_ABOVE_TH
,      AGENT_CALLS_HANDLED_TOTAL
,      AGENT_CALLS_TRAN_CONF_TO_NAC
,      AGENT_CONT_CALLS_HAND_NA
,      AGENT_CONT_CALLS_TC_NA
,      AGENT_LEADS_AMOUNT
,      AGENT_LEADS_CONVERTED_TO_OPP
,      AGENT_LEADS_CREATED
,      AGENT_OPPORTUNITIES_CREATED
,      AGENT_OPPORTUNITIES_CROSS_SOLD
,      AGENT_OPPORTUNITIES_DECLINED
,      AGENT_OPPORTUNITIES_LOST
,      AGENT_OPPORTUNITIES_UP_SOLD
,      AGENT_OPPORTUNITIES_WON
,      AGENT_OPPORTUNITIES_WON_AMOUNT
,      AGENT_PREVIEW_TIME
,      AGENT_SR_CREATED
,      AGENT_TALK_TIME_NAC
,      AGENT_WRAP_TIME_NAC
,      CALL_CALLS_ABANDONED
,      CALL_CALLS_ABANDONED_US
,      CALL_CALLS_HANDLED_ABOVE_TH
,      CALL_CALLS_HANDLED_TOTAL
,      CALL_CALLS_OFFERED_ABOVE_TH
,      CALL_CALLS_OFFERED_TOTAL
,      CALL_CALLS_TRANSFERRED
,      CALL_CONT_CALLS_HANDLED_TOT_NA
,      CALL_CONT_CALLS_OFFERED_NA
,      CALL_IVR_TIME
,      CALL_QUEUE_TIME
,      CALL_ROUTE_TIME
,      CALL_TALK_TIME
,      CALL_TOT_QUEUE_TO_ABANDON
,      CALL_TOT_QUEUE_TO_ANSWER
,      CAMPAIGN_ID
,      CLASSIFICATION_VALUE
,      DAY_OF_WEEK
,      DIALING_METHOD
,      DIRECTION
,      DNIS_NAME
,      MEDIA_ITEM_TYPE
,      OUTCOME_ID
,      PARTITION_KEY
,      PARTY_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      PERIOD_TYPE_ID
,      REASON_ID
,      RESOURCE_ID
,      RESULT_ID
,      SCHEDULE_ID
,      SERVER_GROUP_ID
,      SOURCE_CODE_ID
,      TIME_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM BIX.MLOG$_BIX_CALL_DETAILS_F;

Dependencies

[top of page]

BIX.MLOG$_BIX_CALL_DETAILS_F does not reference any database object

BIX.MLOG$_BIX_CALL_DETAILS_F is referenced by following:

APPS: MLOG$_BIX_CALL_DETAILS_F