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.

[Home] [Help]

VIEW: IEC.IEC_REP_AGENT_CPN_DETAILS#

Source

View Text - Preformatted


select AGENT_CPN_DETAIL_ID AGENT_CPN_DETAIL_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RESOURCE_ID RESOURCE_ID, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID, DIAL_SERVER_ID DIAL_SERVER_ID, TOTAL_LOGIN_TIME TOTAL_LOGIN_TIME, TOTAL_ACTIVITY_TIME TOTAL_ACTIVITY_TIME, CURRENT_STATUS CURRENT_STATUS, CURRENT_STATUS_BEGIN_TIME CURRENT_STATUS_BEGIN_TIME, TOTAL_IDLE_TIME TOTAL_IDLE_TIME, TOTAL_WAIT_TIME TOTAL_WAIT_TIME, TOTAL_TALK_TIME TOTAL_TALK_TIME, TOTAL_WRAPUP_TIME TOTAL_WRAPUP_TIME, CALLS_OFFERED CALLS_OFFERED, OUTCOME_ID OUTCOME_ID, RESULT_ID RESULT_ID, RESULT_COUNT RESULT_COUNT, POSITIVE_RESPONSE_FLAG POSITIVE_RESPONSE_FLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONTACT_FLAG CONTACT_FLAG, LOGIN_AGENT_COUNT LOGIN_AGENT_COUNT, PREDICTIVE_CALLS_OFFERED PREDICTIVE_CALLS_OFFERED, CAMPAIGN_ID CAMPAIGN_ID from "IEC"."IEC_REP_AGENT_CPN_DETAILS"

View Text - HTML Formatted

SELECT AGENT_CPN_DETAIL_ID AGENT_CPN_DETAIL_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RESOURCE_ID RESOURCE_ID
, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID
, DIAL_SERVER_ID DIAL_SERVER_ID
, TOTAL_LOGIN_TIME TOTAL_LOGIN_TIME
, TOTAL_ACTIVITY_TIME TOTAL_ACTIVITY_TIME
, CURRENT_STATUS CURRENT_STATUS
, CURRENT_STATUS_BEGIN_TIME CURRENT_STATUS_BEGIN_TIME
, TOTAL_IDLE_TIME TOTAL_IDLE_TIME
, TOTAL_WAIT_TIME TOTAL_WAIT_TIME
, TOTAL_TALK_TIME TOTAL_TALK_TIME
, TOTAL_WRAPUP_TIME TOTAL_WRAPUP_TIME
, CALLS_OFFERED CALLS_OFFERED
, OUTCOME_ID OUTCOME_ID
, RESULT_ID RESULT_ID
, RESULT_COUNT RESULT_COUNT
, POSITIVE_RESPONSE_FLAG POSITIVE_RESPONSE_FLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONTACT_FLAG CONTACT_FLAG
, LOGIN_AGENT_COUNT LOGIN_AGENT_COUNT
, PREDICTIVE_CALLS_OFFERED PREDICTIVE_CALLS_OFFERED
, CAMPAIGN_ID CAMPAIGN_ID
FROM "IEC"."IEC_REP_AGENT_CPN_DETAILS"