PSOPTCONSEXP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Optimizaiton Model Name (see PSOPTMODEL). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Opt. Constant Array Name | |
| 3 | PAMS_CONSEXP_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Opt. Constant Exp Type |
| 4 | PAMS_OBJ1_ID | Character(30) | VARCHAR2(30) NOT NULL | Optimization Object 1 ID |
| 5 | PAMS_OBJ2_ID | Character(30) | VARCHAR2(30) NOT NULL | Optimization Object 2 ID |
| 6 | PAMS_BIN_OP | Character(30) | VARCHAR2(30) NOT NULL | Opt. Binary Operator |
| 7 | PAMS_VAL | Signed Number(26,8) | DECIMAL(24,8) NOT NULL | Optimization PAMS Value |
| 8 | PAMS_NUM_DIM | Number(1,0) | SMALLINT NOT NULL | Number of Dimension |