PSSERVICEOPR_VW

(SQL View)
 Index Back

IB service operations view.


SELECT D.IB_SERVICENAME , B.IB_OPERATIONNAME , B.VERSIONNAME , A.RTNGTYPE , B.DESCR , B.ACTIVE_FLAG , C.PARAMETERNAME , C.MSGNAME , C.IB_MSGVERSION , A.IB_ALIASNAME , A.IB_RESTMETHOD FROM PSSERVICEOPR D , PSOPERATION A , PSOPRVERDFN B , PSOPRVERDFNPARM C WHERE D.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.VERSIONNAME = C.VERSIONNAME

  • Related Language Record: PSSERVICEOP_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 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
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive
    7 PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
    8 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
    9 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    10 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    11 IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method