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_AGENT_SESSION_F

Object Details

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

Denormalized summary Table used for storing Agent Session information

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_AGENT_SESSION_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	APPLICATION_ID TIME_ID PERIOD_TYPE_ID AGENT_ID PERIOD_START_DATE PERIOD_START_TIME
BIX_AGENT_SESSION_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_ID	NUMBER		Yes	Foreign key to resource dimension
SERVER_GROUP_ID	NUMBER		Yes	Foreign key to call center dimension,
SCHEDULE_ID	NUMBER		Yes	Foreign key to campaign schedule,
CAMPAIGN_ID	NUMBER		Yes	Foreign key to campaign dimension,
APPLICATION_ID	NUMBER		Yes	Identifies if the application is Advanced Inbound/Outbound or Email Center.
TIME_ID	NUMBER		Yes	Foreign key to time dimension
PERIOD_TYPE_ID	NUMBER		Yes	Identifies the period type (day, week,
PERIOD_START_DATE	DATE		Yes	Start date of the period for which agent session information is summarized
PERIOD_START_TIME	VARCHAR2	(5)	Yes	Start Time of the period for which agent session information is summarized
DAY_OF_WEEK	NUMBER		Yes	Identifies the day of the week (Monday,Tuesday, etc.)
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
LOGIN_TIME	NUMBER			The total time an agent has logged in during the period
AVAILABLE_TIME	NUMBER			The total time an agent is available to take calls.Applicable for Telephony
IDLE_TIME	NUMBER			Idle time of the agent in the period,
WORK_TIME	NUMBER			Work time of the agent in the period,Applicable for Telephony
AGENT_COST	NUMBER			Not used in 11.5.10
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

Query Text

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


SELECT AGENT_ID
,      SERVER_GROUP_ID
,      SCHEDULE_ID
,      CAMPAIGN_ID
,      APPLICATION_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      DAY_OF_WEEK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOGIN_TIME
,      AVAILABLE_TIME
,      IDLE_TIME
,      WORK_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
FROM BIX.BIX_AGENT_SESSION_F;

Dependencies

[top of page]

BIX.BIX_AGENT_SESSION_F does not reference any database object

BIX.BIX_AGENT_SESSION_F is referenced by following:

APPS: BIX_AGENT_SESSION_F