Appendix 5: Database objects/CGMS12xxx

note: this page was generated as a round trip of Appendix_5:_CGMS_tables and therefore shoul be identical except for the lay-out.

content
1. CMETEO-datasets
2. COMPLETE-datasets
3. CROP-datasets
4. LINK-datasets
5. RAIN-datasets
6. SIMULATION-datasets
7. SIMYIELD-datasets
8. SOIL-datasets
9. SUPIT-datasets
10. WEATHER-datasets
11. other datasets
12. synonyms

CMETEO-datasets

content
1.1 CMETEO_AEZ_GRID_LANDCOVERS
1.2 CMETEO_AGGREGATION_AREAS
1.3 CMETEO_CROPS
1.4 CMETEO_LANDCOVERS
1.5 CMETEO_REGION_GRID_LANDCOVERS
1.6 CMETEO_WEATHER_OBS_AEZ
1.7 CMETEO_WEATHER_OBS_GRID
1.8 CMETEO_WEATHER_OBS_REGION

CMETEO_AEZ_GRID_LANDCOVERS

Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
Use: input for cmeteo with standardized attribute names
Type: View
Remarks: user defined, derived from GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	unique region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landcover code
AREA	NOT NULL	NUMBER(22, 10)	m2	landcover area within intersection of grid cell en region

definition:

select
   grid_no
  ,reg_map_id
  ,landcover_id
  ,area
from link_aez_grid_landcover

CMETEO_AGGREGATION_AREAS

Description: cultivated areas per region used for spatial aggregation of crop indicators
Use: input for cmeteo, converting names of columns for use in cmeteo package
Type: View
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
REG_CODE	NOT NULL	VARCHAR2(10)	-	region code
YEAR	NOT NULL	NUMBER(22, 4)	-	year for which cultivated area is valid
AREA_CULTIVATED		NUMBER(22, 38)	10^3 Ha	cultivated area

* All attributes Nullable in table versions ** Not in view, only in table

definition:

select
   a.crop_no
 , r.reg_code
 , a.year
 , a.area_cultivated
from
   aggregation_areas a
 , region r
where a.reg_map_id = r.reg_map_id

CMETEO_CROPS

Description: description of crops. Crop name, number, associated crop group and general month.
Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
Type: View
Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 8)	-	crop number
CROP_NAME	NOT NULL	VARCHAR2(40)	-	name of crop
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-	group where crop belongs to
CROP_MODEL	NOT NULL	NUMBER(22, 1)	-	WOFOST (0 of LINGRA (1
START_MONTH	NOT NULL	NUMBER(22, 2)	-	start month of crop season
LANDCOVER_ID		NUMBER(22, 10)	-

definition:

select
  cl.crop_no
 ,cl.crop_name
 ,cl.cropgroup_no
 ,cl.crop_model
 ,cl.start_month
 ,cl.landcover_id
from crop cl
where cl.crop_no > 0
and cl.crop_no < 100

CMETEO_LANDCOVERS

Description:
Use: input for cmeteo, renaming columns to a standardized naming
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit
CROP_NO	NOT NULL	NUMBER(22, 8)	-
CROP_NAME	NOT NULL	VARCHAR2(40)	-
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)
CROP_MODEL	NOT NULL	NUMBER(22, 1)
START_MONTH	NOT NULL	NUMBER(22, 2)
LANDCOVER_ID		NUMBER(22, 10)
STARTMONTH_ASIA		NUMBER(22)

* All attributes Nullable in table versions

definition:

select
  crop_no
 ,crop_name
 ,cropgroup_no
 ,crop_model
 ,start_month
 ,landcover_id
 ,0 as startmonth_asia
from crop_landcover

CMETEO_REGION_GRID_LANDCOVERS

Description: landcover areas for each intersection of grid and administartive region (only level 3).
Use: input for cmeteo with standardized attribute names
Type: View
Remarks: user defined, derived from GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	unique region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landcover code
AREA	NOT NULL	NUMBER(22, 10)	m2	landcover area within intersection of grid cell en region

definition:

select
   grid_no
  ,reg_map_id
  ,landcover_id
  ,area
from link_region_grid_landcover

CMETEO_WEATHER_OBS_AEZ

Description: weather indicators per agri-environmental region
Use: input for cmeteo, renaming columns to a standardized naming
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	agro-environmental region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landmask / cropmask id
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY	NOT NULL	DATE	-	calendar day
DAY_OFFSET		NUMBER(22)		0 as day_offset
MEMBER_NO		NUMBER(22)		1 as member_no
MAX_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	maximum daily air temperature
MIN_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	minimum daily air temperature
MEAN_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	average daily air temperature
DEW_TEMPERATURE		NUMBER(22)		to_number(null as dew_temperature
VAPOUR_PRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WIND_SPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
GLOBAL_RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOW_DEPTH		NUMBER(22, 6)	cm	daily mean snow depth
SNOW_WEQ		NUMBER(22)		to_number(null as snow_weq
FRACTIONS		TD_THRESHOLD_VALUES

definition:

select
  woa.reg_map_id
 ,woa.landcover_id
 ,woa.threshold
 ,woa.day
 ,0                     day_offset
 ,1                     member_no
 ,woa.temperature_max
 ,woa.temperature_min
 ,woa.temperature_avg
 ,to_number(null)       dew_temperature
 ,woa.vapourpressure
 ,woa.windspeed
 ,woa.precipitation
 ,woa.e0
 ,woa.es0
 ,woa.et0
 ,woa.radiation
 ,woa.snowdepth
 ,to_number(null)       snow_weq
 ,td_threshold_values
   (td_threshold_value('FRAC_AREA_TEMP_MAX'     , 25, woa.frac_area_temp_max_ge_25)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 30, woa.frac_area_temp_max_ge_30)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 35, woa.frac_area_temp_max_ge_35)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 40, woa.frac_area_temp_max_ge_40)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,  0, woa.frac_area_temp_min_le_0)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     , -8, woa.frac_area_temp_min_le_min8)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-10, woa.frac_area_temp_min_le_min10)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-18, woa.frac_area_temp_min_le_min18)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-20, woa.frac_area_temp_min_le_min20)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  1, woa.frac_area_precipitation_ge_1)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  3, woa.frac_area_precipitation_ge_3)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  5, woa.frac_area_precipitation_ge_5)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, woa.frac_area_precipitation_ge_10)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, woa.frac_area_precipitation_ge_15)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, woa.frac_area_precipitation_ge_30)
   ,td_threshold_value('AVG_TEMP'               ,  0, woa.avg_temp_ge_0)
   ,td_threshold_value('AVG_TEMP'               ,  2, woa.avg_temp_ge_2)
   ,td_threshold_value('AVG_TEMP'               ,  4, woa.avg_temp_ge_4)
   ,td_threshold_value('AVG_TEMP'               ,  6, woa.avg_temp_ge_6)
   ,td_threshold_value('AVG_TEMP'               ,  8, woa.avg_temp_ge_8)
   ,td_threshold_value('AVG_TEMP'               , 10, woa.avg_temp_ge_10)
   )                    fractions
from weather_obs_aez  woa

CMETEO_WEATHER_OBS_GRID

Description: weather indicators per grid
Use: input for cmeteo, renaming columns to a standardized naming
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY	NOT NULL	DATE	-	calendar day
DAY_OFFSET		NUMBER(22)		0 as day_offset
MEMBER_NO		NUMBER(22)		1 as member_no
MAX_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	maximum air temperature
MIN_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	minimum air temperature
MEAN_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	average daily air temperature
DEW_TEMPERATURE		NUMBER(22)		0 as dew_temperature
VAPOUR_PRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WIND_SPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
GLOBAL_RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOW_DEPTH		NUMBER(22, 6)	cm	daily mean snow depth
SNOW_WEQ		NUMBER(22)		to_number(null as snow_weq

definition:

select
  grid_no
 ,day
 ,0                as day_offset
 ,1                as member_no
 ,temperature_max
 ,temperature_min
 ,temperature_avg
 ,0                as dew_temperature
 ,vapourpressure
 ,windspeed
 ,precipitation
 ,e0
 ,es0
 ,et0
 ,radiation
 ,snowdepth
 ,to_number(null)  as snow_weq
from weather_obs_grid

CMETEO_WEATHER_OBS_REGION

Description: weather indicators per region
Use: input for cmeteo, renaming columns to a standardized naming
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY	NOT NULL	DATE	-	calendar day
DAY_OFFSET		NUMBER(22)		0 as day_offset
MEMBER_NO		NUMBER(22)		1 as member_no
MAX_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	maximum daily air temperature
MIN_TEMPERATURE	NOT NULL	NUMBER(22, 3)	°C	minimum daily air temperature
MEAN_TEMPERATURE	NOT NULL	NUMBER(22, 3)
DEW_TEMPERATURE		NUMBER(22)		to_number(null as dew_temperature
VAPOUR_PRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WIND_SPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
GLOBAL_RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOW_DEPTH		NUMBER(22, 6)	cm	daily mean snow depth
SNOW_WEQ		NUMBER(22)		to_number(null as snow_weq
FRACTIONS		TD_THRESHOLD_VALUES

definition:

select
  wor.reg_map_id
 ,wor.landcover_id
 ,wor.threshold
 ,wor.day
 ,0                     day_offset
 ,1                     member_no
 ,wor.temperature_max
 ,wor.temperature_min
 ,wor.temperature_avg
 ,to_number(null)       dew_temperature
 ,wor.vapourpressure
 ,wor.windspeed
 ,wor.precipitation
 ,wor.e0
 ,wor.es0
 ,wor.et0
 ,wor.radiation
 ,wor.snowdepth
 ,to_number(null)       snow_weq
 ,td_threshold_values
   (td_threshold_value('FRAC_AREA_TEMP_MAX'     , 25, wor.frac_area_temp_max_ge_25)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 30, wor.frac_area_temp_max_ge_30)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 35, wor.frac_area_temp_max_ge_35)
   ,td_threshold_value('FRAC_AREA_TEMP_MAX'     , 40, wor.frac_area_temp_max_ge_40)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,  0, wor.frac_area_temp_min_le_0)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     , -8, wor.frac_area_temp_min_le_min8)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-10, wor.frac_area_temp_min_le_min10)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-18, wor.frac_area_temp_min_le_min18)
   ,td_threshold_value('FRAC_AREA_TEMP_MIN'     ,-20, wor.frac_area_temp_min_le_min20)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  1, wor.frac_area_precipitation_ge_1)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  3, wor.frac_area_precipitation_ge_3)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION',  5, wor.frac_area_precipitation_ge_5)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, wor.frac_area_precipitation_ge_10)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, wor.frac_area_precipitation_ge_15)
   ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, wor.frac_area_precipitation_ge_30)
   ,td_threshold_value('AVG_TEMP'               ,  0, wor.avg_temp_ge_0)
   ,td_threshold_value('AVG_TEMP'               ,  2, wor.avg_temp_ge_2)
   ,td_threshold_value('AVG_TEMP'               ,  4, wor.avg_temp_ge_4)
   ,td_threshold_value('AVG_TEMP'               ,  6, wor.avg_temp_ge_6)
   ,td_threshold_value('AVG_TEMP'               ,  8, wor.avg_temp_ge_8)
   ,td_threshold_value('AVG_TEMP'               , 10, wor.avg_temp_ge_10)
   )                    fractions
from weather_obs_region   wor

COMPLETE-datasets

content
2.1 COMPLETE_LIST_OF_SIM_UNITS
2.2 COMPLETE_LIST_OF_SIM_UNITS_X

COMPLETE_LIST_OF_SIM_UNITS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NAME		VARCHAR2(40)
GRID_NO	NOT NULL	NUMBER(22, 8)
STU_NO	NOT NULL	NUMBER(22, 8)
CROP_NO	NOT NULL	NUMBER(22, 8)

COMPLETE_LIST_OF_SIM_UNITS_X

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 8)
CROP_NAME	NOT NULL	VARCHAR2(40)
GRID_NO	NOT NULL	NUMBER(22, 8)
STU_NO	NOT NULL	NUMBER(22, 8)

definition:

select distinct
    x.crop_no
  , x.crop_name
  , e.grid_no
  , t.stu_no
from
    soil_association_composition s
  , emu e
  , smu_suitability u
  , suitability t
  , crop x
  , crop_calendar c
where s.smu_no       = e.smu_no
and   s.stu_no       = t.stu_no
and   e.smu_no       = u.smu_no
and   u.cropgroup_no = t.cropgroup_no
and   x.cropgroup_no = t.cropgroup_no
and   x.crop_no      = c.crop_no
and   c.grid_no      = e.grid_no
and   c.year         = 2014
and   c.crop_no      in (1,3,2,8,7,6,10,15,9,11,4,13)

CROP-datasets

content
3.1 CROP_CALENDAR
3.2 CROP_GROUP
3.3 CROP_LANDCOVER
3.4 CROP_PARAMETER_VALUE

CROP_CALENDAR

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
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
VARIETY_NO	NOT NULL	NUMBER(22, 4)	-	variety number
YEAR	NOT NULL	NUMBER(22, 4)	-	calendar year
START_TYPE	NOT NULL	VARCHAR2(20)
START_DATE	NOT NULL	DATE	-	start of planting/sowing window
START_WINDOW	NOT NULL	NUMBER(22, 3)	number of day's	length of planting/sowing window
END_TYPE	NOT NULL	VARCHAR2(20)
END_DATE		DATE	-
MAX_DURATION		NUMBER(22, 3)	number of day's	maximum duration of crop season
SYS_STSWTD#8$_VMJFQ1ADV99QGLUE		NUMBER(22)
SYS_STSC6_77QSN5A286MN9F5BC_TE		NUMBER(22)

* 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_GROUP

Description: description of crop groups
Use: input table for the crop group number and name where crop belongs to
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-	group where crop belongs to
CROPGROUP_NAME	NOT NULL	VARCHAR2(40)	-	name of crop group

CROP_LANDCOVER

Description:
Use: source for various views & synonyms
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
CROP_NO	NOT NULL	NUMBER(22, 8)	-
CROP_NAME	NOT NULL	VARCHAR2(40)	-
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-
CROP_MODEL	NOT NULL	NUMBER(22, 1)	-
START_MONTH	NOT NULL	NUMBER(22, 2)	-
LANDCOVER_ID		NUMBER(22, 10)	-

CROP_PARAMETER_VALUE

Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
Use: input table for the crop simulation process
Type: Table
Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
PARAMETER_CODE	NOT NULL	VARCHAR2(20)	-	character code of crop parameter
PARAMETER_XVALUE	NOT NULL	NUMBER(22, 38)	-	crop parameter value
PARAMETER_YVALUE		NUMBER(22, 38)	-	crop parameter value - multiple

LINK-datasets

content
4.1 LINK_AEZ_GRID_LANDCOVER
4.2 LINK_EMU_REGION
4.3 LINK_EMU_REGION_LANDCOVER
4.4 LINK_REGION_GRID_LANDCOVER
4.5 LINK_STATION_GRID

LINK_AEZ_GRID_LANDCOVER

Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
Use: input for cmeteo
Type: Table
Remarks: user defined, derived from GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	agri-environmental region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landcover code
AREA	NOT NULL	NUMBER(22, 10)	m2	landcover area within intersection of grid cell en region

LINK_EMU_REGION

Description: intersection of grid, administrative regions and soil mapping units, and their area.
Use: input/reference table for the crop simulation process
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
AREA	NOT NULL	NUMBER(22, 10)	m2	total area of intersection between elementary mapping unit and grid cell

LINK_EMU_REGION_LANDCOVER

Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
Use: input/reference table for the crop simulation process
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
AREA	NOT NULL	NUMBER(22, 10)	m2	crop area of intersection between elementary mapping unit and grid cell

LINK_REGION_GRID_LANDCOVER

Description: landcover areas for each intersection of grid and NUTS region (only level 3).
Use: input for cmeteo
Type: Table
Remarks: user defined, derived from GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	unique region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landcover code
AREA	NOT NULL	NUMBER(22, 10)	m2	landcover area within intersection of grid cell en region

LINK_STATION_GRID

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
GRID_NO	NOT NULL	NUMBER(22, 8)	-
DISTANCE		NUMBER(22, 10)

RAIN-datasets

content
5.1 RAIN_OBS_STATION
5.2 RAIN_OBS_STATION_INFO
5.3 RAIN_OBS_STATION_RAW

RAIN_OBS_STATION

Description: contains the station based 6-hourly rainfall data
Use: input level 1
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-	station number
DAY	NOT NULL	DATE	-	calendar day
HOUR	NOT NULL	VARCHAR2(5)	hh:mm	UTC end time of the 6-hourly period
PRECIPITATION		NUMBER(22, 6)	mm/6h	6-hourly rainfall sum
SYS_STSULD_6L8BYSKKCR1Q6W_0609		NUMBER(22)

RAIN_OBS_STATION_INFO

Description: table for storing specific metadata for 6-hourly rainfall data (flags)
Use: meta data
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY	NOT NULL	DATE	-
HOUR	NOT NULL	VARCHAR2(5)	-
PRECIPITATION		NUMBER(22, 2)	-	flag*
SYS_STSULD_6L8BYSKKCR1Q6W_0609		NUMBER(22)

* Possible values for precipitation (flags):
1 Changed by meteoroloog
2 Automaticaly corrected
3 Observation
4 Lineair interpolation from observations
5 Interpolated via MOS from observations
6 MOS analyses

RAIN_OBS_STATION_RAW

Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
Use: input level 1
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY	NOT NULL	VARCHAR2(16)	-
PRECIPITATION		NUMBER(22, 6)	-
PRECIPITATION_INFO		NUMBER(22, 2)	-

SIMULATION-datasets

content
6.1 SIMULATION_LOG
6.2 SIMULATION_UNIT
6.3 SIMULATION_UNIT_ALL

SIMULATION_LOG

Description: contains information about simulation
Use: reference table
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
YEAR	NOT NULL	NUMBER(22, 4)	-
GRID_NO	NOT NULL	NUMBER(22, 8)	-
CROP_NO	NOT NULL	NUMBER(22, 4)	-
VARIETY_NO	NOT NULL	NUMBER(22, 4)	-
SOWING_DATE		DATE	-
EMERGENCE_DATE		DATE	-
ANTHESIS_DATE		DATE	-
END_DATE		DATE	-
STATUS		VARCHAR2(250)	-

Possible status messeges:

BND: Number of leaf classes exceeds 365
DEC: Exceeded end decade, but not yet lifemax
DVS: DVS >= DVSEND (development stage)
EBE: End date before emergence
EME: Invalid emergence date (either from sowing, or fixed emergence (CC))
IED: Invalid end date
LAI: No living leaves (anymore)
LAY: No soil layers found
MAX: Exceeded lifemax (as read from database)
MFI: Maximum Flow Iteration exceeded
MSL: Number of soil layers exceeds maximum number
NEQ: Number of simulated rows for potential and water limited not equal
NGW: No grid weather for this grid
NSU: No simulation units for this grid
RDM: Does not coincide with a layer boundary
SOW: Invalid sowing date (either from variable sowing, or fixed sowing (CC))
WLG: Crop failure due to waterlogging
???: Unknown

SIMULATION_UNIT

Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
Use: lookup table used during crop simulation
Type: View
Remarks: the content of this table is based on the intersection of soil map and climatic grid, excluding intersections (STU's) that are unsuitable for crop growth.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
STU_NO	NOT NULL	NUMBER(22, 8)	-	soil typological unit number

definition:

SELECT "CROP_NO","GRID_NO","STU_NO" from SIMULATION_UNIT_ALL
--where grid_no in (69093)

SIMULATION_UNIT_ALL

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
STU_NO	NOT NULL	NUMBER(22, 8)

SIMYIELD-datasets

content
7.1 SIMYIELD_BLAST_GRID
7.2 SIMYIELD_BLAST_GRID_LOG
7.3 SIMYIELD_BLAST_GRID_LTA
7.4 SIMYIELD_BLAST_REGION
7.5 SIMYIELD_BLAST_REGION_LOG
7.6 SIMYIELD_BLAST_REGION_LTA
7.7 SIMYIELD_EMU
7.8 SIMYIELD_EMU_LOG
7.9 SIMYIELD_EMU_LTA
7.10 SIMYIELD_GRID
7.11 SIMYIELD_GRID_LOG
7.12 SIMYIELD_GRID_LTA
7.13 SIMYIELD_REGION
7.14 SIMYIELD_REGION_LOG
7.15 SIMYIELD_REGION_LTA
7.16 SIMYIELD_STU
7.17 SIMYIELD_WARM_GRID
7.18 SIMYIELD_WARM_GRID_LOG
7.19 SIMYIELD_WARM_GRID_LTA
7.20 SIMYIELD_WARM_REGION
7.21 SIMYIELD_WARM_REGION_LOG
7.22 SIMYIELD_WARM_REGION_LTA

SIMYIELD_BLAST_GRID

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
ID_SIM_ENV	NOT NULL	NUMBER(22, 8)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIMYIELD_BLAST_GRID_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
ID_SIM_ENV	NOT NULL	NUMBER(22, 8)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIMYIELD_BLAST_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_BLASTRISKLEVEL		NUMBER(22, 8)
AVG_BLASTINFECTION		NUMBER(22, 1)
AVG_BLASTSPORULATION		NUMBER(22, 1)
AVG_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
AVG_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
AVG_GAIPOTENTIAL		NUMBER(22, 12)
AVG_GAIWITHBLAST		NUMBER(22, 12)
AVG_AGBPOTENTIAL		NUMBER(22, 12)
AVG_AGBWITHBLAST		NUMBER(22, 12)
AVG_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
AVG_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
AVG_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
AVG_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_RUE_POTENTIAL		NUMBER(22, 12)
AVG_RUE_WITH_BLAST		NUMBER(22, 12)
AVG_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
AVG_HUMIDITYMINIMUM		NUMBER(22, 12)
AVG_HUMIDITYMAXIMUM		NUMBER(22, 12)
MIN_BLASTRISKLEVEL		NUMBER(22, 8)
MIN_BLASTINFECTION		NUMBER(22, 1)
MIN_BLASTSPORULATION		NUMBER(22, 1)
MIN_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MIN_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MIN_GAIPOTENTIAL		NUMBER(22, 12)
MIN_GAIWITHBLAST		NUMBER(22, 12)
MIN_AGBPOTENTIAL		NUMBER(22, 12)
MIN_AGBWITHBLAST		NUMBER(22, 12)
MIN_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MIN_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MIN_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MIN_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_RUE_POTENTIAL		NUMBER(22, 12)
MIN_RUE_WITH_BLAST		NUMBER(22, 12)
MIN_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MIN_HUMIDITYMINIMUM		NUMBER(22, 12)
MIN_HUMIDITYMAXIMUM		NUMBER(22, 12)
MAX_BLASTRISKLEVEL		NUMBER(22, 8)
MAX_BLASTINFECTION		NUMBER(22, 1)
MAX_BLASTSPORULATION		NUMBER(22, 1)
MAX_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MAX_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MAX_GAIPOTENTIAL		NUMBER(22, 12)
MAX_GAIWITHBLAST		NUMBER(22, 12)
MAX_AGBPOTENTIAL		NUMBER(22, 12)
MAX_AGBWITHBLAST		NUMBER(22, 12)
MAX_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MAX_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MAX_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MAX_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_RUE_POTENTIAL		NUMBER(22, 12)
MAX_RUE_WITH_BLAST		NUMBER(22, 12)
MAX_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MAX_HUMIDITYMINIMUM		NUMBER(22, 12)
MAX_HUMIDITYMAXIMUM		NUMBER(22, 12)
STD_BLASTRISKLEVEL		NUMBER(22, 8)
STD_BLASTINFECTION		NUMBER(22, 1)
STD_BLASTSPORULATION		NUMBER(22, 1)
STD_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
STD_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
STD_GAIPOTENTIAL		NUMBER(22, 12)
STD_GAIWITHBLAST		NUMBER(22, 12)
STD_AGBPOTENTIAL		NUMBER(22, 12)
STD_AGBWITHBLAST		NUMBER(22, 12)
STD_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STD_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
STD_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
STD_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_RUE_POTENTIAL		NUMBER(22, 12)
STD_RUE_WITH_BLAST		NUMBER(22, 12)
STD_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
STD_HUMIDITYMINIMUM		NUMBER(22, 12)
STD_HUMIDITYMAXIMUM		NUMBER(22, 12)
NUM_BLASTRISKLEVEL		NUMBER(22, 2)
NUM_BLASTINFECTION		NUMBER(22, 2)
NUM_BLASTSPORULATION		NUMBER(22, 2)
NUM_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 2)
NUM_LEAVESBIOMASSWITHBLAST		NUMBER(22, 2)
NUM_GAIPOTENTIAL		NUMBER(22, 2)
NUM_GAIWITHBLAST		NUMBER(22, 2)
NUM_AGBPOTENTIAL		NUMBER(22, 2)
NUM_AGBWITHBLAST		NUMBER(22, 2)
NUM_STORAGEORGANSPOTENTIAL		NUMBER(22, 2)
NUM_STORAGEORGANSWITHBLAST		NUMBER(22, 2)
NUM_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 2)
NUM_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_RUE_POTENTIAL		NUMBER(22, 2)
NUM_RUE_WITH_BLAST		NUMBER(22, 2)
NUM_BLAST_EFFECT_ON_RUE		NUMBER(22, 2)
NUM_HUMIDITYMINIMUM		NUMBER(22, 2)
NUM_HUMIDITYMAXIMUM		NUMBER(22, 2)

SIMYIELD_BLAST_REGION

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIMYIELD_BLAST_REGION_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIMYIELD_BLAST_REGION_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_BLASTRISKLEVEL		NUMBER(22, 8)
AVG_BLASTINFECTION		NUMBER(22, 1)
AVG_BLASTSPORULATION		NUMBER(22, 1)
AVG_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
AVG_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
AVG_GAIPOTENTIAL		NUMBER(22, 12)
AVG_GAIWITHBLAST		NUMBER(22, 12)
AVG_AGBPOTENTIAL		NUMBER(22, 12)
AVG_AGBWITHBLAST		NUMBER(22, 12)
AVG_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
AVG_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
AVG_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
AVG_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_RUE_POTENTIAL		NUMBER(22, 12)
AVG_RUE_WITH_BLAST		NUMBER(22, 12)
AVG_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
AVG_HUMIDITYMINIMUM		NUMBER(22, 12)
AVG_HUMIDITYMAXIMUM		NUMBER(22, 12)
MIN_BLASTRISKLEVEL		NUMBER(22, 8)
MIN_BLASTINFECTION		NUMBER(22, 1)
MIN_BLASTSPORULATION		NUMBER(22, 1)
MIN_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MIN_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MIN_GAIPOTENTIAL		NUMBER(22, 12)
MIN_GAIWITHBLAST		NUMBER(22, 12)
MIN_AGBPOTENTIAL		NUMBER(22, 12)
MIN_AGBWITHBLAST		NUMBER(22, 12)
MIN_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MIN_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MIN_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MIN_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_RUE_POTENTIAL		NUMBER(22, 12)
MIN_RUE_WITH_BLAST		NUMBER(22, 12)
MIN_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MIN_HUMIDITYMINIMUM		NUMBER(22, 12)
MIN_HUMIDITYMAXIMUM		NUMBER(22, 12)
MAX_BLASTRISKLEVEL		NUMBER(22, 8)
MAX_BLASTINFECTION		NUMBER(22, 1)
MAX_BLASTSPORULATION		NUMBER(22, 1)
MAX_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MAX_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MAX_GAIPOTENTIAL		NUMBER(22, 12)
MAX_GAIWITHBLAST		NUMBER(22, 12)
MAX_AGBPOTENTIAL		NUMBER(22, 12)
MAX_AGBWITHBLAST		NUMBER(22, 12)
MAX_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MAX_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MAX_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MAX_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_RUE_POTENTIAL		NUMBER(22, 12)
MAX_RUE_WITH_BLAST		NUMBER(22, 12)
MAX_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MAX_HUMIDITYMINIMUM		NUMBER(22, 12)
MAX_HUMIDITYMAXIMUM		NUMBER(22, 12)
STD_BLASTRISKLEVEL		NUMBER(22, 8)
STD_BLASTINFECTION		NUMBER(22, 1)
STD_BLASTSPORULATION		NUMBER(22, 1)
STD_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
STD_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
STD_GAIPOTENTIAL		NUMBER(22, 12)
STD_GAIWITHBLAST		NUMBER(22, 12)
STD_AGBPOTENTIAL		NUMBER(22, 12)
STD_AGBWITHBLAST		NUMBER(22, 12)
STD_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STD_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
STD_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
STD_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_RUE_POTENTIAL		NUMBER(22, 12)
STD_RUE_WITH_BLAST		NUMBER(22, 12)
STD_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
STD_HUMIDITYMINIMUM		NUMBER(22, 12)
STD_HUMIDITYMAXIMUM		NUMBER(22, 12)
NUM_BLASTRISKLEVEL		NUMBER(22, 2)
NUM_BLASTINFECTION		NUMBER(22, 2)
NUM_BLASTSPORULATION		NUMBER(22, 2)
NUM_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 2)
NUM_LEAVESBIOMASSWITHBLAST		NUMBER(22, 2)
NUM_GAIPOTENTIAL		NUMBER(22, 2)
NUM_GAIWITHBLAST		NUMBER(22, 2)
NUM_AGBPOTENTIAL		NUMBER(22, 2)
NUM_AGBWITHBLAST		NUMBER(22, 2)
NUM_STORAGEORGANSPOTENTIAL		NUMBER(22, 2)
NUM_STORAGEORGANSWITHBLAST		NUMBER(22, 2)
NUM_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 2)
NUM_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_RUE_POTENTIAL		NUMBER(22, 2)
NUM_RUE_WITH_BLAST		NUMBER(22, 2)
NUM_BLAST_EFFECT_ON_RUE		NUMBER(22, 2)
NUM_HUMIDITYMINIMUM		NUMBER(22, 2)
NUM_HUMIDITYMAXIMUM		NUMBER(22, 2)

SIMYIELD_EMU

Description: results of the crop simulation per emu. Level 2 output based on weather observations
Use: output table for the crop simulation process
Type: Table
Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
DAY	NOT NULL	DATE	-	day
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	folumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD		NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF		NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION		NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL		NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop
SYS_STSYYVWSSFG040S#TTSZ4#AZHU		NUMBER(22)
SYS_STSVI6U7RSQJ3QIMWUW5LDQNE2		NUMBER(22)
SYS_STS6GWE0R6M6BOZ05VYX6X0LBJ		NUMBER(22)

SIMYIELD_EMU_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
SMU_NO	NOT NULL	NUMBER(22, 8)
DAY	NOT NULL	DATE
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)
FSM	NOT NULL	NUMBER(22, 3)
FSMUR	NOT NULL	NUMBER(22, 3)
LEAVES_DIED_BY_COLD		NUMBER(22, 8)
RUNOFF		NUMBER(22, 8)
SOIL_EVAPORATION		NUMBER(22, 8)
LOSS_TO_SUBSOIL		NUMBER(22, 8)

SIMYIELD_EMU_LTA

Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
Use: Output table for the crop simulation process.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
DAY_NO	NOT NULL	VARCHAR2(4)	-	day number in year (1-366
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF	NOT NULL	NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_GRID

Description: results of the crop simulation per grid. Level 2 output, based observed weather.
Use: output table for the crop simulation process
Type: Table
Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY	NOT NULL	DATE	-	day
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	folumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD		NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF		NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION		NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL		NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_GRID_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
DAY	NOT NULL	DATE
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)
FSM	NOT NULL	NUMBER(22, 3)
FSMUR	NOT NULL	NUMBER(22, 3)
LEAVES_DIED_BY_COLD		NUMBER(22, 8)
RUNOFF		NUMBER(22, 8)
SOIL_EVAPORATION		NUMBER(22, 8)
LOSS_TO_SUBSOIL		NUMBER(22, 8)

SIMYIELD_GRID_LTA

Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
Use: Output table for the crop simulation process.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
DAY_NO	NOT NULL	VARCHAR2(4)	-	day number in year (1-366
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF	NOT NULL	NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop
MIN_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MIN_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MIN_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
MIN_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
MIN_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
MIN_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
MIN_FSM	NOT NULL	NUMBER(22, 3)	-
MIN_FSMUR	NOT NULL	NUMBER(22, 3)	-
MIN_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
MIN_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
MIN_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
MIN_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
MAX_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MAX_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MAX_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
MAX_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
MAX_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
MAX_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
MAX_FSM	NOT NULL	NUMBER(22, 3)	-
MAX_FSMUR	NOT NULL	NUMBER(22, 3)	-
MAX_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
MAX_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
MAX_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
MAX_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
STD_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
STD_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
STD_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
STD_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
STD_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
STD_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
STD_FSM	NOT NULL	NUMBER(22, 3)	-
STD_FSMUR	NOT NULL	NUMBER(22, 3)	-
STD_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
STD_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
STD_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
STD_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
NUM_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 4)	-
NUM_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 4)	-
NUM_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 4)	-
NUM_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
NUM_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 4)	-
NUM_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 4)	-
NUM_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 4)	-
NUM_FSM	NOT NULL	NUMBER(22, 4)	-
NUM_FSMUR	NOT NULL	NUMBER(22, 4)	-
NUM_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 4)	-
NUM_RUNOFF	NOT NULL	NUMBER(22, 4)	-
NUM_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 4)	-
NUM_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 4)	-

SIMYIELD_REGION

Description: results of the crop simulation per administrative region. Level 2 output
Use: output table for the crop simulation process
Type: Table
Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
DAY	NOT NULL	DATE	-	day
REG_MAP_ID	NOT NULL	NUMBER(22, 8)	-	administrative region code
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	folumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD		NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF		NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION		NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL		NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_REGION_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
DAY	NOT NULL	DATE
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)
FSM	NOT NULL	NUMBER(22, 3)
FSMUR	NOT NULL	NUMBER(22, 3)
LEAVES_DIED_BY_COLD		NUMBER(22, 8)
RUNOFF		NUMBER(22, 8)
SOIL_EVAPORATION		NUMBER(22, 8)
LOSS_TO_SUBSOIL		NUMBER(22, 8)

SIMYIELD_REGION_LTA

Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
Use: Output table for the crop simulation process.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
DAY_NO	NOT NULL	VARCHAR2(4)	-	day number in year (1-366
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region code
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm	sum of potential transpiration
FSM	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in rooted zone
FSMUR	NOT NULL	NUMBER(22, 3)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-	fraction of leaves died by cold wrt total biomass
RUNOFF	NOT NULL	NUMBER(22, 8)	cm	run off
SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm	soil evaporation
LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm	amount of water drained to the sub soil and therefore lost for the crop
MIN_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MIN_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MIN_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MIN_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
MIN_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
MIN_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
MIN_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
MIN_FSM	NOT NULL	NUMBER(22, 3)	-
MIN_FSMUR	NOT NULL	NUMBER(22, 3)	-
MIN_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
MIN_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
MIN_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
MIN_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
MAX_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
MAX_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MAX_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
MAX_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
MAX_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
MAX_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
MAX_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
MAX_FSM	NOT NULL	NUMBER(22, 3)	-
MAX_FSMUR	NOT NULL	NUMBER(22, 3)	-
MAX_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
MAX_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
MAX_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
MAX_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
STD_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)	kg.ha-1
STD_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
STD_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)	m2.m2
STD_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
STD_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)	-
STD_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)	cm
STD_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)	cm
STD_FSM	NOT NULL	NUMBER(22, 3)	-
STD_FSMUR	NOT NULL	NUMBER(22, 3)	-
STD_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 8)	-
STD_RUNOFF	NOT NULL	NUMBER(22, 8)	cm
STD_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 8)	cm
STD_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 8)	cm
NUM_POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 4)	-
NUM_POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 4)	-
NUM_POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 4)	-
NUM_WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 4)	-
NUM_DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)	-
NUM_RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 4)	-
NUM_TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 4)	-
NUM_TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 4)	-
NUM_FSM	NOT NULL	NUMBER(22, 4)	-
NUM_FSMUR	NOT NULL	NUMBER(22, 4)	-
NUM_LEAVES_DIED_BY_COLD	NOT NULL	NUMBER(22, 4)	-
NUM_RUNOFF	NOT NULL	NUMBER(22, 4)	-
NUM_SOIL_EVAPORATION	NOT NULL	NUMBER(22, 4)	-
NUM_LOSS_TO_SUBSOIL	NOT NULL	NUMBER(22, 4)	-

SIMYIELD_STU

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
STU_NO	NOT NULL	NUMBER(22, 8)
DAY	NOT NULL	DATE
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22, 5)
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22, 8)
FSM	NOT NULL	NUMBER(22, 3)
FSMUR	NOT NULL	NUMBER(22, 3)
LEAVES_DIED_BY_COLD		NUMBER(22, 8)
RUNOFF		NUMBER(22, 8)
SOIL_EVAPORATION		NUMBER(22, 8)
LOSS_TO_SUBSOIL		NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
ID_SERIES	NOT NULL	NUMBER(22)
SYS_STS$3#JU9RUMW#9XG9P5J1TN30		NUMBER(22)
SYS_STSRG8UZ53W2BO9W4QAPBNXVD1		NUMBER(22)
SYS_STSR_XZ04EGL25RJLOQHPKXBTB		NUMBER(22)

SIMYIELD_WARM_GRID

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DECADE	NOT NULL	NUMBER(22, 2)
ID_SIM_ENV	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIMYIELD_WARM_GRID_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DECADE	NOT NULL	NUMBER(22, 2)
ID_SIM_ENV	NOT NULL	NUMBER(22, 8)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIMYIELD_WARM_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
GRID_NO	NOT NULL	NUMBER(22, 8)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 12)
AVG_SPIKELET_STERILITY		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_TRANSPIRATION		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 12)
MIN_SPIKELET_STERILITY		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_TRANSPIRATION		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 12)
MAX_SPIKELET_STERILITY		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_TRANSPIRATION		NUMBER(22, 12)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
STD_DEVELOPMENT_STAGE		NUMBER(22, 12)
STD_SPIKELET_STERILITY		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
STD_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_TRANSPIRATION		NUMBER(22, 12)
NUM_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_POTENTIAL_YIELD_STORAGE		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 2)
NUM_DEVELOPMENT_STAGE		NUMBER(22, 2)
NUM_SPIKELET_STERILITY		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_TRANSPIRATION		NUMBER(22, 2)

SIMYIELD_WARM_REGION

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DECADE	NOT NULL	NUMBER(22, 2)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIMYIELD_WARM_REGION_LOG

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDRUN	NOT NULL	DATE
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
YEAR	NOT NULL	NUMBER(22, 4)
DECADE	NOT NULL	NUMBER(22, 2)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIMYIELD_WARM_REGION_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CROP_NO	NOT NULL	NUMBER(22, 4)
REG_MAP_ID	NOT NULL	NUMBER(22, 8)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 12)
AVG_SPIKELET_STERILITY		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_TRANSPIRATION		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 12)
MIN_SPIKELET_STERILITY		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_TRANSPIRATION		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 12)
MAX_SPIKELET_STERILITY		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_TRANSPIRATION		NUMBER(22, 12)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
STD_DEVELOPMENT_STAGE		NUMBER(22, 12)
STD_SPIKELET_STERILITY		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
STD_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_TRANSPIRATION		NUMBER(22, 12)
NUM_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_POTENTIAL_YIELD_STORAGE		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 2)
NUM_DEVELOPMENT_STAGE		NUMBER(22, 2)
NUM_SPIKELET_STERILITY		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_TRANSPIRATION		NUMBER(22, 2)

SOIL-datasets

content
8.1 SOIL_ASSOCIATION_COMPOSITION
8.2 SOIL_DATA_FOR_BIOMA
8.3 SOIL_MAPPING_UNIT
8.4 SOIL_PHYSICAL_GROUP
8.5 SOIL_TYPOLOGIC_UNIT

SOIL_ASSOCIATION_COMPOSITION

Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
Type: Table
Remarks: derived from the soil map

Structure

Attribute	Constraint	Type	Unit	Comment
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
STU_NO	NOT NULL	NUMBER(22, 8)	-	soil typologic unit number
PERCENTAGE	NOT NULL	NUMBER(22, 3)	%	share of soil typologic unit in soil mapping unit

SOIL_DATA_FOR_BIOMA

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
STU_NO	NOT NULL	NUMBER(22, 8)
SOIL_WRB	NOT NULL	VARCHAR2(8)
SOIL_WRB_CL	NOT NULL	VARCHAR2(1)
SOIL_FAO90	NOT NULL	VARCHAR2(8)
SOIL_FAO90_CL	NOT NULL	VARCHAR2(1)
SOIL	NOT NULL	VARCHAR2(8)
SOIL_FAO85_CL	NOT NULL	VARCHAR2(1)
SLOPE1	NOT NULL	VARCHAR2(1)
TEXT1	NOT NULL	VARCHAR2(1)
PHASE1	NOT NULL	VARCHAR2(2)
CALCULATED_ROOTING_DEPTH	NOT NULL	NUMBER(22, 5)
SOIL_GROUP_NO	NOT NULL	NUMBER(22, 3)
DRAINAGE	NOT NULL	VARCHAR2(2)
ALKALINITY	NOT NULL	VARCHAR2(1)
SALINITY	NOT NULL	VARCHAR2(1)
PARAMETER_CODE	NOT NULL	VARCHAR2(30)
PARAMETER_XVALUE	NOT NULL	NUMBER(22, 38)
PARAMETER_YVALUE		NUMBER(22, 38)
MIN_DEPTH	NOT NULL	NUMBER(22, 5)

definition:

select
    h.stu_no
  , h.soil_wrb
  , h.soil_wrb_cl
  , h.soil_fao90
  , h.soil_fao90_cl
  , h.soil
  , h.soil_fao85_cl
  , h.slope1
  , h.text1
  , h.phase1
  , h.calculated_rooting_depth
  , h.soil_group_no
  , h.drainage
  , h.alkalinity
  , h.salinity
  , x.parameter_code
  , x.parameter_xvalue
  , x.parameter_yvalue
  , r.min_depth
from
    soil_typologic_unit h
  , soil_physical_group x
  , rooting_depth r
where h.soil_group_no = x.soil_group_no
and   r.class         = h.calculated_rooting_depth

SOIL_MAPPING_UNIT

Description: listing of unique soil mapping units and related countries
Use: used by the crop growth model
Type: Table
Remarks: user defined, derived from the soil map

Structure

Attribute	Constraint	Type	Unit	Comment
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
COUNTRY_CODE	NOT NULL	VARCHAR2(3)	-	country code*

SOIL_PHYSICAL_GROUP

Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
Use: used by the crop growth model
Type: Table
Remarks: user defined, derived from the soil map

Structure

Attribute	Constraint	Type	Unit	Comment
SOIL_GROUP_NO	NOT NULL	NUMBER(22, 3)	-	soil physical group number
PARAMETER_CODE	NOT NULL	VARCHAR2(30)	-	character code of soil phys. parameter
PARAMETER_XVALUE	NOT NULL	NUMBER(22, 38)	-	soil phys. parameter value
PARAMETER_YVALUE		NUMBER(22, 38)	-	soil phys. parameter value – multiple

SOIL_TYPOLOGIC_UNIT

Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
Use: used by the crop growth model
Type: Table
Remarks: user defined, derived from the soil map

Structure

Attribute	Constraint	Type	Unit	Comment
STU_NO	NOT NULL	NUMBER(22, 8)	-	soil typologic unit number
SOIL_WRB	NOT NULL	VARCHAR2(8)	-	World Reference Base soil code
SOIL_WRB_CL	NOT NULL	VARCHAR2(1)	-	World Reference Base soil code
SOIL_FAO90	NOT NULL	VARCHAR2(8)	-	FAO 1990 soil code
SOIL_FAO90_CL	NOT NULL	VARCHAR2(1)	-	FAO 1990 soil code
SOIL	NOT NULL	VARCHAR2(8)	-	character code to characterize the soil
SOIL_FAO85_CL	NOT NULL	VARCHAR2(1)	-	FAO 1985 soil code
SLOPE1	NOT NULL	VARCHAR2(1)	-	slope
TEXT1	NOT NULL	VARCHAR2(1)	-	texture of the soil
PHASE1	NOT NULL	VARCHAR2(2)	-	agricultural limitation
CALCULATED_ROOTING_DEPTH	NOT NULL	NUMBER(22, 5)	-	rooting depth class
SOIL_GROUP_NO	NOT NULL	NUMBER(22, 3)	-	soil physical group number
DRAINAGE	NOT NULL	VARCHAR2(2)	-	the drainage of the soil
ALKALINITY	NOT NULL	VARCHAR2(1)	-	alkalinity of the soil
SALINITY	NOT NULL	VARCHAR2(1)	-	salinity of the soil

SUPIT-datasets

content
9.1 SUPIT_CONSTANTS
9.2 SUPIT_REFERENCE_STATIONS

SUPIT_CONSTANTS

Description: the regression constants per weather station used for the estimation of global radiation for the station
Use: support table program SupitConstant; results are copied to table STATION
Type: Table
Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)

Structure

Attribute	Constraint	Type	Unit	Comment
WMO_NO	NOT NULL	NUMBER(22, 7)	-	station number
ANGSTROM_A		NUMBER(22)	-	ångström constant A using sun shine duration
ANGSTROM_B		NUMBER(22)	-	ångström constant B using sun shine duration
SUPIT_A		NUMBER(22)	-	supit constant A using cloud cover and temperature
SUPIT_B		NUMBER(22)	-	supit constant B using cloud cover and temperature
SUPIT_C		NUMBER(22)	KJ.m-2.d-1	supit constant C using cloud cover and temperature
HARGREAVES_A		NUMBER(22)	-	hargreaves constant A using temperature
HARGREAVES_B		NUMBER(22)	KJ.m-2.d-1	hargreaves constant B using temperature

SUPIT_REFERENCE_STATIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
STATION_NAME		CHAR(10)
LATITUDE	NOT NULL	NUMBER(22)
LONGITUDE	NOT NULL	NUMBER(22)
ALTITUDE		NUMBER(22)
ANGSTROM_A		NUMBER(22)
ANGSTROM_B		NUMBER(22)
SUPIT_A		NUMBER(22)
SUPIT_B		NUMBER(22)
SUPIT_C		NUMBER(22)
HARGREAVES_A		NUMBER(22)
HARGREAVES_B		NUMBER(22)

definition:

select
    'dummy_name'   as station_name
	, latitude
	, longitude
    , 0            as altitude
    , angstrom_a
    , angstrom_b
    , supit_a
    , supit_b
    , supit_c
    , hargreaves_a
    , hargreaves_b
from station_reference_coefficients

WEATHER-datasets

content
10.1 WEATHER_OBS_AEZ
10.2 WEATHER_OBS_AEZ_LTA
10.3 WEATHER_OBS_AEZ_LTA_THRES
10.4 WEATHER_OBS_AEZ_THRES
10.5 WEATHER_OBS_GRID
10.6 WEATHER_OBS_GRID_INFO
10.7 WEATHER_OBS_GRID_LTA
10.8 WEATHER_OBS_GRID_LTA_MISS
10.9 WEATHER_OBS_HIS_OPE_GRID
10.10 WEATHER_OBS_REGION
10.11 WEATHER_OBS_REGION_LTA
10.12 WEATHER_OBS_REGION_LTA_THRES
10.13 WEATHER_OBS_REGION_THRES
10.14 WEATHER_OBS_STATION
10.15 WEATHER_OBS_STATION_AVAIL
10.16 WEATHER_OBS_STATION_CALCULATED
10.17 WEATHER_OBS_STATION_ERRAIN
10.18 WEATHER_OBS_STATION_ERRORS
10.19 WEATHER_OBS_STATION_INFO
10.20 WEATHER_OBS_STATION_LTA
10.21 WEATHER_OBS_STATION_RAW
10.22 WEATHER_STATION

WEATHER_OBS_AEZ

Description: interpolated weather data per grid per agro-environmental egion
Use: input for monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	agro-environmental region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)	°C	maximum daily air temperature
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)	°C	minimum daily air temperature
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)	°C	average daily air temperature
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WINDSPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth
FRAC_AREA_TEMP_MAX_GE_25		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 25°C
FRAC_AREA_TEMP_MAX_GE_30		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 30°C
FRAC_AREA_TEMP_MAX_GE_35		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 35°C
FRAC_AREA_TEMP_MAX_GE_40		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 40°C
FRAC_AREA_TEMP_MIN_LE_0		NUMBER(22, 3)	-	fraction of area with minimum <= 0°C
FRAC_AREA_TEMP_MIN_LE_MIN8		NUMBER(22, 3)	-	fraction of area with minimum <= -8°C
FRAC_AREA_TEMP_MIN_LE_MIN10		NUMBER(22, 3)	-	fraction of area with minimum <= -10°C
FRAC_AREA_TEMP_MIN_LE_MIN18		NUMBER(22, 3)	-	fraction of area with minimum <= -18°C
FRAC_AREA_TEMP_MIN_LE_MIN20		NUMBER(22, 3)	-	fraction of area with minimum <= -20°C
FRAC_AREA_PRECIPITATION_GE_1		NUMBER(22, 3)	-	fraction of area with rainfall >= 1mm
FRAC_AREA_PRECIPITATION_GE_3		NUMBER(22, 3)	-	fraction of area with rainfall >= 3mm
FRAC_AREA_PRECIPITATION_GE_5		NUMBER(22, 3)	-	fraction of area with rainfall >= 5mm
FRAC_AREA_PRECIPITATION_GE_10		NUMBER(22, 3)	-	fraction of area with rainfall >= 10mm
FRAC_AREA_PRECIPITATION_GE_15		NUMBER(22, 3)	-	fraction of area with rainfall >= 15mm
FRAC_AREA_PRECIPITATION_GE_30		NUMBER(22, 3)	-	fraction of area with rainfall >= 30mm
AVG_TEMP_GE_0		NUMBER(22, 3)	°C	average temperature above 0°C
AVG_TEMP_GE_2		NUMBER(22, 3)	°C	average temperature above 2°C
AVG_TEMP_GE_4		NUMBER(22, 3)	°C	average temperature above 4°C
AVG_TEMP_GE_6		NUMBER(22, 3)	°C	average temperature above 6°C
AVG_TEMP_GE_8		NUMBER(22, 3)	°C	average temperature above 8°C
AVG_TEMP_GE_10		NUMBER(22, 3)	°C	average temperature above 10°C

WEATHER_OBS_AEZ_LTA

Description: long term average interpolated weather data per agri-environmental region per day
Use: Monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	agri-environmental region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)	-	landcover mask / crop mask id
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY_NO	NOT NULL	VARCHAR2(4)	-	day of year stored as mmdd
TEMPERATURE_MIN		NUMBER(22, 3)	°C	average maximum air temperature
TEMPERATURE_MAX		NUMBER(22, 3)	°C	average minimum air temperature
TEMPERATURE_AVG		NUMBER(22, 3)	°C	average mean air temperature
PRECIPITATION		NUMBER(22, 4)	mm.d-1	average daily rainfall
RADIATION		NUMBER(22, 7)	KJ.m-2.d-1	average daily radiation at surface
VAPOURPRESSURE		NUMBER(22, 4)	hPa	average mean daily vapour pressure
WINDSPEED		NUMBER(22, 5)	m.s-1	average mean daily wind speed at 10 m height
E0		NUMBER(22, 4)	mm.d-1	average daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	average daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	average daily transpiration of crop canopy
SNOWDEPTH		NUMBER(22, 6)	cm	average daily mean snow depth
FRAC_AREA_TEMP_MAX_GE_25		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 25°C
FRAC_AREA_TEMP_MAX_GE_30		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 30°C
FRAC_AREA_TEMP_MAX_GE_35		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 35°C
FRAC_AREA_TEMP_MAX_GE_40		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 40°C
FRAC_AREA_TEMP_MIN_LE_0		NUMBER(22, 3)	-	fraction of days with minimum <= 0°C
FRAC_AREA_TEMP_MIN_LE_MIN8		NUMBER(22, 3)	-	fraction of days with minimum <= -8°C
FRAC_AREA_TEMP_MIN_LE_MIN10		NUMBER(22, 3)	-	fraction of days with minimum <= -10°C
FRAC_AREA_TEMP_MIN_LE_MIN18		NUMBER(22, 3)	-	fraction of days with minimum <= -18°C
FRAC_AREA_TEMP_MIN_LE_MIN20		NUMBER(22, 3)	-	fraction of days with minimum <= -20°C
FRAC_AREA_PRECIPITATION_GE_1		NUMBER(22, 3)	-	fraction of days with rainfall >= 1mm
FRAC_AREA_PRECIPITATION_GE_3		NUMBER(22, 3)	-	fraction of days with rainfall >= 3mm
FRAC_AREA_PRECIPITATION_GE_5		NUMBER(22, 3)	-	fraction of days with rainfall >= 5mm
FRAC_AREA_PRECIPITATION_GE_10		NUMBER(22, 3)	-	fraction of days with rainfall >= 10mm
FRAC_AREA_PRECIPITATION_GE_15		NUMBER(22, 3)	-	fraction of days with rainfall >= 15mm
FRAC_AREA_PRECIPITATION_GE_30		NUMBER(22, 3)	-	fraction of days with rainfall >= 30mm
AVG_TEMP_GE_0		NUMBER(22, 3)	°C	average temperature above 0°C
AVG_TEMP_GE_2		NUMBER(22, 3)	°C	average temperature above 2°C
AVG_TEMP_GE_4		NUMBER(22, 3)	°C	average temperature above 4°C
AVG_TEMP_GE_6		NUMBER(22, 3)	°C	average temperature above 6°C
AVG_TEMP_GE_8		NUMBER(22, 3)	°C	average temperature above 8°C
AVG_TEMP_GE_10		NUMBER(22, 3)	-	average temperature above 10°C
MIN_TEMPERATURE_MIN		NUMBER(22, 3)	°C	minimum minimum air temperature
MIN_TEMPERATURE_MAX		NUMBER(22, 3)	°C	minimum maximum air temperature
MIN_TEMPERATURE_AVG		NUMBER(22, 3)	°C	minimum mean air temperature
MIN_PRECIPITATION		NUMBER(22, 4)	mm.d-1	minimum daily rainfall
MIN_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	minimum daily radiation at surface
MIN_VAPOURPRESSURE		NUMBER(22, 4)	hPa	minimum mean daily vapour pressure
MIN_WINDSPEED		NUMBER(22, 5)	m.s-1	minimum mean daily wind speed at 10 m height
MIN_E0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of water surface
MIN_ES0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of wet bare soil
MIN_ET0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of crop canopy
MIN_SNOWDEPTH		NUMBER(22, 6)	cm	minimum daily mean snow depth
MAX_TEMPERATURE_MIN		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_MAX		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_AVG		NUMBER(22, 3)	°C	maximum mean air temperature
MAX_PRECIPITATION		NUMBER(22, 4)	mm.d-1	maximum daily rainfall
MAX_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	maximum daily radiation at surface
MAX_VAPOURPRESSURE		NUMBER(22, 4)	hPa	maximum mean daily vapour pressure
MAX_WINDSPEED		NUMBER(22, 5)	m.s-1	maximum mean daily wind speed at 10 m height
MAX_E0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of water surface
MAX_ES0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of wet bare soil
MAX_ET0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of crop canopy
MAX_SNOWDEPTH		NUMBER(22, 6)
STD_TEMPERATURE_MIN		NUMBER(22, 4)	°C	standard deviation of minimum air temperature
STD_TEMPERATURE_MAX		NUMBER(22, 4)	°C	standard deviation of maximum air temperature
STD_TEMPERATURE_AVG		NUMBER(22, 4)	°C	standard deviation of mean air temperature
STD_PRECIPITATION		NUMBER(22, 5)	mm.d-1	standard deviation of daily rainfall
STD_RADIATION		NUMBER(22, 8)	KJ.m-2.d-1	standard deviation of daily radiation at surface
STD_VAPOURPRESSURE		NUMBER(22, 6)	hPa	standard deviation of mean daily vapour pressure
STD_WINDSPEED		NUMBER(22, 6)	m.s-1	standard deviation of mean daily wind speed at 10 m height
STD_E0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of water surface
STD_ES0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of wet bare soil
STD_ET0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of crop canopy
STD_SNOWDEPTH		NUMBER(22, 7)	cm	standard deviation of daily mean snow depth
NUM_TEMPERATURE_MIN		NUMBER(22, 6)	-	count of air temperature
NUM_TEMPERATURE_MAX		NUMBER(22, 6)	-	count of maximum air temperature
NUM_TEMPERATURE_AVG		NUMBER(22, 6)	-	count of mean air temperature
NUM_PRECIPITATION		NUMBER(22, 6)	-	count of daily rainfall
NUM_RADIATION		NUMBER(22, 6)	-	count of daily radiation at surface
NUM_VAPOURPRESSURE		NUMBER(22, 6)	-	count of mean daily vapour pressure
NUM_WINDSPEED		NUMBER(22, 6)	-	count of mean daily wind speed at 10 m height
NUM_E0		NUMBER(22, 6)	-	count of daily transpiration of water surface
NUM_ES0		NUMBER(22, 6)	-	count of daily transpiration of wet bare soil
NUM_ET0		NUMBER(22, 6)	-	count of daily transpiration of crop canopy
NUM_SNOWDEPTH		NUMBER(22, 6)	-	count of daily mean snow depth

WEATHER_OBS_AEZ_LTA_THRES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_AEZ_THRES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_GRID

Description: interpolated weather data per grid per day
Use: output for level 1, input for level 2
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)	°C	maximum air temperature
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)	°C	minimum air temperature
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)	°C	average air temperature
HUMIDITY_06H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)	m.s-1	mean daily vapour pressure
WINDSPEED	NOT NULL	NUMBER(22, 5)	hPa	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

WEATHER_OBS_GRID_INFO

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY	NOT NULL	DATE	-
PRECIPITATION	NOT NULL	VARCHAR2(10)	-
SNOWDEPTH	NOT NULL	VARCHAR2(10)	-
TEMPERATURE_GROUP	NOT NULL	VARCHAR2(10)	-
HUMIDITY_GROUP	NOT NULL	VARCHAR2(10)	-
REST_GROUP	NOT NULL	VARCHAR2(10)	-

WEATHER_OBS_GRID_LTA

Description: long term average interpolated weather data per grid cell per day
Use: Monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY_NO	NOT NULL	VARCHAR2(4)	-	day of year stored as mmdd
TEMPERATURE_MIN		NUMBER(22, 3)	°C	average maximum air temperature
TEMPERATURE_MAX		NUMBER(22, 3)	°C	average minimum air temperature
TEMPERATURE_AVG		NUMBER(22, 3)	°C	average mean air temperature
PRECIPITATION		NUMBER(22, 4)	mm.d-1	average daily rainfall
RADIATION		NUMBER(22, 7)	KJ.m-2.d-1	average daily radiation at surface
VAPOURPRESSURE		NUMBER(22, 4)	hPa	average mean daily vapour pressure
WINDSPEED		NUMBER(22, 5)	m.s-1	average mean daily wind speed at 10 m height
E0		NUMBER(22, 4)	mm.d-1	average daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	average daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	average daily transpiration of crop canopy
SNOWDEPTH		NUMBER(22, 6)	cm	average daily mean snow depth
FRAC_DAYS_TEMP_MAX_GE_25		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 25°C
FRAC_DAYS_TEMP_MAX_GE_30		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 30°C
FRAC_DAYS_TEMP_MAX_GE_35		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 35°C
FRAC_DAYS_TEMP_MAX_GE_40		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 40°C
FRAC_DAYS_TEMP_MIN_LE_0		NUMBER(22, 3)	-	fraction of days with minimum <= 0°C
FRAC_DAYS_TEMP_MIN_LE_MIN8		NUMBER(22, 3)	-	fraction of days with minimum <= -8°C
FRAC_DAYS_TEMP_MIN_LE_MIN10		NUMBER(22, 3)	-	fraction of days with minimum <= -10°C
FRAC_DAYS_TEMP_MIN_LE_MIN18		NUMBER(22, 3)	-	fraction of days with minimum <= -18°C
FRAC_DAYS_TEMP_MIN_LE_MIN20		NUMBER(22, 3)	-	fraction of days with minimum <= -20°C
FRAC_DAYS_PRECIPITATION_GE_1		NUMBER(22, 3)	-	fraction of days with rainfall >= 1mm
FRAC_DAYS_PRECIPITATION_GE_3		NUMBER(22, 3)	-	fraction of days with rainfall >= 3mm
FRAC_DAYS_PRECIPITATION_GE_5		NUMBER(22, 3)	-	fraction of days with rainfall >= 5mm
FRAC_DAYS_PRECIPITATION_GE_10		NUMBER(22, 3)	-	fraction of days with rainfall >= 10mm
FRAC_DAYS_PRECIPITATION_GE_15		NUMBER(22, 3)	-	fraction of days with rainfall >= 15mm
FRAC_DAYS_PRECIPITATION_GE_30		NUMBER(22, 3)	-	fraction of days with rainfall >= 30mm
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)	-
MIN_TEMPERATURE_MIN		NUMBER(22, 3)	°C	minimum minimum air temperature
MIN_TEMPERATURE_MAX		NUMBER(22, 3)	°C	minimum maximum air temperature
MIN_TEMPERATURE_AVG		NUMBER(22, 3)	°C	minimum mean air temperature
MIN_PRECIPITATION		NUMBER(22, 4)	mm.d-1	minimum daily rainfall
MIN_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	minimum daily radiation at surface
MIN_VAPOURPRESSURE		NUMBER(22, 4)	hPa	minimum mean daily vapour pressure
MIN_WINDSPEED		NUMBER(22, 5)	m.s-1	minimum mean daily wind speed at 10 m height
MIN_E0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of water surface
MIN_ES0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of wet bare soil
MIN_ET0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of crop canopy
MIN_SNOWDEPTH		NUMBER(22, 6)	cm	minimum daily mean snow depth
MAX_TEMPERATURE_MIN		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_MAX		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_AVG		NUMBER(22, 3)	°C	maximum mean air temperature
MAX_PRECIPITATION		NUMBER(22, 4)	mm.d-1	maximum daily rainfall
MAX_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	maximum daily radiation at surface
MAX_VAPOURPRESSURE		NUMBER(22, 4)	hPa	maximum mean daily vapour pressure
MAX_WINDSPEED		NUMBER(22, 5)	m.s-1	maximum mean daily wind speed at 10 m height
MAX_E0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of water surface
MAX_ES0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of wet bare soil
MAX_ET0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of crop canopy
MAX_SNOWDEPTH		NUMBER(22, 6)
STD_TEMPERATURE_MIN		NUMBER(22, 4)	°C	standard deviation of minimum air temperature
STD_TEMPERATURE_MAX		NUMBER(22, 4)	°C	standard deviation of maximum air temperature
STD_TEMPERATURE_AVG		NUMBER(22, 4)	°C	standard deviation of mean air temperature
STD_PRECIPITATION		NUMBER(22, 5)	mm.d-1	standard deviation of daily rainfall
STD_RADIATION		NUMBER(22, 8)	KJ.m-2.d-1	standard deviation of daily radiation at surface
STD_VAPOURPRESSURE		NUMBER(22, 6)	hPa	standard deviation of mean daily vapour pressure
STD_WINDSPEED		NUMBER(22, 6)	m.s-1	standard deviation of mean daily wind speed at 10 m height
STD_E0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of water surface
STD_ES0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of wet bare soil
STD_ET0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of crop canopy
STD_SNOWDEPTH		NUMBER(22, 7)	cm	standard deviation of daily mean snow depth
NUM_TEMPERATURE_MIN		NUMBER(22, 6)	-	count of air temperature
NUM_TEMPERATURE_MAX		NUMBER(22, 6)	-	count of maximum air temperature
NUM_TEMPERATURE_AVG		NUMBER(22, 6)	-	count of mean air temperature
NUM_PRECIPITATION		NUMBER(22, 6)	-	count of daily rainfall
NUM_RADIATION		NUMBER(22, 6)	-	count of daily radiation at surface
NUM_VAPOURPRESSURE		NUMBER(22, 6)	-	count of mean daily vapour pressure
NUM_WINDSPEED		NUMBER(22, 6)	-	count of mean daily wind speed at 10 m height
NUM_E0		NUMBER(22, 6)	-	count of daily transpiration of water surface
NUM_ES0		NUMBER(22, 6)	-	count of daily transpiration of wet bare soil
NUM_ET0		NUMBER(22, 6)	-	count of daily transpiration of crop canopy
NUM_SNOWDEPTH		NUMBER(22, 6)	-	count of daily mean snow depth

* In script changed to 4,2. Not yet installed.

WEATHER_OBS_GRID_LTA_MISS

Description: long term average number of grid cells per country.
Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
Type: Table
Remarks: filled with procedure lta_missing_grid_weather.sql

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
REG_NAME	NOT NULL	VARCHAR2(50)	-	administrative region name
TOTAL_GRIDS		NUMBER(22, 10)	-	total number of grid cells
TOTAL_GRIDS_CC		NUMBER(22, 10)	-	total number of grid cells with at least 1 crop calendar
MISSING_GRIDS		NUMBER(22, 10)
MISSING_GRIDS_CC		NUMBER(22, 10)	-	total number of missing grid cells with at least 1 crop calendar
MISSING_GRIDS_ORIGINAL		NUMBER(22, 10)	-	total number of missing grid cells

* When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL.

WEATHER_OBS_HIS_OPE_GRID

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
GRID_NO	NOT NULL	NUMBER(22, 8)
DAY	NOT NULL	DATE
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)

definition:

select
  grid_no
, day
, temperature_max
, temperature_min
, temperature_avg
, vapourpressure
, windspeed
, precipitation
, e0
, es0
, et0
, radiation
, snowdepth
--, 'OBS' as source
from cgms12eu.weather_obs_grid

WEATHER_OBS_REGION

Description: interpolated weather data per grid per administrative region
Use: input for monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)	°C	maximum daily air temperature
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)	°C	minimum daily air temperature
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)	°C	average daily air temperature
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WINDSPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth
FRAC_AREA_TEMP_MAX_GE_25		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 25°C
FRAC_AREA_TEMP_MAX_GE_30		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 30°C
FRAC_AREA_TEMP_MAX_GE_35		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 35°C
FRAC_AREA_TEMP_MAX_GE_40		NUMBER(22, 3)	-	fraction of area with maximum temperature >= 40°C
FRAC_AREA_TEMP_MIN_LE_0		NUMBER(22, 3)	-	fraction of area with minimum <= 0°C
FRAC_AREA_TEMP_MIN_LE_MIN8		NUMBER(22, 3)	-	fraction of area with minimum <= -8°C
FRAC_AREA_TEMP_MIN_LE_MIN10		NUMBER(22, 3)	-	fraction of area with minimum <= -10°C
FRAC_AREA_TEMP_MIN_LE_MIN18		NUMBER(22, 3)	-	fraction of area with minimum <= -18°C
FRAC_AREA_TEMP_MIN_LE_MIN20		NUMBER(22, 3)	-	fraction of area with minimum <= -20°C
FRAC_AREA_PRECIPITATION_GE_1		NUMBER(22, 3)	-	fraction of area with rainfall >= 1mm
FRAC_AREA_PRECIPITATION_GE_3		NUMBER(22, 3)	-	fraction of area with rainfall >= 3mm
FRAC_AREA_PRECIPITATION_GE_5		NUMBER(22, 3)	-	fraction of area with rainfall >= 5mm
FRAC_AREA_PRECIPITATION_GE_10		NUMBER(22, 3)	-	fraction of area with rainfall >= 10mm
FRAC_AREA_PRECIPITATION_GE_15		NUMBER(22, 3)	-	fraction of area with rainfall >= 15mm
FRAC_AREA_PRECIPITATION_GE_30		NUMBER(22, 3)	-	fraction of area with rainfall >= 30mm
AVG_TEMP_GE_0		NUMBER(22, 3)	°C	average temperature above 0°C
AVG_TEMP_GE_2		NUMBER(22, 3)	°C	average temperature above 2°C
AVG_TEMP_GE_4		NUMBER(22, 3)	°C	average temperature above 4°C
AVG_TEMP_GE_6		NUMBER(22, 3)	°C	average temperature above 6°C
AVG_TEMP_GE_8		NUMBER(22, 3)	°C	average temperature above 8°C
AVG_TEMP_GE_10		NUMBER(22, 3)	°C	average temperature above 10°C

WEATHER_OBS_REGION_LTA

Description: long term average interpolated weather data per administrative region per day
Use: Monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
LANDCOVER_ID	NOT NULL	NUMBER(22, 10)
THRESHOLD	NOT NULL	NUMBER(22, 3)	-	used threshold in percentage
DAY_NO	NOT NULL	VARCHAR2(4)	-	day of year stored as mmdd
TEMPERATURE_MIN		NUMBER(22, 3)	°C	average maximum air temperature
TEMPERATURE_MAX		NUMBER(22, 3)	°C	average minimum air temperature
TEMPERATURE_AVG		NUMBER(22, 3)	°C	average mean air temperature
PRECIPITATION		NUMBER(22, 4)	mm.d-1	average daily rainfall
RADIATION		NUMBER(22, 7)	KJ.m-2.d-1	average daily radiation at surface
VAPOURPRESSURE		NUMBER(22, 4)	hPa	average mean daily vapour pressure
WINDSPEED		NUMBER(22, 5)	m.s-1	average mean daily wind speed at 10 m height
E0		NUMBER(22, 4)	mm.d-1	average daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	average daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	average daily transpiration of crop canopy
SNOWDEPTH		NUMBER(22, 6)	cm	average daily mean snow depth
FRAC_AREA_TEMP_MAX_GE_25		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 25°C
FRAC_AREA_TEMP_MAX_GE_30		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 30°C
FRAC_AREA_TEMP_MAX_GE_35		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 35°C
FRAC_AREA_TEMP_MAX_GE_40		NUMBER(22, 3)	-	fraction of days with maximum temperature >= 40°C
FRAC_AREA_TEMP_MIN_LE_0		NUMBER(22, 3)	-	fraction of days with minimum <= 0°C
FRAC_AREA_TEMP_MIN_LE_MIN8		NUMBER(22, 3)	-	fraction of days with minimum <= -8°C
FRAC_AREA_TEMP_MIN_LE_MIN10		NUMBER(22, 3)	-	fraction of days with minimum <= -10°C
FRAC_AREA_TEMP_MIN_LE_MIN18		NUMBER(22, 3)	-	fraction of days with minimum <= -18°C
FRAC_AREA_TEMP_MIN_LE_MIN20		NUMBER(22, 3)	-	fraction of days with minimum <= -20°C
FRAC_AREA_PRECIPITATION_GE_1		NUMBER(22, 3)	-	fraction of days with rainfall >= 1mm
FRAC_AREA_PRECIPITATION_GE_3		NUMBER(22, 3)	-	fraction of days with rainfall >= 3mm
FRAC_AREA_PRECIPITATION_GE_5		NUMBER(22, 3)	-	fraction of days with rainfall >= 5mm
FRAC_AREA_PRECIPITATION_GE_10		NUMBER(22, 3)	-	fraction of days with rainfall >= 10mm
FRAC_AREA_PRECIPITATION_GE_15		NUMBER(22, 3)	-	fraction of days with rainfall >= 15mm
FRAC_AREA_PRECIPITATION_GE_30		NUMBER(22, 3)	-	fraction of days with rainfall >= 30mm
AVG_TEMP_GE_0		NUMBER(22, 3)	°C	average temperature above 0°C
AVG_TEMP_GE_2		NUMBER(22, 3)	°C	average temperature above 2°C
AVG_TEMP_GE_4		NUMBER(22, 3)	°C	average temperature above 4°C
AVG_TEMP_GE_6		NUMBER(22, 3)	°C	average temperature above 6°C
AVG_TEMP_GE_8		NUMBER(22, 3)	°C	average temperature above 8°C
AVG_TEMP_GE_10		NUMBER(22, 3)	°C	average temperature above 10°C
MIN_TEMPERATURE_MIN		NUMBER(22, 3)	°C	minimum minimum air temperature
MIN_TEMPERATURE_MAX		NUMBER(22, 3)	°C	minimum maximum air temperature
MIN_TEMPERATURE_AVG		NUMBER(22, 3)	°C	minimum mean air temperature
MIN_PRECIPITATION		NUMBER(22, 4)	mm.d-1	minimum daily rainfall
MIN_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	minimum daily radiation at surface
MIN_VAPOURPRESSURE		NUMBER(22, 4)	hPa	minimum mean daily vapour pressure
MIN_WINDSPEED		NUMBER(22, 5)	m.s-1	minimum mean daily wind speed at 10 m height
MIN_E0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of water surface
MIN_ES0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of wet bare soil
MIN_ET0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of crop canopy
MIN_SNOWDEPTH		NUMBER(22, 6)	cm	minimum daily mean snow depth
MAX_TEMPERATURE_MIN		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_MAX		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_AVG		NUMBER(22, 3)	°C	maximum mean air temperature
MAX_PRECIPITATION		NUMBER(22, 4)	mm.d-1	maximum daily rainfall
MAX_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	maximum daily radiation at surface
MAX_VAPOURPRESSURE		NUMBER(22, 4)	hPa	maximum mean daily vapour pressure
MAX_WINDSPEED		NUMBER(22, 5)	m.s-1	maximum mean daily wind speed at 10 m height
MAX_E0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of water surface
MAX_ES0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of wet bare soil
MAX_ET0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of crop canopy
MAX_SNOWDEPTH		NUMBER(22, 6)
STD_TEMPERATURE_MIN		NUMBER(22, 4)	°C	standard deviation of minimum air temperature
STD_TEMPERATURE_MAX		NUMBER(22, 4)	°C	standard deviation of maximum air temperature
STD_TEMPERATURE_AVG		NUMBER(22, 4)	°C	standard deviation of mean air temperature
STD_PRECIPITATION		NUMBER(22, 5)	mm.d-1	standard deviation of daily rainfall
STD_RADIATION		NUMBER(22, 8)	KJ.m-2.d-1	standard deviation of daily radiation at surface
STD_VAPOURPRESSURE		NUMBER(22, 6)	hPa	standard deviation of mean daily vapour pressure
STD_WINDSPEED		NUMBER(22, 6)	m.s-1	standard deviation of mean daily wind speed at 10 m height
STD_E0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of water surface
STD_ES0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of wet bare soil
STD_ET0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of crop canopy
STD_SNOWDEPTH		NUMBER(22, 7)	cm	standard deviation of daily mean snow depth
NUM_TEMPERATURE_MIN		NUMBER(22, 6)	-	count of air temperature
NUM_TEMPERATURE_MAX		NUMBER(22, 6)	-	count of maximum air temperature
NUM_TEMPERATURE_AVG		NUMBER(22, 6)	-	count of mean air temperature
NUM_PRECIPITATION		NUMBER(22, 6)	-	count of daily rainfall
NUM_RADIATION		NUMBER(22, 6)	-	count of daily radiation at surface
NUM_VAPOURPRESSURE		NUMBER(22, 6)	-	count of mean daily vapour pressure
NUM_WINDSPEED		NUMBER(22, 6)	-	count of mean daily wind speed at 10 m height
NUM_E0		NUMBER(22, 6)	-	count of daily transpiration of water surface
NUM_ES0		NUMBER(22, 6)	-	count of daily transpiration of wet bare soil
NUM_ET0		NUMBER(22, 6)	-	count of daily transpiration of crop canopy
NUM_SNOWDEPTH		NUMBER(22, 6)	-	count of daily mean snow depth

WEATHER_OBS_REGION_LTA_THRES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_REGION_THRES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_STATION

Description: contains the station based daily meteorological data
Use: input for level 1
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-	station number
DAY	NOT NULL	DATE	-	calendar day
CLOUD_TOTAL_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_LOW_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_MIDDLE_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_HIGH_24H		NUMBER(22, 6)	oktas	not used in CGMS
SUNSHINE		NUMBER(22, 6)	h	daily sunshine duration (2
RADIATION		NUMBER(22, 11)	KJ.m-2.d-1	daily global radiation at surface (1
TEMPERATURE_MIN		NUMBER(22, 6)	°C	minimum air temperature (3,4
TEMPERATURE_MAX		NUMBER(22, 6)	°C	maximum air temperature (3,4
VAPOURPRESSURE		NUMBER(22, 6)	hPa	daily mean vapour pressure
WINDSPEED		NUMBER(22, 6)	m.s-1	not used in CGMS
WINDSPEED_10M		NUMBER(22, 6)	m.s-1	daily mean wind speed at 10 m height
PRECIPITATION		NUMBER(22, 6)	mm.d-1	daily rainfall
TEMPERATURE_06H		NUMBER(22, 6)	°C	air temperature 6 UTC
HUMIDITY_06H		NUMBER(22, 6)	%	humidity 6 UTC
TEMPERATURE_09H		NUMBER(22, 6)	°C	air temperature 9 UTC
HUMIDITY_09H		NUMBER(22, 6)	%	humidity 9 UTC
TEMPERATURE_12H		NUMBER(22, 6)	°C	air temperature 12 UTC
HUMIDITY_12H		NUMBER(22, 6)	%	humidity 12 UTC
TEMPERATURE_15H		NUMBER(22, 6)	°C	air temperature 15 UTC
HUMIDITY_15H		NUMBER(22, 6)	%	humidity 15 UTC
TEMPERATURE_18H		NUMBER(22, 6)	°C	air temperature 18 UTC
HUMIDITY_18H		NUMBER(22, 6)	%	humidity 18 UTC
STATE_SOIL		NUMBER(22, 6)	-	not used in CGMS
VAPOURPRESSURE_DEF		NUMBER(22, 6)	hPa	not used in CGMS
SLOPE_VP_VS_T		NUMBER(22, 6)	hPa.°C-1	not used in CGMS
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	oktas	daily mean of total cloud cover (3
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_SHADOW		NUMBER(22, 6)	oktas	not used in CGMS
VISIBILITY		NUMBER(22, 6)	-	not used in CGMS
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

1 this variable returns directly radiation
2 this variable can be used to derive radiation via the angstrom formula
3 these variables can be used to derive radiation via the Supit formula
4 these variables can be used to derive radiation via the Hargreaves formula

WEATHER_OBS_STATION_AVAIL

Description: available weather stations for interpolation per station and per year.
Use: output of the weather data availability calculation, used by the grid weather interpolation
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
YEAR	NOT NULL	NUMBER(22, 4)	-	historic year
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-	station number
AVAILABILITY_TYPE	NOT NULL	VARCHAR2(30)	-	class e.g. temperature
SYS_STSBA3JD78QHQY0ZO$L75NIOAE		NUMBER(22)

WEATHER_OBS_STATION_CALCULATED

Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
Use: output table for additional weather calculation, input for grid weather
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-	station number
DAY	NOT NULL	DATE	-	calendar day
E0		NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION		NUMBER(22, 9)	KJ.m-2.d-1	daily radiation at surface

WEATHER_OBS_STATION_ERRAIN

Description: contains deleted wrongly rain records of the station based daily meteorological data
Use: archive reasons
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY	NOT NULL	DATE	-
PRECIPITATION		NUMBER(22, 6)	-
REASON		VARCHAR2(4000)	-

WEATHER_OBS_STATION_ERRORS

Description: contains deleted wrongly weather records of the station based daily meteorological data
Use: archive reasons
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY	NOT NULL	DATE	-
CLOUD_TOTAL_24H		NUMBER(22, 6)	-
CLOUD_LOW_24H		NUMBER(22, 6)	-
CLOUD_MIDDLE_24H		NUMBER(22, 6)	-
CLOUD_HIGH_24H		NUMBER(22, 6)	-
SUNSHINE		NUMBER(22, 6)	-
RADIATION		NUMBER(22, 11)	-
TEMPERATURE_MIN		NUMBER(22, 6)	-
TEMPERATURE_MAX		NUMBER(22, 6)	-
VAPOURPRESSURE		NUMBER(22, 6)	-
WINDSPEED		NUMBER(22, 6)	-
WINDSPEED_10M		NUMBER(22, 6)	-
PRECIPITATION		NUMBER(22, 6)	-
TEMPERATURE_06H		NUMBER(22, 6)	-
HUMIDITY_06H		NUMBER(22, 6)	-
TEMPERATURE_09H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
TEMPERATURE_12H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
TEMPERATURE_15H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
TEMPERATURE_18H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)	-
STATE_SOIL		NUMBER(22, 6)	-
VAPOURPRESSURE_DEF		NUMBER(22, 6)	-
SLOPE_VP_VS_T		NUMBER(22, 6)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	-
CLOUD_SHADOW		NUMBER(22, 6)	-
VISIBILITY		NUMBER(22, 6)	-
SNOWDEPTH		NUMBER(22, 6)	-

WEATHER_OBS_STATION_INFO

Description: table for storing specific metadata on daily weather data (flags)
Use: meta data
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-	station number
DAY	NOT NULL	DATE	-	calendar day
CLOUD_TOTAL_24H		NUMBER(22, 2)	-
CLOUD_LOW_24H		NUMBER(22, 2)	-
CLOUD_MIDDLE_24H		NUMBER(22, 2)	-
CLOUD_HIGH_24H		NUMBER(22, 2)	-
SUNSHINE		NUMBER(22, 2)	-
RADIATION		NUMBER(22, 2)	-
TEMPERATURE_MIN		NUMBER(22, 2)	-
TEMPERATURE_MAX		NUMBER(22, 2)	-
VAPOURPRESSURE		NUMBER(22, 2)	-
WINDSPEED		NUMBER(22, 2)	-
WINDSPEED_10M		NUMBER(22, 2)	-
PRECIPITATION		NUMBER(22, 2)	-
TEMPERATURE_06H		NUMBER(22, 2)	-
HUMIDITY_06H		NUMBER(22, 2)	-
TEMPERATURE_09H		NUMBER(22, 2)	-
HUMIDITY_09H		NUMBER(22, 2)	-
TEMPERATURE_12H		NUMBER(22, 2)	-
HUMIDITY_12H		NUMBER(22, 2)	-
TEMPERATURE_15H		NUMBER(22, 2)	-
HUMIDITY_15H		NUMBER(22, 2)	-
TEMPERATURE_18H		NUMBER(22, 2)	-
HUMIDITY_18H		NUMBER(22, 2)	-
STATE_SOIL		NUMBER(22, 2)	-
VAPOURPRESSURE_DEF		NUMBER(22, 2)	-
SLOPE_VP_VS_T		NUMBER(22, 2)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 2)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 2)	-
CLOUD_SHADOW		NUMBER(22, 2)	-
VISIBILITY		NUMBER(22, 2)	-
SNOWDEPTH		NUMBER(22, 2)	-

In case of precipitation:

0=real observation 06-06 UTC
1=MOS estimate 06-06 UTC
2=real observation 00-00 UTC
3=real observation 03-03 UTC
4=real observation 12-12 UTC
5=real observation 18-18 UTC

WEATHER_OBS_STATION_LTA

Description: contains the long term average weather data per station per day
Use: substitute data in case of missing data during level 1 processing
Type: Table
Remarks: filled by software tool ReferenceWeather

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY_NO	NOT NULL	VARCHAR2(4)	-	calendar day for leap year
TEMPERATURE_MAX		NUMBER(22, 6)	°C	maximum air temperature
TEMPERATURE_MIN		NUMBER(22, 6)	°C	minimum air temperature
VAPOURPRESSURE		NUMBER(22, 6)	hPa	mean daily vapour pressure
WINDSPEED		NUMBER(22, 6)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION		NUMBER(22, 6)	mm.d-1	daily rainfall
E0		NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	daily transpiration of closed crop canopy
RADIATION		NUMBER(22, 9)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

WEATHER_OBS_STATION_RAW

Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
Use: input level 1
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
DAY_NO	NOT NULL	NUMBER(22, 8)	-
DAY		DATE	-
CLOUD_TOTAL_24H		NUMBER(22, 6)	-
CLOUD_LOW_24H		NUMBER(22, 6)	-
CLOUD_MIDDLE_24H		NUMBER(22, 6)	-
CLOUD_HIGH_24H		NUMBER(22, 6)	-
SUNSHINE		NUMBER(22, 6)	-
RADIATION		NUMBER(22, 11)	-
TEMPERATURE_MIN		NUMBER(22, 6)	-
TEMPERATURE_MAX		NUMBER(22, 6)	-
VAPOURPRESSURE		NUMBER(22, 6)	-
WINDSPEED		NUMBER(22, 6)	-
WINDSPEED_10M		NUMBER(22, 6)	-
PRECIPITATION		NUMBER(22, 6)	-
TEMPERATURE_06H		NUMBER(22, 6)	-
HUMIDITY_06H		NUMBER(22, 6)	-
TEMPERATURE_09H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
TEMPERATURE_12H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
TEMPERATURE_15H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
TEMPERATURE_18H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)	-
STATE_SOIL		NUMBER(22, 6)	-
VAPOURPRESSURE_DEF		NUMBER(22, 6)	-
SLOPE_VP_VS_T		NUMBER(22, 6)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	-
CLOUD_SHADOW		NUMBER(22, 6)	-
VISIBILITY		NUMBER(22, 6)	-
SNOWDEPTH		NUMBER(22, 6)	-
CLOUD_TOTAL_24H_INFO		NUMBER(22, 2)	-
CLOUD_LOW_24H_INFO		NUMBER(22, 2)	-
CLOUD_MIDDLE_24H_INFO		NUMBER(22, 2)	-
CLOUD_HIGH_24H_INFO		NUMBER(22, 2)	-
SUNSHINE_INFO		NUMBER(22, 2)	-
RADIATION_INFO		NUMBER(22, 2)	-
TEMPERATURE_MIN_INFO		NUMBER(22, 2)	-
TEMPERATURE_MAX_INFO		NUMBER(22, 2)	-
VAPOURPRESSURE_INFO		NUMBER(22, 2)	-
WINDSPEED_INFO		NUMBER(22, 2)	-
WINDSPEED_10M_INFO		NUMBER(22, 2)	-
PRECIPITATION_INFO		NUMBER(22, 2)	-
TEMPERATURE_06H_INFO		NUMBER(22, 2)	-
HUMIDITY_06H_INFO		NUMBER(22, 2)	-
TEMPERATURE_09H_INFO		NUMBER(22, 2)	-
HUMIDITY_09H_INFO		NUMBER(22, 2)	-
TEMPERATURE_12H_INFO		NUMBER(22, 2)	-
HUMIDITY_12H_INFO		NUMBER(22, 2)	-
TEMPERATURE_15H_INFO		NUMBER(22, 2)	-
HUMIDITY_15H_INFO		NUMBER(22, 2)	-
TEMPERATURE_18H_INFO		NUMBER(22, 2)	-
HUMIDITY_18H_INFO		NUMBER(22, 2)	-
STATE_SOIL_INFO		NUMBER(22, 2)	-
VAPOURPRESSURE_DEF_INFO		NUMBER(22, 2)	-
SLOPE_VP_VS_T_INFO		NUMBER(22, 2)	-
CLOUD_TOTAL_DAYTIME_INFO		NUMBER(22, 2)	-
CLOUD_LOW_DAYTIME_INFO		NUMBER(22, 2)	-
CLOUD_SHADOW_INFO		NUMBER(22, 2)	-
VISIBILITY_INFO		NUMBER(22, 2)	-
SNOWDEPTH_INFO		NUMBER(22, 2)	-

WEATHER_STATION

Description:
Use: interface between the CGMS12EU database and the SupitConstants software
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
WMO_NO	NOT NULL	NUMBER(22, 7)	-
WMO_NAME	NOT NULL	VARCHAR2(32)	-
LATITUDE	NOT NULL	NUMBER(22, 7)	dd	latitude
LONGITUDE	NOT NULL	NUMBER(22, 8)	dd	longitude
Y_COORDINATE	NOT NULL	NUMBER(22, 13)	m
X_COORDINATE	NOT NULL	NUMBER(22, 13)	m
ALTITUDE	NOT NULL	NUMBER(22, 5)	m	altitude
CLIMATE_BARRIER_NO	NOT NULL	NUMBER(22, 2)	-
COUNTRY_CODE	NOT NULL	VARCHAR2(26)	-	country code
DISTANCE_TO_COAST	NOT NULL	NUMBER(22, 4)	km	distance to coast
PERCENT_COMPLETE		NUMBER(22)	-
RELIABLE_STATION	NOT NULL	NUMBER(22, 1)	-

definition:

select
      station_number
    , station_name
    , latitude
    , longitude
    , y_coordinate
    , x_coordinate
    , altitude
    , climate_zone
    , country
    , distance_to_coast
    , 80 as percent_complete
    , reliable_station
from station

other datasets

content
11.1 AEZ
11.2 AGGREGATION_AREAS
11.3 ALL_SIMULATION_UNITS
11.4 CGMS_SYSLOG
11.5 CROP
11.6 CROPSUSE
11.7 CW
11.8 DATES_75_15
11.9 EMU
11.10 GRID
11.11 GRID_ALL
11.12 INITIAL_SOIL_WATER
11.13 JSOW
11.14 ORDER_EAST_EUROPE
11.15 PARAMETER_DESCRIPTION
11.16 REGION
11.17 REGION_GRIDS_EMU
11.18 ROOTING_DEPTH
11.19 SITE
11.20 SMU_SUITABILITY
11.21 STATION
11.22 STATIONS_PER_GRID
11.23 STATION_REFERENCE_COEFFICIENTS
11.24 STAT_CROP
11.25 STU_LAYER
11.26 SUITABILITY
11.27 SYE
11.28 SYSCON
11.29 SYSTABLES
11.30 TASKS
11.31 VARIETY_PARAMETER_VALUE
11.32 VIEWER_REQUESTS
11.33 WOG
11.34 WOGINFO
11.35 WOSC

AEZ

Description: synonym to oracle package
Use: use to references the tables REGION_DESCRIPTIONS and REGION_MAPPINGS
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
REG_MAP_ID	NOT NULL	NUMBER(22)
REG_CODE	NOT NULL	VARCHAR2(10)
REG_NAME	NOT NULL	VARCHAR2(250)
REG_LEVEL	NOT NULL	NUMBER(22)
BELONGS_TO	NOT NULL	VARCHAR2(10)
BELONGS_TO_NAME	NOT NULL	VARCHAR2(250)
AREA_HA	NOT NULL	NUMBER(22)
AREA_KM2	NOT NULL	NUMBER(22)	-

AGGREGATION_AREAS

Description: cultivated areas per region used for spatial aggregation of crop indicators
Use: used for weighting during aggregating crop indicators towards regional crop indicators
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
REG_MAP_ID	NOT NULL	NUMBER(22, 10)	-	administrative region id
YEAR	NOT NULL	NUMBER(22, 4)	-	year for which cultivated area is valid
AREA_CULTIVATED		NUMBER(22, 38)	10^3 Ha	cultivated area
SOURCE	NOT NULL	VARCHAR2(40)
DAY	NOT NULL	DATE	-	day on which area was derived
PERCENTAGE		NUMBER(22, 5)	-	percentage of area cultivated; not used; NoData
AREA_ORIGINAL		NUMBER(22, 38)	10^3 Ha	backup to store original cultivated area in this was adapted
TREATMENT		VARCHAR2(50)	-	calculation method
NOTE		VARCHAR2(50)	-	free comments

* 'SOURCE' can have the following values:

based on EUROSTAT
- EUROSTAT CROPUSE for crops 1,2,3,4,5,6,7,8,9,10,11,12,76,77
- EUROSTAT LANDUSE for crop 50

based on EMU_PLUS_NUTS_LANDCOVER
- CGMS LANDCOVER for crop 51
- LANDCOVER where EUROSTAT is not available and land cover area > 0
- EMU_PLUS_NUTS where EUROSTAT is not available and land cover area = 0 (set to zero)

ALL_SIMULATION_UNITS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)
STU_NO	NOT NULL	NUMBER(22, 8)

definition:

select distinct
    t.grid_no
  , t.stu_no
from simulation_unit_all t

CGMS_SYSLOG

Description: logging of run options.
Use: output table containing information on the run executed
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
RUNID	NOT NULL	NUMBER(22, 8)	-	identification number of run
DBUSER		VARCHAR2(20)	-	username
RUNDATE		DATE	-	run date
RUNINFO		VARCHAR2(250)	-	codes explaining kind of run executed
CAMPAIGN_START		VARCHAR2(50)	-	start month of campaign (agricultural season
WEATHER_START		DATE	-	start date of weather calculations
WEATHER_END		DATE	-	end date of weather calculations
START_YEAR	NOT NULL	NUMBER(22, 4)	-	year for which simulation is executed
CAMPAIGN_YEARS	NOT NULL	NUMBER(22, 3)	-	number of campaign years the model is run for
RUNSTATUS		VARCHAR2(20)	-	final status of run
WEATHER_DATA_SOURCE		VARCHAR2(20)	-	source type used for simulation crop yield
INITIALISATION_WATER_BALANCE	NOT NULL	NUMBER(22, 1)	-	code indication type of water balance initialisations
GROUND_WATER_BALANCE	NOT NULL	NUMBER(22, 1)	-	code indication usage of ground water balance

CROP

Description: description of crops. Crop name, number, associated crop group and general month.
Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
Type: Table
Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 8)
CROP_NAME	NOT NULL	VARCHAR2(40)	-	name of crop
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-	group where crop belongs to
CROP_MODEL	NOT NULL	NUMBER(22, 1)	-	WOFOST (0 of LINGRA (1
START_MONTH	NOT NULL	NUMBER(22, 2)	-	start month of crop season
LANDCOVER_ID		NUMBER(22, 10)

* CROP_NO in (1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51)
** LANDCOVER_ID values:

101 Arable Land
102 Non-irrigated arable land
103 Agricultural areas
104 Pasture
105 Temporary forage
106 Rice

CROPSUSE

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
CODE	NOT NULL	VARCHAR2(30)
LABEL	NOT NULL	VARCHAR2(120)
SIM_PRO_NO	NOT NULL	NUMBER(22)
PROXY		NUMBER(22)
STAT_PRO_NO		NUMBER(22)
DELIVERABLE		VARCHAR2(1)
CRONOS		VARCHAR2(30)
REGIO		VARCHAR2(30)
AGRI4CAST		VARCHAR2(30)
PRIORITY		NUMBER(22, 2)
GRAPH		NUMBER(22, 1)
LANDCOVER		NUMBER(22, 2)
AGGREGATED	NOT NULL	VARCHAR2(1)

CW

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
WMO_NO	NOT NULL	NUMBER(22)
DAY	NOT NULL	DATE
E0		NUMBER(22)
ES0		NUMBER(22)
ET0		NUMBER(22)
CALCULATED_RADIATION		NUMBER(22, 9)

DATES_75_15

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

Structure

Attribute	Constraint	Type	Unit
DAY	NOT NULL	DATE
DAYNO_WK	NOT NULL	NUMBER(22, 1)
WEEK	NOT NULL	NUMBER(22, 2)
DAYNO_MON	NOT NULL	NUMBER(22, 2)
MONTH	NOT NULL	NUMBER(22, 2)
DAYNO_YR	NOT NULL	NUMBER(22, 3)
YEAR	NOT NULL	NUMBER(22, 4)
DAYNO_DEC	NOT NULL	NUMBER(22, 2)
DECADE	NOT NULL	NUMBER(22, 2)
DEC_MONTH	NOT NULL	VARCHAR2(10)
JULIAN	NOT NULL	NUMBER(22)	-

EMU

Description: the intersection of the soil map and the grid
Use: input/reference table for the crop simulation process
Type: Table
Remarks: user defined, derived from GIS, provides the link to the GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
AREA	NOT NULL	NUMBER(22, 10)	-	area of elementary mapping unit

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: View
Remarks: user defined, derived from GIS, provides the link to the GIS

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
LATITUDE	NOT NULL	NUMBER(22, 8)	-	latitude of grid cell centre
LONGITUDE	NOT NULL	NUMBER(22, 8)	-	longitude of grid cell centre
ALTITUDE	NOT NULL	NUMBER(22, 5)	Meter	altitude of grid cell*
CLIMATE_ZONE	NOT NULL	NUMBER(22, 2)	-
DISTANCE_TO_COAST	NOT NULL	NUMBER(22, 5)	Km	distance from centre of gravity of land part to coast
X_COORDINATE	NOT NULL	NUMBER(22)	-
Y_COORDINATE	NOT NULL	NUMBER(22)	-

* Not a simple average (see 'Similarity score' in paragraph Qualification of weather stations).

definition:

SELECT "GRID_NO","LATITUDE","LONGITUDE","ALTITUDE","CLIMATE_ZONE","DISTANCE_TO_COAST","X_COORDINATE","Y_COORDINATE" FROM GRID_ALL
--WHERE GRID_NO in (69093)

GRID_ALL

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
GRID_NO	NOT NULL	NUMBER(22, 8)
LATITUDE	NOT NULL	NUMBER(22, 8)
LONGITUDE	NOT NULL	NUMBER(22, 8)
ALTITUDE	NOT NULL	NUMBER(22, 5)
CLIMATE_ZONE	NOT NULL	NUMBER(22, 2)
DISTANCE_TO_COAST	NOT NULL	NUMBER(22, 5)
X_COORDINATE	NOT NULL	NUMBER(22)
Y_COORDINATE	NOT NULL	NUMBER(22)

INITIAL_SOIL_WATER

Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
Use: input for level 2
Type: Table
Remarks: user defined

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
STU_NO	NOT NULL	NUMBER(22, 8)	-	soil typological unit number
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
YEAR	NOT NULL	NUMBER(22, 4)	-	calendar year
ZTI	NOT NULL	NUMBER(22, 4)
DD	NOT NULL	NUMBER(22, 4)
WAV	NOT NULL	NUMBER(22, 3)	cm	water available in potential rooting depth
GIVEN_STARTDATE_WATBAL	NOT NULL	DATE	-	date for which WAV is valid

Set to 999 to avoid the the ground water module being used (see Initial available soil water).

JSOW

Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
Use: Input table for calculating one of the Crop Simulation indicators.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number, equal to CROP_NO in CROP table
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number, equal to GRID_NO in GRID table
JSOW	NOT NULL	NUMBER(22, 3)	julian day (1-366)	day in year

ORDER_EAST_EUROPE

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER		NUMBER(22, 8)
DAY		DATE
PRECIPITATION		NUMBER(22, 6)

PARAMETER_DESCRIPTION

Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
Use: used during system initialisation to correctly interpret the parameter tables
Type: Table
Remarks: do not change this table

Structure

Attribute	Constraint	Type	Unit	Comment
PARAMETER_CODE	NOT NULL	VARCHAR2(20)	-	character code of crop parameter
MULTIPLE	NOT NULL	VARCHAR2(1)	-	N = single value, Y = value pairs
PARAMETER_DESCR	NOT NULL	VARCHAR2(80)	-	description of crop parameter

REGION

Description: Administrative regions
Use: input for monitoring extreme weather events
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
REG_MAP_ID	NOT NULL	NUMBER(22)	-	unique id for region
REG_MAP_ID_BT	NOT NULL	NUMBER(22)	-	unique id (one level up where the administrative region belongs to
REG_CODE	NOT NULL	VARCHAR2(10)
REG_NAME	NOT NULL	VARCHAR2(250)	-	name of administrative region
REG_LEVEL	NOT NULL	NUMBER(22)
BELONGS_TO	NOT NULL	VARCHAR2(10)
BELONGS_TO_NAME	NOT NULL	VARCHAR2(250)	-	region name (one level up where the administrative region belongs to
AREA_HA	NOT NULL	NUMBER(22)	ha	area in hectare
AREA_KM2	NOT NULL	NUMBER(22)	km2	area in square km
SYS_STSW46C6GTS8M09JGVCKDL66TF		NUMBER(22)

* According to the 'NUTS' nomenclature (see Administrative_regions).

REGION_GRIDS_EMU

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
REG_CODE0	NOT NULL	VARCHAR2(10)
REGION0	NOT NULL	VARCHAR2(250)
MAPID0	NOT NULL	NUMBER(22)
LEVEL0	NOT NULL	NUMBER(22)
AREA0		NUMBER(22)
REG_CODE1	NOT NULL	VARCHAR2(10)
REGION1	NOT NULL	VARCHAR2(250)
MAPID1	NOT NULL	NUMBER(22)
LEVEL1	NOT NULL	NUMBER(22)
AREA1		NUMBER(22)
REG_CODE2	NOT NULL	VARCHAR2(10)
REGION2	NOT NULL	VARCHAR2(250)
MAPID2	NOT NULL	NUMBER(22)
LEVEL2	NOT NULL	NUMBER(22)
AREA2		NUMBER(22)
REG_CODE3	NOT NULL	VARCHAR2(10)
REGION3	NOT NULL	VARCHAR2(250)
MAPID3	NOT NULL	NUMBER(22)
LEVEL3	NOT NULL	NUMBER(22)
AREA3		NUMBER(22)
GRID_NO	NOT NULL	NUMBER(22, 8)
GRID_AREA		NUMBER(22)

definition:

select
      r0.reg_code      as reg_code0
    , r0.reg_name      as region0
    , r0.reg_map_id    as mapid0
    , r0.reg_level     as level0
    , r0.area_ha*10000 as area0
    , r1.reg_code      as reg_code1
    , r1.reg_name      as region1
    , r1.reg_map_id    as mapid1
    , r1.reg_level     as level1
    , r1.area_ha*10000 as area1
    , r2.reg_code      as reg_code2
    , r2.reg_name      as region2
    , r2.reg_map_id    as mapid2
    , r2.reg_level     as level2
    , r2.area_ha*10000 as area2
    , r3.reg_code      as reg_code3
    , r3.reg_name      as region3
    , r3.reg_map_id    as mapid3
    , r3.reg_level     as level3
    , r3.area_ha*10000 as area3
    , epn.grid_no      as grid_no
    , sum(epn.area)    as grid_area
from
      region r0
    , region r1
    , region r2
    , region r3
    , link_emu_region epn
where r0.reg_level  = 0
and   r0.reg_map_id = r1.reg_map_id_bt
and   r1.reg_map_id = r2.reg_map_id_bt
and   r2.reg_map_id = r3.reg_map_id_bt
and   r3.reg_map_id = epn.reg_map_id
group by
      r0.reg_code
    , r0.reg_name
    , r0.reg_map_id
    , r0.reg_level
    , r0.area_ha
    , r1.reg_code
    , r1.reg_name
    , r1.reg_map_id
    , r1.reg_level
    , r1.area_ha
    , r2.reg_code
    , r2.reg_name
    , r2.reg_map_id
    , r2.reg_level
    , r2.area_ha
    , r3.reg_code
    , r3.reg_name
    , r3.reg_map_id
    , r3.reg_level
    , r3.area_ha
    , epn.grid_no
order by
      r0.reg_name
    , r1.reg_name
    , r2.reg_name
    , r3.reg_name
    , epn.grid_no

ROOTING_DEPTH

Description: the rooting depth classes and associated rooting depth limits
Use: reference table used in crop simulation
Type: Table
Remarks: part of the soil model, can be changed or extended if necessary

Structure

Attribute	Constraint	Type	Unit	Comment
CLASS	NOT NULL	NUMBER(22, 5)	-	rooting depth class
MIN_DEPTH	NOT NULL	NUMBER(22, 5)	cm	depth to which crop roots extends

SITE

Description: Contains some soil model parameters on a system wide basis
Use: input table for the crop simulation process
Type: Table
Remarks: supplied by the user, but rarely changed

Structure

Attribute	Type	Unit	Comment
IFUNRN	NUMBER(22, 1)	-	infiltration rate depends on storm size. 0=no, 1 = yes
NOTINF	NUMBER(22, 2)	-	non infiltration fration, 0 = infiltration, 1 = no infiltration
MAX_SURFACE_STORAGE	NUMBER(22, 5)	(cm)	maximum surface storage

SMU_SUITABILITY

Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
Type: Table
Remarks: this table needs to be recalculated whenever the simulation_unit table changes

Structure

Attribute	Constraint	Type	Unit	Comment
SMU_NO	NOT NULL	NUMBER(22, 8)	-	soil mapping unit number
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-	group where crop belongs to
PERCENTAGE	NOT NULL	NUMBER(22, 3)	-	percentage of soil mapping unit suitable for crop group

STATION

Description: the weather stations and weather station characteristics to be used by the system
Use: used by all of the level 1 steps (additional weather, availability, grid weather)
Type: Table
Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated

Structure

Attribute	Constraint	Type	Unit	Comment
STATION_NUMBER	NOT NULL	NUMBER(22, 7)	-
STATION_NAME	NOT NULL	VARCHAR2(32)	-
ORGANIZATION	NOT NULL	VARCHAR2(32)	-
WMO_NO		NUMBER(22, 5)	-
WMO_NAME		VARCHAR2(32)	-
LATITUDE	NOT NULL	NUMBER(22, 7)	dd	latitude
LONGITUDE	NOT NULL	NUMBER(22, 8)	dd	longitude
Y_COORDINATE	NOT NULL	NUMBER(22, 13)	m	not used in CGMS
X_COORDINATE	NOT NULL	NUMBER(22, 13)	m	not used in CGMS
ALTITUDE	NOT NULL	NUMBER(22, 5)	m	altitude
CLIMATE_ZONE	NOT NULL	NUMBER(22, 2)	-
COUNTRY	NOT NULL	VARCHAR2(26)
DISTANCE_TO_COAST	NOT NULL	NUMBER(22, 4)	km	distance to coast
ANGSTROM_A	NOT NULL	NUMBER(22, 18)	-
ANGSTROM_B	NOT NULL	NUMBER(22, 18)	-
SUPIT_A	NOT NULL	NUMBER(22, 18)	-
SUPIT_B	NOT NULL	NUMBER(22, 18)	-
SUPIT_C	NOT NULL	NUMBER(22, 18)	-
HARGREAVES_A	NOT NULL	NUMBER(22, 18)	-
HARGREAVES_B	NOT NULL	NUMBER(22, 18)	-
RELIABLE_STATION	NOT NULL	NUMBER(22, 1)	-
ACTIVE_STATION	NOT NULL	NUMBER(22, 1)	-
AVAIL_PRECIPITATION_THRESHOLD	NOT NULL	NUMBER(22, 4)	-
AVAIL_SNOWDEPTH_THRESHOLD	NOT NULL	NUMBER(22, 4)	-
AVAIL_TEMPERATURE_THRESHOLD	NOT NULL	NUMBER(22, 4)	-
AVAIL_HUMIDITY_THRESHOLD	NOT NULL	NUMBER(22, 4)	-
AVAIL_REST_THRESHOLD	NOT NULL	NUMBER(22, 4)	-
SYS_STS71L#C1HTYXYAPPUSRPQ2438		NUMBER(22)
SYS_STSV6R_T0BD80RL4_R0IMWL5OJ		NUMBER(22)

STATIONS_PER_GRID

Description: the stations used for the grid weather interpolation of the historic year.
Use: output table for the level 1 grid weather calculation
Type: Table
Remarks: contains both information produced by historical interpolation and current year interpolation.

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22, 8)	-	grid number
DAY	NOT NULL	DATE	-
PRECIPITATION_STATION	NOT NULL	NUMBER(22, 7)	-	station number used for rainfall
SNOW_STATION		NUMBER(22, 7)	-
TEMPERATURE_STATION_1	NOT NULL	NUMBER(22, 7)	-	first station used for interpolation temperature
TEMPERATURE_STATION_2		NUMBER(22, 7)	-	second station used for interpolation temperature
TEMPERATURE_STATION_3		NUMBER(22, 7)	-	third station used for interpolation temperature
TEMPERATURE_STATION_4		NUMBER(22, 7)	-	fourth station used for interpolation temperature
HUMIDITY_STATION		NUMBER(22, 7)	-
REST_STATION_1	NOT NULL	NUMBER(22, 7)	-	first station used for interpolation other variables
REST_STATION_2		NUMBER(22, 7)	-	second station used for interpolation other variables
REST_STATION_3		NUMBER(22, 7)	-	third station used for interpolation other variables
REST_STATION_4		NUMBER(22, 7)	-	fourth station used for interpolation other variables
PRECIPITATION_SCORE	NOT NULL	NUMBER(22, 6)	km	similarity score for station used rainfall
SNOW_SCORE		NUMBER(22, 6)	-
TEMPERATURE_SCORE	NOT NULL	NUMBER(22, 6)	km	similarity score for first station used interpolation temperature
HUMIDITY_SCORE		NUMBER(22, 6)	-
REST_SCORE	NOT NULL	NUMBER(22, 6)	km	similarity score for first station used interpolation other variables

STATION_REFERENCE_COEFFICIENTS

Description: contains calculated regression constants for selected weather stations covering a large part of Europe
Use: is used by view SUPIT_REFERENCE_STATIONS
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
LATITUDE	NOT NULL	NUMBER(22)	-
LONGITUDE	NOT NULL	NUMBER(22)	-
ALTITUDE	NOT NULL	NUMBER(22)	-
ANGSTROM_A		NUMBER(22)	-
ANGSTROM_B		NUMBER(22)	-
SUPIT_A		NUMBER(22)	-
SUPIT_B		NUMBER(22)	-
SUPIT_C		NUMBER(22)	-
HARGREAVES_A		NUMBER(22)	-
HARGREAVES_B		NUMBER(22)	-

STAT_CROP

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
STAT_CROP_NO	NOT NULL	NUMBER(22, 4)	-
STAT_CROP_NAME	NOT NULL	VARCHAR2(40)	-
CROP_NO	NOT NULL	NUMBER(22, 4)	-
CROP_NAME	NOT NULL	VARCHAR2(40)	-
PROXY	NOT NULL	NUMBER(22, 4)	-
PROXY_NAME	NOT NULL	VARCHAR2(40)	-

STU_LAYER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
STU_NO	NOT NULL	NUMBER(22, 8)	-
LAYER_NO	NOT NULL	NUMBER(22, 2)	-
THICKNESS	NOT NULL	NUMBER(22, 3)	-
SOIL_GROUP_NO	NOT NULL	NUMBER(22, 3)	-

SUITABILITY

Description: the suitable STUs for each crop _ group
Use: used to derive the simulation_unit table
Type: Table
Remarks: user defined, derived from the soil map

Structure

Attribute	Constraint	Type	Unit	Comment
CROPGROUP_NO	NOT NULL	NUMBER(22, 2)	-	group where crop belongs to
STU_NO	NOT NULL	NUMBER(22, 8)	-	soil typologic unit number

SYE

Description: table for storing temporary results during Crop_Simulation. When the calculation is finshed, all records are inserted into SIMYIELD_EMU overwriting old results.
Use: temporary output table for the calculation of crop indicators.
Type: Table
Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22)	-	crop number
GRID_NO	NOT NULL	NUMBER(22)	-	grid number
SMU_NO	NOT NULL	NUMBER(22)	-	soil mapping unit number
DAY	NOT NULL	DATE	-	day
POTENTIAL_YIELD_BIOMASS	NOT NULL	NUMBER(22)	kg.ha-1	potential dry weight biomass
POTENTIAL_YIELD_STORAGE	NOT NULL	NUMBER(22)	kg.ha-1	potential dry weight storage organs
WATER_LIM_YIELD_BIOMASS	NOT NULL	NUMBER(22)	kg.ha-1	water limited dry weight biomass
WATER_LIM_YIELD_STORAGE	NOT NULL	NUMBER(22)	kg.ha-1	water limited dry weight storage organs
POTENTIAL_LEAF_AREA_INDEX	NOT NULL	NUMBER(22)	m2.m2	potential leaf area divided by surface area
WATER_LIM_LEAF_AREA_INDEX	NOT NULL	NUMBER(22)	m2.m2	water limited leaf area divided by surface area
DEVELOPMENT_STAGE	NOT NULL	NUMBER(22)	-	development stag of crop (0-200
RELATIVE_SOIL_MOISTURE	NOT NULL	NUMBER(22)	-	percentage of (field capacity minus wilting point
TOTAL_WATER_CONSUMPTION	NOT NULL	NUMBER(22)	cm	sum of water limited transpiration
TOTAL_WATER_REQUIREMENT	NOT NULL	NUMBER(22)	cm	sum of potential transpiration
FSM		NUMBER(22)	-	folumetric soil moisture content in rooted zone
FSMUR		NUMBER(22)	-	volumetric soil moisture content in not rooted zone
LEAVES_DIED_BY_COLD		NUMBER(22)	-	fraction of leaves died by cold wrt total biomass
RUNOFF		NUMBER(22)	cm	run off
SOIL_EVAPORATION		NUMBER(22)	cm	soil evaporation
LOSS_TO_SUBSOIL		NUMBER(22)	cm	amount of water drained to the sub soil and therefore lost for the crop

SYSCON

Description: contains system parameters
Use: upon system initialisation
Type: Table
Remarks: user defined

Structure

Attribute	Constraint	Type	Unit	Comment
SNAME	NOT NULL	VARCHAR2(30)	-	name of variable
SVALUE	NOT NULL	VARCHAR2(30)	-	value of variable

SYSTABLES

Description:
Use:
Type: Table
Remarks:

Structure

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

TASKS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit
TASK_ID	NOT NULL	NUMBER(22, 8)	-
MODEL	NOT NULL	VARCHAR2(12)	-
DAY	NOT NULL	DATE
STATUS	NOT NULL	NUMBER(22, 2)
TIMESTAMP	NOT NULL	DATE
FRACTION		NUMBER(22)
MCOMMENT		VARCHAR2(255)	-

definition:

select
    task_id
  , model
  , day
  , status
  , timestamp
  , fraction
  , mcomment
from eurman.tasks
where model in ('OBS','OPE','OBS+OPE')
order by task_id

VARIETY_PARAMETER_VALUE

Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
Use: input table for the crop simulation process
Type: Table
Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in CROP_PARAMETER_VALUE table). In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.

Structure

Attribute	Constraint	Type	Unit	Comment
CROP_NO	NOT NULL	NUMBER(22, 4)	-	crop number
VARIETY_NO	NOT NULL	NUMBER(22, 4)	-	crop number
PARAMETER_CODE	NOT NULL	VARCHAR2(20)	-	character code of crop parameter
PARAMETER_XVALUE	NOT NULL	NUMBER(22, 38)	-	crop parameter value
PARAMETER_YVALUE		NUMBER(22, 38)	-	crop parameter value - multiple
SYS_STSC3A_GW#CT_BNWQTW9RFSRP9		NUMBER(22)

(in case of single parameters PARAMETER_XVALUE gives the value; in case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE)

VIEWER_REQUESTS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
REQUEST_ID	NOT NULL	NUMBER(22)	-
URL	NOT NULL	VARCHAR2(4000)	-
CREATION_TIMESTAMP	NOT NULL	DATE	-
REQUEST_STATUS	NOT NULL	NUMBER(22)	-
FILE_PATH		VARCHAR2(4000)	-
ACCESS_TIMESTAMP	NOT NULL	DATE	-
HIT_COUNT	NOT NULL	NUMBER(22)	-

WOG

Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
Type: Table
Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

Structure

Attribute	Constraint	Type	Unit	Comment
GRID_NO	NOT NULL	NUMBER(22)	-	grid number
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22)
TEMPERATURE_MIN	NOT NULL	NUMBER(22)
TEMPERATURE_AVG	NOT NULL	NUMBER(22)
VAPOURPRESSURE	NOT NULL	NUMBER(22)
WINDSPEED	NOT NULL	NUMBER(22)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22)
E0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22)
SNOWDEPTH		NUMBER(22)
HUMIDITY_06H		NUMBER(22)
HUMIDITY_09H		NUMBER(22)
HUMIDITY_12H		NUMBER(22)
HUMIDITY_15H		NUMBER(22)
HUMIDITY_18H		NUMBER(22)

WOGINFO

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
GRID_NO	NOT NULL	NUMBER(22)
DAY	NOT NULL	DATE
TEMPERATURE_GROUP	NOT NULL	VARCHAR2(10)
PRECIPITATION	NOT NULL	VARCHAR2(10)
SNOWDEPTH	NOT NULL	VARCHAR2(10)
HUMIDITY_GROUP	NOT NULL	VARCHAR2(10)
REST_GROUP	NOT NULL	VARCHAR2(10)

WOSC

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
STATION_NUMBER	NOT NULL	NUMBER(22)
DAY	NOT NULL	DATE
E0		NUMBER(22)
ES0		NUMBER(22)
ET0		NUMBER(22)
RADIATION		NUMBER(22)

synonyms

content
12.1 CMETEO_ADMIN
12.2 REGION_MAPPINGS

CMETEO_ADMIN

Description: synonym to oracle package
Use:
Type: Synonym ➞ CMETEO@ADMIN_MRSMAN
Remarks: none

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_EURMAN
Remarks: none

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