PSIBWSDLOPRVW

(SQL View)
 Index Back

IB WSDL.


SELECT A.IB_SERVICENAME , D.IB_OPERATIONNAME , C.VERSIONNAME , B.IB_ALIASNAME , B.RTNGTYPE , B.DESCR FROM PSSERVICE A , PSSERVICEOPR D , PSOPERATION B , PSOPRVERDFN C WHERE A.IB_SERVICENAME = D.IB_SERVICENAME AND D.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.DEFAULTVER = C.VERSIONNAME AND C.IB_EXPORTSTATUS='E' AND A.IB_REST_SERVICE = 0

  • Related Language Record: PSIBWSDLOPR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    2 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    3 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    4 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description