[Home] [Help] [Dependency Information]
Object Name: | IEC_REP_AGENT_CPN_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_CPN_DETAIL_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RESOURCE_ID | NUMBER | (15) | Yes | |
CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | |
DIAL_SERVER_ID | NUMBER | (15) | Yes | |
TOTAL_LOGIN_TIME | NUMBER | (15) | Yes | |
TOTAL_ACTIVITY_TIME | NUMBER | (15) | Yes | |
CURRENT_STATUS | VARCHAR2 | (15) | Yes | |
CURRENT_STATUS_BEGIN_TIME | DATE | Yes | ||
TOTAL_IDLE_TIME | NUMBER | (15) | ||
TOTAL_WAIT_TIME | NUMBER | (15) | ||
TOTAL_TALK_TIME | NUMBER | (15) | ||
TOTAL_WRAPUP_TIME | NUMBER | (15) | ||
CALLS_OFFERED | NUMBER | (4) | Yes | |
OUTCOME_ID | NUMBER | (10) | Yes | |
RESULT_ID | NUMBER | (10) | Yes | |
RESULT_COUNT | NUMBER | (10) | Yes | |
POSITIVE_RESPONSE_FLAG | VARCHAR2 | (1) | ||
SECURITY_GROUP_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
CONTACT_FLAG | VARCHAR2 | (1) | ||
LOGIN_AGENT_COUNT | NUMBER | (9) | ||
PREDICTIVE_CALLS_OFFERED | NUMBER | (9) | ||
CAMPAIGN_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_CPN_DETAIL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESOURCE_ID
, CAMPAIGN_SCHEDULE_ID
, DIAL_SERVER_ID
, TOTAL_LOGIN_TIME
, TOTAL_ACTIVITY_TIME
, CURRENT_STATUS
, CURRENT_STATUS_BEGIN_TIME
, TOTAL_IDLE_TIME
, TOTAL_WAIT_TIME
, TOTAL_TALK_TIME
, TOTAL_WRAPUP_TIME
, CALLS_OFFERED
, OUTCOME_ID
, RESULT_ID
, RESULT_COUNT
, POSITIVE_RESPONSE_FLAG
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, CONTACT_FLAG
, LOGIN_AGENT_COUNT
, PREDICTIVE_CALLS_OFFERED
, CAMPAIGN_ID
FROM IEC.IEC_REP_AGENT_CPN_DETAILS#;
|
|
|