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_SESSION_SUM

Object Details

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

This table stores summarized session information for an agent. The information is summarized by agent by day in half-hour buckets. The table is sourced from the ieu_sh_sessions table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_DM_AGENT_SESSION_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_ID PERIOD_START_DATE_TIME
BIX_DM_AGENT_SESSION_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE_TIME
BIX_DM_AGENT_SESSION_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_SESSION_SUMMARY_ID	NUMBER		Yes	Unique identifier generated from the sequence .
RESOURCE_ID	NUMBER		Yes	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		Yes	The date-time that the measures correspond to . This column is a concatenation of the columns period_start_date and period_start_time .
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column .
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column .
CREATION_DATE	DATE		Yes	Standard WHO column .
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column .
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column .
AVAILABLE_TIME	NUMBER			Available Time of the agent .
LOGIN_TIME	NUMBER			Login Time of the agent .
AGENT_COST	NUMBER			Cost of the agent . It is calculated as login time multiplied by agent cost per hour , a system profile .
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	(15)		Request identifier of last concurrent program to update this record .
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record .
PROGRAM_ID	NUMBER	(15)		Identifier of last concurrent program to update this record .
PROGRAM_UPDATE_DATE	DATE			Date when a concurrent program last updated this record .
IDLE_TIME	NUMBER			Idle Time of the agent .

Query Text

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


SELECT AGENT_SESSION_SUMMARY_ID
,      RESOURCE_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      PERIOD_START_DATE_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AVAILABLE_TIME
,      LOGIN_TIME
,      AGENT_COST
,      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
,      IDLE_TIME
FROM BIX.BIX_DM_AGENT_SESSION_SUM;

Dependencies

[top of page]

BIX.BIX_DM_AGENT_SESSION_SUM does not reference any database object

BIX.BIX_DM_AGENT_SESSION_SUM is referenced by following:

APPS: BIX_DM_AGENT_SESSION_SUM