Appendix 5: Database objects/GWSI E 12

content
1. ACTUAL-datasets
2. CROP-datasets
3. GRID-datasets
4. REGION-datasets
5. SOIL-datasets
6. UNITS-datasets
7. other datasets
8. synonyms

ACTUAL-datasets

content
1.1 ACTUAL_CALENDARS
1.2 ACTUAL_CALENDARS_LTA

ACTUAL_CALENDARS

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment ACTUAL_CALENDAR_ID NOT NULL NUMBER(22) UNIT_CALC_INPUT_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) SEASON_NO NOT NULL NUMBER(22) SUB_SEASON VARCHAR2(1) START_YEAR NOT NULL NUMBER(22) START_DEKAD_IN_YEAR NOT NULL NUMBER(22) END_YEAR NOT NULL NUMBER(22) END_DEKAD_IN_YEAR NOT NULL NUMBER(22) EARLINESS NOT NULL NUMBER(22) FORCED VARCHAR2(1) YEAR_OF_ENTRY NOT NULL NUMBER(22) DEKAD_IN_YEAR_OF_ENTRY NOT NULL NUMBER(22)

ACTUAL_CALENDARS_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment ACTUAL_CALENDAR_LTA_ID NOT NULL NUMBER(22) UNIT_CALC_INPUT_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) SEASON_NO NOT NULL NUMBER(22) START_DEKAD_IN_YEAR NOT NULL NUMBER(22) END_DEKAD_IN_YEAR NOT NULL NUMBER(22) EARLINESS NUMBER(22) FORCED NOT NULL NUMBER(22) AGG_COUNT NUMBER(22)

CROP-datasets

content
2.1 CROP_CALENDARS
2.2 CROP_COEFFICIENTS
2.3 CROP_TEMP_COEFFICIENTS

CROP_CALENDARS

• Description: where and when crops are grown. crop, crop variety and growing season per grid.
• Use: determines which crops are simulated for a grid, and simulation period
• Type: Table
• Remarks: user defined, one of the ‘driving’ tables of the system

Structure

Attribute Constraint Type Unit Comment CROP_CALENDAR_ID NOT NULL NUMBER(22) GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) HAS_CLIMATE_SEASON_1 NOT NULL NUMBER(22, 1) HAS_CLIMATE_SEASON_2 NOT NULL NUMBER(22, 1) HAS_CLIMATE_SEASON_3 NOT NULL NUMBER(22, 1) MAX_FAO_DURATION NUMBER(22, 2) HAS_CROP_SEASON_1 NOT NULL NUMBER(22, 1) HAS_CROP_SEASON_2 NOT NULL NUMBER(22, 1) HAS_CROP_SEASON_3 NOT NULL NUMBER(22, 1) MIN_CROP_DURATION NUMBER(22, 2) NR_OF_SEASONS NUMBER(22) START1 NUMBER(22) DUR1 NUMBER(22) SUBSEASON1 VARCHAR2(1) START2 NUMBER(22) DUR2 NUMBER(22) SUBSEASON2 VARCHAR2(1) START3 NUMBER(22) DUR3 NUMBER(22) SUBSEASON3 VARCHAR2(1) START4 NUMBER(22) DUR4 NUMBER(22) SUBSEASON4 VARCHAR2(1) * possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category). ** possible values: HARVEST, MATURITY, EARLIEST (see Spatial/temporal variation category).

CROP_COEFFICIENTS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment CROP_COEFFICIENT_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) PROGRESS_INDEX NOT NULL NUMBER(22) CROP_COEFFICIENT_VALUE NOT NULL NUMBER(22)

CROP_TEMP_COEFFICIENTS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment CROP_ID NOT NULL NUMBER(22) TEMPERATURE_MEAN NOT NULL NUMBER(22) REDUCTION NOT NULL NUMBER(22)

GRID-datasets

content
3.1 GRID_CLIMATE_SEASONS
3.2 GRID_CLIMATE_SEASONS_CROP_MASK
3.3 GRID_CROPMASKS
3.4 GRID_CUMETA_DUR1
3.5 GRID_CUMETA_LTA
3.6 GRID_CUMETA_LTA_ADJ
3.7 GRID_CUMETA_TIMESERIES
3.8 GRID_FULL
3.9 GRID_FULLXUNITS
3.10 GRID_FULLXUNITS_JOINOPT
3.11 GRID_INI_SEASONS
3.12 GRID_REGION_LANDCOVERS
3.13 GRID_THRESHOLDS_1
3.14 GRID_THRESHOLDS_2
3.15 GRID_THRESHOLDS_3
3.16 GRID_WEATHER_MODEL_10
3.17 GRID_WEATHER_MODEL_10_LTA

GRID_CLIMATE_SEASONS

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) NR_OF_SEASONS NUMBER(22, 1) START1 NUMBER(22, 2) START2 NUMBER(22, 2) START3 NUMBER(22, 2) DUR1 NUMBER(22, 2) DUR2 NUMBER(22, 2) DUR3 NUMBER(22, 2) START1_THLD1 NUMBER(22, 5) START1_THLD2 NUMBER(22, 5) START1_THLD3 NUMBER(22, 5) START1_THLD4 NUMBER(22, 5) START1_THLD5 NUMBER(22, 5) START1_THLD6 NUMBER(22, 5) START1_THLD7 NUMBER(22, 5) START2_THLD1 NUMBER(22, 5) START2_THLD2 NUMBER(22, 5) START2_THLD3 NUMBER(22, 5) START2_THLD4 NUMBER(22, 5) START2_THLD5 NUMBER(22, 5) START2_THLD6 NUMBER(22, 5) START2_THLD7 NUMBER(22, 5) START3_THLD1 NUMBER(22, 5) START3_THLD2 NUMBER(22, 5) START3_THLD3 NUMBER(22, 5) START3_THLD4 NUMBER(22, 5) START3_THLD5 NUMBER(22, 5) START3_THLD6 NUMBER(22, 5) START3_THLD7 NUMBER(22, 5) LOGGING_CHANGES VARCHAR2(500)

GRID_CLIMATE_SEASONS_CROP_MASK

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) SEASON_CNT NUMBER(22, 1) SEASON_1 NUMBER(22) SEASON_2 NUMBER(22) SEASON_3 NUMBER(22) definition: select gs.grid_id ,gs.crop_id ,gs.nr_of_seasons as season_cnt ,case when gs.start1 > 0 then 1 else 0 end as season_1 ,case when gs.start2 > 0 then 1 else 0 end as season_2 ,case when gs.start3 > 0 then 1 else 0 end as season_3 from grid_cropmasks gc ,grid_climate_seasons gs where (gc.wheat = 1 and gs.crop_id = 1 and gs.grid_id = gc.grid_id) or (gc.maize = 1 and gs.crop_id = 2 and gs.grid_id = gc.grid_id) or (gc.barley = 1 and gs.crop_id = 3 and gs.grid_id = gc.grid_id) or (gc.rice = 1 and gs.crop_id = 5 and gs.grid_id = gc.grid_id) or (gc.potato = 1 and gs.crop_id = 7 and gs.grid_id = gc.grid_id) or (gc.beans = 1 and gs.crop_id = 8 and gs.grid_id = gc.grid_id) or (gc.soybean = 1 and gs.crop_id = 9 and gs.grid_id = gc.grid_id) or (gc.sorghum = 1 and gs.crop_id = 30 and gs.grid_id = gc.grid_id) or (gc.groundnut = 1 and gs.crop_id = 31 and gs.grid_id = gc.grid_id) or (gc.millet = 1 and gs.crop_id = 32 and gs.grid_id = gc.grid_id) or (gc.pulses = 1 and gs.crop_id = 33 and gs.grid_id = gc.grid_id)

GRID_CROPMASKS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) MAIZE NOT NULL NUMBER(22, 1) WHEAT NOT NULL NUMBER(22, 1) BARLEY NUMBER(22, 1) RICE NOT NULL NUMBER(22, 1) SORGHUM NOT NULL NUMBER(22, 1) SOYBEAN NOT NULL NUMBER(22, 1) MILLET NOT NULL NUMBER(22, 1) BEANS NOT NULL NUMBER(22, 1) POTATO NOT NULL NUMBER(22, 1) PULSES NOT NULL NUMBER(22, 1) GROUNDNUT NOT NULL NUMBER(22, 1)

GRID_CUMETA_DUR1

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) CUMETA NOT NULL NUMBER(22)

GRID_CUMETA_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NUMBER(22) CROP_ID NUMBER(22) DEKAD_IN_YEAR NUMBER(22) DURATION NUMBER(22) CUMETA NUMBER(22) ISVALIDSTART NUMBER(22)

GRID_CUMETA_LTA_ADJ

• Description:
• Use:
• Type: View
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NUMBER(22) CROP_ID NUMBER(22) DEKAD_IN_YEAR NUMBER(22) DURATION NUMBER(22) CUMETA NUMBER(22) ISVALIDSTART NUMBER(22) definition: SELECT GRID_ID , CROP_ID , DEKAD_IN_YEAR , DURATION , -- (case when isvalidstart = 100 then cumeta else 0 end) cumeta , cumeta , ISVALIDSTART FROM GRID_CUMETA_LTA

GRID_CUMETA_TIMESERIES

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) DURATION NOT NULL NUMBER(22) CUMETA NUMBER(22) ISVALIDSTART VARCHAR2(1)

GRID_FULL

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_FULL_ID NOT NULL NUMBER(22) XCENTRE NOT NULL NUMBER(22) YCENTRE NOT NULL NUMBER(22) AREA_KM2 NOT NULL NUMBER(22) AREA_M2 NOT NULL NUMBER(22) SNUM NOT NULL NUMBER(22) GRID_ID NOT NULL NUMBER(22) REG_MAP_ID NOT NULL NUMBER(22)

GRID_FULLXUNITS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_FULLXUNIT_ID NOT NULL NUMBER(22) GRID_FULL_ID NOT NULL NUMBER(22) UNIT_CALC_INPUT_ID NOT NULL NUMBER(22)

GRID_FULLXUNITS_JOINOPT

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment UNIT_CALC_INPUT_ID NUMBER(22) XCENTRE NUMBER(22) YCENTRE NUMBER(22)

GRID_INI_SEASONS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) NR NUMBER(22, 2) MAX1 NUMBER(22, 2) MAX2 NUMBER(22, 2) MAX3 NUMBER(22, 2) MAX4 NUMBER(22, 2)

GRID_REGION_LANDCOVERS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 10) REG_MAP_ID NOT NULL NUMBER(22, 10) LANDCOVER_ID NOT NULL NUMBER(22, 10) AREA NOT NULL NUMBER(22, 10)

GRID_THRESHOLDS_1

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) DEKAD NUMBER(22, 2) THR_1 NUMBER(22) THR_2 NUMBER(22) THR_3 NUMBER(22) THR_4 NUMBER(22) THR_5 NUMBER(22) THR_6 NUMBER(22) THR_7 NUMBER(22)

GRID_THRESHOLDS_2

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) DEKAD NUMBER(22, 2) THR_1 NUMBER(22) THR_2 NUMBER(22) THR_3 NUMBER(22) THR_4 NUMBER(22) THR_5 NUMBER(22) THR_6 NUMBER(22) THR_7 NUMBER(22)

GRID_THRESHOLDS_3

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 7) CROP_ID NOT NULL NUMBER(22, 2) DEKAD NUMBER(22, 2) THR_1 NUMBER(22) THR_2 NUMBER(22) THR_3 NUMBER(22) THR_4 NUMBER(22) THR_5 NUMBER(22) THR_6 NUMBER(22) THR_7 NUMBER(22)

GRID_WEATHER_MODEL_10

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_WEATHER_MODEL_10_ID NOT NULL NUMBER(22) GRID_ID NUMBER(22) YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NUMBER(22) TEMPERATURE_MEAN NUMBER(22) TEMPERATURE_MAXIMUM NUMBER(22) TEMPERATURE_MINIMUM NUMBER(22) PRECIPITATION NUMBER(22) ET0 NUMBER(22) GLOBAL_RADIATION NUMBER(22) SNOW_DEPTH NUMBER(22)

GRID_WEATHER_MODEL_10_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_WEATHER_MODEL_10_LTA_ID NOT NULL NUMBER(22) GRID_ID NUMBER(22) DEKAD_IN_YEAR NUMBER(22) MEAN_TEMPERATURE_MEAN NUMBER(22) MEAN_TEMPERATURE_MAXIMUM NUMBER(22) MEAN_TEMPERATURE_MINIMUM NUMBER(22) MEAN_PRECIPITATION NUMBER(22) MEAN_ET0 NUMBER(22) MEAN_GLOBAL_RADIATION NUMBER(22) MEAN_SNOW_DEPTH NUMBER(22) P25_TEMPERATURE_MEAN NUMBER(22) P25_TEMPERATURE_MAXIMUM NUMBER(22) P25_TEMPERATURE_MINIMUM NUMBER(22) P25_PRECIPITATION NUMBER(22) P25_ET0 NUMBER(22) P25_GLOBAL_RADIATION NUMBER(22) P25_SNOW_DEPTH NUMBER(22) P50_TEMPERATURE_MEAN NUMBER(22) P50_TEMPERATURE_MAXIMUM NUMBER(22) P50_TEMPERATURE_MINIMUM NUMBER(22) P50_PRECIPITATION NUMBER(22) P50_ET0 NUMBER(22) P50_GLOBAL_RADIATION NUMBER(22) P50_SNOW_DEPTH NUMBER(22) P75_TEMPERATURE_MEAN NUMBER(22) P75_TEMPERATURE_MAXIMUM NUMBER(22) P75_TEMPERATURE_MINIMUM NUMBER(22) P75_PRECIPITATION NUMBER(22) P75_ET0 NUMBER(22) P75_GLOBAL_RADIATION NUMBER(22) P75_SNOW_DEPTH NUMBER(22) SDV_TEMPERATURE_MEAN NUMBER(22) SDV_TEMPERATURE_MAXIMUM NUMBER(22) SDV_TEMPERATURE_MINIMUM NUMBER(22) SDV_PRECIPITATION NUMBER(22) SDV_ET0 NUMBER(22) SDV_GLOBAL_RADIATION NUMBER(22) SDV_SNOW_DEPTH NUMBER(22) AVG_TEMP_GE_0 NUMBER(22) AVG_TEMP_GE_2 NUMBER(22) AVG_TEMP_GE_4 NUMBER(22) AVG_TEMP_GE_6 NUMBER(22) AVG_TEMP_GE_8 NUMBER(22) AVG_TEMP_GE_10 NUMBER(22)

REGION-datasets

content
4.1 REGION_WEATHER_MODEL_10
4.2 REGION_WEATHER_MODEL_10_LTA

REGION_WEATHER_MODEL_10

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID NOT NULL NUMBER(22, 10) LANDCOVER_ID NOT NULL NUMBER(22, 10) THRESHOLD NOT NULL NUMBER(22, 3) YEAR NOT NULL NUMBER(22, 4) DEKAD_IN_YEAR NOT NULL NUMBER(22, 2) TEMPERATURE_MEAN NOT NULL NUMBER(22, 3) TEMPERATURE_MAXIMUM NOT NULL NUMBER(22, 3) TEMPERATURE_MINIMUM NOT NULL NUMBER(22, 3) PRECIPITATION NOT NULL NUMBER(22, 5) ET0 NOT NULL NUMBER(22, 5) GLOBAL_RADIATION NOT NULL NUMBER(22, 7) SNOW_DEPTH NOT NULL NUMBER(22, 6)

REGION_WEATHER_MODEL_10_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID NOT NULL NUMBER(22, 10) LANDCOVER_ID NOT NULL NUMBER(22, 10) THRESHOLD NOT NULL NUMBER(22, 3) DEKAD_IN_YEAR NOT NULL NUMBER(22, 2) MEAN_TEMPERATURE_MEAN NUMBER(22, 3) MEAN_TEMPERATURE_MAXIMUM NUMBER(22, 3) MEAN_TEMPERATURE_MINIMUM NUMBER(22, 3) MEAN_PRECIPITATION NUMBER(22, 5) MEAN_ET0 NUMBER(22, 5) MEAN_GLOBAL_RADIATION NUMBER(22, 7) MEAN_SNOW_DEPTH NUMBER(22, 6) P25_TEMPERATURE_MEAN NUMBER(22, 3) P25_TEMPERATURE_MAXIMUM NUMBER(22, 3) P25_TEMPERATURE_MINIMUM NUMBER(22, 3) P25_PRECIPITATION NUMBER(22, 5) P25_ET0 NUMBER(22, 5) P25_GLOBAL_RADIATION NUMBER(22, 7) P25_SNOW_DEPTH NUMBER(22, 6) P50_TEMPERATURE_MEAN NUMBER(22, 3) P50_TEMPERATURE_MAXIMUM NUMBER(22, 3) P50_TEMPERATURE_MINIMUM NUMBER(22, 3) P50_PRECIPITATION NUMBER(22, 5) P50_ET0 NUMBER(22, 5) P50_GLOBAL_RADIATION NUMBER(22, 7) P50_SNOW_DEPTH NUMBER(22, 6) P75_TEMPERATURE_MEAN NUMBER(22, 3) P75_TEMPERATURE_MAXIMUM NUMBER(22, 3) P75_TEMPERATURE_MINIMUM NUMBER(22, 3) P75_PRECIPITATION NUMBER(22, 5) P75_ET0 NUMBER(22, 5) P75_GLOBAL_RADIATION NUMBER(22, 7) P75_SNOW_DEPTH NUMBER(22, 6) SDV_TEMPERATURE_MEAN NUMBER(22, 3) SDV_TEMPERATURE_MAXIMUM NUMBER(22, 3) SDV_TEMPERATURE_MINIMUM NUMBER(22, 3) SDV_PRECIPITATION NUMBER(22, 5) SDV_ET0 NUMBER(22, 5) SDV_GLOBAL_RADIATION NUMBER(22, 7) SDV_SNOW_DEPTH NUMBER(22, 6) AVG_TEMP_GE_0 NUMBER(22, 3) AVG_TEMP_GE_2 NUMBER(22, 3) AVG_TEMP_GE_4 NUMBER(22, 3) AVG_TEMP_GE_6 NUMBER(22, 3) AVG_TEMP_GE_8 NUMBER(22, 3) AVG_TEMP_GE_10 NUMBER(22, 3)

SOIL-datasets

content
5.1 SOIL_MAP_UNITS
5.2 SOIL_TYPES

SOIL_MAP_UNITS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment SNUM NOT NULL NUMBER(22, 8)

SOIL_TYPES

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment SOIL_TYPE_ID NOT NULL NUMBER(22) SNUM NOT NULL NUMBER(22) WATER_HOLDING_CAPACITY NOT NULL NUMBER(22) MAXIMUM_ROOTING_DEPTH_MM NOT NULL NUMBER(22) PERCENTAGE_AREA NOT NULL NUMBER(22) SOIL_TYPE NOT NULL VARCHAR2(31)

UNITS-datasets

content
6.1 UNITS_CALC_INPUT
6.2 UNITS_CALC_OUTPUT
6.3 UNITS_CALC_OUTPUT_LTA
6.4 UNITS_CALC_STATUS
6.5 UNITS_CALC_STATUS_LTA

UNITS_CALC_INPUT

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment UNIT_CALC_INPUT_ID NOT NULL NUMBER(22) GRID_ID NOT NULL NUMBER(22) SNUM NOT NULL NUMBER(22)

UNITS_CALC_OUTPUT

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment ACTUAL_CALENDAR_ID NOT NULL NUMBER(22) YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) WSI_P25 NOT NULL NUMBER(22) WSI_P50 NOT NULL NUMBER(22) WSI_P75 NOT NULL NUMBER(22) WSI_SUFF NOT NULL NUMBER(22) PROGRESS_INDEX NUMBER(22) CR NOT NULL NUMBER(22) CR_CUM NOT NULL NUMBER(22) ETA NOT NULL NUMBER(22) ETA_CUM NOT NULL NUMBER(22) WD NOT NULL NUMBER(22) WD_CUM NOT NULL NUMBER(22) WS NOT NULL NUMBER(22) WS_CUM NOT NULL NUMBER(22) WA NUMBER(22)

UNITS_CALC_OUTPUT_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment ACTUAL_CALENDAR_LTA_ID NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) WSI_P25 NOT NULL NUMBER(22) WSI_P50 NOT NULL NUMBER(22) WSI_P75 NOT NULL NUMBER(22) WSI_SUFF NOT NULL NUMBER(22) PROGRESS_INDEX NUMBER(22) CR NOT NULL NUMBER(22) CR_CUM NOT NULL NUMBER(22) ETA NOT NULL NUMBER(22) ETA_CUM NOT NULL NUMBER(22) WD NOT NULL NUMBER(22) WD_CUM NOT NULL NUMBER(22) WS NOT NULL NUMBER(22) WS_CUM NOT NULL NUMBER(22) AGG_COUNT NUMBER(22) WA NUMBER(22)

UNITS_CALC_STATUS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment UNIT_CALC_INPUT_ID NOT NULL NUMBER(22) YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) SEASON_NO NOT NULL NUMBER(22) SUB_SEASON VARCHAR2(1) PLANTING_STATUS NOT NULL NUMBER(22) STATUS_AGE NUMBER(22) YEAR_OF_ENTRY NOT NULL NUMBER(22) DEKAD_IN_YEAR_OF_ENTRY NOT NULL NUMBER(22)

UNITS_CALC_STATUS_LTA

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment UNIT_CALC_INPUT_ID NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) SEASON_NO NOT NULL NUMBER(22) PLANTING_STATUS NOT NULL NUMBER(22) STATUS_AGE NUMBER(22) AGG_COUNT NUMBER(22)

other datasets

content
7.1 CROPS
7.2 DAY_DECADEYEAR
7.3 GRID
7.4 MAX_FAO
7.5 REGIONS
7.6 SYSTABLES
7.7 TASKS

CROPS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment CROP_ID NOT NULL NUMBER(22) NAME_UK NOT NULL VARCHAR2(255) MAXIMUM_ROOTING_DEPTH_MM NOT NULL NUMBER(22) YIELD_REDUCTION_FACTOR NOT NULL NUMBER(22) CROP_PHYS_TYPE NOT NULL VARCHAR2(2)

DAY_DECADEYEAR

• Description: synonym to oracle package
• Use: view on DATE_GENERATOR package
• Type: Table
• Remarks: none

Structure
Attribute Constraint Type Unit Comment DAY NOT NULL DATE DECADE NOT NULL NUMBER(22, 2) YEAR NOT NULL NUMBER(22, 4) -

GRID

• Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
• Use: input/reference table for both level 1 and level 2
• Type: Table
• Remarks: user defined, derived from GIS, provides the link to the GIS

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22) XCENTRE NUMBER(22) YCENTRE NUMBER(22) HAS_LAND VARCHAR2(1) SELECTED VARCHAR2(1) * Not a simple average (see 'Similarity score' in paragraph Qualification of weather stations).

MAX_FAO

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment GRID_ID NOT NULL NUMBER(22, 10) MAX_FAO NUMBER(22, 4) CROP_ID NOT NULL NUMBER(22, 2)

REGIONS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment REG_ID NOT NULL NUMBER(22) REG_CODE NOT NULL VARCHAR2(10) REG_NAME NOT NULL VARCHAR2(250) REG_LEVEL NOT NULL NUMBER(22) AREA_M2 NOT NULL NUMBER(22) REG_MAP_ID NOT NULL NUMBER(22) REG_MAP_ID_BT NOT NULL NUMBER(22)

SYSTABLES

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment TABLE_NAME NOT NULL VARCHAR2(31) - HIGHEST_ID NUMBER(22) -

TASKS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment TASK_ID NOT NULL NUMBER(22) - YEAR NOT NULL NUMBER(22) DEKAD_IN_YEAR NOT NULL NUMBER(22) CROP_ID NOT NULL NUMBER(22) STATUS_INDICATORS NOT NULL NUMBER(22)

synonyms

content
8.1 DATELIST
8.2 REGION_INFO
8.3 REGION_MAPPINGS
8.4 REGLISTS

DATELIST

• Description:
• Use:
• Type: Synonym ➞ DATELIST@_WSIMAN
• Remarks:

REGION_INFO

• Description:
• Use:
• Type: Synonym ➞ REGION@INFO_WSIMAN
• Remarks:

REGION_MAPPINGS

• Description: regions and their relations (mappings)
• Use: used by many object to find relation between regions of different levels.
• Type: Synonym ➞ REGION@MAPPINGS_WSIMAN
• Remarks: none

* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.

REGLISTS

• Description: synonym to oracle package
• Use: link to REGLISTS
• Type: Synonym ➞ REGLISTS@_WSIMAN
• Remarks: none