PSOPERATION_VW

(SQL View)
 Index Back

IB Non-default versions.

View of non-default service operation versions currently defined in the IB system.

SELECT A.IB_OPERATIONNAME , A.VERSIONNAME , A.ACTIVE_FLAG , A.DESCR FROM PSOPRVERDFN A WHERE A.VERSIONNAME NOT IN ( SELECT B.DEFAULTVER FROM PSOPERATION B WHERE B.IB_OPERATIONNAME = A.IB_OPERATIONNAME)

  • Related Language Record: PSOPERATION_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    3 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description