PSOPTPRBTYPE

 index back

Optimization Problem Types

This table stores the optimization applications installed in a database. Each optimization application is identified by a problem type.

  • Related language record: PSOPTPRBTYPELNG

    • PeopleSoft Field Name Field Type Column Type Description
    PROBTYPE Character(20) VARCHAR2(20) NOT NULL Optimization Problem Type

    Default: PSOPTPRBTYPE.PROBTYPE

    Prompt Table: PSOPTPRBTYPE
    Set Control Field: PROBTYPE

    DLLNAME Character(30) VARCHAR2(30) NOT NULL DLL Name
    DLLVERSION Character(10) VARCHAR2(10) NOT NULL Version of the plugin DLL.
    MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
    APPPKGPATH Character(92) VARCHAR2(92) NOT NULL Application Package Full PATH
    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    APPPKGPATH2 Character(92) VARCHAR2(92) NOT NULL Application Package Full PATH
    APPCLASSID2 Character(30) VARCHAR2(30) NOT NULL Application Class ID
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL 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.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20