[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_AGENT_OUTCOME_SUMS |
---|---|
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_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_G_REP_AGENT_OUTCOME_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
RESULT_ID
DATA_START_TIME CAMPAIGN_SCHEDULE_ID |
IEC_G_REP_AGENT_OUTCOME_SUM_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_OUTCOME_SUM_ID | NUMBER | (15) | Yes | Unique identifier. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | Identifies the campaign schedule defined in AMS_CAMPAIGN_SCHDULES_B. |
RESOURCE_ID | NUMBER | (15) | Yes | Identifies the resource defined in JTF_RS_RESOURCE_EXTNS. |
DATA_START_TIME | DATE | Yes | Start time of the current interval during which the results are tallied. | |
DATA_END_TIME | DATE | Yes | End time of the current interval during which the results were tallied. | |
OUTCOME_ID | NUMBER | (15) | Yes | Represents the outcome of the dial. |
RESULT_ID | NUMBER | (15) | Represents the result of the customer interaction. | |
TOTAL_RESULT_COUNT | NUMBER | (9) | Represents the number of occurences of a certain outcome_id/result_id pair in the current interval. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_OUTCOME_SUM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CAMPAIGN_SCHEDULE_ID
, RESOURCE_ID
, DATA_START_TIME
, DATA_END_TIME
, OUTCOME_ID
, RESULT_ID
, TOTAL_RESULT_COUNT
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEC.IEC_G_REP_AGENT_OUTCOME_SUMS;
IEC.IEC_G_REP_AGENT_OUTCOME_SUMS does not reference any database object
IEC.IEC_G_REP_AGENT_OUTCOME_SUMS is referenced by following:
|
|
|