[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_CALL_SUM |
---|---|
Object Type: | TABLE |
Owner: | BIX |
Subobject Name: | |
Status: | VALID |
This table stores call related informations . The dimensions of this table are time , classification , site , and dnis . The data is stored by half-hour bucket .
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_DM_CALL_SUM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | PERIOD_START_DATE |
BIX_DM_CALL_SUM_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
CLASSIFICATION_ID
PERIOD_START_DATE |
BIX_DM_CALL_SUM_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
CLASSIFICATION_ID
PERIOD_START_DATE_TIME |
BIX_DM_CALL_SUM_N5 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
DNIS_ID
PERIOD_START_DATE_TIME |
BIX_DM_CALL_SUM_N6 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE_TIME
CAMPAIGN_ID CAMPAIGN_SCHEDULE_ID SERVER_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALL_SUMMARY_ID | NUMBER | Yes | Unique identifier generated from a sequence . | |
LAST_UPDATE_DATE | DATE | Standard Who COlumn | ||
LAST_UPDATED_BY | NUMBER | Standard Who COlumn | ||
CREATION_DATE | DATE | Standard Who COlumn | ||
CREATED_BY | NUMBER | Standard Who COlumn | ||
LAST_UPDATE_LOGIN | DATE | Standard Who COlumn | ||
PERIOD_START_DATE | DATE | Yes | The date that the measures correspond to . | |
PERIOD_START_TIME | VARCHAR2 | (5) | Yes | The half-hour bucket that the measures correspond to . |
PERIOD_START_DATE_TIME | DATE | The date-time that the measures correspond to . This column is a concatenation of the columns period_start_date and period_start_time . | ||
CLASSIFICATION_ID | NUMBER | Not used . | ||
SERVER_GROUP_ID | NUMBER | (15) | Unique identifier for the site . | |
DNIS_ID | NUMBER | Unique identifier for DNIS . | ||
CALLS_OFFERED | NUMBER | Number of inbound calls that have come to the system . | ||
CALLS_IN_QUEUE | NUMBER | Number of calls that were in queue . | ||
CALLS_ABANDONED | NUMBER | Number of calls that were abandoned . | ||
CALLS_ANSWRD_WITHIN_X_TIME | NUMBER | Number of calls that were answered within a threshold time , defined by the user as a profile . | ||
IVR_TIME | NUMBER | Total interactive Voice Response time of all the calls . | ||
ROUTE_TIME | NUMBER | Total route time of all the calls . | ||
QUEUE_TIME | NUMBER | Total queue time of all the calls . | ||
ABANDON_TIME | NUMBER | Total time of the calls before they were abandoned . | ||
MIN_IVR_TIME | NUMBER | Minimum Interactive Voice Response time of all the calls . | ||
MAX_IVR_TIME | NUMBER | Maximum Interactive Voice Response time of all the calls . | ||
MIN_ROUTE_TIME | NUMBER | Minimum route time of all the calls . | ||
MAX_ROUTE_TIME | NUMBER | Maximum Route time of all the calls . | ||
MIN_QUEUE_TIME | NUMBER | Minimum queue time of all the calls . | ||
MAX_QUEUE_TIME | NUMBER | Maximum queue time of all the calls . | ||
MIN_ABANDON_TIME | NUMBER | Minimum abandon time of all the calls which are abandoned . | ||
MAX_ABANDON_TIME | NUMBER | Maximum abandon time of all the calls which are abandoned . | ||
IN_CALLS_HANDLED | NUMBER | Number of inbound calls handled . | ||
IN_CALLS_HANDLD_GT_THN_X_TIME | NUMBER | Number of inbound calls handled which are greater than a threshold time , defined by the user as a profile . | ||
OUT_CALLS_HANDLED | NUMBER | Number of outbound calls handled . | ||
OUT_CALLS_HANDLD_GT_THN_X_TIME | NUMBER | Number of outbound calls handled which are greater than a threshold time , defined by the user as a profile . | ||
CALLS_TRANSFERED | NUMBER | Number of calls transferred from one agent to another . | ||
CALLS_OFFRD_GT_THN_X_TIME | NUMBER | Number of calls that has come into the system and the duration of the calls is greater than a threshold time , defined by the user as a profile . | ||
QUEUE_TIME_FOR_CALLS_HANDLED | NUMBER | Total queue time for all the calls which are handled . | ||
MAX_QUEUE_TIME_CALLS_HANDLD | NUMBER | Maximum queue time for all the calls which are handled . | ||
NUMBER_OF_REROUTES | NUMBER | Not used . | ||
PRIMARY_COUNT | NUMBER | Not Used . | ||
IN_TALK_TIME | NUMBER | Time spent in talking for all inbound calls . | ||
OUT_TALK_TIME | NUMBER | Time spent in talking for all outbound calls . | ||
IN_WRAP_TIME | NUMBER | Time spent in wrapping all inbound calls . | ||
OUT_WRAP_TIME | NUMBER | Time spent in wrapping all outbound calls . | ||
SR_CREATED | NUMBER | Number of Service Requests created . | ||
SR_OPENED | NUMBER | Number of service requests opened . | ||
SR_CLOSED | NUMBER | Number of service requests opened . | ||
SR_FIRST_CONTACT_CLOSE | NUMBER | Number of service requests closed during the first contact with the customer . | ||
SR_ADDITIONAL_INFO_REQUESTED | NUMBER | Number of service requests for which additional information is requested . | ||
SR_KB_UPDATES | NUMBER | Number of service requests which has lead to updates in knowledge base information . | ||
LEADS_CREATED | NUMBER | Number of leads created . | ||
LEADS_UPDATED | NUMBER | Number of leads updated . | ||
LEADS_AMOUNT | NUMBER | Total lead amount of all the leads created in BIX currency . | ||
LEADS_CONVERTED_TO_OPP | NUMBER | Number of leads converted to opportunities . | ||
OPPORTUNITIES_CREATED | NUMBER | Number of opportunities created . | ||
OPPORTUNITIES_UPDATED | NUMBER | Number of opportunities updated . | ||
OPPORTUNITIES_WON | NUMBER | Number of opportunities won . | ||
OPPORTUNITIES_WON_AMOUNT | NUMBER | Total amount of all the opportunities won in BIX currency . | ||
OPPORTUNITIES_CROSS_SOLD | NUMBER | Number of opportunities cross sold . | ||
OPPORTUNITIES_UP_SOLD | NUMBER | Number of opportunities up sold . | ||
OPPORTUNITIES_DECLINED | NUMBER | Number of opportunities declined . | ||
OPPORTUNITIES_LOST | NUMBER | Number of opportunities lost . | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfiled structure defining column . | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment . | |
SECURITY_GROUP_ID | NUMBER | Subscriber id for CRM Online Services use . | ||
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update this record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update this record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update this record . | ||
PROGRAM_UPDATE_DATE | DATE | Date when a concurrent program last updated this record . | ||
NO_OF_OPP_WON_CALLS | NUMBER | Number of calls in which opportunities are won . | ||
NO_OF_OPP_SOLD_CALLS | NUMBER | Number of calls in which opportunities are sold . | ||
OPPORTUNITIES_WON_AMOUNT_TXN | NUMBER | Toatl amount of all the opportunities which are won in transactional curreny . | ||
LEADS_AMOUNT_TXN | NUMBER | Toatl amount of all the leads which are creaated in transactional curreny . | ||
CAMPAIGN_ID | NUMBER | Unique identifier for the marketing campaign . | ||
CAMPAIGN_SCHEDULE_ID | NUMBER | Unique identifier for the marketing campaign schedule . | ||
OUT_PREVIEW_TIME | NUMBER | Preview time of all the outbound calls . | ||
OUT_CONTACT_HANDLE_TIME | NUMBER | Handle time of all the outbound calls which are contacted . | ||
OUT_CALLS_DIALED | NUMBER | Number of outbound calls dialed . | ||
OUT_CONNECT_COUNT | NUMBER | Number of outbound calls which are connected . | ||
OUT_NON_CONNECT_COUNT | NUMBER | Number of outbound calls which are not connected . | ||
OUT_CONTACT_COUNT | NUMBER | Number of outbound calls which are contacted . | ||
OUT_NON_CONTACT_COUNT | NUMBER | Number of outbound calls which are not contacted . | ||
OUT_POSITIVE_RESPONSE_COUNT | NUMBER | Number of outbound calls which are considered as positive response from the customer . | ||
OUT_BUSY_COUNT | NUMBER | Number of outbound calls which have got busy signal . | ||
OUT_ABANDON_COUNT | NUMBER | Number of outbound calls which are abandoned . | ||
OUT_RING_NOANSWER_COUNT | NUMBER | Number of outbound calls which has got the ring but has not got any answer . | ||
OUT_ANS_MC_COUNT | NUMBER | Number of outbound calls which has reached answering machine . | ||
OUT_SIT_COUNT | NUMBER | Number of outbound SIT calls . | ||
OUT_OTHER_OUTCOME_COUNT | NUMBER | Number of outbound calls having other outcomes . | ||
CLASSIFICATION_VALUE_ID | NUMBER | (15) | Unique identifier for the classification . |
Cut, paste (and edit) the following text to query this object:
SELECT CALL_SUMMARY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PERIOD_START_DATE
, PERIOD_START_TIME
, PERIOD_START_DATE_TIME
, CLASSIFICATION_ID
, SERVER_GROUP_ID
, DNIS_ID
, CALLS_OFFERED
, CALLS_IN_QUEUE
, CALLS_ABANDONED
, CALLS_ANSWRD_WITHIN_X_TIME
, IVR_TIME
, ROUTE_TIME
, QUEUE_TIME
, ABANDON_TIME
, MIN_IVR_TIME
, MAX_IVR_TIME
, MIN_ROUTE_TIME
, MAX_ROUTE_TIME
, MIN_QUEUE_TIME
, MAX_QUEUE_TIME
, MIN_ABANDON_TIME
, MAX_ABANDON_TIME
, IN_CALLS_HANDLED
, IN_CALLS_HANDLD_GT_THN_X_TIME
, OUT_CALLS_HANDLED
, OUT_CALLS_HANDLD_GT_THN_X_TIME
, CALLS_TRANSFERED
, CALLS_OFFRD_GT_THN_X_TIME
, QUEUE_TIME_FOR_CALLS_HANDLED
, MAX_QUEUE_TIME_CALLS_HANDLD
, NUMBER_OF_REROUTES
, PRIMARY_COUNT
, IN_TALK_TIME
, OUT_TALK_TIME
, IN_WRAP_TIME
, OUT_WRAP_TIME
, SR_CREATED
, SR_OPENED
, SR_CLOSED
, SR_FIRST_CONTACT_CLOSE
, SR_ADDITIONAL_INFO_REQUESTED
, SR_KB_UPDATES
, LEADS_CREATED
, LEADS_UPDATED
, LEADS_AMOUNT
, LEADS_CONVERTED_TO_OPP
, OPPORTUNITIES_CREATED
, OPPORTUNITIES_UPDATED
, OPPORTUNITIES_WON
, OPPORTUNITIES_WON_AMOUNT
, OPPORTUNITIES_CROSS_SOLD
, OPPORTUNITIES_UP_SOLD
, OPPORTUNITIES_DECLINED
, OPPORTUNITIES_LOST
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE14
, ATTRIBUTE13
, ATTRIBUTE15
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, NO_OF_OPP_WON_CALLS
, NO_OF_OPP_SOLD_CALLS
, OPPORTUNITIES_WON_AMOUNT_TXN
, LEADS_AMOUNT_TXN
, CAMPAIGN_ID
, 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
, CLASSIFICATION_VALUE_ID
FROM BIX.BIX_DM_CALL_SUM;
BIX.BIX_DM_CALL_SUM does not reference any database object
BIX.BIX_DM_CALL_SUM is referenced by following:
|
|
|