WIA_SCENARIO_UNSYNCED

This table stores what-if analysis scenarios that are not synced.

Foreign Keys

This table does not use any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
SCENARIO_ID	NOT NULL	NUMBER	Identifier for the scenario.
NAME	NOT NULL	VARCHAR2(200)	Name of the scenario.
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
WIA_SNAPSHOT_UNSYNCED_PK	NORMAL	1	SCENARIO_ID

Sequences

This table has no sequences.