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 NameField TypeColumn TypeDescription
    PROBTYPECharacter(20)VARCHAR2(20) NOT NULLOptimization Problem Type

    Default: PSOPTPRBTYPE.PROBTYPE

    Prompt Table: PSOPTPRBTYPE
    Set Control Field: PROBTYPE

    DLLNAMECharacter(30)VARCHAR2(30) NOT NULLDLL Name
    DLLVERSIONCharacter(10)VARCHAR2(10) NOT NULLVersion of the plugin DLL.
    MSGSETNumber(5,0)INTEGER NOT NULLMessage Set Number
    APPPKGPATHCharacter(92)VARCHAR2(92) NOT NULLApplication Package Full PATH
    APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    APPPKGPATH2Character(92)VARCHAR2(92) NOT NULLApplication Package Full PATH
    APPCLASSID2Character(30)VARCHAR2(30) NOT NULLApplication Class ID
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    LASTUPDDTTMDateTime(26)TIMESTAMP NOT NULLSpecifies 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.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19