[Home] [Help] [Dependency Information]
Object Name: | IEO_PBX_INFO |
---|---|
Object Type: | TABLE |
Owner: | IEO |
FND Design Data: | IEO.IEO_PBX_INFO |
Subobject Name: | |
Status: | VALID |
PBX configuration info
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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;
IEO.IEO_PBX_INFO does not reference any database object
IEO.IEO_PBX_INFO is referenced by following:
|
|
|