Share this page
WIA_SCENARIOS
This table stores what-if analysis scenario details.
Foreign keys
This table has no foreign keys.
Column descriptions
| Column Name | Null? | Data Type | Description |
|---|---|---|---|
| ID | NOT NULL | NUMBER | Identifier for the scenario. |
| NAME | NOT NULL | VARCHAR2(200 CHAR) | Name of the scenario. |
| DATA_SOURCE | NOT NULL | VARCHAR2(400 CHAR) | 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. |
| VERSION | NOT NULL | NUMBER | System-generated version, used for version control. |
|
CREATION_DATE |
NOT NULL | DATE | Date when the scenario was created. |
|
CREATED_BY |
NOT NULL | NUMBER | User that created the scenario. |
|
LAST_UPDATE_DATE |
NOT NULL | DATE | Date when the scenario was last updated. |
|
LAST_UPDATED_BY |
NOT NULL | NUMBER | User that last updated the scenario. |
| AUTO_SYNC_CONTENT_CHANGE | NOT NULL | CHAR(1) | Flag to indicate whether portfolio updates are automatically synced to the scenario. |
Indexes
This table has no indexes.
Sequences
| Sequence Name | Sequence Type |
|---|---|
| wia_scenarios_s |
