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 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
    IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default: A

    NR_FLAG Character(1) VARCHAR2(1) NOT NULL Non-Repudiation

    Y/N Table Edit

    Default: N

    IB_VALIDATION Character(1) VARCHAR2(1) NOT NULL Runtime Schema Validation

    Y/N Table Edit

    CLIENTIMPLEMENT Character(1) VARCHAR2(1) NOT NULL Local Implementation

    Y/N Table Edit

    Default: N

    IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    IB_VALID_LEVEL Number(1,0) SMALLINT NOT NULL Validation Level
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20