WIA_SCENARIO_SNAPSHOTS

This table stores snapshots of what-if analysis scenarios.

Foreign Keys

This table has no foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
ID	NOT NULL	NUMBER	Identifier for the scenario snapshot.
SCENARIO_ID	NOT NULL	NUMBER	Identifier for the scenario.
NAME	NOT NULL	VARCHAR2(200)	Name of the scenario snapshot.
DATA_SOURCE	NOT NULL	NUMBER	Data source information of the scenario.
SCEN_DETAIL_DIFF	NULLABLE	CLOB	It stores modification information of scenario after the scenario is created or refreshed. It may include scope in/out info, ranking info, and so on.
SCEN_DETAIL_DATA	NULLABLE	CLOB	It stores latest details of scenario.
VERSION	NOT NULL	NUMBER	System-generated version, used for version control.
CREATION_DATE	NOT NULL	DATE	Date when the scenario snapshot was created.
CREATED_BY	NOT NULL	NUMBER	User that created the scenario snapshot.
LAST_UPDATE_DATE	NOT NULL	DATE	Date when the scenario snapshot was last updated.
LAST_UPDATED_BY	NOT NULL	NUMBER	User that last updated the scenario snapshot.

Indexes

Index Name	Index Type	Sequence	Column Name
SNAPSHOT_NAME_UNIQUE	NORMAL	1	NAME
WIA_SNAPSHOT_DATA_SOURCE	NORMAL	2	DATA_SOURCE
WIA_SNAPSHOT_SCENARIO_ID	NORMAL	3	SCENARIO_ID

Sequences

Sequence Name	Sequence Type
WIA_SCENARIO_SNAPSHOTS_S