PSOPERATION_VW

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 NameField TypeColumn TypeDescription
    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
    VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive
    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