ROUTINGDEFNNAMEEFFDTDefault: %date
PARAMETERNAMEA=Asynchronous - One Way
N=Synchronous Non-Blocking
R=Asynch Request/Response
S=Synchronous
X=Asynch to Synch
PSIBANYRTNGP_VW |
index back |
|---|---|
IB Routing View |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |