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 |