[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_CAMPAIGN_DIAL_STATS |
---|---|
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_CAMPAIGN_DIAL_ST_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
DATA_START_TIME
CAMPAIGN_SCHEDULE_ID |
IEC_G_REP_CAMPAIGN_DIAL_ST_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CPN_DIAL_STATS_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. |
LIST_HEADER_ID | NUMBER | (15) | Yes | Identifies the list header defined in AMS_LIST_HEADERS_ALL. |
LIST_SUBSET_ID | NUMBER | (15) | Yes | Identifies the list header defined in IEC_G_LIST_SUBSETS. |
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. | |
DIALS | NUMBER | (9) | Number of dails made during the current interval. | |
PREVIEW_DIALS | NUMBER | (9) | Number of preview dails made during the current interval. | |
PROGRESSIVE_DIALS | NUMBER | (9) | Number of progressive dails made during the current interval. | |
PREDICTIVE_DIALS | NUMBER | (9) | Number of predictive dails made during the current interval. | |
DO_NOT_CALL | NUMBER | (9) | Number of DO NOT CALL records encountered during the current interval. | |
VOICE_DETECTED | NUMBER | (9) | Number of voices detected during the current interval. | |
ABANDONED_CALL | NUMBER | (9) | Number of abandoned calls during the current interval. | |
WITHDRAWN_CALL | NUMBER | (9) | Number of withdrawn calls during the current interval. | |
FRONT_HOLD_CALL | NUMBER | (9) | Number of calls in the hold queue during the current interval. | |
ABANDONED_CALL_HO | NUMBER | (9) | Number of calls withdrawn from the hold queue during the current interval. | |
MESSAGES_ON_ANS_MACH | NUMBER | (9) | Number of answering machine messages left during the current interval. | |
CONNECTED | NUMBER | (9) | Number ofsuccessful connections during the current interval. | |
RING_NO_ANSWER | NUMBER | (9) | Number of unanswered calls made during the current interval. | |
BUSIES | NUMBER | (9) | Number of busy signals received during the current interval. | |
ANSWER_MACHINE | NUMBER | (9) | Number of answering machines encountered during the current interval. | |
FAX | NUMBER | (9) | Number of fax machines encountered during the current interval. | |
MODEM | NUMBER | (9) | Number of modems encountered during the current interval. | |
CHANGE_NUMBER_SIT | NUMBER | (9) | Number of times the 'Change Number' tone was encountered during the current interval. This tone means that the callee is no longer at the number dialed. | |
FAST_BUSIES_SIT | NUMBER | (9) | Number of times the 'Fast Busyr' tone was encountered during the current interval. This tone means that the telephone network is busy. | |
UNDEFINED_SIT | NUMBER | (9) | Number of times an unknown Special Information Tone was encountered during the current interval. | |
OTHER | NUMBER | (9) | Number of times during the current interval that the outcome of the dial was other than those being tracked. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Standard who column. | |
MANUAL_DIALS | NUMBER | (9) | Number of manual dials made during the current interval. |
Cut, paste (and edit) the following text to query this object:
SELECT CPN_DIAL_STATS_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CAMPAIGN_SCHEDULE_ID
, LIST_HEADER_ID
, LIST_SUBSET_ID
, DATA_START_TIME
, DATA_END_TIME
, DIALS
, PREVIEW_DIALS
, PROGRESSIVE_DIALS
, PREDICTIVE_DIALS
, DO_NOT_CALL
, VOICE_DETECTED
, ABANDONED_CALL
, WITHDRAWN_CALL
, FRONT_HOLD_CALL
, ABANDONED_CALL_HO
, MESSAGES_ON_ANS_MACH
, CONNECTED
, RING_NO_ANSWER
, BUSIES
, ANSWER_MACHINE
, FAX
, MODEM
, CHANGE_NUMBER_SIT
, FAST_BUSIES_SIT
, UNDEFINED_SIT
, OTHER
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, MANUAL_DIALS
FROM IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS;
IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS does not reference any database object
IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS is referenced by following:
|
|
|