PSOPTPRBINST(SQL Table) |
Index Back |
|---|---|
Optmz. Problem InstancesThis table stores the problem instances for a given problem type. Note that the problem instance ID must be unique across all problem types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance | |
| 2 | PROBTYPE | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Type (see PSOPTPRBTYPE).
Prompt Table: PSOPTPRBTYPE |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | PTVALIDINST | Character(1) | VARCHAR2(1) NOT NULL | Valid Instance |