PSIBANYOPERM_VW

index back

IB Routing View

Selects IB routing parameter rows for ANY to Local routings that have a transform program defined and are tied to service operations that have WSDL exposed. Used to determine if a message should be read-only.
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 , PSOPRVERDFN D WHERE R.ROUTINGDEFNNAME = P.ROUTINGDEFNNAME AND R.EFFDT = P.EFFDT AND R.SENDERNODENAME = '~~ANY~~' AND P.XFRMNAME <> ' ' AND R.IB_OPERATIONNAME = D.IB_OPERATIONNAME AND R.VERSIONNAME = D.VERSIONNAME AND D.IB_EXPORTSTATUS <> 'N'

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