PSSERVICE2_VW

(SQL View)
 Index Back

IB service view.


SELECT DISTINCT D.IB_SERVICENAME , A.IB_OPERATIONNAME , A.RTNGTYPE , A.DEFAULTVER , A.DESCR , B.VERSIONNAME , B.ACTIVE_FLAG FROM PSOPERATION A , PSSERVICEOPR D , PSOPRVERDFN B WHERE A.IB_OPERATIONNAME = D.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.PTIBAPPLNAME = ' '

  • Related Language Record: PSSERVICE2_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 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
    4 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    7 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive