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

Prompt Table: PSOPTPRBTYPE

TRANNAMECharacter(30)VARCHAR2(30) NOT NULLTransaction Name
PARMIDCharacter(20)VARCHAR2(20) NOT NULLParameter Name
PARM_TYPENumber(2,0)SMALLINT NOT NULLParameter Data Type

Prompt Table: PSOPTPARMTYPE

DEF_VALUECharacter(50)VARCHAR2(50) NOT NULLDefault Value as String.
PARM_ATTRCharacter(1)VARCHAR2(1) NOT NULLParameter attribute. Input or output or both.
B=Input and Output
I=Input
O=Output
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19