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