PVO_SCENARIOS
This table stores what-if analysis scenarios information.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
PVO_SCENARIO_TEMPLATES |
SCEN_TEMPLATE_ID |
SCEN_TEMPLATE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
SCENARIO_ID |
NOT NULL |
NUMBER |
Identifier for the scenario |
SCENARIO_NAME |
NOT NULL |
VARCHAR2 |
Name of the scenario |
SCEN_CONSTRAINTS |
NOT NULL |
CLOB |
Scenario constraints information |
VERSION |
NOT NULL |
NUMBER |
System-generated version, used for hibernate version control. |
CREATION_DATE |
NOT NULL |
DATE |
Date when the scenario was created |
CREATED_BY |
NOT NULL |
NUMBER |
User that created the scenario |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
User that last updated the scenario |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date when the scenario was last updated |
SCEN_TEMPLATE_ID |
NOT NULL |
NUMBER |
Identifier for the scenario template |
Indexes
There are no indexes for this table.
Sequences
There are no sequences for this table.