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 Name Field Type Column Type Description
ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
EFFDT Date(10) DATE Effective Date

Default: %date

PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
RECEIVERNODENAME Character(30) VARCHAR2(30) NOT NULL Receiver Node Name
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
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
XFRMNAME Character(30) VARCHAR2(30) NOT NULL Transform Program 1
INMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
INMSGVERSION Character(30) VARCHAR2(30) NOT NULL In Message Version
OUTMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
OUTMSGVERSION Character(30) VARCHAR2(30) NOT NULL Out Message Version
ALIASNAME Character(254) VARCHAR2(254) NOT NULL External Alias
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19