# DW_CST_SCENARIOS_D

This table contains the header information about the cost planning scenarios

## Details

Module: Cost Management

## Key Columns

SCENARIO_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SCENARIO_ID | NUMBER | 38 | 0 | True | Surrogate key and unique identifier for each cost planning scenario |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Identifier |  |
EFFECTIVE_START_DATE | DATE |  |  |  | Indicates the date when the scenario becomes effective |  |
SCENARIO_NUMBER | VARCHAR2 | 32 |  |  | User definable number to identify the cost planning scenario |  |
SCENARIO_TYPE | VARCHAR2 | 32 |  |  | Indicates the type of the scenario | DW_ORA_CST_SCENARIO_TYPES_LKP_TL | ORA_CST_SCENARIO_TYPES_CODE
STATE_CODE | VARCHAR2 | 32 |  |  | Indicates the state of the scenario | DW_ORA_CST_SCENARIO_STATE_LKP_TL | ORA_CST_SCENARIO_STATE_CODE
STATUS_CODE | VARCHAR2 | 32 |  |  | Indicates the status of the scenario | DW_ORA_CST_SCENARIO_STATUS_SMPL_LKP_TL | ORA_CST_SCENARIO_STATUS_SMPL_CODE
COMMENTS | VARCHAR2 | 999 |  |  | Indicates the detailed information or comments about the cost planning scenario being defined |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.