PSIBRTNGDEFN_VW

(SQL View)
Index Back

IB Routings


SELECT IB_OPERATIONNAME , VERSIONNAME , SENDERNODENAME , RECEIVERNODENAME , RTNGTYPE , ROUTINGDEFNNAME , EFFDT , EFF_STATUS FROM PSIBRTNGDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
3 SENDERNODENAME Character(30) VARCHAR2(30) NOT NULL Sender Node 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 ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
7 EFFDT Date(10) DATE Effective Date
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive