PSOPTCONSEXP(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAMS_MODEL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Optimizaiton Model Name (see PSOPTMODEL). |
2 | PAMS_CONSEXP_ID | 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 |