IB_UG_NODE_TRX

index back

Node Transactions for Upgrade

Node transactions for IB Upgrade.

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)DATEEffective 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

NODE_TYPECharacter(4)VARCHAR2(4) NOT NULLNode Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
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

LOGMSGDTLFLGNumber(1,0)SMALLINT NOT NULLLog Message Detail?
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

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19