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_AGENT_SUM

Object Details

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

This table stores call related informations . The dimensions are agent , time , classification, site, campaign and campaign schedule . The data is summarized to half-hour bucket .

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_DM_AGENT_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE
BIX_DM_AGENT_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_ID PERIOD_START_DATE_TIME
BIX_DM_AGENT_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_ID PERIOD_START_DATE
BIX_DM_AGENT_SUM_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME CLASSIFICATION_ID
BIX_DM_AGENT_SUM_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME RESOURCE_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_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 .
RESOURCE_ID	NUMBER		Yes	Unique identifier for agent .
CLASSIFICATION_ID	NUMBER			Not Used .
SERVER_GROUP_ID	NUMBER	(15)		Unique identifier for classification .
CAMPAIGN_ID	NUMBER			Unique identifier for marketing campaign .
CAMPAIGN_SCHEDULE_ID	NUMBER			Unique identifier for campaign schedule .
IN_CALLS_HANDLED	NUMBER			Number of inbound calls handled by the agent .
IN_CALLS_HANDLD_GT_THN_X_TIME	NUMBER			Number of inbound calls , greater than a threshold time set by the user through a profile , handled by the agent .
OUT_CALLS_HANDLED	NUMBER			Number of outbound calls handled by the agent .
OUT_CALLS_HANDLD_GT_THN_X_TIME	NUMBER			Number of outbound calls , greater than a threshold time set by the user through a profile , handled by the agent .
CALLS_TRANSFERED	NUMBER			Number of calls transferred by the agent to some other agent .
CALLS_OFFRD_GT_THN_X_TIME	NUMBER			Not Used .
QUEUE_TIME_FOR_CALLS_HANDLED	NUMBER			Queue time for all the calls handled by the agent .
MAX_QUEUE_TIME_CALLS_HANDLD	NUMBER			Maximum queue time of the calls handled by the agent .
IN_TALK_TIME	NUMBER			Time spent by the agent in talking for inbound calls .
OUT_TALK_TIME	NUMBER			Time spent by the agent in talking for outbound calls .
IN_WRAP_TIME	NUMBER			Time spent by the agent in wrapping the inbound calls.
OUT_WRAP_TIME	NUMBER			Time spent by the agent in wrapping the outbound calls.
IN_MIN_TALK_TIME	NUMBER			The minimum time an agent has spent in talking for an inbound call .
IN_MAX_TALK_TIME	NUMBER			The maximum time an agent has spent in talking for an inbound call .
OUT_MIN_TALK_TIME	NUMBER			The minimum time an agent has spent in talking for an outbound call .
OUT_MAX_TALK_TIME	NUMBER			The maximum time an agent has spent in talking for an outbound call .
IN_MIN_WRAP_TIME	NUMBER			The minimum time an agent has spent in wrapping an inbound call .
IN_MAX_WRAP_TIME	NUMBER			The maximum time an agent has spent in wrapping an inbound call .
OUT_MIN_WRAP_TIME	NUMBER			The minimum time an agent has spent in wrapping an outbound call .
OUT_MAX_WRAP_TIME	NUMBER			The maximum time an agent has spent in wrapping an outbound call .
SR_CREATED	NUMBER			Number of service requests created by the agent .
SR_OPENED	NUMBER			Number of service requests opened by the agent .
SR_CLOSED	NUMBER			Number of Service Requests Closed by the agent .
SR_FIRST_CONTACT_CLOSE	NUMBER			Number of service requests closed at 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 for which knowledge base information has to be updated .
LEADS_CREATED	NUMBER			Number of leads created by the agent .
LEADS_UPDATED	NUMBER			Number of leads updated by the agent .
LEADS_AMOUNT	NUMBER			The amount of all the leads created by the agent in BIX currency .
LEADS_AMOUNT_TXN	NUMBER			The amount of all the leads created by the agent in transaction currency .
LEADS_CONVERTED_TO_OPP	NUMBER			Number of leads that have been converted to opportunities by the agent .
OPPORTUNITIES_CREATED	NUMBER			Number of opportunities created by the agent .
OPPORTUNITIES_UPDATED	NUMBER			Number of opportunities updated by the agent .
OPPORTUNITIES_WON	NUMBER			Number of opportunities won by the agent .
OPPORTUNITIES_WON_AMOUNT	NUMBER			The amount of all the opportunities won by the agent in BIX currency .
OPPORTUNITIES_WON_AMOUNT_TXN	NUMBER			The amount of all the opportunities won by the agent in transaction currency .
OPPORTUNITIES_CROSS_SOLD	NUMBER			Number of opportunities cross sold by the agent .
OPPORTUNITIES_UP_SOLD	NUMBER			Number of opportunities up sold by the agent .
OPPORTUNITIES_DECLINED	NUMBER			Number of opportunities declined by the customer .
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 .
OUT_PREVIEW_TIME	NUMBER			Preview Time for outbound calls .
OUT_CONTACT_HANDLE_TIME	NUMBER			Handle time for 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 .
OUT_BUSY_COUNT	NUMBER			Number of outbound calls which has got a 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 no answer from the customer .
OUT_ANS_MC_COUNT	NUMBER			Number of outbound calls that have reached answering machine .
OUT_SIT_COUNT	NUMBER			Number of SIT Outbound 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 AGENT_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
,      RESOURCE_ID
,      CLASSIFICATION_ID
,      SERVER_GROUP_ID
,      CAMPAIGN_ID
,      CAMPAIGN_SCHEDULE_ID
,      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
,      IN_TALK_TIME
,      OUT_TALK_TIME
,      IN_WRAP_TIME
,      OUT_WRAP_TIME
,      IN_MIN_TALK_TIME
,      IN_MAX_TALK_TIME
,      OUT_MIN_TALK_TIME
,      OUT_MAX_TALK_TIME
,      IN_MIN_WRAP_TIME
,      IN_MAX_WRAP_TIME
,      OUT_MIN_WRAP_TIME
,      OUT_MAX_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_AMOUNT_TXN
,      LEADS_CONVERTED_TO_OPP
,      OPPORTUNITIES_CREATED
,      OPPORTUNITIES_UPDATED
,      OPPORTUNITIES_WON
,      OPPORTUNITIES_WON_AMOUNT
,      OPPORTUNITIES_WON_AMOUNT_TXN
,      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
,      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_AGENT_SUM;

Dependencies

[top of page]

BIX.BIX_DM_AGENT_SUM does not reference any database object

BIX.BIX_DM_AGENT_SUM is referenced by following:

APPS: BIX_DM_AGENT_SUM