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]

TABLE: IEC.IEC_REP_CPN_DIAL_STATS

Object Details

Object Name:	IEC_REP_CPN_DIAL_STATS
Object Type:	TABLE
Owner:	IEC
Subobject Name:
Status:	VALID

This table stores the dialing statistics for a campaign schedule between two data collecting time points.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CAMPAIGN_SCHEDULE_ID	NUMBER	(15)	Yes	Foreign Key to SCHEDULE_ID in AMS_CAMPAIGN_SCHEDULES
DIAL_SERVER_ID	NUMBER	(15)	Yes	Foreign Key to SERVER_ID
DATA_START_TIME	DATE		Yes	Begin time of data collection
DATA_END_TIME	DATE		Yes	End time of data collection
TOTAL_DIALS	NUMBER	(10)	Yes	Total Dials
OUTCOME_ID	NUMBER	(10)	Yes	Total Predictive Dials
RESULT_ID	NUMBER	(10)	Yes	Total positive response
RESULT_COUNT	NUMBER	(10)	Yes	Other count 1
POSITIVE_RESPONSE_FLAG	VARCHAR2	(1)		Other count 2
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			Used for locking purposes
CONTACT_FLAG	VARCHAR2	(1)		Flag indicating whether contact has been made or not
CAMPAIGN_ID	NUMBER	(15)	Yes	Campaign ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CPN_DIAL_STATS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CAMPAIGN_SCHEDULE_ID
,      DIAL_SERVER_ID
,      DATA_START_TIME
,      DATA_END_TIME
,      TOTAL_DIALS
,      OUTCOME_ID
,      RESULT_ID
,      RESULT_COUNT
,      POSITIVE_RESPONSE_FLAG
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      CONTACT_FLAG
,      CAMPAIGN_ID
FROM IEC.IEC_REP_CPN_DIAL_STATS;

Dependencies

[top of page]

IEC.IEC_REP_CPN_DIAL_STATS does not reference any database object

IEC.IEC_REP_CPN_DIAL_STATS is referenced by following:

APPS: IEC_REP_CPN_DIAL_STATS