PSIBANYRTNGP_VW

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

Default Value: %date

3 PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
4 RECEIVERNODENAME Character(30) VARCHAR2(30) NOT NULL Receiver Node Name
5 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
6 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
7 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
8 XFRMNAME Character(30) VARCHAR2(30) NOT NULL Transform Program 1
9 INMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
10 INMSGVERSION Character(30) VARCHAR2(30) NOT NULL In Message Version
11 OUTMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
12 OUTMSGVERSION Character(30) VARCHAR2(30) NOT NULL Out Message Version
13 ALIASNAME Character(254) VARCHAR2(254) NOT NULL External Alias