[Home] [Help] [Dependency Information]
Object Name: | IEC_REP_AGENT_CPN_DETAILS |
---|---|
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_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_REP_AGENT_CPN_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_CPN_DETAIL_ID | NUMBER | (15) | Yes | Unique Id |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | Standards WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
RESOURCE_ID | NUMBER | (15) | Yes | Foreign Key to RESOURCE_ID in JTF_RS_RESOURCE_EXTNS |
CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | Foreign Key to SCHEDULE_ID in AMS_CAMPAIGN_SCHEDULES |
DIAL_SERVER_ID | NUMBER | (15) | Yes | |
TOTAL_LOGIN_TIME | NUMBER | (15) | Yes | Agent login time in number of seconds |
TOTAL_ACTIVITY_TIME | NUMBER | (15) | Yes | Activity time in number of seconds, used to calculate utilization percentage. |
CURRENT_STATUS | VARCHAR2 | (15) | Yes | Current status |
CURRENT_STATUS_BEGIN_TIME | DATE | Yes | Time when CURRENT_STATUS was recorded | |
TOTAL_IDLE_TIME | NUMBER | (15) | Total idle time in number of seconds for completed transaction | |
TOTAL_WAIT_TIME | NUMBER | (15) | Total wait time in number of seconds for completed transaction | |
TOTAL_TALK_TIME | NUMBER | (15) | Total talk time in seconds for completed transaction | |
TOTAL_WRAPUP_TIME | NUMBER | (15) | Total wrapup time in seconds for completed transaction | |
CALLS_OFFERED | NUMBER | (4) | Yes | Number of call offered |
OUTCOME_ID | NUMBER | (10) | Yes | Number of contacts |
RESULT_ID | NUMBER | (10) | Yes | Number of sales |
RESULT_COUNT | NUMBER | (10) | Yes | Number of no sales |
POSITIVE_RESPONSE_FLAG | VARCHAR2 | (1) | Number of category 1 contacts | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environment | |
OBJECT_VERSION_NUMBER | NUMBER | Used for locking purposed | ||
CONTACT_FLAG | VARCHAR2 | (1) | Flag to indicate if a contact has been made | |
LOGIN_AGENT_COUNT | NUMBER | (9) | number of login agent | |
PREDICTIVE_CALLS_OFFERED | NUMBER | (9) | predictive calls offered to agent | |
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;
IEC.IEC_REP_AGENT_CPN_DETAILS does not reference any database object
IEC.IEC_REP_AGENT_CPN_DETAILS is referenced by following:
|
|
|