[Home] [Help] [Dependency Information]
Object Name: | BIX_INTERACTIONS |
---|---|
Object Type: | TABLE |
Owner: | BIX |
FND Design Data: | BIX.BIX_INTERACTIONS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_INTERACTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
START_TS
RESOURCE_ID |
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 |
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;
BIX.BIX_INTERACTIONS does not reference any database object
BIX.BIX_INTERACTIONS is referenced by following:
|
|
|