Share this page
WIA_SCENARIO_LOCKED
This table stores what-if analysis scenarios that are locked.
Foreign Keys
This table does not have 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 | 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 | 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_LOCKED_PK | NORMAL 13 |
Sequences
This table uses no sequences.
