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