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_OUTCOME_SUM

Object Details

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

This table stores informations related to the outcomes of the outbound calls . The dimensions of the tables are campaign , campaign schedule, site, outcome, result, reason, direction, media item type, agent and time . The data is captured at the half-hour time bucket .

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_DM_AGENT_OUTCOME_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME RESOURCE_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID
BIX_DM_AGENT_OUTCOME_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID
BIX_DM_AGENT_OUTCOME_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID OUTCOME_ID RESULT_ID
BIX_DM_AGENT_OUTCOME_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE RESOURCE_ID CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID OUTCOME_ID RESULT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_OUTCOME_SUM_ID	NUMBER		Yes	Unique identifier generated from a sequence .
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
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	NUMBER			Date when a concurrent program last updated this record .
CAMPAIGN_ID	NUMBER			Unique identifier for the marketing campaign .
CAMPAIGN_SCHEDULE_ID	NUMBER			Unique identifier for the marketing campaign schedule .
SERVER_GROUP_ID	NUMBER	(15)	Yes	Unique identifier for the site of the call .
OUTCOME_ID	NUMBER	(15)		Unique Identifier for the outcome of the call .
RESULT_ID	NUMBER	(15)		Unique identifier for the result of the call .
REASON_ID	NUMBER	(15)		Unique identifier for the reason of the call .
DIRECTION	VARCHAR2	(240)		Identifies the direction of the call . The value of this column is 'Outbound' for outbound calls and 'Inbound' for inbound calls .
MEDIA_ITEM_TYPE	VARCHAR2	(80)		Not Used .
RESOURCE_ID	NUMBER			Unique identifier for the agent .
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 .
NUMBER_OF_CALLS	NUMBER			Number of Calls .
CONTACT_FLAG	VARCHAR2	(3)		This flag indicates whether the call can be considered as contacted . It is derived from the outcome of the call .
POSITIVE_RESPONSE_FLAG	VARCHAR2	(3)		This flag indicates whether the call can be considered as positive response . It is derived from the result of the call .
CONNECT_FLAG	VARCHAR2	(3)		This flag indicates whether the call is connected . It is derived from the outcome of the call .

Query Text

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


SELECT AGENT_OUTCOME_SUM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CAMPAIGN_ID
,      CAMPAIGN_SCHEDULE_ID
,      SERVER_GROUP_ID
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      DIRECTION
,      MEDIA_ITEM_TYPE
,      RESOURCE_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      PERIOD_START_DATE_TIME
,      NUMBER_OF_CALLS
,      CONTACT_FLAG
,      POSITIVE_RESPONSE_FLAG
,      CONNECT_FLAG
FROM BIX.BIX_DM_AGENT_OUTCOME_SUM;

Dependencies

[top of page]

BIX.BIX_DM_AGENT_OUTCOME_SUM does not reference any database object

BIX.BIX_DM_AGENT_OUTCOME_SUM is referenced by following:

APPS: BIX_DM_AGENT_OUTCOME_SUM