PSSERVICE_VW

index back

IB services view.


SELECT DISTINCT B.IB_SERVICENAME , A.IB_OPERATIONNAME , A.RTNGTYPE , A.DEFAULTVER , A.IB_ALIASNAME , A.DESCR FROM PSSERVICEOPR B , PSOPERATION A WHERE B.IB_OPERATIONNAME = A.IB_OPERATIONNAME

  • Related language record: PSSERVICE_LVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
    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
    DEFAULTVERCharacter(30)VARCHAR2(30) NOT NULLDefault Application Message Version
    IB_ALIASNAMECharacter(128)VARCHAR2(128) NOT NULLService Alias
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19