Share this page

# KPPO_OPT_PARAMETERS

This table stores header level optimization information related to a particular scenario or efficient frontier (within a scenario comparison). It is a parent of the KPPO_OPT_MIX_ENTRIES and KPPO_PER_PROJECT_SETTINGS tables.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OPT_PARAMETERS_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
SCENARIO_ID | NULLABLE | NUMBER | Reference to KPFM_SCENARIOS for which scenario these optimization parameters are for
SCEN_COMPARISON_ID | NULLABLE | NUMBER | Reference to KPFM_SCENARIO_COMPARISONS for the scenario comparison that contains the scenario that these parameters are for
OPTIMIZED_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', is the scenario optimized? parameters are kept even if the optimization is disabled.
EFFICIENT_FRONTIER_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', are these parameters for the efficient frontier.
RUN_DATE | NULLABLE | DATE | when was the optimizer run
OBJECTIVE_CODE | NOT NULL | VARCHAR2(30) | 'SCORE', 'VALUE' or 'NPV', represents the objective of the optimization. Are we optimizing for score, value, or NPV (Net Present Value)
USE_BUDGET_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use the per period budget information as a constraint?
USE_RESOURCE_POOL_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use the per period per role resource pool information as a constraint?
ENABLE_RISK_THRESHOLD_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on the average risk that is tolerable
RISK_THRESHOLD | NULLABLE | NUMBER | if enable_risk_threshold is Y, this contains the average risk score that can be tolerated.
ENABLE_VALUE_THRESHOLD_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on the average value that must be met
VALUE_THRESHOLD | NULLABLE | NUMBER | if enable_value_threshold is 'Y', this contains the average value that must be met
ENABLE_CUSTOM_THRESHOLD_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on the average value of custom field that is expected
CUSTOM_THRESHOLD | NULLABLE | NUMBER | if enable_custom_threshold is Y, this contains the value of the constraint - it uses the threshold_type to determine if the average value must be above or below the threshold
CUSTOM_THRESHOLD_TYPE_CODE | NULLABLE | VARCHAR2(30) | 'ABOVE' or 'BELOW', it indicates how the optimizer should interpret the constraint value in custom_threshold
ENABLE_BIZ_OBJECTIVE_MIX_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on how much budget goes to a particular business objective. The rest of the data is in KPPO_OPT_MIX_ENTRIES.
ENABLE_PROJECT_CLASS_MIX_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on how much budget goes to a particular project class. The rest of the data is in KPPO_OPT_MIX_ENTRIES.
ENABLE_ASSET_CLASS_MIX_FLAG | NOT NULL | VARCHAR2(1) | 'Y' or 'N', should the optimizer use a constraint on how much budget goes to a particular asset class. The rest of the data is in KPPO_OPT_MIX_ENTRIES.
IS_STALE | NULLABLE | VARCHAR2(1) | 'Y' or 'N', this can be set to 'Y' when the scenario changes enough to make the optimization out of date (usually changes in content)

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KPPO_OPT_PARAMETERS_U1 | UNIQUE | 1 | OPT_PARAMETERS_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KPPO_OPT_PARAMETERS_S | OPT_PARAMETERS_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: