[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIX_SUM_GRP_CLS |
|---|---|
| Object Type: | TABLE |
| Owner: | BIX |
| FND Design Data: |  BIX.BIX_SUM_GRP_CLS
|
| 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_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| BIX_SUM_GRP_CLS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
 HOUR
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SUM_GRP_CLS_ID | NUMBER | Yes | Primary Key | |
| INTERACTION_TYPE | VARCHAR2 | (32) | Primary Key | |
| TRANSFERS | NUMBER | Number of transfers | ||
| ABANDONED_COUNT | NUMBER | Number of abandoned calls | ||
| WAIT_TIME_TO_ABANDON | NUMBER | Total number of seconds | ||
| INTERACTIONS_HANDLED_BY_IVR | NUMBER | Total number of calls handled by IVR | ||
| INTERACTIONS_ANSWERED_LIVE | NUMBER | Total number of calls answered live | ||
| MEDIA_ITEM_TYPE | VARCHAR2 | (240) | Kind of media | |
| SERVICE_REQUEST_COUNT | NUMBER | Number of Service requests | ||
| FIRST_INTERACTION_RESOLN_COUNT | NUMBER | Number of calls resolved by first agent | ||
| INTERACTION_CENTER_ID | NUMBER | From CCT_CALL_CENTER | ||
| IVR_TIME | NUMBER | Total IVR duration in seconds | ||
| ROUTE_TIME | NUMBER | Total Routing duration | ||
| PARTY_WAIT_TIME | NUMBER | Total customer wait time | ||
| SPEED_TO_ANSWER | NUMBER | Total ringing duration | ||
| TALK_TIME | NUMBER | Total talk time with customer | ||
| WRAP_TIME | NUMBER | Total time spent in wrap-up | ||
| IDLE_TIME | NUMBER | Total time agent waits for next call | ||
| PREVIEW_TIME | NUMBER | Total time spent previewing calls | ||
| NON_PRODUCTIVE_TIME | NUMBER | Total non-productive time | ||
| RESPONSE_TIME | NUMBER | Total time to respond to iCenter requests | ||
| RESOLUTION_TIME | NUMBER | Total clock time to resolve iCenter requests | ||
| RESOLUTION_TIME_INTERNAL | NUMBER | Total actual time to resolve iCenter request | ||
| CONTACTS | NUMBER | Number of Contacts | ||
| TRANSACTIONS | NUMBER | Number of transactions | ||
| SALES_QUOTES | NUMBER | Number of Sales quotes generated | ||
| LEADS_GENERATED | NUMBER | Number of Leads generated | ||
| SALES_REVENUE | NUMBER | (16) | Total revenue for this group | |
| SALES_ORDERS | NUMBER | Total orders for this group | ||
| PROMISE_TO_PAY | NUMBER | (16) | Amount delinquest promises to pay | |
| CAMPAIGN_ID | NUMBER | Campaign that generated this call | ||
| AMOUNT_COLLECTED | NUMBER | (16) | Amount collected from the customer | |
| INTERACTION_CLASSIFICATION | VARCHAR2 | (240) | Routing module classification | |
| RESOURCE_GROUP_ID | NUMBER | Agent's group | ||
| HOUR | DATE | Hour of Summaries | ||
| NUMBER_OF_INTERACTIONS | NUMBER | Number of interactions making up sums | ||
| 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 | (150) | User definable column5 | |
| SECURITY_GROUP_ID | NUMBER | column for CRM hosting |
Cut, paste (and edit) the following text to query this object:
SELECT SUM_GRP_CLS_ID
, INTERACTION_TYPE
, TRANSFERS
, ABANDONED_COUNT
, WAIT_TIME_TO_ABANDON
, INTERACTIONS_HANDLED_BY_IVR
, INTERACTIONS_ANSWERED_LIVE
, MEDIA_ITEM_TYPE
, SERVICE_REQUEST_COUNT
, FIRST_INTERACTION_RESOLN_COUNT
, INTERACTION_CENTER_ID
, IVR_TIME
, ROUTE_TIME
, PARTY_WAIT_TIME
, SPEED_TO_ANSWER
, TALK_TIME
, WRAP_TIME
, IDLE_TIME
, PREVIEW_TIME
, NON_PRODUCTIVE_TIME
, RESPONSE_TIME
, RESOLUTION_TIME
, RESOLUTION_TIME_INTERNAL
, CONTACTS
, TRANSACTIONS
, SALES_QUOTES
, LEADS_GENERATED
, SALES_REVENUE
, SALES_ORDERS
, PROMISE_TO_PAY
, CAMPAIGN_ID
, AMOUNT_COLLECTED
, INTERACTION_CLASSIFICATION
, RESOURCE_GROUP_ID
, HOUR
, NUMBER_OF_INTERACTIONS
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, SECURITY_GROUP_ID
FROM BIX.BIX_SUM_GRP_CLS;
BIX.BIX_SUM_GRP_CLS does not reference any database object
BIX.BIX_SUM_GRP_CLS is referenced by following:
APPS
BIX_SUM_GRP_CLS
|
|
|
|