PSOPTPRBTYPE (SQL Table)	Index Back
Optimization Problem Types This table stores the optimization applications installed in a database. Each optimization application is identified by a problem type.

PSOPTPRBTYPE

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

1 PROBTYPE Character(20) VARCHAR2(20) NOT NULL Optimization Problem Type
Default Value: PSOPTPRBTYPE.PROBTYPE
Prompt Table: PSOPTPRBTYPE
Set Control Field: PROBTYPE

2 DLLNAME Character(30) VARCHAR2(30) NOT NULL DLL Name

3 DLLVERSION Character(10) VARCHAR2(10) NOT NULL Version of the plugin DLL.

4 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number

5 APPPKGPATH Character(92) VARCHAR2(92) NOT NULL Application Package Full PATH

6 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

7 APPPKGPATH2 Character(92) VARCHAR2(92) NOT NULL Application Package Full PATH

8 APPCLASSID2 Character(30) VARCHAR2(30) NOT NULL Application Class ID

9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 DESCRLONG Long Character CLOB Long Description

12 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

13 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.

14 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBTYPE	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Type Default Value: PSOPTPRBTYPE.PROBTYPE Prompt Table: PSOPTPRBTYPE Set Control Field: PROBTYPE
2	DLLNAME	Character(30)	VARCHAR2(30) NOT NULL	DLL Name
3	DLLVERSION	Character(10)	VARCHAR2(10) NOT NULL	Version of the plugin DLL.
4	MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
5	APPPKGPATH	Character(92)	VARCHAR2(92) NOT NULL	Application Package Full PATH
6	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
7	APPPKGPATH2	Character(92)	VARCHAR2(92) NOT NULL	Application Package Full PATH
8	APPCLASSID2	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
9	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	DESCRLONG	Long Character	CLOB	Long Description
12	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
13	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.
14	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.