PROBTYPEPrompt Table: PSOPTPRBTYPE
TRANNAMEPARMIDPrompt Table: PSOPTPARMTYPE
B=Input and Output
I=Input
O=Output
PSOPTTRNCTLG(SQL Table) |
Index Back |
|---|---|
Optmz. Transaction CatalogThis table consists of all the transactions, their parameters and defaults supported by a problem type and optimization solver plug-in. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBTYPE |
Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Type (see PSOPTPRBTYPE).
Prompt Table: PSOPTPRBTYPE |
| 2 | TRANNAME |
Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |
| 3 | PARMID |
Character(20) | VARCHAR2(20) NOT NULL | Parameter Name |
| 4 | PARM_TYPE | Number(2,0) | SMALLINT NOT NULL |
Parameter Data Type
Prompt Table: PSOPTPARMTYPE |
| 5 | DEF_VALUE | Character(50) | VARCHAR2(50) NOT NULL | Default Value as String. |
| 6 | PARM_ATTR | Character(1) | VARCHAR2(1) NOT NULL |
Parameter attribute. Input or output or both.
B=Input and Output I=Input O=Output |