MSC_ENGINE_NODE_FORECAST
Engine node forecast details table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_ENGINE_NODE_FORECAST_PK |
LEVEL_ID, ITEM_NODE, LOC_NODE, SALES_DATE, TIME_SIG |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEVEL_ID | NUMBER | 2 | Yes | LEVEL_ID parameter for engine node forecast table. | |
| ITEM_NODE | NUMBER | 18 | Yes | ITEM_NODE parameter for engine node forecast table. | |
| LOC_NODE | NUMBER | 18 | Yes | LOC_NODE parameter for engine node forecast table. | |
| SALES_DATE | DATE | Yes | SALES_DATE parameter for engine node forecast table. | ||
| FORECAST | NUMBER | 18 | FORECAST parameter for engine node forecast table. | ||
| SPLIT_DONE | NUMBER | 1 | SPLIT_DONE parameter for engine node forecast table. | ||
| TIME_SIG | DATE | Yes | TIME_SIG parameter for engine node forecast table. | ||
| PROP_SUM | NUMBER | 12 | PROP_SUM parameter for engine node forecast table. | ||
| ACTUAL | NUMBER | 12 | ACTUAL parameter for engine node forecast table. | ||
| REGR | NUMBER | 12 | REGR parameter for engine node forecast table. | ||
| LOG | NUMBER | 12 | LOG parameter for engine node forecast table. | ||
| CMREG | NUMBER | 12 | CMREG parameter for engine node forecast table. | ||
| ELOG | NUMBER | 12 | ELOG parameter for engine node forecast table. | ||
| HOLT | NUMBER | 12 | HOLT parameter for engine node forecast table. | ||
| FCROST | NUMBER | 12 | FCROST parameter for engine node forecast table. | ||
| IREGR | NUMBER | 12 | IREGR parameter for engine node forecast table. | ||
| ICMREGR | NUMBER | 12 | ICMREGR parameter for engine node forecast table. | ||
| BWINT | NUMBER | 12 | BWINT parameter for engine node forecast table. | ||
| LOGISTIC | NUMBER | 12 | LOGISTIC parameter for engine node forecast table. | ||
| ARLOGISTIC | NUMBER | 12 | ARLOGISTIC parameter for engine node forecast table. | ||
| ARX | NUMBER | 12 | ARX parameter for engine node forecast table. | ||
| ARIX | NUMBER | 12 | ARIX parameter for engine node forecast table. | ||
| MRIDGE | NUMBER | 12 | MRIDGE parameter for engine node forecast table. | ||
| DAILY | NUMBER | 12 | DAILY parameter for engine node forecast table. | ||
| SIG_SQR | NUMBER | 12 | SIG_SQR parameter for engine node forecast table. | ||
| OUTLIER | NUMBER | 12 | OUTLIER parameter for engine node forecast table. | ||
| REGIME_CHANGE | NUMBER | 12 | REGIME_CHANGE parameter for engine node forecast table. | ||
| MAPE | NUMBER | 12 | MAPE parameter for engine node forecast table. | ||
| OOS_MAPE | NUMBER | 12 | Out of sample column for node forecast table. | ||
| TEST_MODE | NUMBER | 12 | Test mode for node forecast table. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_ENGINE_NODE_FORECAST | msc_engine_node_forecast | LEVEL_ID, ITEM_NODE, LOC_NODE, SALES_DATE, TIME_SIG |
| msc_engine_node_forecast | msc_engine_node_forecast | LEVEL_ID, ITEM_NODE, LOC_NODE, SALES_DATE, TIME_SIG |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ENGINE_NODE_FORECAST_U1 | Unique | Default | LEVEL_ID, ITEM_NODE, LOC_NODE, SALES_DATE, TIME_SIG |