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.
Description: | ACD Queue setup data |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_ACD_QUEUE_INFO.SREF_TYPE
IEO_ACD_QUEUE_INFO.PBX_NAME |
IEO_PBX_INFO |
ACD Queue setup data
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACD_QUEUE_INFO_ID | NUMBER | (15) | Y | ACD queue Identifier |
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 | |
ACD_QUEUE_NAME | VARCHAR2 | (30) | Y | ACD Queue Name |
PBX_NAME | VARCHAR2 | (30) | Y | PBX Name to which this ACD Queue belong |
SREF_TYPE | VARCHAR2 | (5) | Y | Reference Type, always 'S' |
ACD_QUE_NUM | VARCHAR2 | (16) | ACD queue number | |
ACD_QUE_QUALIFIER | VARCHAR2 | (16) | acd queue qualifier | |
ACD_QUE_FLAG | VARCHAR2 | (5) | queue flag | |
ACD_TYPE | VARCHAR2 | (32) | Type of the ACD queue | |
ACTIVE_Y_N | VARCHAR2 | (5) | Indicates whether the ACD is currently active or not | |
CDN_SPECIFIER | VARCHAR2 | (80) | Switch specific value - some swithces (Meridian, for ex) require this | |
ENABLER_INFO_1 | VARCHAR2 | (80) | Enabler specific info | |
ENABLER_INFO_2 | VARCHAR2 | (80) | Enabler specific info | |
ENABLER_INFO_3 | VARCHAR2 | (80) | Enabler specific info | |
ENABLER_INFO_4 | VARCHAR2 | (80) | Enabler specific info | |
RESTART_TIME | NUMBER | (9) | Time interval to restart an ACD queue after shutdown | |
ACTUAL_PBX_NAME | VARCHAR2 | (30) | The actual name of the PBX. Allows a single PBX to be shared among more than one service using the PBX_NAME column value | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_ACD_QUEUE_INFO does not reference any database object
IEO.IEO_ACD_QUEUE_INFO is referenced by following:
Description: | Advanced outbound algorithms table |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_ALGORITHMS_ALL.NAME
IEO_ALGORITHMS_ALL.TYPE |
IEO_ALGORITHM_NAMES_ALL |
Advanced outbound algorithms table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALGORITHM_ID | NUMBER | (15) | Y | Algorithms 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 | |
NAME | VARCHAR2 | (128) | Y | algorithm name |
TYPE | VARCHAR2 | (10) | Y | algorithm type |
LINE_NUMBER | NUMBER | (15) | Y | line number |
LINE_TEXT | VARCHAR2 | (256) | Y | line text |
ORG_ID | NUMBER | (15) | Y | multi-org support |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_ALGORITHMS_ALL does not reference any database object
IEO.IEO_ALGORITHMS_ALL is referenced by following:
Description: | Name for Advanced outbound Calendar and Recycle algorithms |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_SERVICES_ALL.CALENDAR_FILE
IEO_CP_SERVICES_ALL.CAL_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
IEO_CP_SERVICES_ALL.RECYCLING_METHOD
IEO_CP_SERVICES_ALL.RCY_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
IEO_ALGORITHMS_ALL.NAME
IEO_ALGORITHMS_ALL.TYPE |
IEO_ALGORITHM_NAMES_ALL |
IEO_CP_SVC_LISTS_ALL.CALENDAR_FILE
IEO_CP_SVC_LISTS_ALL.CAL_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
Name for Advanced outbound Calendar and Recycle Algorithms
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALGORITHM_NAME_ID | NUMBER | (15) | Y | algorithm name 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 | |
NAME | VARCHAR2 | (128) | Y | algorithm name |
TYPE | VARCHAR2 | (10) | Y | algorithm type |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_ALGORITHM_NAMES_ALL does not reference any database object
IEO.IEO_ALGORITHM_NAMES_ALL is referenced by following:
Description: | Campaign Plus campaigns |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CAMPAIGNS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IEO_LIST_CAMP_XRS_ALL.REF_TYPE
IEO_LIST_CAMP_XRS_ALL.REF_NAME |
IEO_CAMPAIGNS_ALL |
Campaign Plus campaigns
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | (10) | Y | campaign identifier |
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 | |
ORG_ID | NUMBER | (15) | Y | Multi org support column |
REF_TYPE | VARCHAR2 | (5) | Y | 'C' for campaigns and 'G' for list groups |
REF_NAME | VARCHAR2 | (30) | Y | Campaign name |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | The Campaign Plus service associated with this campaign |
POWER_SCORE_Y_N | VARCHAR2 | (5) | Obsolete | |
PRODUCT_SELECT_MAX | NUMBER | (38) | Obsolete | |
POWER_GUIDE_FILE | VARCHAR2 | (254) | Obsolete | |
PBX_NAME | VARCHAR2 | (30) | Obsolete | |
PRIORITY_NUMBER | NUMBER | (9) | Obsolete | |
PROD_SELECT_MAX | NUMBER | (38) | Obsolete | |
QUOTE_EXPR_DAYS | NUMBER | (38) | Obsolete | |
CATEGORY | VARCHAR2 | (15) | Not currently used | |
CALL_PROG_DETECT | VARCHAR2 | (20) | Not currently used | |
CAMPAIGN_CODE | VARCHAR2 | (10) | Not currently used | |
SHORT_DESCRIPTION | VARCHAR2 | (30) | Short description of the campaign | |
AFFINITY_Y_N | VARCHAR2 | (5) | Not currently used | |
PRODUCT_ORDER_Y_N | VARCHAR2 | (5) | Not currently used | |
LIST_MANAGER_Y_N | VARCHAR2 | (5) | Indicates whether the campaign is associated with a Campaign Plus or not | |
LIST_NAME | VARCHAR2 | (30) | Not currently used | |
STARTUP_DATE | DATE | Date on which this campaign was started | ||
SET_NUMBER | NUMBER | (9) | Campaign Plus's internal numeric id for this campaign | |
SET_STATUS | VARCHAR2 | (5) | "Y" = normal, "C" = closed due to data inconsistency, "N" = new | |
SET_TYPE | NUMBER | (9) | Not used | |
TRANS_SCORE_ITEM | VARCHAR2 | (96) | Not used | |
USE_DIALING_Y_N | VARCHAR2 | (5) | Not used | |
LONG_DESCRIPTION | VARCHAR2 | (254) | Long description of the campaign | |
MAX_WAIT_LS_RESP | NUMBER | (38) | Not used | |
ACTIVE_Y_N | VARCHAR2 | (5) | Indicates whether the campaign is active or not | |
PRODUCT_ID | VARCHAR2 | (20) | Not used | |
CPDRCT | NUMBER | (9) | Not used | |
CLIENT_ID | VARCHAR2 | (20) | Not used | |
DEF_INTERNAL_LIST | VARCHAR2 | (30) | Not used | |
DEF_EXTERNAL_LIST | VARCHAR2 | (30) | Not used | |
DEF_LIST_GROUP | VARCHAR2 | (30) | Not used | |
AUTO_START_PG_Y_N | VARCHAR2 | (5) | Not used | |
GROUP_TYPE | VARCHAR2 | (30) | Indicates whether the campaign is a campaign or a list group | |
DIALING_TYPE | NUMBER | (9) | Numerical dialing type of the campaign | |
NUM_MEMBERS | NUMBER | (9) | Number of members in this campaign | |
NUM_SET_MEMBERS | NUMBER | (9) | Number of members of this campaign/list group that are list groups | |
DIALING_OPTIONS | VARCHAR2 | (128) | Options string transmitted to Predictive along with any record from this campaign | |
CAM_CP_SERVICE_ID | NUMBER | not used | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CAMPAIGNS_ALL does not reference any database object
IEO.IEO_CAMPAIGNS_ALL is referenced by following:
Description: | Release statistics for records from CP lists |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_LIST_STATS_ALL.LIST_NAME
IEO_CP_LIST_STATS_ALL.LIST_SRV_NAME IEO_CP_LIST_STATS_ALL.SREF_TYPE |
IEO_CP_SVC_LISTS_ALL |
Release statistics for records from CP Lists
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_LIST_STAT_ID | NUMBER | Y | Primary key column | |
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 | |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
LIST_NAME | VARCHAR2 | (30) | Y | List name |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service name |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
T10AM | NUMBER | (9) | Number of records released from 10am-10:59am | |
T10PM | NUMBER | (9) | Number of records released from 10pm-10:59pm | |
T10_MIN | NUMBER | (9) | Records released in the last 10 minutes | |
T11AM | NUMBER | (9) | Number of records released from 11am-11:59am | |
T11PM | NUMBER | (9) | Number of records released from 11pm-11:59pm | |
T12PM | NUMBER | (9) | Number of records released from 12pm-12:59pm | |
T1PM | NUMBER | (9) | Number of records released from 1pm-1:59pm | |
T12AM | NUMBER | (9) | Number of records released from 12am-12:59am | |
T1AM | NUMBER | (9) | Number of records released from 1am-1:59am | |
T15_MIN | NUMBER | (9) | Records released in the last 15 minutes | |
T1_MIN | NUMBER | (9) | Records released in the last 1 minute | |
T2PM | NUMBER | (9) | Number of records released from 2pm-2:59pm | |
T2AM | NUMBER | (9) | Number of records released from 2am-2:59am | |
T3PM | NUMBER | (9) | Number of records released from 3pm-3:59pm | |
T3AM | NUMBER | (9) | Number of records released from 3am-3:59am | |
T30_MIN | NUMBER | (9) | Records released in the last 30 minutes | |
T4PM | NUMBER | (9) | Number of records released from 4pm-4:59pm | |
T4AM | NUMBER | (9) | Number of records released from 4am-4:59am | |
T5PM | NUMBER | (9) | Number of records released from 5pm-5:59pm | |
T5AM | NUMBER | (9) | Number of records released from 5am-5:59am | |
T5_MIN | NUMBER | (9) | Records released in the last 5 minutes | |
T6PM | NUMBER | (9) | Number of records released from 6pm-6:59pm | |
T6AM | NUMBER | (9) | Number of records released from 6am-6:59am | |
T60_MIN | NUMBER | (9) | Records released in the last 60 minutes | |
T7PM | NUMBER | (9) | Number of records released from 7pm-7:59pm | |
T7AM | NUMBER | (9) | Number of records released from 7am-7:59am | |
T8PM | NUMBER | (9) | Number of records released from 8pm-8:59pm | |
T8AM | NUMBER | (9) | Number of records released from 8am-8:59am | |
T9PM | NUMBER | (9) | Number of records released from 9pm-9:59pm | |
RELEASED_1 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_10 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_11 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_12 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_13 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_14 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_15 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_16 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_17 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_18 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_19 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_2 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_20 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_21 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_22 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_23 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_24 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_25 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_26 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_27 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_28 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_29 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_3 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_30 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_31 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_32 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_33 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_34 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_35 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_36 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_37 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_38 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_39 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_4 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_40 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_41 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_42 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_43 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_44 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_45 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_46 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_47 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_48 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_49 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_5 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_50 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_51 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_52 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_53 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_54 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_55 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_56 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_57 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_58 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_59 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_6 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_60 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_7 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_8 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
RELEASED_9 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
TN1_MIN | NUMBER | (9) | Records expected to be relesaed in the next 1 minute | |
TN5_MIN | NUMBER | (9) | Records expected to be relesaed in the next 5 minutes | |
TN10_MIN | NUMBER | (9) | Records expected to be released in the next 10 minutes | |
TN15_MIN | NUMBER | (9) | Records expected to be released in the next 15 minutes | |
TN30_MIN | NUMBER | (9) | Records expected to be released in the next 30 minutes | |
TN60_MIN | NUMBER | (9) | Records expected to be released in the next 60 minutes | |
REC_ADDED | NUMBER | (9) | Number of records added since process started | |
REC_TAKEN | NUMBER | (9) | Number of records taken since process started | |
CUR_TOTAL_REC | NUMBER | (9) | Total records stored in this service | |
REC_AVAILABLE | NUMBER | (9) | Records available for release | |
REC_UNAVAILABLE | NUMBER | (9) | Records unavailable due to timestamps or closed lists | |
T9AM | NUMBER | (9) | Number of records released from 9am-9:59am | |
LAST_STAT_REFRESH | DATE | Obsolete | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_LIST_STATS_ALL does not reference any database object
IEO.IEO_CP_LIST_STATS_ALL is referenced by following:
Description: | Phone Type and Message ID cross reference table |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_PHONETYPE_MSG_XRS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_ANS_MACHINE | IEO_VOICE_MSGS_ALL |
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_FRONT_HOLD | IEO_VOICE_MSGS_ALL |
Phone Type and Message ID cross reference table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
CREATION_DATE | DATE | Y | Standard WHO column | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO column |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO column |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
PHONE_TYPE | VARCHAR2 | (30) | Y | Phone type - 'Home' or 'Work' etc. |
CP_PHONETYPE_MSG_ID | NUMBER | (15) | Y | Primary key column |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | Campaign Plus server name |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
MESSAGEID_ANS_MACHINE | NUMBER | (10) | Answering Machine Message ID associated with the phone type | |
MESSAGEID_FRONT_HOLD | NUMBER | (10) | Frond Hold Message ID associated with the phone type | |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_PHONETYPE_MSG_XRS_ALL does not reference any database object
IEO.IEO_CP_PHONETYPE_MSG_XRS_ALL is referenced by following:
Description: | Setup/configuration for all Campaign Plus services on this system |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_SERVICES_ALL.CAMPAIGN_LIST_ID | AMS_LIST_HEADERS_ALL |
IEO_CP_SERVICES_ALL.CALENDAR_FILE
IEO_CP_SERVICES_ALL.CAL_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
IEO_CP_SERVICES_ALL.RECYCLING_METHOD
IEO_CP_SERVICES_ALL.RCY_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IEO_CAMPAIGNS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
IEO_CP_PHONETYPE_MSG_XRS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
IEO_CP_SVC_FIELDS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
IEO_CP_SVC_LISTS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
Setup/configuration for all Campaign Plus services on this system
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SERVICE_ID | NUMBER | Y | Primary key column | |
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 | |
SREF_TYPE | VARCHAR2 | (5) | Y | Always "S" |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service name |
RECYCLING_METHOD | VARCHAR2 | (30) | Obsolete | |
CALENDAR_FILE | VARCHAR2 | (128) | Y | Location info (filename or other unique ID) for service calendar file |
CAL_ALG_TYPE | VARCHAR2 | (10) | Y | "SCHEDULE" |
RCY_ALG_TYPE | VARCHAR2 | (10) | Y | "RECYCLE" |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
REORG_RECHECK_FLG | VARCHAR2 | (5) | "Y"(es) if records should be rechecked and redistributed at shutdown | |
REORG_DATE | DATE | Last reorganization date | ||
REVISION | NUMBER | (9) | Timestamp when record was updated on disk | |
REORG_FLAG | VARCHAR2 | (5) | "Y"(es) if shutdown-time reorganization completed successfully | |
STOP_LIST_LD_FLAG | VARCHAR2 | (5) | Obsolete | |
SEND_ORIG_LIST_FLG | VARCHAR2 | (5) | Obsolete | |
SCRIPT_NAME | VARCHAR2 | (32) | Obsolete | |
SQL_SELECT_STR | VARCHAR2 | (1000) | WHERE clause for SQL SELECT statement that qualifies records for loading in this service | |
STOP_CNTCT_CH_FLAG | VARCHAR2 | (5) | Obsolete | |
T2PM | NUMBER | (9) | Number of records released from 2pm-2:59pm | |
T3PM | NUMBER | (9) | Number of records released from 3pm-3:59pm | |
T30_MIN | NUMBER | (9) | Number of records released in the last 30 minutes | |
T4PM | NUMBER | (9) | Number of records released from 4pm-4:59pm | |
T5PM | NUMBER | (9) | Number of records released from 5pm-5:59pm | |
T5_MIN | NUMBER | (9) | Number of records released in the last 5 minutes | |
T6PM | NUMBER | (9) | Number of records released from 6pm-6:59pm | |
T60_MIN | NUMBER | (9) | Number of records released in the last 60 minutes | |
T7PM | NUMBER | (9) | Number of records released from 7pm-7:59pm | |
T8PM | NUMBER | (9) | Number of records released from 8pm-8:59pm | |
T9PM | NUMBER | (9) | Number of records released from 9pm-9:59pm | |
T10PM | NUMBER | (9) | Number of records released from 10pm-10:59pm | |
T10_MIN | NUMBER | (9) | Number of records released in the last 10 minutes | |
T10AM | NUMBER | (9) | Number of records released from 10am-10:59am | |
T11PM | NUMBER | (9) | Number of records released from 11pm-11:59pm | |
LAST_STAT_REFRESH | DATE | Obsolete | ||
LIST_DB_NAME | VARCHAR2 | (128) | Database identifier for customer table | |
LISTDB_RELEASE_STR | VARCHAR2 | (1000) | Boolean logic that permits records to be released from this service | |
LISTDB_SELECT_STR | VARCHAR2 | (1000) | Boolean logic that qualifies records for loading in this service - not currently supported | |
LIST_DB_STATUS | VARCHAR2 | (5) | Obsolete | |
LAST_QBLOCK_BYTES | NUMBER | (9) | Bytes used in last .QLD file block | |
MASTER_FILE_SPEC | VARCHAR2 | (250) | Obsolete | |
MASTER_TABLE | VARCHAR2 | (30) | Table or view name from which customer data is loaded | |
MASTER_FS_LEN | NUMBER | (9) | Obsolete | |
NUM_AGENTS | NUMBER | (9) | Obsolete | |
NUM_BLKS_LIST_FILE | NUMBER | (9) | Size of .QLD file in 16KB blocks | |
NUM_CACHE_READS | NUMBER | (9) | Cache performance statistics | |
NUM_CACHE_WRITES | NUMBER | (9) | Cache performance statistics | |
NUM_CACHE_HITS | NUMBER | (9) | Cache performance statistics | |
NUM_CACHE_MISSES | NUMBER | (9) | Cache performance statistics | |
NUM_CACHE_COLLISNS | NUMBER | (9) | Cache performance statistics | |
NUM_FIELD_RECORDS | NUMBER | (9) | Number of columns used in customer records in .QLD | |
NUM_SET_RECORDS | NUMBER | (9) | Number of defined list groups/campaigns in this service | |
NUM_LIST_RECORDS | NUMBER | (9) | Number of lists in this service | |
NUM_CACHE_FLUSHES | NUMBER | (9) | Cache performance statistics | |
CHECK_DUPES_FLAG | VARCHAR2 | (5) | Determine whether or not duplicate records should be identified and purged at shutdown time. (Always "Y" currently) | |
PROP_RLS_FLAG | VARCHAR2 | (5) | Obsolete | |
CURRENT_ENTRY_CNT | NUMBER | (9) | Total number of records in this service | |
DIALING_OPTIONS | VARCHAR2 | (128) | Dialing options string passed to Predictive | |
ABANDON_LIMIT | NUMBER | (9) | Obsolete | |
TALK_TIME_LOCAL | NUMBER | (9) | Obsolete | |
PACING_METHOD | NUMBER | (9) | Obsolete | |
PACE_Y_N | VARCHAR2 | (5) | Obsolete | |
PBX_NAME | VARCHAR2 | (30) | Predictive service name associated with this service | |
LISTDB_TYPE | NUMBER | (9) | 99 = SQL-based RDBMS | |
T1_MIN | NUMBER | (9) | Number of records released in the last 1 minute | |
T15_MIN | NUMBER | (9) | Number of records released in the last 15 minutes | |
T9AM | NUMBER | (9) | Number of records released from 9am-9:59am | |
T11AM | NUMBER | (9) | Number of records released from 11am-11:59am | |
T12PM | NUMBER | (9) | Number of records released from 12pm-12:59pm | |
T1PM | NUMBER | (9) | Number of records released from 1pm-1:59pm | |
TIME_ZONE | NUMBER | (38) | Time zone in which the server operates | |
ACCT_NAME_COLUMNS | VARCHAR2 | (100) | Name(s) of column(s) in MASTER_TABLE that, together, represent the customer name | |
DATA_FIELDS | VARCHAR2 | (1100) | Name(s) of column(s) in MASTER_TABLE that (in addition to ACCT_NAME_COLUMNS) populate each customer record in the .QLD | |
DB_PASSWORD | VARCHAR2 | (60) | Authorization info for LIST_DB_NAME | |
ACCOUNT_ID | VARCHAR2 | (30) | Name of column in MASTER_TABLE that holds unique customer ID | |
POST_PROC_FILE | VARCHAR2 | (128) | Location info (filename or other unique ID) for reycling algorithm file | |
JOURNAL_FLUSH | NUMBER | (9) | Journal flush interval - obsolete | |
DIALING_TYPE | NUMBER | (9) | Dialing type supported by this service (45 = predictive, 5 = preview) | |
NPR_LST_DB_LIST | NUMBER | (9) | Obsolete | |
USER_DATA_SIZE | NUMBER | (9) | Total size of the ACCT_NAME_COLUMNS and DATA_FIELDS columns record in the .QLD file | |
VERSION | NUMBER | (9) | Software version compatibility | |
CAMPAIGN_LIST_ID | NUMBER | (15) | FK to AMS_LIST_HEADERS_ALL, connects Campaign Plus to AMS Campaign | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_SERVICES_ALL does not reference any database object
IEO.IEO_CP_SERVICES_ALL is referenced by following:
Description: | People who should not be called |
---|
People who should not be called
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_STOP_LIST_ID | NUMBER | (15) | Y | Identifies the column that acts as the key to this table |
STOP_EXPIRES_DATE | DATE | Specifies the date the 'stop' expires for the customer ID | ||
STOP_LIST_CODE | VARCHAR2 | (5) | The code associated with this stop list | |
TELEPHONE_NUMBER | VARCHAR2 | (24) | Telephone number of the customer | |
CUSTOMER_ID | VARCHAR2 | (20) | Customer ID | |
TIME_ZONE | VARCHAR2 | (2) | Time zone of the telephone number | |
CAMPAIGN | VARCHAR2 | (30) | Campaign name | |
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 | |
CP_STOP_LIST_KEY | VARCHAR2 | (60) | Y | Key used by CP to find this record. Typically configured either as customer ID or phone number but can be something else (e.g. a combination of both of those). |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_STOP_LIST does not reference any database object
IEO.IEO_CP_STOP_LIST is referenced by following:
Description: | Fields (user-defined and name fields) implemented in each CP service |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_SVC_FIELDS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
Fields (user defined and name fields) implemented in each CP service
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SVC_FIELD_ID | NUMBER | (15) | Y | Primary key column |
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 | |
FIELD_NAME | VARCHAR2 | (30) | Y | Name of a column in "customer" table to be included in .QLD |
ORG_ID | NUMBER | (15) | Y | Multi org support column |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service name |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
FIELD_WIDTH | NUMBER | (9) | Max size of this column | |
FIELD_TYPE | NUMBER | (9) | Datatype of this column | |
JUSTIFY_FLG | NUMBER | (9) | Bitmask for various field attributes including right-justification | |
SRV_FIELD_NUM | NUMBER | (9) | Internal sequential number of this column | |
OFFSET | NUMBER | (9) | Location of the beginning of this column in a .QLD record | |
SORT_DIRECTION | VARCHAR2 | (5) | Not used | |
TEL_FLAG | VARCHAR2 | (5) | Not used | |
CALL_MAP | VARCHAR2 | (100) | Not used | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_SVC_FIELDS_ALL does not reference any database object
IEO.IEO_CP_SVC_FIELDS_ALL is referenced by following:
Description: | Calling lists supported by CP services |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_SVC_LISTS_ALL.CALENDAR_FILE
IEO_CP_SVC_LISTS_ALL.CAL_ALG_TYPE |
IEO_ALGORITHM_NAMES_ALL |
IEO_CP_SVC_LISTS_ALL.LIST_SRV_NAME | IEO_CP_SERVICES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IEO_LIST_CAMP_XRS_ALL.IL_CP_SVC_LIST_ID | IEO_CP_SVC_LISTS_ALL |
IEO_LIST_CAMP_XRS_ALL.LIST_NAME
IEO_LIST_CAMP_XRS_ALL.LIST_SRV_NAME IEO_LIST_CAMP_XRS_ALL.SREF_TYPE |
IEO_CP_SVC_LISTS_ALL |
IEO_CP_LIST_STATS_ALL.LIST_NAME
IEO_CP_LIST_STATS_ALL.LIST_SRV_NAME IEO_CP_LIST_STATS_ALL.SREF_TYPE |
IEO_CP_SVC_LISTS_ALL |
Calling lists supported by CP services
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SVC_LIST_ID | NUMBER | Y | Primary key column | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
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 | |
LIST_NAME | VARCHAR2 | (30) | Y | List name |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service in which this list is defined |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
CALENDAR_FILE | VARCHAR2 | (30) | Filename or other locator for list-specific calendar/scheduling file | |
CAL_ALG_TYPE | VARCHAR2 | (10) | Y | Always "SCHEDULE" |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
LIST_RELEASE_STR | VARCHAR2 | (1000) | Boolean logic that permits records to be released from this list | |
QUEUE_FIRST_ENTRY | NUMBER | (9) | Pointer to first record of this list in .QLD | |
QUEUE_LAST_ENTRY | NUMBER | (9) | Pointer to last record of this list in .QLD | |
QUEUE_SCORE | NUMBER | (9) | Total score for this list (applies only to Scoring release strategies) | |
QUEUE_SCORE_CNT | NUMBER | (9) | Count of entries contributing to QUEUE_SCORE (applies only to Scoring) | |
QUEUE_CODE | NUMBER | (9) | Unique numeric identifier for this list in this service | |
QUEUE_PRIORITY | NUMBER | (9) | Release priority for this list (1-100) | |
QUEUE_STATUS | VARCHAR2 | (5) | "N" = new, "D" = deleted, "X" = deletion in process, "Y" = other | |
QUEUE_TYPE | VARCHAR2 | (5) | "O" = always open | |
RELEASE_STRATEGY | NUMBER | (9) | 1 = Quantum, 2 = Quota, 3 = Avg Score, 4 = Total Score | |
RELEASE_ARRAY_CNT | NUMBER | (9) | Number of minutes' of release statistical data available (1-60) | |
RELEASE_STOP_FLAG | VARCHAR2 | (5) | Obsolete | |
REMAIN_QUOTA | NUMBER | (9) | Remaining quota in this time period (only applies to Quota release strategy) | |
RANDOMIZE_FLAG | VARCHAR2 | (5) | Obsolete | |
RECYCLE_METHOD | VARCHAR2 | (30) | Obsolete | |
SHORT_DESCRIPTION | VARCHAR2 | (30) | Obsolete | |
SORT_KEY | NUMBER | (9) | Obsolete | |
CREATE_DT_TM | DATE | Obsolete | ||
CALL_TYPE_CODE | NUMBER | (9) | Obsolete | |
CTRL_LENGTH | NUMBER | (9) | Length of LIST_RELEASE_STR | |
DIALING_METHOD | VARCHAR2 | (20) | Obsolete | |
STOP_DT_TM | DATE | Obsolete | ||
SELECTION_CRITERIA | VARCHAR2 | (1000) | Obsolete | |
SORT_ORDER_MAP | VARCHAR2 | (1000) | Obsolete | |
SELECTION_PRIORITY | NUMBER | (9) | Selection (load) priority for this list (1-32K) | |
SCORE_RESET | NUMBER | (9) | Base score reset value (applies only to Scoring) | |
SORT_FIELD | VARCHAR2 | (240) | Columns by which list is to be sorted | |
SELECT_STRING_LEN | NUMBER | (9) | Length of LIST_SELECT_STR | |
TOTAL_RECORDS | NUMBER | (9) | Count of records in this list | |
NUM_SORT_KEYS | NUMBER | (9) | Number of columns used for record sorting | |
ORIGIN_OF_LIST | VARCHAR2 | (30) | Obsolete | |
VIEW_LIST_Y_N | VARCHAR2 | (5) | Obsolete | |
AUTO_REFRESH | NUMBER | (9) | Obsolete | |
LONG_DESCRIPTION | VARCHAR2 | (1000) | Obsolete | |
LIST_SORT_ORDER | VARCHAR2 | (1000) | Obsolete | |
PRD_EXHAUST | NUMBER | (9) | Obsolete | |
QUANTUM | NUMBER | (9) | Quantum of records to be released during one timeslice for this list | |
QUOTA | NUMBER | (9) | Number of records permitted to be released from this list under Quota release strategy | |
QUOTA_RESET | NUMBER | (9) | Time interval after which quota is to be reset (in minutes) (applies only to Quota release strategy) | |
DEFLT_RECYCLE_LIST | VARCHAR2 | (32) | List to which records from this list should be recycled, absent more specific info | |
TIMESTAMP_FLAG | VARCHAR2 | (5) | "Y"(es) if timestamps on records in this list are to be honored | |
DIALING_TYPE | NUMBER | (9) | 5 = Preview, 45 = Predictive | |
DT_PRD_EXHAUST | DATE | Predicted exhaustion date/time of this list | ||
DIALING_OPTIONS | VARCHAR2 | (128) | Options string transmitted to Predictive along with any record from this list | |
EXHAUST_AVAIL_FLAG | VARCHAR2 | (5) | Release records from this list, regardless of timestamp, if no other lists have releasable records | |
LIST_SELECT_STR | VARCHAR2 | (1000) | Boolean logic that qualifies records for inclusion in this list | |
LIST_MGR_LIST_Y_N | VARCHAR2 | (5) | "Y"(es) if list is to be processed by Campaign Plus | |
LIST_STATUS | VARCHAR2 | (5) | "O"(pen) or "C"(losed) | |
LIST_TYPE | VARCHAR2 | (30) | Campaign to which this list belongs | |
INDEX_SLOTS | NUMBER | (9) | Obsolete | |
TIMESTAMP_ACTUAL | VARCHAR2 | (5) | "Y"(es) if list contains timestamped records | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_CP_SVC_LISTS_ALL does not reference any database object
IEO.IEO_CP_SVC_LISTS_ALL is referenced by following:
Description: | List and Campaign Cross Refreence Table |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_LIST_CAMP_XRS_ALL.REF_TYPE
IEO_LIST_CAMP_XRS_ALL.REF_NAME |
IEO_CAMPAIGNS_ALL |
IEO_LIST_CAMP_XRS_ALL.IL_CP_SVC_LIST_ID | IEO_CP_SVC_LISTS_ALL |
IEO_LIST_CAMP_XRS_ALL.LIST_NAME
IEO_LIST_CAMP_XRS_ALL.LIST_SRV_NAME IEO_LIST_CAMP_XRS_ALL.SREF_TYPE |
IEO_CP_SVC_LISTS_ALL |
List and Campaign cross reference table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_CAMP_XR_ID | NUMBER | (15) | Y | Primary key column |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service in which this list is defined |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
LIST_NAME | VARCHAR2 | (30) | Y | List name |
REF_NAME | VARCHAR2 | (30) | Y | Campaign name |
REF_TYPE | VARCHAR2 | (5) | Y | 'C' for campaigns and 'G' for list groups |
LIST_TYPE | VARCHAR2 | (30) | Obsolete | |
MEMBER_TYPE | VARCHAR2 | (1) | Obsolete | |
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 | |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
IL_CAMPAIGN_ID | NUMBER | (10) | Unused | |
IL_CP_SVC_LIST_ID | NUMBER | Unused | ||
IL_CP_SVC_LIST_ID2 | NUMBER | Unused | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_LIST_CAMP_XRS_ALL does not reference any database object
IEO.IEO_LIST_CAMP_XRS_ALL is referenced by following:
Description: | PBX configuration info |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_PBX_INFO.PRED_SRV_NAME
IEO_PBX_INFO.SREF_TYPE |
IEO_PREDSERVICES_ALL |
Foreign Key Column | Foreign Table |
---|---|
IEO_ACD_QUEUE_INFO.SREF_TYPE
IEO_ACD_QUEUE_INFO.PBX_NAME |
IEO_PBX_INFO |
IEO_VDU_INFO.SREF_TYPE
IEO_VDU_INFO.PBX_NAME |
IEO_PBX_INFO |
PBX configuration info
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PBX_INFO_ID | NUMBER | Y | PBX Identifier, Primary key column | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
CREATION_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO field |
LAST_UPDATE_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO field | |
SREF_TYPE | VARCHAR2 | (5) | Always 'S' | |
PBX_NAME | VARCHAR2 | (30) | Name of the PBX | |
PRED_SRV_NAME | VARCHAR2 | (30) | Predictive service using this PBX | |
PBX_TYPE | VARCHAR2 | (5) | Single character identifying the PBX manufacturer - well known values (eg. 'M' for Meridian) | |
REGISTRATION_FLAG | VARCHAR2 | (5) | Register using Virtual Name, Actual Name or Both | |
CTI_ENABLER | VARCHAR2 | (16) | CTI enabler used for accessing this PBX | |
CTI_ENABLED_Y_N | VARCHAR2 | (5) | Indicates whether this PBX is CTI enabled or not | |
ACTIVE_Y_N | VARCHAR2 | (5) | Indicates whether active or not | |
CTI_SERVER_NAME | VARCHAR2 | (30) | CTI server name | |
PHONE_PROF_NAME | VARCHAR2 | (30) | Phone profile name | |
CTI_NETWORK_NAME | VARCHAR2 | (16) | Network protocol used to talk with CTI server - ncacn_ip_tcp or ncadg_ip_udp | |
CMPLT_TRANS_FLAG | VARCHAR2 | (5) | Indicates how transfer completions are done - (eg. 'E' for event based, 'T' for time based) | |
CTI_INIT | VARCHAR2 | (5) | CTI needs Init | |
DEFAULT_Y_N | VARCHAR2 | (5) | Default PBX | |
LOC_CALL_DATA_FILE | VARCHAR2 | (128) | Location and name of the local call date file, used by predictive when using a PBX | |
ACD_QUEUE_FLAG | VARCHAR2 | (5) | Use ACD queue or not | |
SPEC_TRAN_FLAG1 | VARCHAR2 | (20) | Special transaction flag 1 | |
SPEC_TRAN_FLAG2 | VARCHAR2 | (20) | Special transaction flag 2 | |
SPEC_TRAN_FLAG3 | VARCHAR2 | (20) | Special transaction flag 3 | |
SPEC_TRAN_FLAG4 | VARCHAR2 | (20) | Special transaction flag 4 | |
TRANS_MIN_WT_TM | NUMBER | (9) | Transaction minimum wait time | |
TRANS_MAX_WT_TM | NUMBER | (9) | Transaction maximum wait time | |
ANS_TRANS_FLAG | VARCHAR2 | (5) | Answer flag | |
TRANS_ANSMIN_WT_TM | NUMBER | (9) | Answer minimum time | |
TRANS_ANSMAX_WT_TM | NUMBER | (9) | Answer maximum time | |
INIT_TRANS_WAIT | NUMBER | (9) | Transfer initiating wait time | |
DIALER_Q_DOWN_TM | NUMBER | (9) | dialer quiet down time | |
VOICE_DETECT_MODE | VARCHAR2 | (5) | voice detection mode | |
DIAL_DELAY_TIME | NUMBER | (9) | delay before placing a dial | |
ACTUAL_PBX_NAME | VARCHAR2 | (30) | The actual name of the PBX. Allows a single PBX to be shared among more than one service using the PBX_NAME column value | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_PBX_INFO does not reference any database object
IEO.IEO_PBX_INFO is referenced by following:
Description: | Configuration for Predictive services |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_PBX_INFO.PRED_SRV_NAME
IEO_PBX_INFO.SREF_TYPE |
IEO_PREDSERVICES_ALL |
Configuration for Predictive services
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREDSERVICE_ID | NUMBER | Y | Predictive Server Identifier | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
CREATION_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO field |
LAST_UPDATE_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO field | |
SREF_TYPE | VARCHAR2 | (5) | Always 'S' | |
PRED_SRV_NAME | VARCHAR2 | (30) | Y | Predictive server name |
ORG_ID | NUMBER | (15) | Y | multi-org support column |
HARDWARE_IMAGE | VARCHAR2 | (128) | hardware control dll name | |
IO_LOG_Y_N | VARCHAR2 | (5) | flag controls whether io events are logged or not | |
COUNTRY_CODE | VARCHAR2 | (5) | country code where the server is running | |
DIALER_CON_SHT | NUMBER | (9) | Number of consecutive dialer errors tolerated before the dialer is shutdown. | |
DIALER_TOTAL_ERR | NUMBER | (9) | Number of total dialer errors tolerated before dialer is shut down | |
EVENT_LOG_Y_N | VARCHAR2 | (100) | flag controls whether telephony events are logged or not | |
RECEIVE_DEADLINE | NUMBER | (9) | Receive Deadline | |
RESPONSE_DEADLINE | NUMBER | (9) | Response Deadline | |
AGENT_RPC_TIMEOUT | NUMBER | (9) | Maximum time period before an agent's get_id request times out. | |
RESTART_TIME | NUMBER | (9) | Restart Time | |
REGISTRATION_NAME | VARCHAR2 | (30) | An optional name for the server to regiser with, in DCE CDS | |
RPC_PROTOCOL | VARCHAR2 | (30) | transport protocol(s) to be used when exporting bindings to RPC | |
SERV_RPC_TIMEOUT | NUMBER | (9) | Maximum interval before the server's RPC's time out | |
VOICE_ASGN_TIMEOUT | NUMBER | (9) | Maximum interval before a call transfer times out | |
LOCALE | VARCHAR2 | (16) | Locale of the server | |
MIN_CTX_DOWN_TM | NUMBER | (9) | Minimum Context Down Time | |
VERSION | VARCHAR2 | (20) | Server version | |
THROTTLE | NUMBER | (9) | Used to control the predictive dialing | |
AREA_CODE | VARCHAR2 | (10) | Server area code | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_PREDSERVICES_ALL does not reference any database object
IEO.IEO_PREDSERVICES_ALL is referenced by following:
Description: | Server Components. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_COMPS.SERVER_ID | IEO_SVR_SERVERS |
IEO_SVR_COMPS.COMP_DEF_ID | IEO_SVR_COMP_DEFS |
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_PROTOCOL_MAP.COMP_ID | IEO_SVR_COMPS |
Server Components. This table is written to at run-time by the servers to publish components (object instances) that are available. This is the object publication mechanism.
No WHO columns here... this is run-time data used for publication mechanism.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_COMPS_U1 | UNIQUE | APPS_TS_TX_IDX | COMP_ID |
SYS_IL0000083862C00007$$ | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMP_ID | NUMBER | (15) | Y | UID for row. |
SERVER_ID | NUMBER | (15) | Y | FK to Server UID. |
COMP_DEF_ID | NUMBER | (15) | Y | FK to Component Definition UID. |
COMP_NAME | VARCHAR2 | (1996) | Y | Publication name of the object. |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
OBJECT_REF | BLOB | (4000) | Object reference |
IEO.IEO_SVR_COMPS does not reference any database object
IEO.IEO_SVR_COMPS is referenced by following:
Description: | Server Component Definitions. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_COMP_DEFS.SERVER_TYPE_ID | IEO_SVR_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_COMPS.COMP_DEF_ID | IEO_SVR_COMP_DEFS |
Server Component Definitions. This table is SEEDED to define the types of objects servers can publish. This acts as a simple interface repository.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_COMP_DEFS_U1 | UNIQUE | APPS_TS_SEED | COMP_DEF_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMP_DEF_ID | NUMBER | (15) | Y | UID of row. |
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. | |
SERVER_TYPE_ID | NUMBER | (15) | Y | FK to server type. |
COMP_DEF_NAME | VARCHAR2 | (1996) | Y | Component definition name. |
COMP_DEF_VERSION | NUMBER | (10) | Y | Component definintion version. |
IMPLEMENTATION | VARCHAR2 | (1996) | Y | Implmentation type. |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SVR_COMP_DEFS does not reference any database object
IEO.IEO_SVR_COMP_DEFS is referenced by following:
Description: | Server Groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_GROUPS.GROUP_GROUP_ID | IEO_SVR_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_GROUPS.GROUP_GROUP_ID | IEO_SVR_GROUPS |
IEO_SVR_SERVERS.MEMBER_SVR_GROUP_ID | IEO_SVR_GROUPS |
IEO_SVR_SERVERS.USING_SVR_GROUP_ID | IEO_SVR_GROUPS |
Server Groups group servers or other server groups. Server groups are used to associate users with a group of servers (i.e. in a call center) or to associate other entities in a similar manner.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_GROUPS_U1 | UNIQUE | APPS_TS_TX_IDX | SERVER_GROUP_ID |
IEO_SVR_GROUPS_U2 | UNIQUE | APPS_TS_TX_IDX | GROUP_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_GROUP_ID | NUMBER | (15) | Y | UID of a server group. |
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. | |
GROUP_NAME | VARCHAR2 | (256) | Y | User specified name of the server group. |
GROUP_GROUP_ID | NUMBER | (15) | Grouping of server groups. | |
LOCATION | VARCHAR2 | (500) | User specified location description. | |
DESCRIPTION | VARCHAR2 | (1996) | User specified description of group. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
VISIBLE | VARCHAR2 | (1) | visible |
IEO.IEO_SVR_GROUPS does not reference any database object
IEO.IEO_SVR_GROUPS is referenced by following:
Description: | Server Parameters. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_PARAMS.TYPE_ID | IEO_SVR_TYPES_B |
IEO_SVR_PARAMS.OBJECT_CODE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_VALUES.PARAM_ID | IEO_SVR_PARAMS |
Server Parameters identify parameters that can be associated with a particular type of server. This is technique provides the opportunity to have a more distributed way to administer server parameters, settings, etc.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_PARAMS_U1 | UNIQUE | APPS_TS_SEED | PARAM_ID |
IEO_SVR_PARAMS_U2 | UNIQUE | APPS_TS_SEED |
TYPE_ID
PARAM_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAM_ID | NUMBER | (15) | Y | UID of a parameter. |
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. | |
TYPE_ID | NUMBER | (15) | Y | FK to server type. |
PARAM_NAME | VARCHAR2 | (32) | Y | Name of the parameter. |
DATA_TYPE | VARCHAR2 | (32) | Type of data the parameter represents. | |
DATA_LENGTH | VARCHAR2 | (32) | Length of the data that the parameter represents. | |
LOOKUP_TYPE | VARCHAR2 | (30) | Optional FND_LOOKUP type. | |
OBJECT_CODE | VARCHAR2 | (30) | Optional JTF_OBJECT code. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
PARAM_CONFIG | VARCHAR2 | (256) | Config | |
LOOKUP_PROCEDURE | VARCHAR2 | (256) | Lookup Procedure |
IEO.IEO_SVR_PARAMS does not reference any database object
IEO.IEO_SVR_PARAMS is referenced by following:
Description: | Server Protocol Maps. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_PROTOCOL_MAP.COMP_ID | IEO_SVR_COMPS |
Server Protocol Maps identify protocols that are supported by certain components.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_PROTOCOL_MAP_U1 | UNIQUE | APPS_TS_TX_IDX |
COMP_ID
WIRE_PROTOCOL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMP_ID | NUMBER | (15) | Y | FK to component. |
WIRE_PROTOCOL | VARCHAR2 | (32) | Y | Protocol identifier. |
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. | |
PORT | NUMBER | (5) | Port protocol is registered on. (optional) | |
EXTRA | VARCHAR2 | (1996) | Extra Protocol Configuration or Options. (optional) | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SVR_PROTOCOL_MAP does not reference any database object
IEO.IEO_SVR_PROTOCOL_MAP is referenced by following:
Description: | Real time information about servers. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_RT_INFO.SERVER_ID | IEO_SVR_SERVERS |
Real-time information about servers is used for load-balancing, reconnection logic, etc. It includes server status (i.e., running or not), load factors, etc.
No WHO columns here... this is real-time data used only by the servers.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_RT_INFO_U1 | UNIQUE | APPS_TS_TX_IDX | SERVER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_ID | NUMBER | (15) | Y | FK to server. |
STATUS | NUMBER | (10) | Y | Status of server. (best effort) |
LAST_UPDATE_DATE | DATE | Y | When the information was last updated. (not a WHO column) | |
MAJOR_LOAD_FACTOR | NUMBER | (15) | Server interpretation of major load factor. | |
MINOR_LOAD_FACTOR | NUMBER | (15) | Server interpretation of minor factor. | |
EXTRA | VARCHAR2 | (1996) | Server interpretation of extra data. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
NODE_ID | NUMBER | (15) | Node Id |
IEO.IEO_SVR_RT_INFO does not reference any database object
IEO.IEO_SVR_RT_INFO is referenced by following:
Description: | Servers. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_SERVERS.MEMBER_SVR_GROUP_ID | IEO_SVR_GROUPS |
IEO_SVR_SERVERS.USING_SVR_GROUP_ID | IEO_SVR_GROUPS |
IEO_SVR_SERVERS.TYPE_ID | IEO_SVR_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_COMPS.SERVER_ID | IEO_SVR_SERVERS |
IEO_SVR_RT_INFO.SERVER_ID | IEO_SVR_SERVERS |
IEO_SVR_VALUES.SERVER_ID | IEO_SVR_SERVERS |
Servers identify an instance of a particular type of server, and can be associated with a server groups.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_SERVERS_U1 | UNIQUE | APPS_TS_TX_IDX | SERVER_ID |
IEO_SVR_SERVERS_U2 | NONUNIQUE | APPS_TS_TX_IDX | SERVER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_ID | NUMBER | (15) | Y | Unique ID for a server. |
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. | |
TYPE_ID | NUMBER | (15) | Y | FK to server type. |
SERVER_NAME | VARCHAR2 | (1996) | Y | Server instance name. |
MEMBER_SVR_GROUP_ID | NUMBER | (15) | Server group that this server is a member of. | |
USING_SVR_GROUP_ID | NUMBER | (15) | Server group that this server is using. | |
DNS_NAME | VARCHAR2 | (256) | Host name that identifies the server. | |
IP_ADDRESS | VARCHAR2 | (64) | IP address that identifies the server. | |
USER_ADDRESS | VARCHAR2 | (256) | User specified address (IP or DNS). | |
LOCATION | VARCHAR2 | (500) | User specified location description. | |
DESCRIPTION | VARCHAR2 | (1996) | User specified description of group. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SVR_SERVERS does not reference any database object
IEO.IEO_SVR_SERVERS is referenced by following:
Description: | Server Types (base table). |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_COMP_DEFS.SERVER_TYPE_ID | IEO_SVR_TYPES_B |
IEO_SVR_PARAMS.TYPE_ID | IEO_SVR_TYPES_B |
IEO_SVR_SERVERS.TYPE_ID | IEO_SVR_TYPES_B |
IEO_SVR_TYPES_TL.TYPE_ID | IEO_SVR_TYPES_B |
IEU_UWQ_SVR_MPS_PLUGINS.SVR_TYPE_ID | IEO_SVR_TYPES_B |
A server type classifies a particular type of server.
The base table contains the basic information about a server type entity.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_TYPES_B_U1 | UNIQUE | APPS_TS_SEED | TYPE_ID |
IEO_SVR_TYPES_B_U2 | UNIQUE | APPS_TS_SEED | TYPE_UUID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TYPE_ID | NUMBER | (15) | Y | UID of a type, for key linkage, faster referencing. |
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. | |
TYPE_UUID | VARCHAR2 | (40) | Y | UUID of a server, universally unique, identifying server. |
RT_REFRESH_RATE | NUMBER | (5) | Rate at which real-time data should be refreshed. | |
MAX_MAJOR_LOAD_FACTOR | NUMBER | (15) | Server interpretation of major load factor. | |
MAX_MINOR_LOAD_FACTOR | NUMBER | (15) | Server interpretation of minor factor. | |
IEO_SVR_TYPES | VARCHAR2 | (30) | Parameter lookup types. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. | ||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | Y | FK to FND_APPLICATION.APPLICATION_SHORT_NAME |
IEO.IEO_SVR_TYPES_B does not reference any database object
IEO.IEO_SVR_TYPES_B is referenced by following:
Description: | Server Types (translation table). |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_TYPES_TL.TYPE_ID | IEO_SVR_TYPES_B |
A server type classifies a particular type of server.
The translation table contains the translated information about a server type entity.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_TYPES_TL_U1 | UNIQUE | APPS_TS_SEED |
TYPE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TYPE_ID | NUMBER | (15) | Y | FK to base table TYPE_ID. |
LANGUAGE | VARCHAR2 | (4) | Y | Standard columns for _TL table. |
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. | |
TYPE_NAME | VARCHAR2 | (1996) | Y | User displayable server type. |
SOURCE_LANG | VARCHAR2 | (4) | Standard columns for _TL table. | |
TYPE_DESCRIPTION | VARCHAR2 | (1996) | Server type description. (optional) | |
TYPE_EXTRA | VARCHAR2 | (1996) | Extra information about this type of server. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SVR_TYPES_TL does not reference any database object
IEO.IEO_SVR_TYPES_TL is referenced by following:
Description: | Server Values. |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SVR_VALUES.SERVER_ID | IEO_SVR_SERVERS |
IEO_SVR_VALUES.PARAM_ID | IEO_SVR_PARAMS |
Server Values contains the actual values for a particular instance of a server. The parameters identify thepossible set of parameters for a particular server type, and the values represent the values of those parameters for a particular instnce of a server.
Index | Type | Tablespace | Column |
---|---|---|---|
IEO_SVR_VALUES_U1 | UNIQUE | APPS_TS_TX_IDX | VALUE_ID |
IEO_SVR_VALUES_U2 | UNIQUE | APPS_TS_TX_IDX |
VALUE_INDEX
PARAM_ID SERVER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE_ID | NUMBER | (15) | Y | UID of a value. |
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. | |
VALUE_INDEX | NUMBER | (3) | Y | Used for params that can have list (i.e., strings). |
PARAM_ID | NUMBER | (15) | Y | FK to param which the value belongs to. |
SERVER_ID | NUMBER | (15) | Y | FK to server the value belongs to. |
VALUE | VARCHAR2 | (1996) | Value of parameter. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SVR_VALUES does not reference any database object
IEO.IEO_SVR_VALUES is referenced by following:
Description: | Centralized Gateway to IEO_CAMPAIGNS_ALL, which may be distributed |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SYSTEM_CAMPS_ALL.LIST_SRV_NAME
IEO_SYSTEM_CAMPS_ALL.SREF_TYPE |
IEO_SYST_CP_SVCS_ALL |
ISSUE
=====
All Campaign tables will have to replaced by marketing campaign tables
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_CAMP_ID | NUMBER | Y | Primary key column | |
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 | |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service name |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
ORG_ID | NUMBER | (15) | Y | Multi org support column |
PHYSICAL_DB | VARCHAR2 | (20) | ODBC DSN for campaign database | |
ODBC_DSN_NAME | VARCHAR2 | (60) | Not used | |
REF_TYPE | VARCHAR2 | (5) | "G" = list group, "C" = campaign | |
REF_NAME | VARCHAR2 | (30) | Campaign name | |
SHORT_DESCRIPTION | VARCHAR2 | (30) | Description of this campaign | |
PRDTY_SRV_NAME | VARCHAR2 | (30) | Not used | |
LIST_MANAGER_Y_N | VARCHAR2 | (5) | "Y" if this campaign is to be serviced by Campaign Plus | |
ACTIVE_Y_N | VARCHAR2 | (5) | Indicates whether the campaign is active or not | |
PRIORITY_NUMBER | VARCHAR2 | (9) | Not used | |
VERSA_ENABLED_Y_N | VARCHAR2 | (5) | "Y" if this campaign is known to VTT/OTB | |
PRED_ABDN_LIMIT | VARCHAR2 | (30) | Not used | |
VERSION | VARCHAR2 | (20) | Not used | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SYSTEM_CAMPS_ALL does not reference any database object
IEO.IEO_SYSTEM_CAMPS_ALL is referenced by following:
Description: | Centralized gateway to IEO_LIST_SERVICES which may be distributed |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_SYSTEM_CAMPS_ALL.LIST_SRV_NAME
IEO_SYSTEM_CAMPS_ALL.SREF_TYPE |
IEO_SYST_CP_SVCS_ALL |
Centralized gateway to IEO_LIST_SERVICES which may be distributed
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYST_CP_SVC_ID | NUMBER | Y | Primary key column | |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
CREATION_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO field |
LAST_UPDATE_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO field | |
SREF_TYPE | VARCHAR2 | (5) | Y | "S" |
LIST_SRV_NAME | VARCHAR2 | (30) | Y | List service name |
ORG_ID | NUMBER | (15) | Y | Multi-org support |
CBS_SRV_NAME | VARCHAR2 | (30) | Obsolete | |
PRED_SRV_NAME | VARCHAR2 | (30) | Predictive service name associated with this Campaign Plus service | |
VERSION | VARCHAR2 | (20) | Software version compatibility specifier | |
PHYSICAL_DB | VARCHAR2 | (20) | Database identifier for campaign database | |
DB_PASSWORD | VARCHAR2 | (60) | Authorization info for PHYSICAL_DB | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_SYST_CP_SVCS_ALL does not reference any database object
IEO.IEO_SYST_CP_SVCS_ALL is referenced by following:
Description: | VDU configuration info |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_VDU_INFO.SREF_TYPE
IEO_VDU_INFO.PBX_NAME |
IEO_PBX_INFO |
VDU configuration info
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VDU_INFO_ID | NUMBER | (15) | Y | VDU Identifier, Primary key |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
CREATION_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO field |
LAST_UPDATE_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO field | |
PBX_NAME | VARCHAR2 | (30) | Y | PBX this VDU belongs to |
SREF_TYPE | VARCHAR2 | (5) | Y | Always 'S' |
VDU_NAME | VARCHAR2 | (30) | Name of the VDU | |
DIALER_PORT | VARCHAR2 | (30) | Dialer port for this VDU | |
DIAL_PROFILE_NAME | VARCHAR2 | (30) | Dial profile name | |
DIALER_STATUS | VARCHAR2 | (5) | Availability status of the VDU | |
DIALER_TYPE | VARCHAR2 | (5) | Dialer Type | |
EXTENSION | VARCHAR2 | (12) | VDU extension number | |
EXT_QUALIFIER | VARCHAR2 | (12) | Switch specific enabler qualifier | |
IO_TRACE_FLAG | VARCHAR2 | (5) | Turns vdu's io tracing on or off | |
ACTUAL_PBX_NAME | VARCHAR2 | (30) | The actual name of the PBX. Allows a single PBX to be shared among more than one service using the PBX_NAME column value | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_VDU_INFO does not reference any database object
IEO.IEO_VDU_INFO is referenced by following:
Description: | Currently-defined voice messages available to be played to callee |
---|
Foreign Key Column | Foreign Table |
---|---|
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_ANS_MACHINE | IEO_VOICE_MSGS_ALL |
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_FRONT_HOLD | IEO_VOICE_MSGS_ALL |
Currently defined voice messages available to be played to callee
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VOICE_MSG_ID | NUMBER | (10) | Y | Unique ID identifying the message |
CREATED_BY | NUMBER | (15) | Y | Standard WHO field |
CREATION_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO field |
LAST_UPDATE_DATE | DATE | Y | Standard WHO field | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO field | |
ORG_ID | NUMBER | (15) | Y | Multi org support column |
MESSAGETITLE | VARCHAR2 | (32) | Title for this message | |
FULLFILENAME | VARCHAR2 | (128) | Complete path and file name containing the message | |
HOSTNAME | VARCHAR2 | (64) | Machine where the message file is stored | |
RECORDMODE | NUMBER | (5) | Indicates whether message is in record mode or not | |
PLAYMODE | NUMBER | (5) | Indicates whether message is in play mode or not | |
ACTIVE | NUMBER | (1) | Indicates whether message is active or not | |
INACTIVEREASON | VARCHAR2 | (128) | Indicates the reason if message is inactive | |
SPEAKER | VARCHAR2 | (32) | Name of the person who recorded the message | |
DESCRIPTION | VARCHAR2 | (128) | Description of the message | |
PREDICTIVESERVER | VARCHAR2 | (30) | Predictive server using this message | |
MESSAGEID | NUMBER | (10) | Message ID | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
IEO.IEO_VOICE_MSGS_ALL does not reference any database object
IEO.IEO_VOICE_MSGS_ALL is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Y | QuickCode Lookup Type |
LOOKUP_CODE | VARCHAR2 | (30) | Y | QuickCode Code |
MEANING | VARCHAR2 | (80) | Y | Description of the Quickcode |
DESCRIPTION | VARCHAR2 | (240) | Defines in detail the meaning of a Quickcode | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | This is used to enable or disable a Quickcode |
START_DATE_ACTIVE | DATE | Date to activate the Quickcode | ||
END_DATE_ACTIVE | DATE | Date to inactivate the Quickcode |
APPS.IEO_LOOKUPS is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
This view represents translated server types, and is used to display the server type LOV in the server locator form.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Uniquely identifies a row. | |
TYPE_ID | NUMBER | (15) | Y | FK to the server type id. |
CREATED_BY | NUMBER | (15) | Y | Standard WHO columns. |
CREATION_DATE | DATE | Y | Standard WHO columns. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard WHO columns. |
LAST_UPDATE_DATE | DATE | Y | Standard WHO columns. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns. | |
TYPE_UUID | VARCHAR2 | (40) | Y | The UUID of the server type. |
RT_REFRESH_RATE | NUMBER | (5) | How often servers of this type refresh thier status. | |
MAX_MAJOR_LOAD_FACTOR | NUMBER | (15) | Maximum major load factor this server can support. | |
MAX_MINOR_LOAD_FACTOR | NUMBER | (15) | Maximum minor load factor this server can support. | |
IEO_SVR_TYPES | VARCHAR2 | (30) | Parameter lookup types (for LOVs). | |
TYPE_NAME | VARCHAR2 | (1996) | Y | User displayable server type name. |
TYPE_DESCRIPTION | VARCHAR2 | (1996) | User displayable server type description. | |
TYPE_EXTRA | VARCHAR2 | (1996) | User displayable server type extra information. |
APPS.IEO_SVR_TYPES_VL is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |