PSNODETRX

index back

Node Transaction Definition

Integration Server Business Entity Transaction Definition

PeopleSoft Field NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PSMSGNODEDEFN

EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Default: IA

RQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSMSGDEFNVW1

RQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Request Message Version

Prompt Table: PSRQSTMSGVERVW

VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
EXTRQSTMSGNAMECharacter(254)VARCHAR2(254) NOT NULLIntegration Server External Request Message Name
RESPMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Response Message Name

Prompt Table: PSMSGDEFNVW1

RESPMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Response Message Version

Prompt Table: PSRESPMSGVERVW

EXTRESPMSGNAMECharacter(254)VARCHAR2(254) NOT NULLIntegration Server External Response Message Name
ROUTINGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
E=Explicit
I=Implicit
CONNOVERRIDECharacter(1)VARCHAR2(1) NOT NULLOverride Connector

Y/N Table Edit

Default: N

CONNGATEWAYIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit

Prompt Table: PSGATEWAY

CONNIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Connector ID

Prompt Table: PSCONNIDVW

LOGMSGDTLFLGNumber(1,0)SMALLINT NOT NULLLog Message Detail?

Default: 2

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
COMMENTSLong CharacterCLOBComment
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19