[Home] [Help] [Dependency Information]
Object Name: | BIX_AGENT_SESSION_F |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
Denormalized summary Table used for storing Agent Session information
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BIX.BIX_AGENT_SESSION_F does not reference any database object
BIX.BIX_AGENT_SESSION_F is referenced by following:
|
|
|