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.