[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_AGENT_PERFORMANCE |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_G_REP_AGENT_PERFORMANCE_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
DATA_START_TIME
CAMPAIGN_SCHEDULE_ID |
IEC_G_REP_AGENT_PERFORMANCE_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_PERFORMANCE_ID | NUMBER | (15) | Yes | Unique identifier. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | Identifies the campaign schedule defined in AMS_CAMPAIGN_SCHDULES_B. |
RESOURCE_ID | NUMBER | (15) | Yes | Identifies the resource defined in JTF_RS_RESOURCE_EXTNS. |
DATA_START_TIME | DATE | Yes | Start time of the current interval during which the results are tallied. | |
DATA_END_TIME | DATE | Yes | End time of the current interval during which the results were tallied. | |
LOGIN_TIME | NUMBER | (9) | Time for which the agent was logged in during the current interval. | |
CALLS_SERVICED | NUMBER | (9) | Number of calls serviced by the agent during the current interval. | |
TALK_TIME | NUMBER | (9) | Time for which the agent was talkingt during the current interval. | |
WAIT_TIME | NUMBER | (9) | Time for which the agent was waiting for a call during the current interval. | |
WRAPUP_TIME | NUMBER | (9) | Time for which the agent was performing wrap up tasks during the current interva. | |
IDLE_TIME | NUMBER | (9) | Time for which the agent was idle during the current interval. | |
RESULT_ID | NUMBER | (15) | Represents the result of the customer interaction. | |
TOTAL_RESULT_COUNT | NUMBER | (9) | Represents the number occurences of the current result id. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_PERFORMANCE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CAMPAIGN_SCHEDULE_ID
, RESOURCE_ID
, DATA_START_TIME
, DATA_END_TIME
, LOGIN_TIME
, CALLS_SERVICED
, TALK_TIME
, WAIT_TIME
, WRAPUP_TIME
, IDLE_TIME
, RESULT_ID
, TOTAL_RESULT_COUNT
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEC.IEC_G_REP_AGENT_PERFORMANCE;
IEC.IEC_G_REP_AGENT_PERFORMANCE does not reference any database object
IEC.IEC_G_REP_AGENT_PERFORMANCE is referenced by following:
|
|
|