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