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.BIX_DM_CALL_SUM

Object Details

Object Name:	BIX_DM_CALL_SUM
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

This table stores call related informations . The dimensions of this table are time , classification , site , and dnis . The data is stored by half-hour bucket .

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_DM_CALL_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE
BIX_DM_CALL_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CLASSIFICATION_ID PERIOD_START_DATE
BIX_DM_CALL_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CLASSIFICATION_ID PERIOD_START_DATE_TIME
BIX_DM_CALL_SUM_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	DNIS_ID PERIOD_START_DATE_TIME
BIX_DM_CALL_SUM_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CALL_SUMMARY_ID	NUMBER		Yes	Unique identifier generated from a sequence .
LAST_UPDATE_DATE	DATE			Standard Who COlumn
LAST_UPDATED_BY	NUMBER			Standard Who COlumn
CREATION_DATE	DATE			Standard Who COlumn
CREATED_BY	NUMBER			Standard Who COlumn
LAST_UPDATE_LOGIN	DATE			Standard Who COlumn
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			The date-time that the measures correspond to . This column is a concatenation of the columns period_start_date and period_start_time .
CLASSIFICATION_ID	NUMBER			Not used .
SERVER_GROUP_ID	NUMBER	(15)		Unique identifier for the site .
DNIS_ID	NUMBER			Unique identifier for DNIS .
CALLS_OFFERED	NUMBER			Number of inbound calls that have come to the system .
CALLS_IN_QUEUE	NUMBER			Number of calls that were in queue .
CALLS_ABANDONED	NUMBER			Number of calls that were abandoned .
CALLS_ANSWRD_WITHIN_X_TIME	NUMBER			Number of calls that were answered within a threshold time , defined by the user as a profile .
IVR_TIME	NUMBER			Total interactive Voice Response time of all the calls .
ROUTE_TIME	NUMBER			Total route time of all the calls .
QUEUE_TIME	NUMBER			Total queue time of all the calls .
ABANDON_TIME	NUMBER			Total time of the calls before they were abandoned .
MIN_IVR_TIME	NUMBER			Minimum Interactive Voice Response time of all the calls .
MAX_IVR_TIME	NUMBER			Maximum Interactive Voice Response time of all the calls .
MIN_ROUTE_TIME	NUMBER			Minimum route time of all the calls .
MAX_ROUTE_TIME	NUMBER			Maximum Route time of all the calls .
MIN_QUEUE_TIME	NUMBER			Minimum queue time of all the calls .
MAX_QUEUE_TIME	NUMBER			Maximum queue time of all the calls .
MIN_ABANDON_TIME	NUMBER			Minimum abandon time of all the calls which are abandoned .
MAX_ABANDON_TIME	NUMBER			Maximum abandon time of all the calls which are abandoned .
IN_CALLS_HANDLED	NUMBER			Number of inbound calls handled .
IN_CALLS_HANDLD_GT_THN_X_TIME	NUMBER			Number of inbound calls handled which are greater than a threshold time , defined by the user as a profile .
OUT_CALLS_HANDLED	NUMBER			Number of outbound calls handled .
OUT_CALLS_HANDLD_GT_THN_X_TIME	NUMBER			Number of outbound calls handled which are greater than a threshold time , defined by the user as a profile .
CALLS_TRANSFERED	NUMBER			Number of calls transferred from one agent to another .
CALLS_OFFRD_GT_THN_X_TIME	NUMBER			Number of calls that has come into the system and the duration of the calls is greater than a threshold time , defined by the user as a profile .
QUEUE_TIME_FOR_CALLS_HANDLED	NUMBER			Total queue time for all the calls which are handled .
MAX_QUEUE_TIME_CALLS_HANDLD	NUMBER			Maximum queue time for all the calls which are handled .
NUMBER_OF_REROUTES	NUMBER			Not used .
PRIMARY_COUNT	NUMBER			Not Used .
IN_TALK_TIME	NUMBER			Time spent in talking for all inbound calls .
OUT_TALK_TIME	NUMBER			Time spent in talking for all outbound calls .
IN_WRAP_TIME	NUMBER			Time spent in wrapping all inbound calls .
OUT_WRAP_TIME	NUMBER			Time spent in wrapping all outbound calls .
SR_CREATED	NUMBER			Number of Service Requests created .
SR_OPENED	NUMBER			Number of service requests opened .
SR_CLOSED	NUMBER			Number of service requests opened .
SR_FIRST_CONTACT_CLOSE	NUMBER			Number of service requests closed during the first contact with the customer .
SR_ADDITIONAL_INFO_REQUESTED	NUMBER			Number of service requests for which additional information is requested .
SR_KB_UPDATES	NUMBER			Number of service requests which has lead to updates in knowledge base information .
LEADS_CREATED	NUMBER			Number of leads created .
LEADS_UPDATED	NUMBER			Number of leads updated .
LEADS_AMOUNT	NUMBER			Total lead amount of all the leads created in BIX currency .
LEADS_CONVERTED_TO_OPP	NUMBER			Number of leads converted to opportunities .
OPPORTUNITIES_CREATED	NUMBER			Number of opportunities created .
OPPORTUNITIES_UPDATED	NUMBER			Number of opportunities updated .
OPPORTUNITIES_WON	NUMBER			Number of opportunities won .
OPPORTUNITIES_WON_AMOUNT	NUMBER			Total amount of all the opportunities won in BIX currency .
OPPORTUNITIES_CROSS_SOLD	NUMBER			Number of opportunities cross sold .
OPPORTUNITIES_UP_SOLD	NUMBER			Number of opportunities up sold .
OPPORTUNITIES_DECLINED	NUMBER			Number of opportunities declined .
OPPORTUNITIES_LOST	NUMBER			Number of opportunities lost .
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 .
NO_OF_OPP_WON_CALLS	NUMBER			Number of calls in which opportunities are won .
NO_OF_OPP_SOLD_CALLS	NUMBER			Number of calls in which opportunities are sold .
OPPORTUNITIES_WON_AMOUNT_TXN	NUMBER			Toatl amount of all the opportunities which are won in transactional curreny .
LEADS_AMOUNT_TXN	NUMBER			Toatl amount of all the leads which are creaated in transactional curreny .
CAMPAIGN_ID	NUMBER			Unique identifier for the marketing campaign .
CAMPAIGN_SCHEDULE_ID	NUMBER			Unique identifier for the marketing campaign schedule .
OUT_PREVIEW_TIME	NUMBER			Preview time of all the outbound calls .
OUT_CONTACT_HANDLE_TIME	NUMBER			Handle time of all the outbound calls which are contacted .
OUT_CALLS_DIALED	NUMBER			Number of outbound calls dialed .
OUT_CONNECT_COUNT	NUMBER			Number of outbound calls which are connected .
OUT_NON_CONNECT_COUNT	NUMBER			Number of outbound calls which are not connected .
OUT_CONTACT_COUNT	NUMBER			Number of outbound calls which are contacted .
OUT_NON_CONTACT_COUNT	NUMBER			Number of outbound calls which are not contacted .
OUT_POSITIVE_RESPONSE_COUNT	NUMBER			Number of outbound calls which are considered as positive response from the customer .
OUT_BUSY_COUNT	NUMBER			Number of outbound calls which have got busy signal .
OUT_ABANDON_COUNT	NUMBER			Number of outbound calls which are abandoned .
OUT_RING_NOANSWER_COUNT	NUMBER			Number of outbound calls which has got the ring but has not got any answer .
OUT_ANS_MC_COUNT	NUMBER			Number of outbound calls which has reached answering machine .
OUT_SIT_COUNT	NUMBER			Number of outbound SIT calls .
OUT_OTHER_OUTCOME_COUNT	NUMBER			Number of outbound calls having other outcomes .
CLASSIFICATION_VALUE_ID	NUMBER	(15)		Unique identifier for the classification .

Query Text

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


SELECT CALL_SUMMARY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      PERIOD_START_DATE_TIME
,      CLASSIFICATION_ID
,      SERVER_GROUP_ID
,      DNIS_ID
,      CALLS_OFFERED
,      CALLS_IN_QUEUE
,      CALLS_ABANDONED
,      CALLS_ANSWRD_WITHIN_X_TIME
,      IVR_TIME
,      ROUTE_TIME
,      QUEUE_TIME
,      ABANDON_TIME
,      MIN_IVR_TIME
,      MAX_IVR_TIME
,      MIN_ROUTE_TIME
,      MAX_ROUTE_TIME
,      MIN_QUEUE_TIME
,      MAX_QUEUE_TIME
,      MIN_ABANDON_TIME
,      MAX_ABANDON_TIME
,      IN_CALLS_HANDLED
,      IN_CALLS_HANDLD_GT_THN_X_TIME
,      OUT_CALLS_HANDLED
,      OUT_CALLS_HANDLD_GT_THN_X_TIME
,      CALLS_TRANSFERED
,      CALLS_OFFRD_GT_THN_X_TIME
,      QUEUE_TIME_FOR_CALLS_HANDLED
,      MAX_QUEUE_TIME_CALLS_HANDLD
,      NUMBER_OF_REROUTES
,      PRIMARY_COUNT
,      IN_TALK_TIME
,      OUT_TALK_TIME
,      IN_WRAP_TIME
,      OUT_WRAP_TIME
,      SR_CREATED
,      SR_OPENED
,      SR_CLOSED
,      SR_FIRST_CONTACT_CLOSE
,      SR_ADDITIONAL_INFO_REQUESTED
,      SR_KB_UPDATES
,      LEADS_CREATED
,      LEADS_UPDATED
,      LEADS_AMOUNT
,      LEADS_CONVERTED_TO_OPP
,      OPPORTUNITIES_CREATED
,      OPPORTUNITIES_UPDATED
,      OPPORTUNITIES_WON
,      OPPORTUNITIES_WON_AMOUNT
,      OPPORTUNITIES_CROSS_SOLD
,      OPPORTUNITIES_UP_SOLD
,      OPPORTUNITIES_DECLINED
,      OPPORTUNITIES_LOST
,      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
,      NO_OF_OPP_WON_CALLS
,      NO_OF_OPP_SOLD_CALLS
,      OPPORTUNITIES_WON_AMOUNT_TXN
,      LEADS_AMOUNT_TXN
,      CAMPAIGN_ID
,      CAMPAIGN_SCHEDULE_ID
,      OUT_PREVIEW_TIME
,      OUT_CONTACT_HANDLE_TIME
,      OUT_CALLS_DIALED
,      OUT_CONNECT_COUNT
,      OUT_NON_CONNECT_COUNT
,      OUT_CONTACT_COUNT
,      OUT_NON_CONTACT_COUNT
,      OUT_POSITIVE_RESPONSE_COUNT
,      OUT_BUSY_COUNT
,      OUT_ABANDON_COUNT
,      OUT_RING_NOANSWER_COUNT
,      OUT_ANS_MC_COUNT
,      OUT_SIT_COUNT
,      OUT_OTHER_OUTCOME_COUNT
,      CLASSIFICATION_VALUE_ID
FROM BIX.BIX_DM_CALL_SUM;

Dependencies

[top of page]

BIX.BIX_DM_CALL_SUM does not reference any database object

BIX.BIX_DM_CALL_SUM is referenced by following:

APPS: BIX_DM_CALL_SUM