PSIBANYRTNGP_VW

index back

IB Routing View

Selects IB routing parameter rows for ANY to Local routings that are active and have a transform program defined. Used for WSDL generation.
SELECT R.ROUTINGDEFNNAME , R.EFFDT , P.PARAMETERNAME , R.RECEIVERNODENAME , R.RTNGTYPE , R.IB_OPERATIONNAME , R.VERSIONNAME , P.XFRMNAME , P.INMSGNAME , P.INMSGVERSION , P.OUTMSGNAME , P.OUTMSGVERSION , P.ALIASNAME FROM PSIBRTNGDEFN R , PSRTNGDFNPARM P WHERE R.ROUTINGDEFNNAME = P.ROUTINGDEFNNAME AND R.EFFDT = P.EFFDT AND R.SENDERNODENAME = '~~ANY~~' AND P.XFRMNAME <> ' '

PeopleSoft Field NameField TypeColumn TypeDescription
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
EFFDTDate(10)DATEEffective Date

Default: %date

PARAMETERNAMECharacter(15)VARCHAR2(15) NOT NULLParameter Name
RECEIVERNODENAMECharacter(30)VARCHAR2(30) NOT NULLReceiver Node Name
RTNGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
A=Asynchronous - One Way
N=Synchronous Non-Blocking
R=Asynch Request/Response
S=Synchronous
X=Asynch to Synch
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
XFRMNAMECharacter(30)VARCHAR2(30) NOT NULLTransform Program 1
INMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
INMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLIn Message Version
OUTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
OUTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLOut Message Version
ALIASNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Alias
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19