MSC_FORECAST_PROFILES

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PROFILE_ID INP_GLOB_PROP INP_PREDICTION_STATUS OUT_LEVEL_ID OUT_OUTLIER OUT_MODELS OUT_MAPE OUT_MAD OUT_BIAS OUT_IS_INTERM OUT_INTERVAL_TIME OUT_BATCH_SIZE OUT_AVG_INT_TIME OUT_FORECAST OUT_FORECAST_OUTLIER OUT_REGIME_CHANGE OUT_FCM_WEIGHT OUT_FORECAST_D OUT_FORECAST_OUTLIER_D OUT_REGIME_CHANGE_D OUT_FORECAST_D_TOTAL OUT_COMPLEXITY INP_HISTORY HIST_START_METHOD HIST_START_DATE HIST_END_DAYS HIST_START_REL_DAYS FORE_LOCKED_PERIODS GENERATE_FORECAST IS_SEEDED TABLE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENABLED_WORK_AREA MACHINE_LRNG_TYPE OUT_MODEL_ACC OUT_FEATURE_IMP OUT_TUNED_SETTINGS OUT_TUNED OUT_TUNED_BASE_MAPE OUT_TUNED_BEST_MAPE OUT_TUNED_DATE_MEASURE_ID PROFILE_NAME PROFILE_DESCRIPTION

Name

PROFILE_ID

INP_GLOB_PROP

INP_PREDICTION_STATUS

OUT_LEVEL_ID

OUT_OUTLIER

OUT_MODELS

OUT_MAPE

OUT_MAD

OUT_BIAS

OUT_IS_INTERM

OUT_INTERVAL_TIME

OUT_BATCH_SIZE

OUT_AVG_INT_TIME

OUT_FORECAST

OUT_FORECAST_OUTLIER

OUT_REGIME_CHANGE

OUT_FCM_WEIGHT

OUT_FORECAST_D

OUT_FORECAST_OUTLIER_D

OUT_REGIME_CHANGE_D

OUT_FORECAST_D_TOTAL

OUT_COMPLEXITY

INP_HISTORY

HIST_START_METHOD

HIST_START_DATE

HIST_END_DAYS

HIST_START_REL_DAYS

FORE_LOCKED_PERIODS

GENERATE_FORECAST

IS_SEEDED

TABLE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ENABLED_WORK_AREA

MACHINE_LRNG_TYPE

OUT_MODEL_ACC

OUT_FEATURE_IMP

OUT_TUNED_SETTINGS

OUT_TUNED

OUT_TUNED_BASE_MAPE

OUT_TUNED_BEST_MAPE

OUT_TUNED_DATE_MEASURE_ID

PROFILE_NAME

PROFILE_DESCRIPTION

Query

SQL_Statement
SELECT B.PROFILE_ID, B.INP_GLOB_PROP, B.INP_PREDICTION_STATUS, B.OUT_LEVEL_ID, B.OUT_OUTLIER, B.OUT_MODELS, B.OUT_MAPE, B.OUT_MAD, B.OUT_BIAS, B.OUT_IS_INTERM, B.OUT_INTERVAL_TIME, B.OUT_BATCH_SIZE, B.OUT_AVG_INT_TIME, B.OUT_FORECAST, B.OUT_FORECAST_OUTLIER, B.OUT_REGIME_CHANGE, B.OUT_FCM_WEIGHT, B.OUT_FORECAST_D, B.OUT_FORECAST_OUTLIER_D, B.OUT_REGIME_CHANGE_D, B.OUT_FORECAST_D_TOTAL, B.OUT_COMPLEXITY, B.INP_HISTORY, B.HIST_START_METHOD, B.HIST_START_DATE, B.HIST_END_DAYS, B.HIST_START_REL_DAYS, B.FORE_LOCKED_PERIODS, B.GENERATE_FORECAST, B.IS_SEEDED, B.TABLE_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.ENABLED_WORK_AREA, B.MACHINE_LRNG_TYPE, B.OUT_MODEL_ACC, B.OUT_FEATURE_IMP, B.OUT_TUNED_SETTINGS, B.OUT_TUNED, B.OUT_TUNED_BASE_MAPE, B.OUT_TUNED_BEST_MAPE, B.OUT_TUNED_DATE_MEASURE_ID, T.PROFILE_NAME, T.PROFILE_DESCRIPTION FROM MSC_FORECAST_PROFILES_B B, MSC_FORECAST_PROFILES_TL T WHERE B.PROFILE_ID = T.PROFILE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.PROFILE_ID,

B.INP_GLOB_PROP,

B.INP_PREDICTION_STATUS,

B.OUT_LEVEL_ID,

B.OUT_OUTLIER,

B.OUT_MODELS,

B.OUT_MAPE,

B.OUT_MAD,

B.OUT_BIAS,

B.OUT_IS_INTERM,

B.OUT_INTERVAL_TIME,

B.OUT_BATCH_SIZE,

B.OUT_AVG_INT_TIME,

B.OUT_FORECAST,

B.OUT_FORECAST_OUTLIER,

B.OUT_REGIME_CHANGE,

B.OUT_FCM_WEIGHT,

B.OUT_FORECAST_D,

B.OUT_FORECAST_OUTLIER_D,

B.OUT_REGIME_CHANGE_D,

B.OUT_FORECAST_D_TOTAL,

B.OUT_COMPLEXITY,

B.INP_HISTORY,

B.HIST_START_METHOD,

B.HIST_START_DATE,

B.HIST_END_DAYS,

B.HIST_START_REL_DAYS,

B.FORE_LOCKED_PERIODS,

B.GENERATE_FORECAST,

B.IS_SEEDED,

B.TABLE_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.ENABLED_WORK_AREA,

B.MACHINE_LRNG_TYPE,

B.OUT_MODEL_ACC,

B.OUT_FEATURE_IMP,

B.OUT_TUNED_SETTINGS,

B.OUT_TUNED,

B.OUT_TUNED_BASE_MAPE,

B.OUT_TUNED_BEST_MAPE,

B.OUT_TUNED_DATE_MEASURE_ID,

T.PROFILE_NAME,

T.PROFILE_DESCRIPTION

FROM

MSC_FORECAST_PROFILES_B B,

MSC_FORECAST_PROFILES_TL T

WHERE

B.PROFILE_ID = T.PROFILE_ID AND T.LANGUAGE = USERENV('LANG')