MSC_FCSTPRF_SIMULATION_PARAMS
table which stores the information related to the simulation output parameters.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_FCSTPRF_SIM_PA_PK |
SIMULATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROFILE_ID | NUMBER | 18 | Yes | forecast Profile Identifier required for the simulation. | |
| EXECUTION_ID | NUMBER | 18 | Execution identifier of the simulation. | ||
| SIMULATION_ID | NUMBER | 18 | Yes | primary key column for this table. | |
| PLAN_ID | NUMBER | 18 | Plan Identifier for which the simulation has been ran. | ||
| SIM_FCST_OUT_MEASURE_ID | NUMBER | 18 | the selected output forecast measure for simulation. | ||
| SIM_FCST_METHODS_MEASURE_ID | NUMBER | 18 | simulation forecast methods measure | ||
| SIM_FCST_LEVELS_MEASURE_ID | NUMBER | 18 | simulation forecast levels related measure. | ||
| SIM_FCST_DECOMPTOT_MEASURE_ID | NUMBER | 18 | simulation Decomposed forecast total related measure. | ||
| SIM_FCST_DECFCST_MEASURE_ID | NUMBER | 18 | simulation decomposed foreast measure. | ||
| SIM_FCST_MTHD_WGHT_MEASURE_ID | NUMBER | 18 | simulation forecast method weight measure | ||
| OUT_MSR_TO_TBL | NUMBER | Add the output measure to the table. | |||
| METHODS_MSR_TO_TBL | NUMBER | add forecast methods to the table. | |||
| LEVEL_MSR_TO_TBL | NUMBER | whether to store the levels measure to the table or not. | |||
| DECOMP_TOTAL_MSR_TO_TBL | NUMBER | add the deomposed total measure to the table. | |||
| DECOMP_FCST_MSR_TO_TBL | NUMBER | Add the decomposed measure to the table. | |||
| MTHD_WGHT_MSR_TO_TBL | NUMBER | Add the method weighted measure to the table | |||
| SIMULATION_FILTER | CLOB | Stores the filter set object in the form of clob | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_FCSTPRF_SIM_PA_U1 | Unique | Default | SIMULATION_ID |