PSIBANYOPERM_VW

(SQL View)
 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 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