Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - BIX Tables and Views

TABLE - BIX.BIX_INTERACTIONS
TABLE - BIX.BIX_INTERACTIONS_INF
TABLE - BIX.BIX_SERVER_CP
TABLE - BIX.BIX_SERVER_IB
TABLE - BIX.BIX_SERVER_MCM
TABLE - BIX.BIX_SERVER_SUM_CP
TABLE - BIX.BIX_SERVER_SUM_IB
TABLE - BIX.BIX_SUM_AGENT
TABLE - BIX.BIX_SUM_AGT_CLS
TABLE - BIX.BIX_SUM_AGT_PRD
TABLE - BIX.BIX_SUM_GRP_CLS
TABLE - BIX.BIX_SUM_GRP_CLS_INQ
TABLE - BIX.BIX_SUM_GRP_CLS_TRN
TABLE - BIX.BIX_SUM_GRP_PRD_OUT
TABLE - BIX.BIX_SUM_INFO
TABLE - BIX.BIX_SUM_INFO_CONFIG
TABLE - BIX.BIX_TIME
VIEW - APPS.BIX_AGENT_V
VIEW - APPS.BIX_AK_DUMMY_V
VIEW - APPS.BIX_CALL_CENTER_V
VIEW - APPS.BIX_CENTER_V
VIEW - APPS.BIX_GROUP_V
VIEW - APPS.BIX_INT_CLASSIFICATIONS_V
VIEW - APPS.BIX_RESOURCE_BASE_V
VIEW - APPS.BIX_RESOURCE_LOV_V
VIEW - APPS.BIX_TOTAL_CALL_AGENT_V

Table: BIX_INTERACTIONS

Description: Repository for all interaction data that we get from UWQ (Oracle Universal Work Queue)
Primary Key: BIX_INTERACTIONS_PK
  1. INTERACTIONS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIX_INTERACTIONS_INF.INTERACTIONS_ID BIX_INTERACTIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_INTERACTIONS_N2 NONUNIQUE APPS_TS_INTERFACE START_TS
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
INTERACTIONS_ID NUMBER
Y 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

[top of page]

BIX.BIX_INTERACTIONS does not reference any database object

BIX.BIX_INTERACTIONS is referenced by following:

APPS
SYNONYM - BIX_INTERACTIONS

[top of page]

Table: BIX_INTERACTIONS_INF

Description: Contains Sales data broken up by Product Group and Resource Group
Primary Key: BIX_INTERACTIONS_INF_PK
  1. INTERACTIONS_INF_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIX_INTERACTIONS_INF.INTERACTIONS_ID BIX_INTERACTIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_INTERACTIONS_INF1_N1 NONUNIQUE APPS_TS_SUMMARY INTERACTIONS_ID
Columns
Name Datatype Length Mandatory Comments
INTERACTIONS_INF_ID NUMBER
Y Primary Key
INTERACTIONS_ID NUMBER
Y FK to BIX_INTERACTIONS
HANDLER_ID NUMBER (15)
Client Application ID
KEY VARCHAR2 (32)
e.g. Revenue
SUBKEY VARCHAR2 (32)
e.g. Null
VALUE NUMBER (16)
e.g. 55.00
PRODUCT_GROUP_ID NUMBER

Product Group
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_INTERACTIONS_INF does not reference any database object

BIX.BIX_INTERACTIONS_INF is referenced by following:

APPS
SYNONYM - BIX_INTERACTIONS_INF

[top of page]

Table: BIX_SERVER_CP

Description: Derived from "Advanced Outbound CCI Data"
Primary Key: BIX_SERVER_CP_PK
  1. SERVER_CP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SERVER_CP_N1 NONUNIQUE APPS_TS_SUMMARY MINUTE
CAMPAIGN_ID
BIX_SERVER_CP_N2 NONUNIQUE APPS_TS_SUMMARY MINUTE
LIST_ID
Columns
Name Datatype Length Mandatory Comments
SERVER_CP_ID NUMBER
Y Primary Key
SITE_ID NUMBER

Site ID
CAMPAIGN_ID NUMBER

Campaign ID
LIST_ID NUMBER

List ID
MINUTE DATE

Time to the minute
BUSY_COUNTS NUMBER

Busy Counts
CONNECT_COUNTS NUMBER

Connect Counts
ANSWERING_MACHINE_COUNTS NUMBER

Answering Maching counts
MODEM_COUNTS NUMBER

Modem or Fax Counts
SIT_COUNTS NUMBER

Special tone
RNA_COUNTS NUMBER

Ring no answer counts
OTHER_COUNTS NUMBER

Other counts
WITHDRAWN_DIALS NUMBER

number of calls withdrawn
AVERAGE_WAIT_TIME NUMBER (16)
total wait time / (agents predictive + agents outbound)
STD_DEV_WAIT_TIME NUMBER (16)
deviation from wait time
MINIMUM_WAIT_TIME NUMBER

minmum of wait time
MAXIMUM_WAIT_TIME NUMBER

maximum of wait time
TOTAL_WAIT_TIME NUMBER

Total Wait Time
NUMBER_AGENTS_PREDICTIVE NUMBER

number of agents working in predictive mode
NUMBER_WORKING_DIALERS NUMBER

number of working dialers
NUMBER_ABANDONS NUMBER

number of abandons
ABANDON_PERCENTAGE NUMBER (16)
percentage of abandon
DIALS_PER_MINUTE NUMBER

dials per mintue
NUMBER_AGENTS_OUTBOUND NUMBER

number of agents outbound
NUMBER_CALLS_OUTCOME_1 NUMBER

User defined outcome 1
NUMBER_CALLS_OUTCOME_2 NUMBER

User defined outcome 2
NUMBER_CALLS_OUTCOME_3 NUMBER

User defined outcome 3
NUMBER_RECORDS_REMAINING NUMBER

number of record remaining
PREDICTED_EXHAUSTION_DATE DATE

Date that call lists ends
NUMBER_RECORDS_START_OF_DAY NUMBER

Phone Numbers to call
PREDICTIVE_DIALS NUMBER

number of predictive dials
PROGRESSIVE_DIALS NUMBER

number of progressive dials
PREVIEW_DIALS NUMBER

number of preview dials
PREVIEW_TIME NUMBER

preview time
NUMBER_CALLBACKS NUMBER

number of callbacks
CALLBACK_PERCENTAGE NUMBER (16)
percentage of callbacks
AVERAGE_CUMULATIVE_WAIT_TIME NUMBER (16)
average cumulative wait time
STD_DEV_CUMULATIVE_WAIT_TIME NUMBER (16)
deviation of cumulative wait time
NUM_RECS_TO_BE_RELEASED_NEXT_1 NUMBER

number of records to be released
NUM_REC_TO_BE_RELEASED_NEXT_15 NUMBER

number of records to be released
NUM_REC_TO_BE_RELEASED_NEXT_5 NUMBER

number of records to be released
NUM_REC_TO_BE_RELEASED_NEXT_60 NUMBER

number of records to be released
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SERVER_CP does not reference any database object

BIX.BIX_SERVER_CP is referenced by following:

APPS
SYNONYM - BIX_SERVER_CP

[top of page]

Table: BIX_SERVER_IB

Description: Derived from "Interaction Blending CCI Data"
Primary Key: BIX_SERVER_IB_PK
  1. SERVER_IB_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SERVER_IB_N1 NONUNIQUE APPS_TS_SUMMARY MINUTE
Columns
Name Datatype Length Mandatory Comments
SERVER_IB_ID VARCHAR2 (240) Y Primary Key
MINUTE DATE

Time to the minute
SITE_ID NUMBER

Site ID
MEDIA_ITEM_TYPE VARCHAR2 (240)
Media type
LOS_CATEGORY_ID NUMBER

category ID
NUMBER_OF_ITEMS_QUEUED NUMBER

number of items queued
NUMBER_OF_ITEMS_SERVICED NUMBER

number of items serviced
ITEMS_SERVICED_WITHIN_LOS NUMBER

item serviced
ITEMS_NOT_SERVICED_WITHIN_LOS NUMBER

items not services
NUMBER_AGENTS_WORKING NUMBER

Number of agents working in this media, los
MINIMUM_NUMBER_OF_AGENTS_REQ NUMBER

minimum number of agent request
LOS_CATEGORY_DIRECTION NUMBER

category direction
ITEMS_LEFT_TO_BE_SERVICED NUMBER

items left to be serviced
ITEMS_SERVICED_TODAY NUMBER

items serviced today
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SERVER_IB does not reference any database object

BIX.BIX_SERVER_IB is referenced by following:

APPS
SYNONYM - BIX_SERVER_IB

[top of page]

Table: BIX_SERVER_MCM

Description: Records data from the MCM, grouped by interaction classification
Primary Key: BIX_SERVER_MCM_PK
  1. SERVER_MCM_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SERVER_MCM_N2 NONUNIQUE APPS_TS_SUMMARY MINUTE
INTERACTION_CLASSIFICATION
Columns
Name Datatype Length Mandatory Comments
SERVER_MCM_ID NUMBER
Y Primary Key
MINUTE DATE

To the minute
INTERACTION_CLASSIFICATION VARCHAR2 (240)
classification of interaction
INTERACTION_CENTER_ID NUMBER

From CCT_CALL_CENTER
INTERACTIONS_RECEIVED NUMBER

Number of calls arriving at call center
INTERACTIONS_OFFERED NUMBER

Number of calls routed to agent
INTERACTIONS_ANSWERED NUMBER

Number of calls answered by agent
INTERACTIONS_TRANSFERRED NUMBER

Number of calls transferred by agent
INTERACTIONS_HANDLED NUMBER

Number of calls handled by agent or IVR
INTERACTIONS_ABANDONED NUMBER

Number of calls abandoned by agent
AVERAGE_SPEED_TO_ANSWER NUMBER (16)
In seconds
STD_DEV_SPEED_TO_ANSWER NUMBER (16)
deviation of speed to answer
TOTAL_SPEED_TO_ANSWER NUMBER

total speed to answer
AVERAGE_WAIT_TO_ABANDONED NUMBER (16)
Wait before customer hangs up
STD_DEV_WAIT_TO_ABANDONED NUMBER (16)
deviation of wait to abandoned
TOTAL_WAIT_TO_ABANDONED NUMBER

totoal wait to abandoned
PERCENT_OCCUPANCY_RATE NUMBER (16)
% time agent is in cubicle
TALK_TIME NUMBER

talk time
HOLD_TIME NUMBER

hold time
IDLE_TIME NUMBER

idle time
WRAP_TIME NUMBER

wrap time
PERCENT_UTILIZATION_RATE NUMBER (16)
% time agent is working
LOG_TIME NUMBER

In seconds
PERCENT_TRANSFER_RATE NUMBER (16)
% calls transferred
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SERVER_MCM does not reference any database object

BIX.BIX_SERVER_MCM is referenced by following:

APPS
SYNONYM - BIX_SERVER_MCM

[top of page]

Table: BIX_SERVER_SUM_CP

Description: BIX_SERVER_CP data summarized to the day
Primary Key: BIX_SERVER_SUM_CP_PK
  1. SERVER_SUM_CP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SERVER_SUM_CP_N2 NONUNIQUE APPS_TS_SUMMARY HOUR
CAMPAIGN_ID
BIX_SERVER_SUM_CP_N3 NONUNIQUE APPS_TS_SUMMARY HOUR
LIST_ID
Columns
Name Datatype Length Mandatory Comments
SERVER_SUM_CP_ID NUMBER
Y Primary Key
SITE NUMBER

Site ID
CAMPAIGN_ID NUMBER

Campaign ID
LIST_ID NUMBER

List ID
HOUR DATE

Time to the hour
BUSY_COUNTS NUMBER

Busy Counts
CONNECT_COUNTS NUMBER

Connect Counts
ANSWERING_MACHINE_COUNTS NUMBER

Answering Machine counts
MODEM_COUNTS NUMBER

Modem Counts
SIT_COUNTS NUMBER

Special Tone Counts
RNA_COUNTS NUMBER

Rings no answer counts
OTHER_COUNTS NUMBER

Other counts
WITHDRAWN_DIALS NUMBER

number of dials withdrawn
AVERAGE_WAIT_TIME NUMBER (16)
total wait time / (agents predictive + agents outbound)
STD_DEV_WAIT_TIME NUMBER (16)
deviation of wait time
MINIMUM_WAIT_TIME NUMBER

minimum of wait time
MAXIMUM_WAIT_TIME NUMBER

maximum of wait time
TOTAL_WAIT_TIME NUMBER

total wait time
NUMBER_AGENTS_PREDICTIVE NUMBER

number of oredictive agents
NUMBER_WORKING_DIALERS NUMBER

number of working dialers
NUMBER_ABANDONS NUMBER

number of abandons
ABANDON_PERCENTAGE NUMBER (16)
percentage of abandon
DIALS_PER_MINUTE NUMBER

dials per minute
NUMBER_AGENTS_OUTBOUND NUMBER

number of agent outbound
NUMBER_CALLS_OUTCOME_1 NUMBER

User defined Outcome 1
NUMBER_CALLS_OUTCOME_2 NUMBER

User defined Outcome 2
NUMBER_CALLS_OUTCOME_3 NUMBER

User defined Outcome 3
NUMBER_RECORDS_REMAINING NUMBER

number of remaining records
PREDICTED_EXHAUSTION_RATE DATE

Date that call lists ends
NUMBER_RECORDS_START_OF_DAY NUMBER

Phone numbers to call
NUMBER_RECORDS_TO_BE_RELEASED NUMBER

number of records to be released
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SERVER_SUM_CP does not reference any database object

BIX.BIX_SERVER_SUM_CP is referenced by following:

APPS
SYNONYM - BIX_SERVER_SUM_CP

[top of page]

Table: BIX_SERVER_SUM_IB

Description: BIX_SERVER_IB data summarized to the day
Primary Key: BIX_SERVER_SUM_IB_PK
  1. SERVER_SUM_IB_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SERVER_SUM_IB_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
BIX_SERVER_SUM_IB_N2 NONUNIQUE APPS_TS_SUMMARY RESOURCE_ID
HOUR
Columns
Name Datatype Length Mandatory Comments
SERVER_SUM_IB_ID VARCHAR2 (240) Y Primary Key
HOUR DATE

Time to the hour
SITE NUMBER

site
RESOURCE_ID NUMBER

agent id
MEDIA_ITEM_TYPE VARCHAR2 (240)
media item type
LOS_CATEGORY NUMBER

category
NUMBER_OF_ITEMS_QUEUED NUMBER

Number of Items Queued
NUMBER_OF_ITEMS_SERVICED NUMBER

Number of Items Serviced
ITEMS_SERVICED_WITHIN_LOS NUMBER

items serviced
ITEMS_NOT_SERVICED_WITHIN_LOS NUMBER

items not serviced
NUMBER_AGENTS_WORKING NUMBER

Number of agents working in this media, los
MINIMUM_NUMBER_OF_AGENTS_REQ NUMBER

minimum number if agent request
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SERVER_SUM_IB does not reference any database object

BIX.BIX_SERVER_SUM_IB is referenced by following:

APPS
SYNONYM - BIX_SERVER_SUM_IB

[top of page]

Table: BIX_SUM_AGENT

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_CENTER_N1 NONUNIQUE APPS_TS_SUMMARY INTERACTION_CENTER_ID
BIX_DAY_N1 NONUNIQUE APPS_TS_SUMMARY DAY
BIX_RESOURCE_N1 NONUNIQUE APPS_TS_SUMMARY RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
INTERACTION_CENTER_ID NUMBER

interaction center ID
RESOURCE_ID NUMBER

resource ID
TALK_TIME NUMBER

talk time
AVAILABLE_TIME NUMBER

available time
WRAP_TIME NUMBER

wrap time
IDLE_TIME NUMBER

idle time
LOGGED_IN_TIME NUMBER

logged in time
CALLS_ANSWERED NUMBER

calls answered
DAY DATE

day
SECURITY_GROUP_ID NUMBER

security group ID

[top of page]

BIX.BIX_SUM_AGENT does not reference any database object

BIX.BIX_SUM_AGENT is referenced by following:

APPS
SYNONYM - BIX_SUM_AGENT

[top of page]

Table: BIX_SUM_AGT_CLS

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent, call center, campaign and interaction classification
Primary Key: BIX_SUM_AGT_CLS_PK
  1. SUM_AGT_CLS_ID
Primary Key: BIX_SUM_AGT_CLS_UK
  1. HOUR
  2. RESOURCE_ID
  3. CAMPAIGN_ID
  4. INTERACTION_CLASSIFICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_AGT_CLS_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_AGT_CLS_ID NUMBER
Y Primary Key
INTERACTION_TYPE VARCHAR2 (32)
Type of call placed
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 interactions handled by IVR
INTERACTIONS_ANSWERED_LIVE NUMBER

Total number of interactions 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 requests closed on first interaction
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_TIME 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 eMC requests
RESOLUTION_TIME NUMBER

Total clock time to resolve eMC requests
RESOLUTION_TIME_INTERNAL NUMBER

Total actual time to resolve requests
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

Total revenue for this group
SALES_ORDERS NUMBER

Total Orders for this group
PROMISE_TO_PAY NUMBER

Amount delinquent 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_ID NUMBER

Agent ID
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

[top of page]

BIX.BIX_SUM_AGT_CLS does not reference any database object

BIX.BIX_SUM_AGT_CLS is referenced by following:

APPS
SYNONYM - BIX_SUM_AGT_CLS

[top of page]

Table: BIX_SUM_AGT_PRD

Description: Summarizes BIX_INTERACTIONS to the day along the dimensions of time, agent, campaign and interaction classification
Primary Key: BIX_SUM_AGT_PRD_PK
  1. SUM_AGT_PRD_ID
Primary Key: BIX_SUM_AGT_PRD_UK
  1. HOUR
  2. RESOURCE_ID
  3. CAMPAIGN_ID
  4. INTERACTION_CLASSIFICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_AGT_PRD_N2 NONUNIQUE APPS_TS_SUMMARY HOUR
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
SUM_AGT_PRD_ID NUMBER
Y Primary Key
INTERACTION_CLASSIFICATION VARCHAR2 (240)
classification of interaction
INTERACTION_TYPE VARCHAR2 (32)
Type of call placed
RESOURCE_ID NUMBER

Agent ID
PRODUCT_GROUP_ID NUMBER

Product Group which sold this interaction
INTERACTION_CENTER_ID NUMBER

From CCT_CALL_CENTER
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 agent
SALES_ORDERS NUMBER

Total Orders for this agent
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 the customer
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

[top of page]

BIX.BIX_SUM_AGT_PRD does not reference any database object

BIX.BIX_SUM_AGT_PRD is referenced by following:

APPS
SYNONYM - BIX_SUM_AGT_PRD

[top of page]

Table: BIX_SUM_GRP_CLS

Description: Summarizes BIX_INTERACTIONS to the day the dimension of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_PK
  1. SUM_GRP_CLS_ID
Primary Key: BIX_SUM_GRP_CLS_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_GRP_CLS_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_GRP_CLS_ID NUMBER
Y 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

[top of page]

BIX.BIX_SUM_GRP_CLS does not reference any database object

BIX.BIX_SUM_GRP_CLS is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS

[top of page]

Table: BIX_SUM_GRP_CLS_INQ

Description: Summarizes BIX_INTERACTIONS data to the day along the dimesions of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_INQ_PK
  1. SUM_GRP_CLS_INQ_ID
Primary Key: BIX_SUM_GRP_CLS_INQ_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_GRP_CLS_INQ_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_GRP_CLS_INQ_ID NUMBER
Y Primary Key
INTERACTION_CENTER_ID NUMBER

From CCT_CALL_CENTER
INQUIRY_TYPE VARCHAR2 (32)
Inquiry type
CAMPAIGN_ID NUMBER

Campaign that generated this call
INTERACTION_CLASSIFICATION VARCHAR2 (240)
Routing module classification
RESOURCE_GROUP_ID NUMBER

Agent's group
HOUR DATE

Hour of summary
NUMBER_OF_INTERACTIONS NUMBER

Number of interactions making up sums
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_SUM_GRP_CLS_INQ does not reference any database object

BIX.BIX_SUM_GRP_CLS_INQ is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS_INQ

[top of page]

Table: BIX_SUM_GRP_CLS_TRN

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_TRN_PK
  1. SUM_GRP_CLS_TRN_ID
Primary Key: BIX_SUM_GRP_CLS_TRN_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_GRP_CLS_TRN_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_GRP_CLS_TRN_ID NUMBER
Y Primary Key
INTERACTION_CENTER_ID NUMBER

From CCT_CALL_CENTER
TRANSACTION_TYPE VARCHAR2 (32)
Transaction Type
CAMPAIGN_ID NUMBER

Campaign that generated this call
INTERACTION_CLASSIFICATION VARCHAR2 (240)
Routing module classification
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

[top of page]

BIX.BIX_SUM_GRP_CLS_TRN does not reference any database object

BIX.BIX_SUM_GRP_CLS_TRN is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS_TRN

[top of page]

Table: BIX_SUM_GRP_PRD_OUT

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent, group, call center, campaign and product group
Primary Key: BIX_SUM_GRP_PRD_OUT_PK
  1. SUM_GRP_PRD_OUT_ID
Primary Key: BIX_SUM_GRP_PRD_OUT_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. PRODUCT_GROUP_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_GRP_PRD_OUT_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_GRP_PRD_OUT_ID NUMBER
Y 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

[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:

APPS
SYNONYM - BIX_SUM_GRP_PRD_OUT

[top of page]

Table: BIX_SUM_INFO

Description: Table for 3rd party applications to send data to be summarized along a certain number of dimensions
Primary Key: BIX_SUM_INFO_PK
  1. SUM_INFO_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIX_SUM_INFO_N1 NONUNIQUE APPS_TS_SUMMARY HOUR
Columns
Name Datatype Length Mandatory Comments
SUM_INFO_ID NUMBER
Y Primary key
HOUR DATE

Hour of Summary
CAMPAIGN_ID NUMBER

Campaign that generated this call
LIST_ID NUMBER

List that generated this call
SCRIPT_ID NUMBER

Script used in the interaction
PRODUCT_GROUP_ID NUMBER

Product group which sold this interaction
RESOURCE_ID NUMBER

Agent's ID
RESOURCE_GROUP_ID NUMBER

Agent's group
INTERACTION_CENTER_ID NUMBER

From CCT_CALL_CENTER
MEDIA_ITEM_TYPE VARCHAR2 (240)
Kind of media
INTERACTION_TYPE VARCHAR2 (32)
Type of call placed
INERACTION_CLASSIFICATION VARCHAR2 (240)
Routing Module classification
HANDLER_ID NUMBER

Client Application ID
OUTCOME_ID NUMBER

General outcome of this Interaction
RESULT_ID NUMBER

Specific outcome of this Interaction
REASON_ID NUMBER

Reason for the outcome
PARTY_ID NUMBER (15)
KEY VARCHAR2 (32)
e.g. Revenue
SUBKEY VARCHAR2 (32)
e.g. NULL
VALUE NUMBER (16)
e.g. 55.00
NUMBER_OF_INTERACTIONS NUMBER

Number of interactions making up the value
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

[top of page]

BIX.BIX_SUM_INFO does not reference any database object

BIX.BIX_SUM_INFO is referenced by following:

APPS
SYNONYM - BIX_SUM_INFO

[top of page]

Table: BIX_SUM_INFO_CONFIG

Description: Specifies the dimensions that a particular application will use for summarizing into BIX_SUM_INFO
Primary Key: BIX_SUM_INFO_CONFIG_PK
  1. SUM_INFO_CONFIG_ID
Primary Key: BIX_SUM_INFO_CONFIG_UK
  1. HANDLER_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SUM_INFO_CONFIG_ID NUMBER
Y Primary Key
HANDLER_ID NUMBER

Client Application ID
HOUR DATE

1 = use as a dimension, 0 = not a dimension
CAMPAIGN NUMBER (1)
1 = use as a dimension, 0 = not a dimension
LIST NUMBER

1 = use as a dimension, 0 = not a dimension
SCRIPT NUMBER

1 = use as a dimension, 0 = not a dimension
PRODUCT_GROUP NUMBER (1)
1 = use as a dimension, 0 = not a dimension
RESOURCE_NAME NUMBER (1)
1 = use as a dimension, 0 = not a dimension
RESOURCE_GROUP NUMBER (1)
1 = use as a dimension, 0 = not a dimension
INTERACTION_CENTER NUMBER (1)
1 = use as a dimension, 0 = not a dimension
MEDIA_ITEM_TYPE NUMBER (1)
1 = use as a dimension, 0 = not a dimension
INTERACTION_TYPE NUMBER (1)
1 = use as a dimension, 0 = not a dimension
INERACTION_CLASSIFICATION VARCHAR2 (240)
1 = use as a dimension, 0 = not a dimension
OUTCOME NUMBER

1 = use as a dimension, 0 = not a dimension
RESULT NUMBER

1 = use as a dimension, 0 = not a dimension
REASON NUMBER

1 = use as a dimension, 0 = not a dimension
PARTY NUMBER (1)
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

[top of page]

BIX.BIX_SUM_INFO_CONFIG does not reference any database object

BIX.BIX_SUM_INFO_CONFIG is referenced by following:

APPS
SYNONYM - BIX_SUM_INFO_CONFIG

[top of page]

Table: BIX_TIME

Description:
Primary Key: BIX_TIME_PK
  1. HOUR
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
HOUR_DISPLAY VARCHAR2 (5)
display name of hour
HOUR NUMBER
Y hour
SECURITY_GROUP_ID NUMBER

column for CRM hosting

[top of page]

BIX.BIX_TIME does not reference any database object

BIX.BIX_TIME is referenced by following:

APPS
SYNONYM - BIX_TIME

[top of page]

View: BIX_AGENT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (40)
resource ID
VALUE VARCHAR2 (240)
value
START_DATE_ACTIVE DATE
Y active start date
CATEGORY VARCHAR2 (30) Y category of resources

[top of page]

APPS.BIX_AGENT_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_AGENT_V is not referenced by any database object

[top of page]

View: BIX_AK_DUMMY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
COL1 CHAR (1)
dummy column of dummy view

[top of page]

APPS.BIX_AK_DUMMY_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.BIX_AK_DUMMY_V is not referenced by any database object

[top of page]

View: BIX_CALL_CENTER_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CALL_CENTER_ID NUMBER (15) Y call center ID
CALL_CENTER_NAME VARCHAR2 (256) Y call center name
CALL_CENTER_GROUP NUMBER (15)
call center group
CALL_CENTER_LOCATION VARCHAR2 (500)
call center location

[top of page]

APPS.BIX_CALL_CENTER_V references the following:

APPS
SYNONYM - IEO_SVR_GROUPS
APPS.BIX_CALL_CENTER_V is referenced by following:

APPS
PACKAGE BODY - BIX_ALERT

[top of page]

View: BIX_CENTER_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (40)
center ID
VALUE VARCHAR2 (256) Y value
LOCATION VARCHAR2 (500)
center location
CREATED_BY NUMBER (15) Y Standard Who column

[top of page]

APPS.BIX_CENTER_V references the following:

APPS
SYNONYM - IEO_SVR_GROUPS

APPS.BIX_CENTER_V is not referenced by any database object

[top of page]

View: BIX_GROUP_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (40)
group ID
VALUE VARCHAR2 (60) Y value
START_DATE_ACTIVE DATE

active startr date

[top of page]

APPS.BIX_GROUP_V references the following:

APPS
VIEW - JTF_RS_GROUPS_VL

APPS.BIX_GROUP_V is not referenced by any database object

[top of page]

View: BIX_INT_CLASSIFICATIONS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CLASSIFICATION_ID NUMBER (15) Y classification ID
ROUTE_ID NUMBER

route ID
TYPE VARCHAR2 (32)
type
DBURL VARCHAR2 (256)
DBURL
CLASSIFICATION VARCHAR2 (64)
classification

[top of page]

APPS.BIX_INT_CLASSIFICATIONS_V references the following:

APPS
SYNONYM - CCT_CLASSIFICATIONS

APPS.BIX_INT_CLASSIFICATIONS_V is not referenced by any database object

[top of page]

View: BIX_RESOURCE_BASE_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_NAME VARCHAR2 (240)
resource name
RESOURCE_ID NUMBER
Y resource ID
RESOURCE_GROUP_ID NUMBER

resource group ID

[top of page]

APPS.BIX_RESOURCE_BASE_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_RESOURCE_BASE_V is not referenced by any database object

[top of page]

View: BIX_RESOURCE_LOV_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_NAME VARCHAR2 (240)
resource name
RESOURCE_ID NUMBER
Y resource ID
RESOURCE_GROUP_ID NUMBER

resource group ID

[top of page]

APPS.BIX_RESOURCE_LOV_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_RESOURCE_LOV_V is not referenced by any database object

[top of page]

View: BIX_TOTAL_CALL_AGENT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ID CHAR (2)
agent ID
VALUE VARCHAR2 (255) Y value

[top of page]

APPS.BIX_TOTAL_CALL_AGENT_V references the following:

APPS
VIEW - BISBV_DIMENSION_LEVELS

APPS.BIX_TOTAL_CALL_AGENT_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract