PSOPRVERDFN_VW

index back

IB Service Versions

Joins Service Operations with Service Operation Versions.
SELECT V.IB_OPERATIONNAME , V.VERSIONNAME , A.IB_SERVICENAME , V.VERSION , V.ACTIVE_FLAG , V.NR_FLAG , V.IB_VALIDATION , V.CLIENTIMPLEMENT , V.IBDOCLAYOUTNAME , V.LASTUPDDTTM , V.LASTUPDOPRID , V.OBJECTOWNERID , P.DEFAULTVER , V.DESCR , V.DESCRLONG , V.IB_VALID_LEVEL FROM PSSERVICEOPR A , PSOPERATION P , PSOPRVERDFN V WHERE A.IB_OPERATIONNAME = P.IB_OPERATIONNAME AND P.IB_OPERATIONNAME = V.IB_OPERATIONNAME

  • Related language record: PSOPRVERDFNL_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
    VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
    IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive

    Default: A

    NR_FLAGCharacter(1)VARCHAR2(1) NOT NULLNon-Repudiation

    Y/N Table Edit

    Default: N

    IB_VALIDATIONCharacter(1)VARCHAR2(1) NOT NULLRuntime Schema Validation

    Y/N Table Edit

    CLIENTIMPLEMENTCharacter(1)VARCHAR2(1) NOT NULLLocal Implementation

    Y/N Table Edit

    Default: N

    IBDOCLAYOUTNAMECharacter(20)VARCHAR2(20) NOT NULLLayout Name (see PSDOCLODEFN).
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    DEFAULTVERCharacter(30)VARCHAR2(30) NOT NULLDefault Application Message Version
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    IB_VALID_LEVELNumber(1,0)SMALLINT NOT NULLValidation Level
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19