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_GROUP_SUM

Object Details

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

This table stores call related informations . The dimensions are agent group, 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_GROUP_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE
BIX_DM_GROUP_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GROUP_ID PERIOD_START_DATE
BIX_DM_GROUP_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GROUP_ID PERIOD_START_DATE_TIME
BIX_DM_GROUP_SUM_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME GROUP_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_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 .
GROUP_ID	NUMBER		Yes	Unique identifier for the agent group .
CLASSIFICATION_ID	NUMBER			Not Used .
SERVER_GROUP_ID	NUMBER	(15)		Unique identifier for site .
CAMPAIGN_ID	NUMBER			Unique identifier for campaign .
CAMPAIGN_SCHEDULE_ID	NUMBER			Unique identifier for campaign schedule .
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 set by the user through 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 set by the user through a profile .
CALLS_TRANSFERED	NUMBER			Number of calls transferred .
CALLS_OFFRD_GT_THN_X_TIME	NUMBER			Not Used .
QUEUE_TIME_FOR_CALLS_HANDLED	NUMBER			Queue time for all the calls handled by the agents belonging to the group .
MAX_QUEUE_TIME_CALLS_HANDLD	NUMBER			Maximum queue time of the calls handled by the agents belonging to the group .
IN_TALK_TIME	NUMBER			Time apent by the agents ,belonging to the group, in talking for inbound calls .
OUT_TALK_TIME	NUMBER			Time apent by the agents ,belonging to the group, in talking for outbound calls .
IN_WRAP_TIME	NUMBER			Time spent by agent , belonging to the group , in wrapping inbound calls .
OUT_WRAP_TIME	NUMBER			Time spent by agent , belonging to the group , in wrapping 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 for an inbound call .
IN_MAX_WRAP_TIME	NUMBER			The maximum time an agent has spent in wrapping for an inbound call .
OUT_MIN_WRAP_TIME	NUMBER			The minimum time an agent has spent in wrapping for an outbound call .
OUT_MAX_WRAP_TIME	NUMBER			The maximum time an agent has spent in wrapping for an outbound call .
SR_CREATED	NUMBER			Number of service requests created .
SR_OPENED	NUMBER			Number of service requests opened .
SR_CLOSED	NUMBER			Number of service requests closed .
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 .
LEADS_UPDATED	NUMBER			Number of leads updated .
LEADS_AMOUNT	NUMBER			The amount of all the leads created in BIX currency .
LEADS_AMOUNT_TXN	NUMBER			The amount of all the leads created in transactional 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			The amount of all the opportunities won in BIX currency .
OPPORTUNITIES_WON_AMOUNT_TXN	NUMBER			The amount of all the opportunities won in transactional 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 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 have 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 GROUP_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
,      GROUP_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_GROUP_SUM;

Dependencies

[top of page]

BIX.BIX_DM_GROUP_SUM does not reference any database object

BIX.BIX_DM_GROUP_SUM is referenced by following:

APPS: BIX_DM_GROUP_SUM