| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ROUTINGDEFNNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Routing Name
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SENDERNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Sender Node Name
Prompt Table:
PSMSGNODEDEFN
|
| 6 |
RECEIVERNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Receiver Node Name
Prompt Table:
PSMSGNODEDEFN
|
| 7 |
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
|
| 8 |
IB_DELAYPROCESSING |
Number(6,0) |
INTEGER NOT NULL |
Delay Processing
|
| 9 |
IB_RESTMETHOD |
Character(10) |
VARCHAR2(10) NOT NULL |
REST Method
|
| 10 |
IB_SYNCHNONBLOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
User Exception
Y/N Table Edit
Default Value: N
|
| 11 |
IB_ACCEPT_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept Compression
Y/N Table Edit
Default Value: N
|
| 12 |
IB_SCHEMA_DETAILS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schema Validation Details
Y/N Table Edit
Default Value: N
|
| 13 |
IB_UNORDER_SEGMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unorder Segments
N=No
Y=Yes
|
| 14 |
IB_OPERATIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table:
PSOPERATION
|
| 15 |
VERSIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operation Version
Prompt Table:
PSOPRVERDFN
|
| 16 |
CONNOVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Connector
Y/N Table Edit
Default Value: N
|
| 17 |
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
|
| 18 |
CONNID |
Character(30) |
VARCHAR2(30) NOT NULL |
Integration Server Connector ID
Prompt Table:
PSCONN
|
| 19 |
LOGMSGDTLFLG |
Number(1,0) |
SMALLINT NOT NULL |
Log Message Detail?
Default Value: 0
|
| 20 |
IB_DELIVERYMODE |
Number(5,0) |
INTEGER NOT NULL |
Delivery Mode
|
| 21 |
ONSNDHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnSend Handler
Prompt Table:
PSSRVHDLRSND_VW
|
| 22 |
ONRCVHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnReceive Handler
Prompt Table:
PSSRVHDLRRCV_VW
|
| 23 |
ONPREHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnPreNotify Handler
Prompt Table:
PSSRVHDLRPRN_VW
|
| 24 |
ONPOSTHDLRNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
OnPostNotify Handler
Prompt Table:
PSSRVHDLRPTN_VW
|
| 25 |
GENERATED |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated
Y/N Table Edit
Default Value: N
|
| 26 |
IB_ARR_SECURE_EP |
Character(1) |
VARCHAR2(1) NOT NULL |
ARR Secure EndPoint
|
| 27 |
IB_LOCALIDFLG |
Number(1,0) |
SMALLINT NOT NULL |
Local Node Validation Flag
|
| 28 |
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.
|
| 29 |
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.
|
| 30 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 31 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 32 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|