PSIBRTNGSERV_VW

index back

IB Service Routings

Lists routings tied to IB services.
SELECT DISTINCT S.IB_SERVICENAME , P.IB_OPERATIONNAME , R.ROUTINGDEFNNAME , S.IB_PSOFTSERVICE FROM PSSERVICE S , PSSERVICEOPR B , PSOPERATION P , PSIBRTNGDEFN R WHERE S.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_OPERATIONNAME = P.IB_OPERATIONNAME AND P.IB_OPERATIONNAME = R.IB_OPERATIONNAME

PeopleSoft Field NameField TypeColumn TypeDescription
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
IB_PSOFTSERVICECharacter(1)VARCHAR2(1) NOT NULLRestricted Service
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19