[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IEC_REP_CAMPAIGN_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | IEC |
| Subobject Name: | |
| Status: | VALID |
This table stores the detailed campaign statistics
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAMPAIGN_REP_ID | NUMBER | (15) | Yes | Unique Identifier |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| CREATION_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
| CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | Foreign Key to SCHEDULE_ID of AMS_CAMPAIGN_SCHEDULES |
| DIAL_SERVER_ID | NUMBER | (15) | Yes | Foreign Key to Server_id |
| DIALING_MODE | VARCHAR2 | (4) | Yes | Dialing Mode Code |
| TOTAL_LOGIN_TIME | NUMBER | (15) | Yes | Accumulated login time for all agents in number of seconds |
| TOTAL_ACTIVITY_TIME | NUMBER | (15) | Yes | Accumulated activity time for all agents in number of seconds |
| NUM_LOGIN_AGENT | NUMBER | (4) | Yes | Number of agents currently login to the campaign schedule |
| MAX_LOGIN_AGENT | NUMBER | (4) | Yes | Max number of agents login to the campaign schedule today |
| TOTAL_IDLE_TIME | NUMBER | (15) | Yes | total idle time in number of seconds for completed transaction |
| TOTAL_WAIT_TIME | NUMBER | (15) | Yes | Total wait time in number of seconds for completed transaction |
| TOTAL_TALK_TIME | NUMBER | (15) | Yes | Total talk time in number of seconds for completed transaction |
| TOTAL_WRAPUP_TIME | NUMBER | (15) | Yes | total wrapup time in number of seconds for completed transaction |
| LONGEST_IDLE_TIME | NUMBER | (9) | Yes | Longest idle time in number of seconds for completed transaction |
| LONGEST_WAIT_TIME | NUMBER | (9) | Yes | Longest wait time in number of seconds for completed transaction |
| LONGEST_TALK_TIME | NUMBER | (9) | Yes | Longest talk time for completed transaction |
| LONGEST_WRAPUP_TIME | NUMBER | (9) | Yes | Longest wrapup time for completed transaction |
| SHORTEST_IDLE_TIME | NUMBER | (9) | Yes | Shortest idle time for completed transaction |
| SHORTEST_WAIT_TIME | NUMBER | (9) | Yes | Shorted wait time for completed transaction |
| SHORTEST_TALK_TIME | NUMBER | (9) | Yes | Shortest talk time for completed transaction |
| SHORTEST_WRAPUP_TIME | NUMBER | (9) | Yes | Shortest wrapup time for completed transaction |
| TOTAL_DIALS | NUMBER | (9) | Yes | Number of total dials |
| PREVIEW_DIALS | NUMBER | (9) | Number of preview dials | |
| PROGRESSIVE_DIALS | NUMBER | (9) | Number of progressive dials | |
| PREDICTIVE_DIALS | NUMBER | (9) | Number of predictive dials | |
| MANUAL_DIALS | NUMBER | (9) | Number of manual dials | |
| PREDICTIVE_OUTCOME_ID | NUMBER | (10) | Predictive Outcome ID | |
| PREDICTIVE_RESULT_ID | NUMBER | (10) | Predictive Result ID | |
| PREDICTIVE_RESULT_COUNT | NUMBER | (10) | Number of predictive dials detected with outcome and result ID above | |
| PREDICTIVE_DIAL_FHQ_COUNT | NUMBER | (9) | Number of predictive dials transferred to the front hold queue | |
| CALLS_OFFERED | NUMBER | (9) | Yes | Number of calls offered |
| AGENT_OUTCOME_ID | NUMBER | (10) | Agent Outcome ID | |
| AGENT_RESULT_ID | NUMBER | (10) | Agent Result ID | |
| AGENT_RESULT_COUNT | NUMBER | (10) | Agent Result Count | |
| POSITIVE_RESPONSE_FLAG | VARCHAR2 | (1) | Number of category 1 contacts | |
| NUM_AGENTS_ON_CALL | NUMBER | (10) | Yes | Number of category 2 contacts |
| NUM_AGENTS_IN_WRAPUP | NUMBER | (10) | Yes | Number of category 3 contacts |
| NUM_AGENTS_AVAILABLE | NUMBER | (10) | Yes | Number of available Agents |
| NUM_AGENTS_IDLE | NUMBER | (10) | Yes | Number of Idle Agents |
| NUM_AGENTS_ON_BREAK | NUMBER | (10) | Yes | Number of Agents on Break |
| SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
| OBJECT_VERSION_NUMBER | NUMBER | Used for locking purposed | ||
| CONTACT_FLAG | VARCHAR2 | (1) | Flag indicating whether a contact was made or not | |
| NUM_CUST_IN_FHQ | NUMBER | (9) | number of customers in Front Hold Queue | |
| NUM_VOICE_DETECTED | NUMBER | (9) | number of voice detected | |
| PREDICTIVE_CALLS_OFFERED | NUMBER | (9) | predictive calls offered to agent | |
| CAMPAIGN_ID | NUMBER | (15) | Yes | Campaign ID |
| TIMED_PREVIEW_DIALS | NUMBER | (9) | Number of timed preview dials | |
| FTC_ABANDONMENT_COUNT | NUMBER | (10) | FTC abandonment count | |
| MESSAGE_PLAYED_COUNT | NUMBER | (10) | Message Played Count | |
| CPN_NUM_LOGIN_AGENT | NUMBER | (5) | number of login agent for a campaign | |
| CPN_MAX_LOGIN_AGENT | NUMBER | (5) | max number of login agent for a campaign |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_REP_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CAMPAIGN_SCHEDULE_ID
, DIAL_SERVER_ID
, DIALING_MODE
, TOTAL_LOGIN_TIME
, TOTAL_ACTIVITY_TIME
, NUM_LOGIN_AGENT
, MAX_LOGIN_AGENT
, TOTAL_IDLE_TIME
, TOTAL_WAIT_TIME
, TOTAL_TALK_TIME
, TOTAL_WRAPUP_TIME
, LONGEST_IDLE_TIME
, LONGEST_WAIT_TIME
, LONGEST_TALK_TIME
, LONGEST_WRAPUP_TIME
, SHORTEST_IDLE_TIME
, SHORTEST_WAIT_TIME
, SHORTEST_TALK_TIME
, SHORTEST_WRAPUP_TIME
, TOTAL_DIALS
, PREVIEW_DIALS
, PROGRESSIVE_DIALS
, PREDICTIVE_DIALS
, MANUAL_DIALS
, PREDICTIVE_OUTCOME_ID
, PREDICTIVE_RESULT_ID
, PREDICTIVE_RESULT_COUNT
, PREDICTIVE_DIAL_FHQ_COUNT
, CALLS_OFFERED
, AGENT_OUTCOME_ID
, AGENT_RESULT_ID
, AGENT_RESULT_COUNT
, POSITIVE_RESPONSE_FLAG
, NUM_AGENTS_ON_CALL
, NUM_AGENTS_IN_WRAPUP
, NUM_AGENTS_AVAILABLE
, NUM_AGENTS_IDLE
, NUM_AGENTS_ON_BREAK
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, CONTACT_FLAG
, NUM_CUST_IN_FHQ
, NUM_VOICE_DETECTED
, PREDICTIVE_CALLS_OFFERED
, CAMPAIGN_ID
, TIMED_PREVIEW_DIALS
, FTC_ABANDONMENT_COUNT
, MESSAGE_PLAYED_COUNT
, CPN_NUM_LOGIN_AGENT
, CPN_MAX_LOGIN_AGENT
FROM IEC.IEC_REP_CAMPAIGN_DETAILS;
IEC.IEC_REP_CAMPAIGN_DETAILS does not reference any database object
IEC.IEC_REP_CAMPAIGN_DETAILS is referenced by following:
APPS
IEC_REP_CAMPAIGN_DETAILS
|
|
|
|