PSIBRTNGDEFN_VW

index back

IB Routings


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

PeopleSoft Field NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
SENDERNODENAMECharacter(30)VARCHAR2(30) NOT NULLSender Node Name
RECEIVERNODENAMECharacter(30)VARCHAR2(30) NOT NULLReceiver Node Name
RTNGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
A=Asynchronous - One Way
N=Synchronous Non-Blocking
R=Asynch Request/Response
S=Synchronous
X=Asynch to Synch
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
EFFDTDate(10)DATEEffective Date
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19