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 Name Field Type Column Type Description
    IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19