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: BIX.BIX_INTERACTIONS

Object Details

Object Name:	BIX_INTERACTIONS
Object Type:	TABLE
Owner:	BIX
FND Design Data:	BIX.BIX_INTERACTIONS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIX_INTERACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	START_TS RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERACTIONS_ID	NUMBER		Yes	Primary Key
INTERACTION_IDENTIFICATION	VARCHAR2	(240)		Interaction Identification
MEDIA_ITEM_TYPE	VARCHAR2	(240)		Kind of Media
MEDIA_ITEM_REF	VARCHAR2	(240)		Media Item ID
SEQUENCE	NUMBER	(4)		Sequence number
INTERACTION_TYPE	VARCHAR2	(32)		Type of Call placed
INTERACTION_SUBTYPE	VARCHAR2	(32)		Subtype of call placed
INTERACTION_CLASSIFICATION	VARCHAR2	(240)		Routing module classification
PARTY_ID	NUMBER	(15)
ANI	VARCHAR2	(32)		Customer phone Number
DNIS	VARCHAR2	(32)		Customer Dialed Number
RESOURCE_ID	NUMBER			Agent ID
RESOURCE_GROUP_ID	NUMBER			Agent Group
INTERACTION_CENTER_ID	NUMBER			From CCT_CALL_CENTER
PREVIEW_TIME	NUMBER			Time spent before accepting call
START_TS	DATE			Start of Interaction Timestamp
IVR_TIME	NUMBER			IVR Duration in seconds
ROUTE_TIME	NUMBER			Routing Duration
PARTY_WAIT_TIME	NUMBER			Customer Wait Time
TALK_TIME	NUMBER			Talk time with customer
WRAP_TIME	NUMBER			Time spent completing interaction
IDLE_TIME	NUMBER			Time the agent waits for the next call
COMPLETED_TS	DATE			End of Interaction Timestamp
NON_PRODUCTIVE_TIME	NUMBER			Non-Productive time in this interaction
OUTCOME_ID	NUMBER			General outcome of this Interaction
RESULT_ID	NUMBER			Specific outcome of this interaction
REASON_ID	NUMBER			Reason for the outcome
HANDLER_ID	NUMBER			Client Application ID
CAMPAIGN_ID	NUMBER			Campaign that generated this call
LIST_ID	NUMBER			List that generated this call
SCRIPT_ID	NUMBER			Script used in this Interaction
SERVICE_REQUEST_CHANNEL_ID	NUMBER			Service Request Channel
FIRST_INTERACTION_RESOLN_FLAG	NUMBER	(1)		If Call was resolved by the first agent
RESPONSE_TIME	NUMBER			Time to respond to iCenter request
RESOLUTION_TIME	NUMBER			Clock time to resolve iCenter request
RESOLUTION_TIME_INTERNAL	NUMBER			Actual time to resolve request
SALES_QUOTES	NUMBER			# of Sales Quotes generated
LEADS_GENERATED	NUMBER			# of Leads generated
AMOUNT_COLLECTED	NUMBER	(16)		Amount collected form Customer
PROMISE_TO_PAY	NUMBER	(16)		Amount delinquent promises to pay
USER_ATTRIBUTE1	VARCHAR2	(150)		User definable column1
USER_ATTRIBUTE2	VARCHAR2	(150)		User definable column2
USER_ATTRIBUTE3	VARCHAR2	(150)		User definable column3
USER_ATTRIBUTE4	VARCHAR2	(150)		User definable column4
USER_ATTRIBUTE5	VARCHAR2	(240)		User definable column5
SECURITY_GROUP_ID	NUMBER			column for CRM hosting

Query Text

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


SELECT INTERACTIONS_ID
,      INTERACTION_IDENTIFICATION
,      MEDIA_ITEM_TYPE
,      MEDIA_ITEM_REF
,      SEQUENCE
,      INTERACTION_TYPE
,      INTERACTION_SUBTYPE
,      INTERACTION_CLASSIFICATION
,      PARTY_ID
,      ANI
,      DNIS
,      RESOURCE_ID
,      RESOURCE_GROUP_ID
,      INTERACTION_CENTER_ID
,      PREVIEW_TIME
,      START_TS
,      IVR_TIME
,      ROUTE_TIME
,      PARTY_WAIT_TIME
,      TALK_TIME
,      WRAP_TIME
,      IDLE_TIME
,      COMPLETED_TS
,      NON_PRODUCTIVE_TIME
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      HANDLER_ID
,      CAMPAIGN_ID
,      LIST_ID
,      SCRIPT_ID
,      SERVICE_REQUEST_CHANNEL_ID
,      FIRST_INTERACTION_RESOLN_FLAG
,      RESPONSE_TIME
,      RESOLUTION_TIME
,      RESOLUTION_TIME_INTERNAL
,      SALES_QUOTES
,      LEADS_GENERATED
,      AMOUNT_COLLECTED
,      PROMISE_TO_PAY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      SECURITY_GROUP_ID
FROM BIX.BIX_INTERACTIONS;

Dependencies

[top of page]

BIX.BIX_INTERACTIONS does not reference any database object

BIX.BIX_INTERACTIONS is referenced by following:

APPS: BIX_INTERACTIONS