PSOPRVERDFN

(SQL Table)
Index Back

IB Service Versions

  • Related Language Record: PSOPRVERDFNLANG
  • # 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 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 1

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

    Default Value: A

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    7 IB_VALID_LEVEL Number(1,0) SMALLINT NOT NULL Validation Level
    8 IB_SYNCHNONBLOCK Character(1) VARCHAR2(1) NOT NULL User Exception

    Y/N Table Edit

    Default Value: N

    9 IB_EXPORTSTATUS Character(1) VARCHAR2(1) NOT NULL Export Status
    C=Changed After Export
    E=Exported
    N=Not Exported

    Default Value: N

    10 IB_MULTIQUEUE Character(1) VARCHAR2(1) NOT NULL Enable Multi-queue
    11 IB_EXCLUDE_TOKEN Character(1) VARCHAR2(1) NOT NULL Exclude PSFT Auth Token

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    13 IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
    14 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.
    15 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.
    16 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 DESCRLONG Long Character CLOB Long Description