eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS#

Object Details

Object Name:	IEC_G_REP_CAMPAIGN_DIAL_STATS#
Object Type:	VIEW
Owner:	IEC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CPN_DIAL_STATS_ID	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CAMPAIGN_SCHEDULE_ID	NUMBER	(15)	Yes
LIST_HEADER_ID	NUMBER	(15)	Yes
LIST_SUBSET_ID	NUMBER	(15)	Yes
DATA_START_TIME	DATE		Yes
DATA_END_TIME	DATE		Yes
DIALS	NUMBER	(9)
PREVIEW_DIALS	NUMBER	(9)
PROGRESSIVE_DIALS	NUMBER	(9)
PREDICTIVE_DIALS	NUMBER	(9)
DO_NOT_CALL	NUMBER	(9)
VOICE_DETECTED	NUMBER	(9)
ABANDONED_CALL	NUMBER	(9)
WITHDRAWN_CALL	NUMBER	(9)
FRONT_HOLD_CALL	NUMBER	(9)
ABANDONED_CALL_HO	NUMBER	(9)
MESSAGES_ON_ANS_MACH	NUMBER	(9)
CONNECTED	NUMBER	(9)
RING_NO_ANSWER	NUMBER	(9)
BUSIES	NUMBER	(9)
ANSWER_MACHINE	NUMBER	(9)
FAX	NUMBER	(9)
MODEM	NUMBER	(9)
CHANGE_NUMBER_SIT	NUMBER	(9)
FAST_BUSIES_SIT	NUMBER	(9)
UNDEFINED_SIT	NUMBER	(9)
OTHER	NUMBER	(9)
SECURITY_GROUP_ID	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
MANUAL_DIALS	NUMBER	(9)

Query Text

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#;

Dependencies

[top of page]

IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS# references the following:

IEC: IEC_G_REP_CAMPAIGN_DIAL_STATS

IEC.IEC_G_REP_CAMPAIGN_DIAL_STATS# is referenced by following:

APPS: IEC_G_REP_CAMPAIGN_DIAL_STATS