[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_CALL_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | BIX |
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: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEDIA_ID | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | |||
CLASSIFICATION_ID | NUMBER | |||
SERVER_GROUP_ID | NUMBER | |||
FROM_SERVER_GROUP_ID | NUMBER | |||
MEDIA_ITEM_TYPE | VARCHAR2 | (50) | ||
DNIS | VARCHAR2 | (32) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_START_TIME | VARCHAR2 | (30) | ||
PERIOD_START_DATE_TIME | DATE | |||
CALLS_OFFERED | NUMBER | |||
CALLS_IN_QUEUE | NUMBER | |||
IN_CALLS_HANDLED | NUMBER | |||
CALLS_TRANSFERED | NUMBER | |||
CALLS_ABANDONED | NUMBER | |||
OUT_CALLS_HANDLED | NUMBER | |||
PRIMARY_COUNT | NUMBER | |||
OTHER_COUNT | NUMBER | |||
IVR_TIME | NUMBER | |||
ROUTE_TIME | NUMBER | |||
QUEUE_TIME | NUMBER | |||
IN_TALK_TIME | NUMBER | |||
IN_WRAP_TIME | NUMBER | |||
ABANDON_TIME | NUMBER | |||
OUT_TALK_TIME | NUMBER | |||
OUT_WRAP_TIME | NUMBER | |||
CAMPAIGN_ID | NUMBER | |||
CAMPAIGN_SCHEDULE | VARCHAR2 | (30) | ||
TOTAL_IN_TALK_TIME | NUMBER | |||
TOTAL_OUT_TALK_TIME | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (30) | ||
CAMPAIGN_SCHEDULE_ID | NUMBER | |||
OUT_PREVIEW_TIME | NUMBER | Out Preview Time | ||
OUT_CONTACT_HANDLE_TIME | NUMBER | Out Contact Handle Time | ||
OUT_CALLS_DIALED | NUMBER | OUT_CALLS_DIALED | ||
OUT_CONNECT_COUNT | VARCHAR2 | (240) | OUT_CONNECT_COUNT | |
OUT_NON_CONNECT_COUNT | VARCHAR2 | (240) | OUT_NON_CONNECT_COUNT | |
OUT_CONTACT_COUNT | VARCHAR2 | (240) | OUT_CONTACT_COUNT | |
OUT_NON_CONTACT_COUNT | VARCHAR2 | (240) | OUT_NON_CONTACT_COUNT | |
OUT_POSITIVE_RESPONSE_COUNT | VARCHAR2 | (240) | OUT_POSITIVE_RESPONSE_COUNT | |
OUT_BUSY_COUNT | VARCHAR2 | (240) | OUT_BUSY_COUNT | |
OUT_ABANDON_COUNT | VARCHAR2 | (240) | OUT_ABANDON_COUNT | |
OUT_RING_NOANSWER_COUNT | VARCHAR2 | (240) | OUT_RING_NOANSWER_COUNT | |
OUT_ANS_MC_COUNT | VARCHAR2 | (240) | OUT_ANS_MC_COUNT | |
OUT_SIT_COUNT | VARCHAR2 | (240) | OUT_SIT_COUNT | |
OUT_OTHER_OUTCOME_COUNT | VARCHAR2 | (240) | OUT_OTHER_OUTCOME_COUNT | |
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT MEDIA_ID
, RESOURCE_ID
, CLASSIFICATION_ID
, SERVER_GROUP_ID
, FROM_SERVER_GROUP_ID
, MEDIA_ITEM_TYPE
, DNIS
, CURRENCY_CODE
, PERIOD_START_DATE
, PERIOD_START_TIME
, PERIOD_START_DATE_TIME
, CALLS_OFFERED
, CALLS_IN_QUEUE
, IN_CALLS_HANDLED
, CALLS_TRANSFERED
, CALLS_ABANDONED
, OUT_CALLS_HANDLED
, PRIMARY_COUNT
, OTHER_COUNT
, IVR_TIME
, ROUTE_TIME
, QUEUE_TIME
, IN_TALK_TIME
, IN_WRAP_TIME
, ABANDON_TIME
, OUT_TALK_TIME
, OUT_WRAP_TIME
, CAMPAIGN_ID
, CAMPAIGN_SCHEDULE
, TOTAL_IN_TALK_TIME
, TOTAL_OUT_TALK_TIME
, SOURCE_CODE
, CAMPAIGN_SCHEDULE_ID
, OUT_PREVIEW_TIME
, OUT_CONTACT_HANDLE_TIME
, OUT_CALLS_DIALED
, OUT_CONNECT_COUNT
, OUT_NON_CONNECT_COUNT
, OUT_CONTACT_COUNT
, OUT_NON_CONTACT_COUNT
, OUT_POSITIVE_RESPONSE_COUNT
, OUT_BUSY_COUNT
, OUT_ABANDON_COUNT
, OUT_RING_NOANSWER_COUNT
, OUT_ANS_MC_COUNT
, OUT_SIT_COUNT
, OUT_OTHER_OUTCOME_COUNT
, SECURITY_GROUP_ID
FROM BIX.BIX_DM_CALL_INTERFACE;
BIX.BIX_DM_CALL_INTERFACE does not reference any database object
BIX.BIX_DM_CALL_INTERFACE is referenced by following:
|
|
|