MSC_PROFILE_ENG_PARAMS_VALUES
Engine Parameter Values for Profiles.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_PROFILE_ENG_PARAMS_VAL_PK |
PROFILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROFILE_ID | NUMBER | 18 | Yes | Profile identifier for Engine Profile Parameters Configuration. | |
| SUPERSESSIONLEVEL | NUMBER | 12 | SUPERSESSIONLEVEL for Engine Profile Parameters Configuration. | ||
| WRITECOMBINATIONRESULTS | NUMBER | 12 | Flag Parameter for engine to write out node forecast results. | ||
| WRITEINTERMEDIATERESULTS | NUMBER | 12 | Flag Parameter for engine to write out intermediate results. | ||
| ENABLEFITVALIDATION | NUMBER | 12 | ENABLEFITVALIDATION for Engine Profile Parameters Configuration. | ||
| FITVALIDATIONSENSITIVITY | NUMBER | 12 | FITVALIDATIONSENSITIVITY for Engine Profile Parameters Configuration. | ||
| FITTESTPERIOD | NUMBER | 12 | FITTESTPERIOD for Engine Profile Parameters Configuration. | ||
| DEVIATIONFACTOR | NUMBER | 12 | DEVIATIONFACTOR for Engine Profile Parameters Configuration. | ||
| STDRATIO | NUMBER | 12 | STDRATIO for Engine Profile Parameters Configuration. | ||
| ENABLEFORECASTVALIDATION | NUMBER | 12 | ENABLEFORECASTVALIDATION for Engine Profile Parameters Configuration. | ||
| FORECASTVALIDATIONSENSITIVITY | NUMBER | 12 | FORECASTVALIDATIONSENSITIVITY for Engine Profile Parameters Configuration. | ||
| FORECASTTESTPERIOD | NUMBER | 12 | FORECASTTESTPERIOD for Engine Profile Parameters Configuration. | ||
| ENABLEMODELVALIDATION | NUMBER | 12 | ENABLEMODELVALIDATION for Engine Profile Parameters Configuration. | ||
| MODELVALIDATIONSENSITIVITY | NUMBER | 12 | MODELVALIDATIONSENSITIVITY for Engine Profile Parameters Configuration. | ||
| REMOVERESIDOUTLIER | NUMBER | 12 | REMOVERESIDOUTLIER for Engine Profile Parameters Configuration. | ||
| METRICSPERIOD | NUMBER | 12 | METRICSPERIOD for Engine Profile Parameters Configuration. | ||
| DETECTOUTLIER | NUMBER | 12 | DETECTOUTLIER for Engine Profile Parameters Configuration. | ||
| OUTLIERSENSITIVITY | NUMBER | 12 | OUTLIERSENSITIVITY for Engine Profile Parameters Configuration. | ||
| REMOVEEXTREMEOUTLIER | NUMBER | 12 | REMOVEEXTREMEOUTLIER for Engine Profile Parameters Configuration. | ||
| OUTLIERSPERCENT | NUMBER | 12 | OUTLIERSPERCENT for Engine Profile Parameters Configuration. | ||
| OUTLIERSTDERR | NUMBER | 12 | OUTLIERSTDERR for Engine Profile Parameters Configuration. | ||
| DETECTREGIMECHANGE | NUMBER | 12 | DETECTREGIMECHANGE for Engine Profile Parameters Configuration. | ||
| REGIMESENSITIVITY | NUMBER | 12 | REGIMESENSITIVITY for Engine Profile Parameters Configuration. | ||
| MINLENGTHFORDATASMOOTHING | NUMBER | 12 | MINLENGTHFORDATASMOOTHING for Engine Profile Parameters Configuration. | ||
| FILLMISSINGMETHOD | NUMBER | 12 | FILLMISSINGMETHOD for Engine Profile Parameters Configuration. | ||
| ENABLENONNEGREGR | NUMBER | 12 | ENABLENONNEGREGR for Engine Profile Parameters Configuration. | ||
| ENABLEWEIGHTEDREGR | NUMBER | 12 | ENABLEWEIGHTEDREGR for Engine Profile Parameters Configuration. | ||
| ENABLENAIVEFORECAST | NUMBER | 12 | ENABLENAIVEFORECAST for Engine Profile Parameters Configuration. | ||
| WRITEFIT | NUMBER | 12 | WRITEFIT for Engine Profile Parameters Configuration. | ||
| ENABLEMODIFIEDVARIANCE | NUMBER | 12 | ENABLEMODIFIEDVARIANCE for Engine Profile Parameters Configuration. | ||
| HIGHESTSQUARING | NUMBER | 12 | HIGHESTSQUARING for Engine Profile Parameters Configuration. | ||
| NONNEGREGRITERATIONS | NUMBER | 12 | NONNEGREGRITERATIONS for Engine Profile Parameters Configuration. | ||
| NUMOFSHAPES | NUMBER | 12 | NUMOFSHAPES for Engine Profile Parameters Configuration. | ||
| SHAPESIGN | NUMBER | 12 | SHAPESIGN for Engine Profile Parameters Configuration. | ||
| DAMPPERIOD | NUMBER | 12 | DAMPPERIOD for Engine Profile Parameters Configuration. | ||
| DAMPSTEP | NUMBER | 12 | DAMPSTEP for Engine Profile Parameters Configuration. | ||
| PERIODSUNTILINACTIVE | NUMBER | 12 | PERIODSUNTILINACTIVE for Engine Profile Parameters Configuration. | ||
| PERIODSUNTILACTIVE | NUMBER | 12 | PERIODSUNTILACTIVE for Engine Profile Parameters Configuration. | ||
| GLOBALALLOCATIONPERIODS | NUMBER | 12 | GLOBALALLOCATIONPERIODS for Engine Profile Parameters Configuration. | ||
| GLOBALALLLOCTREATMISSING | NUMBER | 12 | GLOBALALLLOCTREATMISSING for Engine Profile Parameters Configuration. | ||
| SUPERSESSIONMETHOD | NUMBER | 12 | SUPERSESSIONMETHOD for Engine Profile Parameters Configuration. | ||
| ENABLEADJUSTMENT | NUMBER | 12 | ENABLEADJUSTMENT for Engine Profile Parameters Configuration. | ||
| ALLOWNEGATIVEFORECAST | NUMBER | 12 | ALLOWNEGATIVEFORECAST for Engine Profile Parameters Configuration. | ||
| LOGCORRECTION | NUMBER | 12 | LOGCORRECTION for Engine Profile Parameters Configuration. | ||
| DOWNTREND | NUMBER | 12 | DOWNTREND for Engine Profile Parameters Configuration. | ||
| UPTREND | NUMBER | 12 | UPTREND for Engine Profile Parameters Configuration. | ||
| PERCENTOFZEROS | NUMBER | 12 | PERCENTOFZEROS for Engine Profile Parameters Configuration. | ||
| INTERMITCRITERION | NUMBER | 12 | INTERMITCRITERION for Engine Profile Parameters Configuration. | ||
| SMOOTHINTERMITTENT | NUMBER | 12 | SMOOTHINTERMITTENT for Engine Profile Parameters Configuration. | ||
| INTUPDATE | NUMBER | 12 | INTUPDATE for Engine Profile Parameters Configuration. | ||
| INTERMITCROSTONUNSPREAD | NUMBER | 12 | INTERMITCROSTONUNSPREAD for Engine Profile Parameters Configuration. | ||
| CUTLEADINGZEROS | NUMBER | 12 | CUTLEADINGZEROS for Engine Profile Parameters Configuration. | ||
| ENABLECAUSALSSHIFT | NUMBER | 12 | ENABLECAUSALSSHIFT for Engine Profile Parameters Configuration. | ||
| SHIFTBASECAUSALS | NUMBER | 12 | SHIFTBASECAUSALS for Engine Profile Parameters Configuration. | ||
| TOOFEW | NUMBER | 12 | TOOFEW for Engine Profile Parameters Configuration. | ||
| TRENDPREESTIMATION | NUMBER | 12 | TRENDPREESTIMATION for Engine Profile Parameters Configuration. | ||
| TRENDDAMPPERIOD | NUMBER | 12 | TRENDDAMPPERIOD for Engine Profile Parameters Configuration. | ||
| TRENDDAMPSTEP | NUMBER | 12 | TRENDDAMPSTEP for Engine Profile Parameters Configuration. | ||
| TRENDMODELFORSHORT | NUMBER | 12 | TRENDMODELFORSHORT for Engine Profile Parameters Configuration. | ||
| TRENDOUTLIERRATIO | NUMBER | 12 | TRENDOUTLIERRATIO for Engine Profile Parameters Configuration. | ||
| TRENDPERIOD | NUMBER | 12 | TRENDPERIOD for Engine Profile Parameters Configuration. | ||
| TRENDSHORTRATIO | NUMBER | 12 | TRENDSHORTRATIO for Engine Profile Parameters Configuration. | ||
| TESTOUTOFSAMPLEDURATION | NUMBER | 12 | Feature - Intermittent Results. TestOutOfSampleDuration parameter for Intermittent results feature. | ||
| TESTMODE | NUMBER | 12 | Feature - Intermittent Results. TestMode parameter for Intermittent results feature. | ||
| ENGINERUNDATE | DATE | Feature - Net Change. Indication of the date and time the engine profile completed successfully | |||
| COLLINEARITYUSERIDGE | NUMBER | 12 | Feature - Colinearity. A flag controlling use of Ridge regression or QR/SVD decomposition in cases of collinearity. If set to 0 - Ridge Service is not used. 1(default) - use Ridge for cases of collinearity. 2 - use QR instead SVD for cases of collinearity and NonNegRegr. | ||
| COLLINEARITYTOLERANCE | NUMBER | 12 | Feature - Colinearity. Parameter controlling sensitivity of collinearity detection. Default value of 1 detects very strong cases. Large values such as 1000 would detect weaker cases. Can be set between 1 and 100,000 | ||
| COLLINEARITYMAXRATIO | NUMBER | 12 | Feature - Colinearity. Maximum ratio allowed between base or lift elements and total demand. Can be set to any integer greater than one. | ||
| POPULATIONFILTER | VARCHAR2 | 2000 | Feature - Population Filter. 'Applies a filter on a batch profile. Default- No filter. Example: MDP_MATRIX .PREDICTION_STATUS=1. Syntax must include the tables for the from clause. Example: ITEMS.ITEM_ID=MDP_MATRIX.ITEM_ID AND ITEMS.ITEM_ID<100.' | ||
| INTERMITTENCYOUTPUTTYPE | NUMBER | 12 | Feature - Safety Stock. The data for which intermittency information will be calculated and reported. 1 =history,2 = historical fit, 3= forecast | ||
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_PROFILE_ENG_PARAMS_VALUES | msc_profile_eng_params_values | PROFILE_ID |
| msc_profile_eng_params_values | msc_profile_eng_params_values | PROFILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_PROF_ENG_PAR_VALS_U1 | Unique | Default | PROFILE_ID, ORA_SEED_SET1 |
| MSC_PROF_ENG_PAR_VALS_U11 | Unique | Default | PROFILE_ID, ORA_SEED_SET2 |