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

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)

KPPO_OPT_PARAMETERS_U1

UNIQUE

1

OPT_PARAMETERS_ID

KPPO_OPT_PARAMETERS_S

OPT_PARAMETERS_ID