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_G_CPN_RT_INFO

Object Details

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

IEC_G_CPN_RT_INFO stores runtime information for a particular campaign that is used by the OAO components.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEC_G_CPN_RT_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CPN_RT_INFO_ID
IEC_G_CPN_RT_INFO_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAMPAIGN_ID
IEC_G_CPN_RT_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERVER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CPN_RT_INFO_ID	NUMBER	(15)	Yes	Unique Identifier
SERVER_ID	NUMBER	(15)	Yes	Server ID is a foreign key to the IEO_SERVERS table and is used to specify the unique predictive server that is setting this runtime information.
CAMPAIGN_SCHEDULE_ID	NUMBER	(15)
TOTAL_CACHE_COUNT	NUMBER	(10)		The current number of callable entries in the OAO list entry cache.
CACHE_AMT_TAKEN	NUMBER	(10)		The current number of entries to fetch from the cache for this campaign for this predictive server.
CACHE_UPDATE_TIME	DATE			When the last retrieve from the cache occurred.
USE_FLAG	VARCHAR2	(1)		Flag indicating whether or not the campaign corresponding to this entry is currently in use.
WORKING_QUANTUM	NUMBER	(10)		The current working quantum for the campaign corresponding to this entry.
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.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Used for locking in HTML applications.
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments.
CAMPAIGN_ID	NUMBER	(15)		Campaign ID
CALL_CENTER_READY_FLAG	VARCHAR2	(1)		Call Center reday flag
CTI_DISABLED_FLAG	VARCHAR2	(1)		CTI Disable Flag
AGENTLESS_FLAG	VARCHAR2	(1)		Y for AgenlLess Campaign
AGENTLESS_EXEC_MODE	VARCHAR2	(15)		Execution Mode for Agentless Campaigns
NUM_VDU_PORTS	NUMBER	(15)		Number of VDU ports assigned for Agentless Campaigns
EXECUTION_STATUS	VARCHAR2	(240)		Execution Status
STRATEGY_UPDATE_DATE	DATE			The last time a dial server reacted to a modification of the release strategy configuration.

Query Text

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


SELECT CPN_RT_INFO_ID
,      SERVER_ID
,      CAMPAIGN_SCHEDULE_ID
,      TOTAL_CACHE_COUNT
,      CACHE_AMT_TAKEN
,      CACHE_UPDATE_TIME
,      USE_FLAG
,      WORKING_QUANTUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      CAMPAIGN_ID
,      CALL_CENTER_READY_FLAG
,      CTI_DISABLED_FLAG
,      AGENTLESS_FLAG
,      AGENTLESS_EXEC_MODE
,      NUM_VDU_PORTS
,      EXECUTION_STATUS
,      STRATEGY_UPDATE_DATE
FROM IEC.IEC_G_CPN_RT_INFO;

Dependencies

[top of page]

IEC.IEC_G_CPN_RT_INFO does not reference any database object

IEC.IEC_G_CPN_RT_INFO is referenced by following:

IEC: IEC_G_CPN_RT_INFO#