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_LIST_RT_INFO

Object Details

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

Stores run time information for a executing lists.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEC_G_LIST_RT_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_RT_INFO_ID
IEC_G_LIST_RT_INFO_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAMPAIGN_SCHEDULE_ID
IEC_G_LIST_RT_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALL_CENTER_READY_FLAG
IEC_G_LIST_RT_INFO_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_RT_INFO_ID	NUMBER	(15)	Yes	Unique Identifier
LIST_HEADER_ID	NUMBER	(15)	Yes	Foreign key to the AMS_LIST_HEADERS_ALL table specifying which list this workarea represents.
WORKING_QUANTUM	NUMBER	(7)		Used by the release strategy indicates the current working value for the list quantum.
WORKING_QUOTA	NUMBER	(7)		Used by the release strategy indicates the current working value for the list quota..
QUOTA_RESET_TIME	DATE			When the quota needs to be reset.
CACHE_AMT_TAKEN	NUMBER	(10)		The number of entries that we predict are currently necessary in the OAO cache for this list to support the predictive server.
TOTAL_CACHE_COUNT	NUMBER	(10)		The current number of callable entries in the OAO list entry cache.
RT_QUOTA_COUNT	NUMBER	(15)		Run time quota count.
CACHE_AMT_NEEDED	NUMBER	(10)		The number of entries that we predict are currently necessary in the OAO cache for this list to support the list management.
VALID_FLAG	VARCHAR2	(1)		Determines whether the list is valid or not.
USE_FLAG	VARCHAR2	(1)		This will be set to indicate that this list should or shouldn't currently be used.
CALLABLE_FLAG	VARCHAR2	(1)		This flag indicates whether or not this list is currently callable.
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.
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments.
EXECUTION_START_TIME	DATE			Time when AO begin execution on target group.
TRANSITION_STATUS	VARCHAR2	(1)		This flag indicates whether or not a list is undergoing subset transitions.
CAMPAIGN_ID	NUMBER	(15)	Yes	campaign id
CAMPAIGN_SCHEDULE_ID	NUMBER	(15)		Campaign Schedule Id
STATUS_CODE	VARCHAR2	(30)		Advanced Outbound List Status.
DIALING_METHOD	VARCHAR2	(30)		Dialing Method
RELEASE_CONTROL_ALG_ID	NUMBER			Release Control Algorithm Id
RELEASE_STRATEGY	VARCHAR2	(30)		Release Strategy
QUANTUM	NUMBER			Quantum
CALLING_CALENDAR_ID	NUMBER			Calling Calendar id
RECYCLING_ALG_ID	NUMBER			Recycling Algorithm ID
QUOTA	NUMBER	(10)		Quota
QUOTA_RESET	NUMBER			Quota Reset time
CALL_CENTER_READY_FLAG	VARCHAR2	(1)		Call center ready flag
PREVIEW_TIME	NUMBER	(15)		Preview Time
DISTRIBUTION_PRIORITY	VARCHAR2	(20)		Distribution Priority
DISTRIBUTION_WEIGHT	NUMBER			Distribution Weight
VALIDATION_RULE_ID	NUMBER			Validation Rule ID
VALIDATION_ACTION_BLOCK_ID	NUMBER			Validation Action Block ID
RESET_TIME	VARCHAR2	(30)		Reset Time
PREDICTIVE_TIMEOUT	VARCHAR2	(15)		Predictive Timeout
ABANDON_LIMIT	VARCHAR2	(15)		Abandon Limit
AGENT_LINE_RATIO	NUMBER	(15)		Agent Line Ratio
PARAMS_INHERITED_FLAG	VARCHAR2	(1)		Flag for Inherited Campaign Parameters
STRATEGY_RELEASED	NUMBER	(15)		Entries released on this list since the last campaign release strategy modification.
STRATEGY_UPDATE_DATE	DATE			The last time a dial server reacted to a modification of the release strategy configuration.
SERVER_DISTRIBUTION_WEIGHT	NUMBER			The distribution weight the server last reacted to.
SERVER_DISTRIBUTION_PRIORITY	VARCHAR2	(20)		The distribution priority the server last reacted to.
DIALING_COMPLIANCE_RULE	VARCHAR2	(240)		Specifies which Dialing Compliance Rule (eg. FTC) is being enforced.
ENABLE_WITHDRAW_FLAG	VARCHAR2	(1)		Determines whether calls can be withdrawn
ENABLE_ABANDON_FLAG	VARCHAR2	(1)		Determines whether calls can be abandoned
API_INITIATED_FLAG	VARCHAR2	(1)		Flag used to indicate if the action (i.e. valid

Query Text

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


SELECT LIST_RT_INFO_ID
,      LIST_HEADER_ID
,      WORKING_QUANTUM
,      WORKING_QUOTA
,      QUOTA_RESET_TIME
,      CACHE_AMT_TAKEN
,      TOTAL_CACHE_COUNT
,      RT_QUOTA_COUNT
,      CACHE_AMT_NEEDED
,      VALID_FLAG
,      USE_FLAG
,      CALLABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      EXECUTION_START_TIME
,      TRANSITION_STATUS
,      CAMPAIGN_ID
,      CAMPAIGN_SCHEDULE_ID
,      STATUS_CODE
,      DIALING_METHOD
,      RELEASE_CONTROL_ALG_ID
,      RELEASE_STRATEGY
,      QUANTUM
,      CALLING_CALENDAR_ID
,      RECYCLING_ALG_ID
,      QUOTA
,      QUOTA_RESET
,      CALL_CENTER_READY_FLAG
,      PREVIEW_TIME
,      DISTRIBUTION_PRIORITY
,      DISTRIBUTION_WEIGHT
,      VALIDATION_RULE_ID
,      VALIDATION_ACTION_BLOCK_ID
,      RESET_TIME
,      PREDICTIVE_TIMEOUT
,      ABANDON_LIMIT
,      AGENT_LINE_RATIO
,      PARAMS_INHERITED_FLAG
,      STRATEGY_RELEASED
,      STRATEGY_UPDATE_DATE
,      SERVER_DISTRIBUTION_WEIGHT
,      SERVER_DISTRIBUTION_PRIORITY
,      DIALING_COMPLIANCE_RULE
,      ENABLE_WITHDRAW_FLAG
,      ENABLE_ABANDON_FLAG
,      API_INITIATED_FLAG
FROM IEC.IEC_G_LIST_RT_INFO;

Dependencies

[top of page]

IEC.IEC_G_LIST_RT_INFO does not reference any database object

IEC.IEC_G_LIST_RT_INFO is referenced by following:

APPS: IEC_G_LIST_RT_INFO