VIEW: IEC.IEC_REP_CAMPAIGN_DETAILS#

Source

View Text - Preformatted

select CAMPAIGN_REP_ID CAMPAIGN_REP_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, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID, DIAL_SERVER_ID DIAL_SERVER_ID, DIALING_MODE DIALING_MODE, TOTAL_LOGIN_TIME TOTAL_LOGIN_TIME, TOTAL_ACTIVITY_TIME TOTAL_ACTIVITY_TIME, NUM_LOGIN_AGENT NUM_LOGIN_AGENT, MAX_LOGIN_AGENT MAX_LOGIN_AGENT, TOTAL_IDLE_TIME TOTAL_IDLE_TIME, TOTAL_WAIT_TIME TOTAL_WAIT_TIME, TOTAL_TALK_TIME TOTAL_TALK_TIME, TOTAL_WRAPUP_TIME TOTAL_WRAPUP_TIME, LONGEST_IDLE_TIME LONGEST_IDLE_TIME, LONGEST_WAIT_TIME LONGEST_WAIT_TIME, LONGEST_TALK_TIME LONGEST_TALK_TIME, LONGEST_WRAPUP_TIME LONGEST_WRAPUP_TIME, SHORTEST_IDLE_TIME SHORTEST_IDLE_TIME, SHORTEST_WAIT_TIME SHORTEST_WAIT_TIME, SHORTEST_TALK_TIME SHORTEST_TALK_TIME, SHORTEST_WRAPUP_TIME SHORTEST_WRAPUP_TIME, TOTAL_DIALS TOTAL_DIALS, PREVIEW_DIALS PREVIEW_DIALS, PROGRESSIVE_DIALS PROGRESSIVE_DIALS, PREDICTIVE_DIALS PREDICTIVE_DIALS, MANUAL_DIALS MANUAL_DIALS, PREDICTIVE_OUTCOME_ID PREDICTIVE_OUTCOME_ID, PREDICTIVE_RESULT_ID PREDICTIVE_RESULT_ID, PREDICTIVE_RESULT_COUNT PREDICTIVE_RESULT_COUNT, PREDICTIVE_DIAL_FHQ_COUNT PREDICTIVE_DIAL_FHQ_COUNT, CALLS_OFFERED CALLS_OFFERED, AGENT_OUTCOME_ID AGENT_OUTCOME_ID, AGENT_RESULT_ID AGENT_RESULT_ID, AGENT_RESULT_COUNT AGENT_RESULT_COUNT, POSITIVE_RESPONSE_FLAG POSITIVE_RESPONSE_FLAG, NUM_AGENTS_ON_CALL NUM_AGENTS_ON_CALL, NUM_AGENTS_IN_WRAPUP NUM_AGENTS_IN_WRAPUP, NUM_AGENTS_AVAILABLE NUM_AGENTS_AVAILABLE, NUM_AGENTS_IDLE NUM_AGENTS_IDLE, NUM_AGENTS_ON_BREAK NUM_AGENTS_ON_BREAK, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONTACT_FLAG CONTACT_FLAG, NUM_CUST_IN_FHQ NUM_CUST_IN_FHQ, NUM_VOICE_DETECTED NUM_VOICE_DETECTED, PREDICTIVE_CALLS_OFFERED PREDICTIVE_CALLS_OFFERED, CAMPAIGN_ID CAMPAIGN_ID, TIMED_PREVIEW_DIALS TIMED_PREVIEW_DIALS, FTC_ABANDONMENT_COUNT FTC_ABANDONMENT_COUNT, MESSAGE_PLAYED_COUNT MESSAGE_PLAYED_COUNT, CPN_NUM_LOGIN_AGENT CPN_NUM_LOGIN_AGENT, CPN_MAX_LOGIN_AGENT CPN_MAX_LOGIN_AGENT from "IEC"."IEC_REP_CAMPAIGN_DETAILS"

View Text - HTML Formatted

SELECT CAMPAIGN_REP_ID CAMPAIGN_REP_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
, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID
, DIAL_SERVER_ID DIAL_SERVER_ID
, DIALING_MODE DIALING_MODE
, TOTAL_LOGIN_TIME TOTAL_LOGIN_TIME
, TOTAL_ACTIVITY_TIME TOTAL_ACTIVITY_TIME
, NUM_LOGIN_AGENT NUM_LOGIN_AGENT
, MAX_LOGIN_AGENT MAX_LOGIN_AGENT
, TOTAL_IDLE_TIME TOTAL_IDLE_TIME
, TOTAL_WAIT_TIME TOTAL_WAIT_TIME
, TOTAL_TALK_TIME TOTAL_TALK_TIME
, TOTAL_WRAPUP_TIME TOTAL_WRAPUP_TIME
, LONGEST_IDLE_TIME LONGEST_IDLE_TIME
, LONGEST_WAIT_TIME LONGEST_WAIT_TIME
, LONGEST_TALK_TIME LONGEST_TALK_TIME
, LONGEST_WRAPUP_TIME LONGEST_WRAPUP_TIME
, SHORTEST_IDLE_TIME SHORTEST_IDLE_TIME
, SHORTEST_WAIT_TIME SHORTEST_WAIT_TIME
, SHORTEST_TALK_TIME SHORTEST_TALK_TIME
, SHORTEST_WRAPUP_TIME SHORTEST_WRAPUP_TIME
, TOTAL_DIALS TOTAL_DIALS
, PREVIEW_DIALS PREVIEW_DIALS
, PROGRESSIVE_DIALS PROGRESSIVE_DIALS
, PREDICTIVE_DIALS PREDICTIVE_DIALS
, MANUAL_DIALS MANUAL_DIALS
, PREDICTIVE_OUTCOME_ID PREDICTIVE_OUTCOME_ID
, PREDICTIVE_RESULT_ID PREDICTIVE_RESULT_ID
, PREDICTIVE_RESULT_COUNT PREDICTIVE_RESULT_COUNT
, PREDICTIVE_DIAL_FHQ_COUNT PREDICTIVE_DIAL_FHQ_COUNT
, CALLS_OFFERED CALLS_OFFERED
, AGENT_OUTCOME_ID AGENT_OUTCOME_ID
, AGENT_RESULT_ID AGENT_RESULT_ID
, AGENT_RESULT_COUNT AGENT_RESULT_COUNT
, POSITIVE_RESPONSE_FLAG POSITIVE_RESPONSE_FLAG
, NUM_AGENTS_ON_CALL NUM_AGENTS_ON_CALL
, NUM_AGENTS_IN_WRAPUP NUM_AGENTS_IN_WRAPUP
, NUM_AGENTS_AVAILABLE NUM_AGENTS_AVAILABLE
, NUM_AGENTS_IDLE NUM_AGENTS_IDLE
, NUM_AGENTS_ON_BREAK NUM_AGENTS_ON_BREAK
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONTACT_FLAG CONTACT_FLAG
, NUM_CUST_IN_FHQ NUM_CUST_IN_FHQ
, NUM_VOICE_DETECTED NUM_VOICE_DETECTED
, PREDICTIVE_CALLS_OFFERED PREDICTIVE_CALLS_OFFERED
, CAMPAIGN_ID CAMPAIGN_ID
, TIMED_PREVIEW_DIALS TIMED_PREVIEW_DIALS
, FTC_ABANDONMENT_COUNT FTC_ABANDONMENT_COUNT
, MESSAGE_PLAYED_COUNT MESSAGE_PLAYED_COUNT
, CPN_NUM_LOGIN_AGENT CPN_NUM_LOGIN_AGENT
, CPN_MAX_LOGIN_AGENT CPN_MAX_LOGIN_AGENT
FROM "IEC"."IEC_REP_CAMPAIGN_DETAILS"