Share this page

# KPPO_OPT_RESULTS

This table stores the outcome of an optimization run for a scenario. One for each scenario optimization and 50 for an efficient frontier run (ordered by seq).

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KPFM_SCENARIOS | SCENARIO_ID | SCENARIO_ID
KPFM_SCENARIO_COMPARISONS | SCEN_COMPARISON_ID | SCEN_COMPARISON_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OPT_RESULTS_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
SCEN_COMPARISON_ID | NOT NULL | NUMBER | Foreign key reference to KPFM_SCENARIO_COMPARISONS that is a parent of this row
SCENARIO_ID | NULLABLE | NUMBER | Foreign key reference to KPFM_SCENARIOS that is a parent of this row
TOTAL_NPV | NOT NULL | NUMBER | Total NPV calculated by the optimizer for the given solution (solution is a set of portfolio items to select stored in KPPO_OPT_RESULT_PROJECTS).
TOTAL_RISK | NOT NULL | NUMBER | Total Risk calculated by the optimizer for the given solution (solution is a set of portfolio items to select stored in KPPO_OPT_RESULT_PROJECTS).
TOTAL_VALUE | NOT NULL | NUMBER | Total Value calculated by the optimizer for the given solution (solution is a set of portfolio items to select stored in KPPO_OPT_RESULT_PROJECTS).
TOTAL_SCORE | NOT NULL | NUMBER | Total Score calculated by the optimizer for the given solution (solution is a set of portfolio items to select stored in KPPO_OPT_RESULT_PROJECTS).
TOTAL_CUSTOM_FIELD | NOT NULL | NUMBER | Sum of the values in Custom Field for the given solution (solution is a set of portfolio items to select stored in KPPO_OPT_RESULT_PROJECTS).
TOTAL_BUDGET | NOT NULL | NUMBER | Total Budget needed for this solution
TOTAL_RESOURCE | NOT NULL | NUMBER | Total resource headcount needed for this solution
AVERAGE_NPV | NOT NULL | NUMBER | Average NPV for this solution
AVERAGE_RISK | NOT NULL | NUMBER | Average Risk score for this solution
AVERAGE_VALUE | NOT NULL | NUMBER | Average Value score for this solution
AVERAGE_SCORE | NOT NULL | NUMBER | Average Score (Value-Risk) for this solution
AVERAGE_CUSTOM_FIELD | NOT NULL | NUMBER | Average of the value of Custom Field for this solution
RANK | NULLABLE | NUMBER | set to 1 for scenarios and unused for efficient frontier. Is a provision for providing multiple solutions from the optimizer.
EFFICIENT_FRONTIER_SEQ | NULLABLE | NUMBER | 0-49 for the efficient frontier, one for each of the 50 solutions generated to paint the efficient frontier graph
CONSTRAINT_TYPE | NULLABLE | VARCHAR2(30) | Only used for efficient frontier, indicates what parameter was shifted per run for the efficient frontier calculations. Only BUDGET for now.
CONSTRAINT_VALUE | NULLABLE | NUMBER | For efficient frontier, the value for the constraint used when doing the run for this SEQ. For now, always the budget value used for the run
ACTIVE_FLAG | NULLABLE | VARCHAR2(1) | Unused for now

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KPPO_OPT_RESULTS_U1 | UNIQUE | 1 | OPT_RESULTS_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KPPO_OPT_RESULTS_S | OPT_RESULTS_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: