PSOPRVERDFN_VW

(SQL View)
 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 AND P.PTIBAPPLNAME = ' '

  • Related Language Record: PSOPRVERDFNL_VW

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

    Default Value: 1

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

    Default Value: A

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

    9 IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
    10 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.
    11 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.
    12 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    13 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 DESCRLONG Long Character CLOB Long Description
    16 IB_VALID_LEVEL Number(1,0) SMALLINT NOT NULL Validation Level