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 - IEB Tables and Views

TABLE - IEB.IEB_AGENT_INDEXES
TABLE - IEB.IEB_AGENT_MAPS
TABLE - IEB.IEB_INB_SVC_COVERAGES
TABLE - IEB.IEB_MEDIA_TASK_SOURCES
TABLE - IEB.IEB_MMS_SERVERS
TABLE - IEB.IEB_OUTB_SVC_COVERAGES
TABLE - IEB.IEB_SERVICE_PLANS
TABLE - IEB.IEB_SVC_CAT_TEMPS_B
TABLE - IEB.IEB_SVC_CAT_TEMPS_TL
TABLE - IEB.IEB_SVC_VIRTUAL_QUEUES
TABLE - IEB.IEB_WBST_WB_SC_RULES
TABLE - IEB.IEB_WB_SERVERS
TABLE - IEB.IEB_WB_SKILL_TRANS
TABLE - IEB.IEB_WB_SVC_CATS
TABLE - IEB.IEB_WB_SVC_CAT_RULES
TABLE - IEB.IEB_WB_SVRS_MMS_SVRS
TABLE - IEB.IEB_WB_WORK_ITEMS
VIEW - APPS.IEB_SVC_CAT_CLASSIFICATIONS_V
VIEW - APPS.IEB_SVC_CAT_TEMPLATES

Table: IEB_AGENT_INDEXES

Description: Mapping of Agent IDs with internal bit map indexes, for IEB server internal use only.
Primary Key: IEB_AGENT_INDEXES_PK
  1. AGENT_ID
  2. WBSVR_WBSVR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_AGENT_INDEXES.WBSVR_WBSVR_ID IEB_WB_SERVERS
Comments

Mapping of Agent IDs with internal bit map indexes, for IEB server internal use only.

Indexes
Index Type Tablespace Column
IEB_AGENT_INDEX_PK_U UNIQUE APPS_TS_TX_IDX AGENT_ID
WBSVR_WBSVR_ID
IEB_AGENT_INDEXES_FK_N NONUNIQUE APPS_TS_TX_IDX WBSVR_WBSVR_ID
Columns
Name Datatype Length Mandatory Comments
AGENT_ID NUMBER (15) Y Agent ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
AGENT_INDEX NUMBER (8) Y Agent Index assigned by IEB server for internal use.
WBSVR_WBSVR_ID NUMBER (15) Y Interaction Bending Server ID created by system
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.

[top of page]

IEB.IEB_AGENT_INDEXES does not reference any database object

IEB.IEB_AGENT_INDEXES is referenced by following:

IEB
VIEW - IEB_AGENT_INDEXES#

[top of page]

Table: IEB_AGENT_MAPS

Description: Indexes of member agents for virtual queues.
Primary Key: IEB_AGENT_MAPS_PK
  1. AGTMAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_AGENT_MAPS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES
Comments

Indexes of member agents for virtual queues.

Indexes
Index Type Tablespace Column
IEB_AGENT_MAPS_PK_U UNIQUE APPS_TS_TX_IDX AGTMAP_ID
IEB_AGENT_MAPS_FK_N NONUNIQUE APPS_TS_TX_IDX SVCVQ_SVCVQ_ID
Columns
Name Datatype Length Mandatory Comments
AGTMAP_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ROW_INDEX NUMBER (4) Y Bit map row number in agent group bit maps.
ROW_AGENT_BITMAP NUMBER (20) Y Actual countents of bit map for rows in agent bit map.
SVCVQ_SVCVQ_ID NUMBER (15) Y Service Virtual Queue ID
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.

[top of page]

IEB.IEB_AGENT_MAPS does not reference any database object

IEB.IEB_AGENT_MAPS is referenced by following:

IEB
VIEW - IEB_AGENT_MAPS#

[top of page]

Table: IEB_INB_SVC_COVERAGES

Description: Service goals of coverage periods within inbound service plans.
Primary Key: IEB_INB_SVC_COVERAGES_PK
  1. ISVCCOV_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_INB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
Comments

Service goals of coverage periods within inbound service plans.

Indexes
Index Type Tablespace Column
IEB_INB_SVC_COVERAGES_PK_U UNIQUE APPS_TS_TX_IDX ISVCCOV_ID
ZD_EDITION_NAME
IEB_INB_SVC_COVERAGES_FK_N NONUNIQUE APPS_TS_TX_IDX SVCPLN_SVCPLN_ID
IEB_INB_SVC_COVERAGES_N2 NONUNIQUE APPS_TS_TX_IDX SERVICE_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
ISVCCOV_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SCHEDULE_TYPE VARCHAR2 (1) Y Schedule type, "R" -- regualer day in the week or a "S"pecific date
REGULAR_SCHD_DAY NUMBER (1)
0-6 for Sunday to Saturday if the schedule type is "R"egular
SPEC_SCHD_DATE DATE

Date of the coverage if schedule type is "SPECIFIC"
BEGIN_TIME_HHMM NUMBER (4) Y begin time in HHMM(2400)
END_TIME_HHMM NUMBER (4) Y end time in HHMM (2400)
MIN_AGENT NUMBER (8) Y Minimun agent
PERCENTAGE NUMBER (4) Y Percentage requirement
TIME_THRESHOLD NUMBER (8) Y Time threshold for service plan
MAX_WAIT_TIME NUMBER (8) Y Max wait time
REROUTE_TIME NUMBER (8) Y Time limit, in number of seconds, to reroute email messages.
REROUTE_WARNING_TIME NUMBER (8) Y Time limit, in number of seconds, to warn agent to process email messages before rerouting email messages.
SVCPLN_SVCPLN_ID NUMBER (15) Y Service Plan ID
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.
SERVICE_LEVEL_ID NUMBER (15)
Service Level ID
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEB.IEB_INB_SVC_COVERAGES does not reference any database object

IEB.IEB_INB_SVC_COVERAGES is referenced by following:

IEB
VIEW - IEB_INB_SVC_COVERAGES#

[top of page]

Table: IEB_MEDIA_TASK_SOURCES

Description: Media sources of Media Manager Servers. (Obsolete table)
Primary Key: IEB_MEDIA_TASK_SOURCES_PK
  1. MTS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_MEDIA_TASK_SOURCES.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
Comments

Media sources of Media Manager Servers. (Obsolete table)

Indexes
Index Type Tablespace Column
IEB_MEDIA_TASK_SOURCES_FK_N NONUNIQUE APPS_TS_TX_IDX MMSSVR_MMSSVR_ID
Columns
Name Datatype Length Mandatory Comments
MTS_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SOURCE_NAME VARCHAR2 (80) Y Media Task QUeue Name
ACTIVE_Y_N VARCHAR2 (1) Y If the Queue is active, "Y" or "N"
MEDIA_TYPE VARCHAR2 (80) Y Media Type of the queue
SOURCE_CONFIG_Y_N VARCHAR2 (1) Y Yes or No for media server level configuration
MONITOR_OPTIONS VARCHAR2 (256)
Monitor Options if ever
MMSSVR_MMSSVR_ID NUMBER (15) Y Unique ID generated by system as primary key
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.

[top of page]

IEB.IEB_MEDIA_TASK_SOURCES does not reference any database object

IEB.IEB_MEDIA_TASK_SOURCES is referenced by following:

IEB
VIEW - IEB_MEDIA_TASK_SOURCES#

[top of page]

Table: IEB_MMS_SERVERS

Description: Summary of media server information. This is an obsolete table, replaced by IEO server location schema.
Primary Key: IEB_MMS_SERVERS_PK
  1. MMSSVR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_MEDIA_TASK_SOURCES.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
IEB_WB_SVRS_MMS_SVRS.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
Comments

Summary of media server information. This is an obsolete table, replaced by IEO server location schema.

Columns
Name Datatype Length Mandatory Comments
MMSSVR_ID NUMBER (15) Y Unique ID generated by system as primary key
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
MMS_SERVER_NAME VARCHAR2 (80) Y MMS Server Name
ACTIVE_Y_N VARCHAR2 (1) Y Yes or No
DESCRIPTION VARCHAR2 (240)
A brief desciption of the Media Manager Server.
COMMUNICATION_METHOD VARCHAR2 (32) Y Communication type, such as RMI, TCP/IP, etc.
COM_OBJECT_NAME VARCHAR2 (80)
RMI or other Object Name
COM_DNS_NAME VARCHAR2 (80)
DNS Name
COM_IP_ADDRESS VARCHAR2 (15)
TCP/IP port number
COM_PORT_NUMBER NUMBER (15)
TCP/IP port number
COM_PARAM1 VARCHAR2 (80)
Future Use
COM_PARAM2 VARCHAR2 (80)
Future Use
COM_PARAM3 VARCHAR2 (80)
Future Use
COM_PARAM4 VARCHAR2 (80)
Future Use
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.

[top of page]

IEB.IEB_MMS_SERVERS does not reference any database object

IEB.IEB_MMS_SERVERS is referenced by following:

IEB
VIEW - IEB_MMS_SERVERS#

[top of page]

Table: IEB_OUTB_SVC_COVERAGES

Description: Service goals of coverage periods of outbound service plans.
Primary Key: IEB_OUTB_SVC_COVERAGES_PK
  1. OSVCCOV_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_OUTB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
Comments

Service goals of coverage periods of outbound service plans.

Indexes
Index Type Tablespace Column
IEB_OUTB_SVC_COVERAGES_PK_U UNIQUE APPS_TS_TX_IDX OSVCCOV_ID
ZD_EDITION_NAME
IEB_OUTB_SVC_COVERAGES_FK_N NONUNIQUE APPS_TS_TX_IDX SVCPLN_SVCPLN_ID
IEB_OUTB_SVC_COVERAGES_N2 NONUNIQUE APPS_TS_TX_IDX SERVICE_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
OSVCCOV_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SCHEDULE_TYPE VARCHAR2 (1) Y Service coverage record type, regular (day of week), or specific(Date),
REGULAR_SCHD_DAY NUMBER (1)
Day in week, Monday, etc
SPEC_SCHD_DATE DATE

Date for specific schedule type
BEGIN_TIME_HHMM NUMBER (4) Y Time in 2400 fomrat
END_TIME_HHMM NUMBER (4) Y End time in 2400 format
MIN_AGENT NUMBER (8) Y Minimum agent requirement
QUOTA NUMBER (8) Y number of transactions required
SVCPLN_SVCPLN_ID NUMBER (15) Y Service Plan ID
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.
SERVICE_LEVEL_ID NUMBER (15)
Service Level ID
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEB.IEB_OUTB_SVC_COVERAGES does not reference any database object

IEB.IEB_OUTB_SVC_COVERAGES is referenced by following:

IEB
VIEW - IEB_OUTB_SVC_COVERAGES#

[top of page]

Table: IEB_SERVICE_PLANS

Description: Summary information of service plans.
Primary Key: IEB_SERVICE_PLANS_PK
  1. SVCPLN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_INB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_OUTB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_SVC_CAT_TEMPS_B.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_WB_SVC_CATS.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
Comments

Summary information of service plans.

Indexes
Index Type Tablespace Column
IEB_SERVICE_PLANS_PK_U UNIQUE APPS_TS_TX_IDX SVCPLN_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SVCPLN_ID NUMBER (15) Y Service Plan ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SERVICE_PLAN_NAME VARCHAR2 (80) Y Service Plan Name
DIRECTION VARCHAR2 (32) Y Inbound or outbound
TREATMENT VARCHAR2 (80)
Name of handling mechnism - reserved for future use
DESCRIPTION VARCHAR2 (240)
Optional description
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.
MEDIA_TYPE_ID NUMBER (15)
Media Type ID
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEB.IEB_SERVICE_PLANS does not reference any database object

IEB.IEB_SERVICE_PLANS is referenced by following:

IEB
VIEW - IEB_SERVICE_PLANS#

[top of page]

Table: IEB_SVC_CAT_TEMPS_B

Description: Templates for Top Level Service Categories
Primary Key: IEB_SVC_CAT_TEMPS_B_PK
  1. WBSC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_B.PARENT_ID IEB_SVC_CAT_TEMPS_B
IEB_SVC_CAT_TEMPS_B.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_B.PARENT_ID IEB_SVC_CAT_TEMPS_B
IEB_SVC_CAT_TEMPS_TL.WBSC_ID IEB_SVC_CAT_TEMPS_B
Comments

Templates for Top Level Service Categories

Indexes
Index Type Tablespace Column
IEB_SVC_CAT_TEMPS_PK_U UNIQUE APPS_TS_SEED WBSC_ID
ZD_EDITION_NAME
IEB_SVC_CAT_TEMPS_B_N1 NONUNIQUE APPS_TS_SEED MEDIA_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
WBSC_ID NUMBER (15) Y Service Category ID
SVCPLN_SVCPLN_ID NUMBER (15) Y ID of the Service Plan used by this Template.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MEDIA_TYPE VARCHAR2 (80) Y Media type of the tasks in this service category
DEPTH NUMBER (4) Y Depth of the service category node.
PARENT_ID NUMBER (15)
ID of the parent service category
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
ORIGINAL_NAME VARCHAR2 (80) Y Service Category's Original English Name
ACTIVE_Y_N VARCHAR2 (1) Y Flag indicating if this service category entry is active.
SOURCE_TABLE_NAME VARCHAR2 (30) Y Table name to get campaign/classification values
SRC_TBL_KEY_COLUMN VARCHAR2 (30) Y Column name for campaign/classification key value from SOURCE_TABLE_NAME
SRC_TBL_VALUE_COLUMN VARCHAR2 (30) Y Column name for campaign/classification name from SOURCE_TABLE_NAME
SRC_TBL_VALUE_TRANSLATION_FLAG VARCHAR2 (1) Y Value for whether or not data from VALUE_COLUMN is translatable
SRC_TBL_WHERE_CLAUSE VARCHAR2 (240)
Optional where clause for filtering data from SOURCE_TABLE_NAME
MEDIA_TYPE_ID NUMBER (15)
Media Type ID from IEU_UWQ_MEDIA_TYPES_B table.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEB.IEB_SVC_CAT_TEMPS_B does not reference any database object

IEB.IEB_SVC_CAT_TEMPS_B is referenced by following:

IEB
VIEW - IEB_SVC_CAT_TEMPS_B#

[top of page]

Table: IEB_SVC_CAT_TEMPS_TL

Description: Translated Service Category Name
Primary Key: IEB_SCTEMPTL_PK
  1. WBSC_ID
  2. LANGUAGE
Primary Key: IEB_SCTEMPTL_UK
  1. LANGUAGE
  2. SERVICE_CATEGORY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_TL.WBSC_ID IEB_SVC_CAT_TEMPS_B
Comments

Translated Service Category Name

Indexes
Index Type Tablespace Column
IEB_SVC_CAT_TEMPS_TL_PKU UNIQUE APPS_TS_SEED WBSC_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
WBSC_ID NUMBER (15) Y Unique Service Category ID.
LANGUAGE VARCHAR2 (4) Y Language of Text. The language to which things are translated.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SERVICE_CATEGORY_NAME VARCHAR2 (80) Y Translated Service Category Name
SOURCE_LANG VARCHAR2 (4)
Language from which things are translated.
DESCRIPTION VARCHAR2 (1996)
Description of the service category
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
MEDIA_CATEGORY_LABEL VARCHAR2 (30)
Server Category campaign label
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

IEB.IEB_SVC_CAT_TEMPS_TL does not reference any database object

IEB.IEB_SVC_CAT_TEMPS_TL is referenced by following:

IEB
VIEW - IEB_SVC_CAT_TEMPS_TL#

[top of page]

Table: IEB_SVC_VIRTUAL_QUEUES

Description: Summary information of virtal queues, i.e., dynamic agent groups, for IEB server internal use.
Primary Key: IEB_SVC_VIRTUAL_QUEUES_PK
  1. SVCVQ_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_VIRTUAL_QUEUES.WBSC_WBSC_ID IEB_WB_SVC_CATS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_AGENT_MAPS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES
IEB_WB_WORK_ITEMS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES
Comments

Summary information of virtal queues, i.e., dynamic agent groups, for IEB server internal use.

Indexes
Index Type Tablespace Column
IEB_SVC_VIRTUAL_QUEUES_PK_U UNIQUE APPS_TS_TX_IDX SVCVQ_ID
IEB_SVC_VIRTUAL_QUEUES_FK_N NONUNIQUE APPS_TS_TX_IDX WBSC_WBSC_ID
Columns
Name Datatype Length Mandatory Comments
SVCVQ_ID NUMBER (15) Y Service Virtual Queue ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SEQUENCE_NUMBER NUMBER (15) Y Internal ID generated by IEB server for the virtual queue.
EXPIRATION_DATE DATE
Y Time when this category expired
WBSC_WBSC_ID NUMBER (15) Y Service Category ID
SECURITY_GROUP_ID NUMBER (15)
Subscriber?s unique ID for Application Hosting Support

[top of page]

IEB.IEB_SVC_VIRTUAL_QUEUES does not reference any database object

IEB.IEB_SVC_VIRTUAL_QUEUES is referenced by following:

IEB
VIEW - IEB_SVC_VIRTUAL_QUEUES#

[top of page]

Table: IEB_WBST_WB_SC_RULES

Description: Intersection table that defines the M to M relations between service category selection rules and skill requirements.
Primary Key: IEB_WBST_WB_SC_RULES_PK
  1. WBSKTR_WBSKTR_ID
  2. WBSCRULE_WBSCRULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSCRULE_WBSCRULE_ID IEB_WB_SVC_CAT_RULES
IEB_WBST_WB_SC_RULES.WBSKTR_WBSKTR_ID IEB_WB_SKILL_TRANS
Comments

Intersection table that defines the M to M relations between service category selection rules and skill requirements.

Indexes
Index Type Tablespace Column
IEB_WBST_WB_SC_RULES_PK_U NONUNIQUE APPS_TS_TX_IDX WBSCRULE_WBSCRULE_ID
WBSKTR_WBSKTR_ID
IEB_WBST_WB_SC_RULES_SK_FK_N NONUNIQUE APPS_TS_TX_IDX WBSKTR_WBSKTR_ID
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
WBSKTR_WBSKTR_ID NUMBER (15) Y Competence ID
WBSCRULE_WBSCRULE_ID NUMBER (15) Y Service Category Rule ID
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.

[top of page]

IEB.IEB_WBST_WB_SC_RULES does not reference any database object

IEB.IEB_WBST_WB_SC_RULES is referenced by following:

IEB
VIEW - IEB_WBST_WB_SC_RULES#

[top of page]

Table: IEB_WB_SERVERS

Description: Summary Information of IEB servers.
Primary Key: IEB_WB_SERVERS_NM_UK
  1. WB_SERVER_NAME
Primary Key: IEB_WB_SERVERS_PK
  1. WBSVR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_AGENT_INDEXES.WBSVR_WBSVR_ID IEB_WB_SERVERS
IEB_WB_SVC_CATS.WBSVR_WBSVR_ID IEB_WB_SERVERS
IEB_WB_SVRS_MMS_SVRS.WBSVR_WBSVR_ID IEB_WB_SERVERS
Comments

Summary Information of IEB servers.

Indexes
Index Type Tablespace Column
IEB_WB_SERVERS_PK_U UNIQUE APPS_TS_TX_IDX WBSVR_ID
IEB_WB_SERVERS_N1 NONUNIQUE APPS_TS_TX_IDX IEO_SERVER_ID
Columns
Name Datatype Length Mandatory Comments
WBSVR_ID NUMBER (15) Y WorkBending Server ID created by system
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
WB_SERVER_NAME VARCHAR2 (80) Y Server Name
LOG_FILE_NAME VARCHAR2 (256)
Full path of log file
LOG_DBC_FILE_NAME VARCHAR2 (256)
DBC file path of the database for IEB server log messages, if it differs from the database for server data
CCI_DBC_FILE_NAME VARCHAR2 (256)
DBC file path of the database for CCI data, if differs from the database for server data
STAT_DUMP_SUNDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Sunday
STAT_DUMP_MONDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Monday
STAT_DUMP_TUESDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Tuesday
STAT_DUMP_WEDNESDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Wednesday
STAT_DUMP_THURSDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Thursday
STAT_DUMP_FRIDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Friday
STAT_DUMP_SATURDAY_Y_N VARCHAR2 (1) Y Yes or No for Statistics dump on Saturday
STAT_DUMP_BEG_TIME_HHMM NUMBER (4)
Time in 2400 fomrat
STAT_DUMP_END_TIME_HHMM NUMBER (4)
Time in 2400 fomrat
DAILY_CLEANUP_Y_N VARCHAR2 (1) Y Yes or No for daily clean up
CLEANUP_TIME_HHMM NUMBER (4)
Cleanup Time in 2400 fomrat
AUTO_SHUT_DOWN_Y_N VARCHAR2 (1) Y Yes or No for auto shut down
AUTO_SHUT_DOWN_TIME_HHMM NUMBER (4)
Auto shut down Time in 2400 fomrat
VIRTUAL_Q_CLEANUP_SIZE NUMBER (8) Y Size of virutal that requires server clean up function
WORK_QUEUE_CACHE_SIZE NUMBER (8) Y Size of work queue threshold for send to database
TRACE_FILE_NAME VARCHAR2 (256)
Trace File Name
WB_SERVER_TYPE VARCHAR2 (20) Y Enumerated values to describe server type (e.g., production server, test server, etc.) This values will be seeded for FND_LOOKUPS
DESCRIPTION VARCHAR2 (240)
Optional description of the server
COMMUNICATION_METHOD VARCHAR2 (32) Y Communication type, such as RMI, TCP/IP, etc.
COM_OBJECT_NAME VARCHAR2 (32)
RMI or other Object Name
COM_DNS_NAME VARCHAR2 (32)
DNS Name
COM_IP_ADDRESS VARCHAR2 (15)
TCP/IP port number
COM_PORT_NUMBER NUMBER (15)
TCP/IP port number
COM_PARAM1 VARCHAR2 (32)
Future Use
COM_PARAM2 VARCHAR2 (32)
Future Use
COM_PARAM3 VARCHAR2 (32)
Future Use
COM_PARAM4 VARCHAR2 (32)
Future Use
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
CHECK_NEW_SC_ENTRY VARCHAR2 (1)
Flag to check Blending service category configurations. For future use.
IEO_SERVER_ID NUMBER (15)
Server ID from IEO_SVR_SERVERS table.

[top of page]

IEB.IEB_WB_SERVERS does not reference any database object

IEB.IEB_WB_SERVERS is referenced by following:

IEB
VIEW - IEB_WB_SERVERS#

[top of page]

Table: IEB_WB_SKILL_TRANS

Description: Definition of skill requirements for service category selection rules.
Primary Key: IEB_WB_SKILL_TRANS_PK
  1. WBSKTR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSKTR_WBSKTR_ID IEB_WB_SKILL_TRANS
Comments

Definition of skill requirements for service category selection rules.

Indexes
Index Type Tablespace Column
IEB_WB_SKILL_TRANS_PK_U UNIQUE APPS_TS_TX_IDX WBSKTR_ID
Columns
Name Datatype Length Mandatory Comments
WBSKTR_ID NUMBER (15) Y Competence ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SKILL_CATEGORY VARCHAR2 (80) Y SKILL Header statement from MMS, such as "LANGUAGE"
SKILL_CONTENTS VARCHAR2 (80) Y Skill contents statement, such as "SPANISH"
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.

[top of page]

IEB.IEB_WB_SKILL_TRANS does not reference any database object

IEB.IEB_WB_SKILL_TRANS is referenced by following:

IEB
VIEW - IEB_WB_SKILL_TRANS#

[top of page]

Table: IEB_WB_SVC_CATS

Description: Summary Information of service categories.
Primary Key: IEB_WB_SVC_CATS_PK
  1. WBSC_ID
Primary Key: WBSC_UK
  1. SERVICE_CATEGORY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVC_CATS.PARENT_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CATS.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_WB_SVC_CATS.WBSVR_WBSVR_ID IEB_WB_SERVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_SVC_VIRTUAL_QUEUES.WBSC_WBSC_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CATS.PARENT_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CAT_RULES.WBSC_WBSC_ID IEB_WB_SVC_CATS
Comments

Summary Information of service categories.

Indexes
Index Type Tablespace Column
IEB_WB_SVC_CATS_PK_U UNIQUE APPS_TS_TX_IDX WBSC_ID
IEB_WB_SVC_CATS_N4 NONUNIQUE APPS_TS_TX_IDX MEDIA_TYPE_ID
IEB_WB_SVC_CATS_PARENT_FK_N NONUNIQUE APPS_TS_TX_IDX PARENT_ID
IEB_WB_SVC_CATS_SP_FK_N NONUNIQUE APPS_TS_TX_IDX SVCPLN_SVCPLN_ID
IEB_WB_SVC_CATS_WBSVR_FK_N NONUNIQUE APPS_TS_TX_IDX WBSVR_WBSVR_ID
Columns
Name Datatype Length Mandatory Comments
WBSC_ID NUMBER (15) Y Service Category ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SERVICE_CATEGORY_NAME VARCHAR2 (80) Y Service Category Name
CAMPAIGN_SERVER_NAME VARCHAR2 (80)
IEO Campaign Plus server name related to the Service Category, for outbound use only.
CAMPAIGN_NAME VARCHAR2 (80)
Name of the AMS Campaign related to the IEO Campaign Plus Server, for outbound use only.
ACTIVE_Y_N VARCHAR2 (1) Y "Y" if the service category is active
MEDIA_TYPE VARCHAR2 (80) Y Media Type
DESCRIPTION VARCHAR2 (1996)
Description
PRIORITY NUMBER (4) Y Service Category priority
DEPTH NUMBER (4) Y Depth of the Service category node from the tree top.
WBSVR_WBSVR_ID NUMBER (15) Y WorkBending Server ID created by system
PARENT_ID NUMBER (15)
Service Category ID
SVCPLN_SVCPLN_ID NUMBER (15) Y Service Plan ID
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
CAMPAIGN_SCHEDULE_ID NUMBER

Campaign Schedule Id
MEDIA_TYPE_ID NUMBER (15)
Media Type ID from the IEU_UWQ_MEDIA_TYPES_B table.
DEFAULT_FLAG VARCHAR2 (1)
Default Flag to indicate the required parent service categories.

[top of page]

IEB.IEB_WB_SVC_CATS does not reference any database object

IEB.IEB_WB_SVC_CATS is referenced by following:

IEB
VIEW - IEB_WB_SVC_CATS#

[top of page]

Table: IEB_WB_SVC_CAT_RULES

Description: Rules for selecting inbound media tasks into service categories.
Primary Key: IEB_WB_SVC_CAT_RULES_PK
  1. WBSCRULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVC_CAT_RULES.WBSC_WBSC_ID IEB_WB_SVC_CATS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSCRULE_WBSCRULE_ID IEB_WB_SVC_CAT_RULES
Comments

Rules for selecting inbound media tasks into service categories.

Indexes
Index Type Tablespace Column
IEB_WB_SVC_CAT_RULES_PK_U UNIQUE APPS_TS_TX_IDX WBSCRULE_ID
IEB_WB_SVC_CAT_RULES_WBSC_FK_N NONUNIQUE APPS_TS_TX_IDX WBSC_WBSC_ID
Columns
Name Datatype Length Mandatory Comments
WBSCRULE_ID NUMBER (15) Y Service Category Rule ID
RULE_TYPE VARCHAR2 (1) Y Type of information to make up the rule, 'C' for Classification, 'S" for Skills + Arrival Address.
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CLASSIFICATION VARCHAR2 (80)
Task Classification Code from MCM used for selection rules.
ARRIVAL_ADDRESS VARCHAR2 (80)
Name
SKILL_INCLUDED_Y_N VARCHAR2 (1) Y Yes or No
DESCRIPTION VARCHAR2 (240)
Description
WBSC_WBSC_ID NUMBER (15) Y Service Category ID
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.

[top of page]

IEB.IEB_WB_SVC_CAT_RULES does not reference any database object

IEB.IEB_WB_SVC_CAT_RULES is referenced by following:

IEB
VIEW - IEB_WB_SVC_CAT_RULES#

[top of page]

Table: IEB_WB_SVRS_MMS_SVRS

Description: Intersection table between Media Manager Servers and IEB servers. (Obsolete).
Primary Key: IEB_WB_SVRS_MMS_SVRS_PK
  1. WBMMS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVRS_MMS_SVRS.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
IEB_WB_SVRS_MMS_SVRS.WBSVR_WBSVR_ID IEB_WB_SERVERS
Comments

Intersection table between Media Manager Servers and IEB servers. (Obsolete).

Indexes
Index Type Tablespace Column
IEB_WB_SVRS_MMS_SVRS_MMS_FK_N NONUNIQUE APPS_TS_TX_IDX MMSSVR_MMSSVR_ID
IEB_WB_SVRS_MMS_SVRS_WB_FK_N NONUNIQUE APPS_TS_TX_IDX WBSVR_WBSVR_ID
Columns
Name Datatype Length Mandatory Comments
WBMMS_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
MMSSVR_MMSSVR_ID NUMBER (15) Y Unique ID generated by system as primary key
WBSVR_WBSVR_ID NUMBER (15) Y WorkBending Server ID created by system
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.

[top of page]

IEB.IEB_WB_SVRS_MMS_SVRS does not reference any database object

IEB.IEB_WB_SVRS_MMS_SVRS is referenced by following:

IEB
VIEW - IEB_WB_SVRS_MMS_SVRS#

[top of page]

Table: IEB_WB_WORK_ITEMS

Description: Media work items.
Primary Key: IEB_WB_WORK_ITEMS_PK
  1. WITM_ID
Primary Key: IEB_WB_WORK_ITEM_UK
  1. WORK_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_WORK_ITEMS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES
Comments

Media work items.

Indexes
Index Type Tablespace Column
IEB_WB_WORK_ITEMS_PK_U UNIQUE APPS_TS_TX_IDX WITM_ID
IEB_WB_WORK_ITEMS_VQ_FK_N NONUNIQUE APPS_TS_TX_IDX SVCVQ_SVCVQ_ID
Columns
Name Datatype Length Mandatory Comments
WITM_ID NUMBER (15) Y Oracle Standard Primary ID
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
WORK_ITEM_ID VARCHAR2 (32) Y Work Item ID
ORIGINAL_WORK_ID VARCHAR2 (32)
Original Work ID from original server
QUEUED_TIME DATE
Y date and time queued
SOURCE VARCHAR2 (32)
Name of MMS server where the item came from
SVCVQ_SVCVQ_ID NUMBER (15) Y Service Virtual Queue ID
PARAM1 VARCHAR2 (32)
Optional Work Item parameter 1
PARAM2 VARCHAR2 (32)
Optional Work Item parameter 1
SECURITY_GROUP_ID NUMBER (15)
This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
CACHED_Y_N VARCHAR2 (1) Y Flag indicating if the work item has been cached back to server memory.
MMS_SERVER_ID NUMBER (15) Y Unique ID of the MMS server where the work item comes from.

[top of page]

IEB.IEB_WB_WORK_ITEMS does not reference any database object

IEB.IEB_WB_WORK_ITEMS is referenced by following:

IEB
VIEW - IEB_WB_WORK_ITEMS#

[top of page]

View: IEB_SVC_CAT_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
WB_SERVER_NAME VARCHAR2 (80) Y Interaction Blending Server Name
WBSC_ID NUMBER (15) Y Service Category ID
SERVICE_CATEGORY_NAME VARCHAR2 (80) Y Service Category Name
DESCRIPTION VARCHAR2 (1996)
Description
CLASSIFICATION VARCHAR2 (80)
Task Classification Code from MCM used for selection rules.
MEDIA_TYPE VARCHAR2 (80) Y Media Type
ACTIVE_Y_N VARCHAR2 (1) Y "Y" if the service category is active

[top of page]

APPS.IEB_SVC_CAT_CLASSIFICATIONS_V references the following:

APPS
SYNONYM - IEB_WB_SERVERS
SYNONYM - IEB_WB_SVC_CATS
SYNONYM - IEB_WB_SVC_CAT_RULES

APPS.IEB_SVC_CAT_CLASSIFICATIONS_V is not referenced by any database object

[top of page]

View: IEB_SVC_CAT_TEMPLATES

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IEB_SVC_CAT_TEMPLATES is a view of service category templates. Service Category Templates contain the predefined properties for top level service categories. Whenever a new Interaction Blending Server is created, Interaction Blending Server Admin utility automatically creates the top level service categories for the server using the service category properties defined in the templates.

Columns
Name Datatype Length Mandatory Comments
WBSC_ID NUMBER (15) Y Service Category ID
SVCPLN_SVCPLN_ID NUMBER (15) Y ID of the service plan used by this service category
MEDIA_TYPE VARCHAR2 (80) Y Media type of the tasks in this service category
DEPTH NUMBER (4) Y Depth of the service category node.
PARENT_ID NUMBER (15)
ID of the parent service category
ORIGINAL_NAME VARCHAR2 (80) Y Service Category's Original English Name
ACTIVE_Y_N VARCHAR2 (1) Y Flag indicating if this service category entry is active.
SERVICE_CATEGORY_NAME VARCHAR2 (80) Y Service Category's translated name in user language.
DESCRIPTION VARCHAR2 (1996)
Description of the service category in user's language.

[top of page]

APPS.IEB_SVC_CAT_TEMPLATES references the following:

APPS
SYNONYM - IEB_SVC_CAT_TEMPS_B
SYNONYM - IEB_SVC_CAT_TEMPS_TL

APPS.IEB_SVC_CAT_TEMPLATES is not referenced by any database object

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