PARAM_REGR
| NUTS_CODE (character code administrative unit) |
NOT NULL | VARCHAR2(8) | - |
| STAT_CROP_NO ('statistic' crop number) |
NOT NULL | NUMBER(2) | - |
| DECADE (decade) |
NOT NULL | NUMBER(2) | - |
| RUN_CODE (code indicating date/time of run) |
NOT NULL | VARCHAR(25) | - |
| TYPE_OF_DATA_SET (data set over years used to derive parameters (W=window, T=total) |
NOT NULL | VARCHAR2(1) | - |
| START_YEAR (start of sequence where parameters are based on) |
NOT NULL | NUMBER(4) | - |
| END_YEAR (end of sequence where parameters are based on) |
NOT NULL | NUMBER(4) | - |
| NUMBER_OF_OBS_REGRESSION (number of observation (years) for regression; in case of window: window size) |
NOT NULL | NUMBER(2) | - |
| NUMBER_OF_OBS_TOTAL (number of total observations (years) to select the predictor) |
NOT NULL | NUMBER(2) | - |
| MISSING_YEARS_TOTAL (number of missing years from total data set) |
NOT NULL | NUMBER(2) | - |
| MEAN_YEAR (year to be used in forecasting formula) |
NOT NULL | NUMBER(6,1) | - |
| MEAN_OFFICIAL_YIELD (mean official yield) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1 |
| YEARLY_INCREASE (yearly increase in yield) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1.yr-1 |
| USED_REGRESSION_COEFFICIENT (indicates which (simulated) variable is to be used for forecasting) |
NOT NULL | VARCHAR2(50) | - |
| COEFF_INDICATOR_X1 (multiplier for delta X1) |
NOT NULL | NUMBER(6,3) | - |
| COEFF_INDICATOR_X2 (multiplier for delta X2) |
NOT NULL | NUMBER(6,3) | - |
| COEFF_INDICATOR_X3 (multiplier for delta X3) |
NOT NULL | NUMBER(6,3) | - |
| COEFF_INDICATOR_X4 (multiplier for delta X4) |
NOT NULL | NUMBER(6,3) | - |
| MEAN_INDICATOR_X1 (mean X1) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1 |
| MEAN_INDICATOR_X2 (mean X2) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1 |
| MEAN_INDICATOR_X3 (mean X3) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1 |
| MEAN_INDICATOR_X4 (mean X4) |
NOT NULL | NUMBER(8,3) | 103 kg.ha-1 |
| CODE_INDICATOR_X1 (description indicator X1) |
NOT NULL | VARCHAR(50) | - |
| CODE_INDICATOR_X2 (description indicator X2) |
NOT NULL | VARCHAR(50) | - |
| CODE_INDICATOR_X3 (description indicator X3) |
NOT NULL | VARCHAR(50) | - |
| CODE_INDICATOR_X4 (description indicator X4) |
NOT NULL | VARCHAR(50) | - |
| STUDENT_VALUE_P5 (T-value resulting from regression, for model indicator) |
NOT NULL | NUMBER(6,3) | - |
| RSQ_P0 (R-square of trend only) |
NOT NULL | NUMBER(6,3) | - |
| RSQ_P5 (R-square of selected regression) |
NOTNULL | NUMBER(6,3) | - |
| REL_RMSQ_RESIDUAL_ERR_P5 (relative rmsq residual error of selected regression) |
NUMBER(5,1) | % | |
| REL_RMSQ_JACKKNIFE_ERR (relative rmsq jackknife error of prediction based on all years) |
NUMBER(5,1) | % | |
| REL_RMSQ_ONE_YEAR_AHEAD_ERR_P5 (relative rmsq one year ahead error of complete prediction rule) |
NUMBER(5,1) | % | |
| REL_RMSQ_TWO_YEAR_AHEAD_ERR_P5 (relative rmsq two year ahead error of complete prediction rule) |
NUMBER(5,1) | - | |
| ONE_YEAR_AHEAD_ERR_P0 (one year ahead error of trend only) |
NUMBER(8,3) | - | |
| ONE_YEAR_AHEAD_ERR_P5 (one year ahead error of the selected regression) |
NUMBER(8,3) | - | |
| TWO_YEAR_AHEAD_ERR_P0 (two year ahead error of trend only) |
NUMBER(8,3) | - | |
| TWO_YEAR_AHEAD_ERR_P5 (two year ahead error of selected regression) |
NUMBER(8,3) | - | |
| STANDARD_DEV_P5 (standard deviation of selected regression) |
NOT NULL | NUMBER(7,4) | - |