DBA Data[Home] [Help] [Dependency Information]

TABLE: BIX.BIX_SUM_GRP_PRD_OUT

Object Details
Object Name: BIX_SUM_GRP_PRD_OUT
Object Type: TABLE
Owner: BIX
FND Design Data: TableBIX.BIX_SUM_GRP_PRD_OUT
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: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIX_SUM_GRP_PRD_OUT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnHOUR
Columns
Name Datatype Length Mandatory Comments
SUM_GRP_PRD_OUT_ID NUMBER
Yes Primary Key
TRANSFERS NUMBER

Number of transfers
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 request
OUTCOME_ID NUMBER

General outcome of this interaction
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)
Sales for product group/agent group
SALES_ORDERS NUMBER

Orders for product group/agent group
PROMISE_TO_PAY NUMBER (16)
Amount delinquent promises to pay
CAMPAIGN_ID NUMBER

Campaign that generated this call
AMOUNT_COLLECTED NUMBER (16)
Amount collected from customer
PRODUCT_GROUP_ID NUMBER (10)
Product group which sold this interaction
RESOURCE_GROUP_ID NUMBER

Agent's group
HOUR DATE

Hour of summary
NUMBER_OF_INTERACTIONS NUMBER

Number of interactions making up sums
USER_ATTRIBUTE1 VARCHAR2 (240)
User definable column1
USER_ATTRIBUTE2 VARCHAR2 (240)
User definable column2
USER_ATTRIBUTE3 VARCHAR2 (240)
User definable column3
USER_ATTRIBUTE4 VARCHAR2 (240)
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 SUM_GRP_PRD_OUT_ID
,      TRANSFERS
,      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
,      OUTCOME_ID
,      CONTACTS
,      TRANSACTIONS
,      SALES_QUOTES
,      LEADS_GENERATED
,      SALES_REVENUE
,      SALES_ORDERS
,      PROMISE_TO_PAY
,      CAMPAIGN_ID
,      AMOUNT_COLLECTED
,      PRODUCT_GROUP_ID
,      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_PRD_OUT;

Dependencies

[top of page]

BIX.BIX_SUM_GRP_PRD_OUT does not reference any database object

BIX.BIX_SUM_GRP_PRD_OUT is referenced by following:

SchemaAPPS
SynonymBIX_SUM_GRP_PRD_OUT