| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 ROUTINGDEFNNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Routing Name
|
| EFFDT |
Date(10) |
DATE |
Effective Date
Default: %date
|
| VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default: A
|
| SENDERNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Sender Node Name
Prompt Table:
PSMSGNODEDEFN
|
| RECEIVERNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiver Node Name
Prompt Table:
PSMSGNODEDEFN
|
| RTNGTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Routing Type
A=Asynchronous - One Way
N=Synchronous Non-Blocking
R=Asynch Request/Response
S=Synchronous
X=Asynch to Synch
|
| IB_DELAYPROCESSING |
Number(6,0) |
INTEGER NOT NULL |
Delay Processing
|
| IB_RESTMETHOD |
Character(10) |
VARCHAR2(10) NOT NULL |
REST Method
|
| IB_SYNCHNONBLOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
User Exception
Y/N Table Edit
Default: N
|
| IB_ACCEPT_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Compression
Y/N Table Edit
Default: N
|
| IB_SCHEMA_DETAILS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schema Validation Details
Y/N Table Edit
Default: N
|
| IB_UNORDER_SEGMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unorder Segments
N=No
Y=Yes
|
| IB_OPERATIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table:
PSOPERATION
|
| VERSIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operation Version
Prompt Table:
PSOPRVERDFN
|
| CONNOVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Connector
Y/N Table Edit
Default: N
|
| CONNGATEWAYID |
Character(30) |
VARCHAR2(30) NOT NULL |
Integration Broker Connector Gateway ID
URL alias to accomodate 30 char managed object key limit
Prompt Table:
PSGATEWAY
|
| CONNID |
Character(30) |
VARCHAR2(30) NOT NULL |
Integration Server Connector ID
Prompt Table:
PSCONN
|
| LOGMSGDTLFLG |
Number(1,0) |
SMALLINT NOT NULL |
Log Message Detail?
Default: 0
|
| IB_DELIVERYMODE |
Number(5,0) |
INTEGER NOT NULL |
Delivery Mode
|
| ONSNDHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnSend Handler
Prompt Table:
PSSRVHDLRSND_VW
|
| ONRCVHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnReceive Handler
Prompt Table:
PSSRVHDLRRCV_VW
|
| ONPREHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnPreNotify Handler
Prompt Table:
PSSRVHDLRPRN_VW
|
| ONPOSTHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnPostNotify Handler
Prompt Table:
PSSRVHDLRPTN_VW
|
| GENERATED |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated
Y/N Table Edit
Default: N
|
| IB_ARR_SECURE_EP |
Character(1) |
VARCHAR2(1) NOT NULL |
ARR Secure EndPoint
|
| IB_LOCALIDFLG |
Number(1,0) |
SMALLINT NOT NULL |
Local Node Validation Flag
|
| LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
translate values
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| DESCRLONG |
Long Character |
CLOB |
Long Description
|