PSOPTTRNCTLG

index back

Optmz. Transaction Catalog

This table consists of all the transactions, their parameters and defaults supported by a problem type and optimization solver plug-in.

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

Prompt Table: PSOPTPRBTYPE

TRANNAME Character(30) VARCHAR2(30) NOT NULL Transaction Name
PARMID Character(20) VARCHAR2(20) NOT NULL Parameter Name
PARM_TYPE Number(2,0) SMALLINT NOT NULL Parameter Data Type

Prompt Table: PSOPTPARMTYPE

DEF_VALUE Character(50) VARCHAR2(50) NOT NULL Default Value as String.
PARM_ATTR Character(1) VARCHAR2(1) NOT NULL Parameter attribute. Input or output or both.
B=Input and Output
I=Input
O=Output
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19