Skip to content

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

TABLE: IEO.IEO_PBX_INFO

Object Details
Object Name: IEO_PBX_INFO
Object Type: TABLE
Owner: IEO
FND Design Data: TableIEO.IEO_PBX_INFO
Subobject Name:
Status: VALID


PBX configuration info


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PBX_INFO_ID NUMBER
Yes PBX Identifier, Primary key column
CREATED_BY NUMBER (15) Yes Standard WHO field
CREATION_DATE DATE
Yes Standard WHO field
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO field
LAST_UPDATE_DATE DATE
Yes 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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PBX_INFO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SREF_TYPE
,      PBX_NAME
,      PRED_SRV_NAME
,      PBX_TYPE
,      REGISTRATION_FLAG
,      CTI_ENABLER
,      CTI_ENABLED_Y_N
,      ACTIVE_Y_N
,      CTI_SERVER_NAME
,      PHONE_PROF_NAME
,      CTI_NETWORK_NAME
,      CMPLT_TRANS_FLAG
,      CTI_INIT
,      DEFAULT_Y_N
,      LOC_CALL_DATA_FILE
,      ACD_QUEUE_FLAG
,      SPEC_TRAN_FLAG1
,      SPEC_TRAN_FLAG2
,      SPEC_TRAN_FLAG3
,      SPEC_TRAN_FLAG4
,      TRANS_MIN_WT_TM
,      TRANS_MAX_WT_TM
,      ANS_TRANS_FLAG
,      TRANS_ANSMIN_WT_TM
,      TRANS_ANSMAX_WT_TM
,      INIT_TRANS_WAIT
,      DIALER_Q_DOWN_TM
,      VOICE_DETECT_MODE
,      DIAL_DELAY_TIME
,      ACTUAL_PBX_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_PBX_INFO;

Dependencies

[top of page]

IEO.IEO_PBX_INFO does not reference any database object

IEO.IEO_PBX_INFO is referenced by following:

SchemaAPPS
SynonymIEO_PBX_INFO